Module: Common
Type: Dimension
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal Period Set Name | ||||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Fiscal Period Type | ||||
| FISCAL_QUARTER_NUMBER | NUMBER | 38 | 0 | Fiscal Quarter Number | |||
| FISCAL_YEAR_NUMBER | NUMBER | 38 | 0 | Fiscal Year Number | |||
| SOURCE_RECORD_ID | VARCHAR2 | 111 | Source Record Id | ||||
| ACCOUNTING_CAL_FLAG | VARCHAR2 | 16 | Accounting Cal Flag | ||||
| CALENDAR_TYPE_CODE | VARCHAR2 | 32 | Calendar Type Code | ||||
| CURRENT_FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Current Fiscal Quarter Code | ||||
| CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Current Fiscal Year Code | ||||
| FIRST_QUARTER_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | First Quarter Fiscal Year Flag | ||||
| FISCAL_HALF_NUMBER | NUMBER | 38 | 0 | Fiscal Half Number | |||
| 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_START_DATE | DATE | 0 | Fiscal Quarter Start Date | ||||
| FISCAL_QUARTER_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Quarter Start Date ID | |||
| 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_QUARTER_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | Last Quarter Fiscal Year Flag | ||||
| NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number Per Fiscal Year | |||
| 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 | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |