DW_SUSTAINABILITY_PERIODS_D (Preview)
This table requires activation of Sustainability functional area. Sustainability Periods Dimension
Details
Module:
Key Columns
PERIOD_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERIOD_ID | NUMBER | 38 | 0 | True | Period Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. System Identifier | ||||
| PERIOD_NUM | NUMBER | 38 | 0 | Period Number | |||
| PERIOD_NAME | VARCHAR2 | 16 | Period Name | ||||
| PERIOD_STATUS_CODE | VARCHAR2 | 128 | Period Status Code | DW_ORA_SUS_PERIOD_STATUSES_LKP_TL | ORA_SUS_PERIOD_STATUSES_CODE | ||
| PERIOD_YEAR | NUMBER | 38 | 0 | Period Year | |||
| START_DATE | DATE | Start Date | |||||
| END_DATE | DATE | End Date |