UTC to Center time dimension table
bi_dimutctocentertime
Field | Description | Field Type | Primary Key |
|---|---|---|---|
centername | varchar ( 256 ) | ||
centerwid | bigint | ||
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 | |
minutestoadd | The number of minutes that need to be added to UTC time to get the current time at the center. Timestamps that are generated by Tableau [E.g. if you use filters such as Today, Tomorrow, etc.] are in UTC, hence this field is needed to arrive at the center time. This is not needed for timestamps that are in the data source directly- these are already in the center time zone. | integer | |
orgaccountname | varchar ( 514 ) | ||
organizationid | varchar ( 36 ) | ||
organizationname | varchar ( 1028 ) | ||
podname | varchar ( 20 ) | ||
utctocentertimewid | bigint | ||
void | integer |