CM_TZDLS_DAYLIGHTSAVING_DTL
This is a station master table that stores daylight saving details for stations. It provides static reference data for linking stations, and related attributes in transaction processing.
Process: MAINTPLANNING · Component: BASCm · Table type: Master Table Category: Stores station master details to link operational transactions with accurate organizational and locational data.
This table is the canonical store for the DaylightSaving entity.
Primary key
TZDLS_TIMEZONE_NO, TZDLS_CAL_YEAR_NO, TZDLS_OUINSTANCE
Columns (11)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TZDLS_OUINSTANCE 🔑 | varchar | Organization Unit instance for daylight saving details |
| 2 | TZDLS_TIMEZONE_NO 🔑 | #N/A | Time zone number for daylight saving |
| 3 | TZDLS_CAL_YEAR_NO 🔑 | varchar | Calendar year number for daylight saving |
| 4 | TZDLS_START_MONTH_CODE | datetime | Start month code for daylight saving |
| 5 | TZDLS_START_DATETIME | varchar | Start date and time for daylight saving |
| 6 | TZDLS_ENDING_MONTH_CODE | datetime | Ending month code for daylight saving |
| 7 | TZDLS_ENDING_DATETIME | float | Ending date and time for daylight saving |
| 8 | TZDLS_DIFF_FROM_UTC | float | Difference from UTC in hours during daylight saving |
| 9 | TZDLS_DIFF_FROM_UTC_INMIN | varchar | Difference from UTC in minutes during daylight saving |
| 10 | TZDLS_TIME_UNIT | #N/A | Time unit used for daylight saving |
| 11 | TZDLS_TIMESTAMP | varchar | Timestamp of the daylight saving record |
Relationships (1)
- Timezone (CM_TZDTL_TIMEZONE_DTL) →
TIMEZONE_HAS_DST(this table is target)- Join:
CM_TZDTL_TIMEZONE_DTL.TZDTL_TIMEZONE_NO = CM_TZDLS_DAYLIGHTSAVING_DTL.TZDLS_TIMEZONE_NO - Timezone has daylight saving rules
- Join:
Sample rows (from live DB)
TZDLS_OUINSTANCE | TZDLS_TIMEZONE_NO | TZDLS_CAL_YEAR_NO | TZDLS_START_MONTH_CODE | TZDLS_START_DATETIME | TZDLS_ENDING_MONTH_CODE |
|---|---|---|---|---|---|
| 2.0 | BE59 | 2016.0 | APR | 2017-07-06 00:00:00 | OCT |
| 2.0 | BT | 2011.0 | MAR | 2011-03-27 01:00:00 | OCT |
| 2.0 | BT | 2012.0 | MAR | 2012-03-25 01:00:00 | OCT |
Showing 3 of 35 rows.