Recurrence details dimension table
Bi_DimRecurrenceDetails_s3 | RecurrenceId | VARCHAR(36) | PK | |
|---|---|---|---|---|
Bi_DimRecurrenceDetails_s3 | centerId | VARCHAR(36) | ||
Bi_DimRecurrenceDetails_s3 | CreatedBy | VARCHAR(36) | ||
Bi_DimRecurrenceDetails_s3 | createon | TIMESTAMP | ||
Bi_DimRecurrenceDetails_s3 | EndDate | TIMESTAMP | ||
Bi_DimRecurrenceDetails_s3 | Interval | INT | ||
Bi_DimRecurrenceDetails_s3 | IsPerpetual | BOOLEAN | ||
Bi_DimRecurrenceDetails_s3 | LastUpdated | TIMESTAMP | ||
Bi_DimRecurrenceDetails_s3 | Occurences | INT | ||
Bi_DimRecurrenceDetails_s3 | StandingAppts | INT | ||
Bi_DimRecurrenceDetails_s3 | StartDate | TIMESTAMP | ||
Bi_DimRecurrenceDetails_s3 | Timeperiod | VARCHAR(80) | ||
Bi_DimRecurrenceDetails_s3 | unchecked | BOOLEAN | ||
Bi_DimRecurrenceDetails_s3 | weekdays | INT | ||
Bi_DimRecurrenceDetails_s3 | OrganizationId | VARCHAR(36) | ||
Bi_DimRecurrenceDetails_s3 | EtlLastUpdatedOn | TIMESTAMP | ||
Bi_DimRecurrenceDetails_s3 | EtlLastUpdatedBy | NVARCHAR(50) | ||
Bi_DimRecurrenceDetails_s3 | PodName | VARCHAR(20) | ||
Bi_DimRecurrenceDetails_s3 | groupid | BIGINT |