Appointment categories dimension table
Table Name | Column Name | Column Type | Primary Key |
|---|---|---|---|
Bi_DimAppointmentCategories_s3 | AppointmentCategoryId | VARCHAR(36) | PK |
Bi_DimAppointmentCategories_s3 | AppointmentCategoryCode | NVARCHAR(512) | |
Bi_DimAppointmentCategories_s3 | AppointmentCategoryName | NVARCHAR(1024) | |
Bi_DimAppointmentCategories_s3 | AppointmentCategoryOrder | INT | |
Bi_DimAppointmentCategories_s3 | IndicatorColor | NVARCHAR(128) | |
Bi_DimAppointmentCategories_s3 | OverrideAppointmentColor | BOOLEAN | |
Bi_DimAppointmentCategories_s3 | Active | BOOLEAN | |
Bi_DimAppointmentCategories_s3 | OrganizationId | VARCHAR(36) | |
Bi_DimAppointmentCategories_s3 | Void | BOOLEAN | |
Bi_DimAppointmentCategories_s3 | TextColor | NVARCHAR(128) | |
Bi_DimAppointmentCategories_s3 | EtlLastUpdatedOn | TIMESTAMP | |
Bi_DimAppointmentCategories_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |
Bi_DimAppointmentCategories_s3 | PodName | VARCHAR(20) | |
Bi_DimAppointmentCategories_s3 | groupid | BIGINT |