DW_BC_PERIOD_STATUS_D (Preview)
This table requires activation of Budgetary Control functional area. This table stores the periods statuses for control budgets which control when budget is available for consumption.
Details
Module: Budgetary Control
Key Columns
PERIOD_STATUS_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PERIOD_STATUS_ID | NUMBER | 38 | 0 | True | Period Status Unique Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source record identifier. | ||||
| CONTROL_BUDGET_ID | NUMBER | 38 | 0 | Control Budget Identifier | |||
| PERIOD_NAME | VARCHAR2 | 32 | Control budget period name user identifier | ||||
| EFFECTIVE_PERIOD_NUM | NUMBER | 38 | 0 | Effective period number of the period | |||
| START_DATE | DATE | Date on which control budget period begins | |||||
| END_DATE | DATE | Date on which control budget period ends | |||||
| QUARTER_NUM | NUMBER | 38 | 0 | Quarter number of the control budget period | |||
| PERIOD_YEAR | NUMBER | 38 | 0 | Budget year of the control budget period | |||
| PERIOD_NUM | NUMBER | 38 | 0 | Control budget period number internal identifier | |||
| FISCAL_YEAR | VARCHAR2 | 32 | Fiscal year of the control budget | ||||
| STATUS_CODE | VARCHAR2 | 32 | Control budget period status to indicate whether budget activity is allowed | ||||
| BUDGET_EFFECTIVE_PERIOD_NUM | NUMBER | 38 | 0 | Effective period number. Gaps due to adjustment periods are removed. | |||
| BUDGET_PERIOD_NUM | NUMBER | 38 | 0 | Period number. Gaps due to adjustment periods are removed. | |||
| CREATED_BY_USER_ID | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
| UPDATED_BY_USER_ID | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |