Module: Common
Type: Dimension
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FISCAL_PERIOD_NAME | VARCHAR2 | 256 | Fiscal Period Name | ||||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal Period Set Name | ||||
| FISCAL_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Year Number | |||
| SOURCE_RECORD_ID | VARCHAR2 | 312 | Source Record Id | ||||
| ACCOUNTING_CAL_FLAG | VARCHAR2 | 16 | Accounting Cal Flag | ||||
| ADJUSTMENT_PERIOD_FLAG | VARCHAR2 | 16 | Adjustment Period Flag | ||||
| CALENDAR_TYPE_CODE | VARCHAR2 | 32 | Calendar Type Code | ||||
| CURRENT_FISCAL_PERIOD_CODE | VARCHAR2 | 16 | Current Fiscal Period Code | ||||
| CURRENT_FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Current Fiscal Quarter Code | ||||
| CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Current Fiscal Year Code | ||||
| FIRST_PERIOD_FISCAL_QTR_FLAG | VARCHAR2 | 16 | First Period Fiscal Qtr Flag | ||||
| FIRST_PERIOD_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | First Period Fiscal Year Flag | ||||
| FISCAL_HALF_NUMBER | NUMBER | 38 | 0 | Fiscal Half Number | |||
| FISCAL_PERIOD_END_DATE | DATE | 0 | Fiscal Period End Date | ||||
| FISCAL_PERIOD_END_DATE_ID | NUMBER | 38 | 0 | Fiscal Period End Date ID | |||
| FISCAL_PERIOD_NUMBER | NUMBER | 38 | 0 | Fiscal Period Number | |||
| FISCAL_PERIOD_SORT_KEY | VARCHAR2 | 256 | Fiscal Period Sort Key | ||||
| FISCAL_PERIOD_START_DATE | DATE | 0 | Fiscal Period Start Date | ||||
| FISCAL_PERIOD_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Period Start Date ID | |||
| FISCAL_PERIOD_TOTAL_DAYS | NUMBER | 38 | 0 | Fiscal Period Total Days | |||
| FISCAL_PERIOD_TOTAL_WEEKS | NUMBER | 38 | 0 | Fiscal Period Total Weeks | |||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Fiscal Period Type | ||||
| FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Fiscal Quarter Code | ||||
| FISCAL_QUARTER_END_DATE | DATE | 0 | Fiscal Quarter End Date | ||||
| FISCAL_QUARTER_END_DATE_ID | NUMBER | 38 | 0 | Fiscal Quarter End Date ID | |||
| FISCAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Fiscal Quarter Number | |||
| FISCAL_QUARTER_START_DATE | DATE | 0 | Fiscal Quarter Start Date | ||||
| FISCAL_QUARTER_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Quarter Start Date ID | |||
| FISCAL_TRAILING_PERIOD_NUMBER | NUMBER | 38 | 0 | Fiscal Trailing Period Number | |||
| FISCAL_TRAILING_QUARTER_NUMBER | NUMBER | 38 | 0 | Fiscal Trailing Quarter Number | |||
| FISCAL_TRAILING_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Trailing Year Number | |||
| FISCAL_YEAR_END_DATE | DATE | 0 | Fiscal Year End Date | ||||
| FISCAL_YEAR_END_DATE_ID | NUMBER | 38 | 0 | Fiscal Year End Date ID | |||
| FISCAL_YEAR_START_DATE | DATE | 0 | Fiscal Year Start Date | ||||
| FISCAL_YEAR_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Year Start Date ID | |||
| FISCAL_YEAR_TOTAL_DAYS | NUMBER | 38 | 0 | Fiscal Year Total Days | |||
| FISCAL_YEAR_TOTAL_WEEKS | NUMBER | 38 | 0 | Fiscal Year Total Weeks | |||
| LAST_PERIOD_FISCAL_QTR_FLAG | VARCHAR2 | 16 | Last Period Fiscal Qtr Flag | ||||
| LAST_PERIOD_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | Last Period Fiscal Year Flag | ||||
| NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number Per Fiscal Year | |||
| PERIOD_END_OR_PRV_CRNT_DATE | DATE | 0 | Period End Or Prv Crnt Date | ||||
| PERIOD_END_OR_PRV_CRNT_DATE_ALT | DATE | 0 | Period End Or Prv Crnt Date Alt | ||||
| QUARTER_END_OR_PRV_CRNT_DATE | DATE | 0 | Quarter End Or Prv Crnt Date | ||||
| QUARTER_END_OR_PRV_CRNT_DATE_ALT | DATE | 0 | Quarter End Or Prv Crnt Date Alt | ||||
| USER_PERIOD_SET_NAME | VARCHAR2 | 16 | User Period Set Name | ||||
| YEAR_END_OR_PRV_CRNT_DATE | DATE | 0 | Year End Or Prv Crnt Date | ||||
| YEAR_END_OR_PRV_CRNT_DATE_ALT | DATE | 0 | Year End Or Prv Crnt Date Alt | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |