Module: Common
Type: Dimension
FISCAL_DAY_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| FISCAL_DAY_DATE | DATE | 0 | True | Fiscal Day Date | |||
| SOURCE_RECORD_ID | VARCHAR2 | 20 | 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_DAY_CODE | VARCHAR2 | 16 | Current Fiscal Day Code | ||||
| CURRENT_FISCAL_PERIOD_CODE | VARCHAR2 | 16 | Current Fiscal Period Code | ||||
| CURRENT_FISCAL_QUARTER_CODE | VARCHAR2 | 16 | Current Fiscal Quarter Code | ||||
| CURRENT_FISCAL_WEEK_CODE | VARCHAR2 | 16 | Current Fiscal Week Code | ||||
| CURRENT_FISCAL_YEAR_CODE | VARCHAR2 | 16 | Current Fiscal Year Code | ||||
| FIRST_DAY_FISCAL_PERIOD_FLAG | VARCHAR2 | 16 | First Day Fiscal Period Flag | ||||
| FIRST_DAY_FISCAL_QUARTER_FLAG | VARCHAR2 | 16 | First Day Fiscal Quarter Flag | ||||
| FIRST_DAY_FISCAL_WEEK_FLAG | VARCHAR2 | 16 | First Day Fiscal Week Flag | ||||
| FIRST_DAY_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | First Day Fiscal Year Flag | ||||
| FISCAL_DAY_CODE | VARCHAR2 | 64 | Fiscal Day Code | ||||
| FISCAL_DAY_DATE_ID | NUMBER | 38 | 0 | Fiscal Day Date ID | |||
| FISCAL_DAY_OF_PERIOD | NUMBER | 38 | 0 | Fiscal Day Of Period | |||
| FISCAL_DAY_OF_QUARTER | NUMBER | 38 | 0 | Fiscal Day Of Quarter | |||
| FISCAL_DAY_OF_WEEK | NUMBER | 38 | 0 | Fiscal Day Of Week | |||
| FISCAL_DAY_OF_YEAR | NUMBER | 38 | 0 | Fiscal Day Of Year | |||
| 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_NAME | VARCHAR2 | 64 | Fiscal Period Name | ||||
| FISCAL_PERIOD_NUMBER | NUMBER | 38 | 0 | Fiscal Period Number | |||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Fiscal Period Set Name | ||||
| 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_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_WEEK_END_DATE | DATE | 0 | Fiscal Week End Date | ||||
| FISCAL_WEEK_END_DATE_ID | NUMBER | 38 | 0 | Fiscal Week End Date ID | |||
| FISCAL_WEEK_NUMBER | NUMBER | 38 | 0 | Fiscal Week Number | |||
| FISCAL_WEEK_START_DATE | DATE | 0 | Fiscal Week Start Date | ||||
| FISCAL_WEEK_START_DATE_ID | NUMBER | 38 | 0 | Fiscal Week Start Date ID | |||
| 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_NUMBER | NUMBER | 4 | 0 | Fiscal Year Number | |||
| 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_DAY_FISCAL_PERIOD_FLAG | VARCHAR2 | 16 | Last Day Fiscal Period Flag | ||||
| LAST_DAY_FISCAL_QUARTER_FLAG | VARCHAR2 | 16 | Last Day Fiscal Quarter Flag | ||||
| LAST_DAY_FISCAL_WEEK_FLAG | VARCHAR2 | 16 | Last Day Fiscal Week Flag | ||||
| LAST_DAY_FISCAL_YEAR_FLAG | VARCHAR2 | 16 | Last Day Fiscal Year Flag | ||||
| NUMBER_PER_FISCAL_YEAR | NUMBER | 38 | 0 | Number Per Fiscal Year | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |