DW_BUDGET_ORG_INFORMATION_D (Preview)

This table requires activation of Position Management functional area. This table stores enterprise configuration for position budget

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ORG_INFORMATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ORG_INFORMATION_ID NUMBER 38 0 True Transaction system generated primary key column.
EFFECTIVE_START_DATE DATE True Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE True Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier This column contains JOB_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
ENTERPRISE_BUDGET_PATTERN VARCHAR2 256 Enterprise position budget pattern
ENTERPRISE_BUDGET_CURRENCY VARCHAR2 256 Enterprise position budget currency
ORG_INFORMATION_CONTEXT VARCHAR2 128 Organization information context