Center timing dimension table
bi_dimcentertiming
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centerendtime | The time at which the center is scheduled to close. This corresponds to the 'scheduledate' field. This is stored in HHMM format. E.g. 1630, 1400, etc. | double precision | |
centerid | varchar ( 36 ) | ||
centername | varchar ( 512 ) | ||
centerstarttime | The time at which the center is scheduled to start. This corresponds to the 'scheduledate' field. This is stored in HHMM format. E.g. 1630, 1400, etc. | double precision | |
centertimingpk | numeric | ||
centertimingwid | unique identifer for the row in the table | bigint | |
cntrtimngpk | varchar ( 400 ) | ||
dayofweek | The day of the week corresponding to the 'scheduledate'. | varchar ( 320 ) | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
onlinebookingendtime | The time at which online bookings close at the center. This corresponds to the 'scheduledate' field. This is stored in HHMM format. E.g. 1630, 1400, etc. | double precision | |
onlinebookingstarttime | The time at which online bookings start at the center. This corresponds to the 'scheduledate' field. This is stored in HHMM format. E.g. 1630, 1400, etc. | double precision | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |