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.
Module: Budgetary Control
PERIOD_STATUS_ID
| 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. | |||
| FUNDS_RELEASE_ID | NUMBER | 38 | 0 | Temporary processing identifier to group periods when sharing funds across periods. The value is cleared once the process to release pending funds to summary control budget completes successfully. | |||
| ARCHIVED_BUDGET_ENTRIES_FLAG | VARCHAR2 | 16 | Indicates whether there are archived budget entries. | ||||
| ARCHIVED_ACTIVITIES_FLAG | VARCHAR2 | 16 | Indicates whether there are archived activities. | ||||
| 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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.