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 | 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, 2023, Oracle and/or its affiliates.