DW_FUNDING_POSITION_D (Preview)

This table requires activation of Position Management functional area. Stores relationships between positions and their funding positions

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, FUNDING_RELATIONSHIP_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
FUNDING_RELATIONSHIP_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 FUNDING_RELATIONSHIP_ID,EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
POSITION_ID NUMBER 38 0 Position Identifier
FUNDING_POSITION_ID NUMBER 38 0 Funding Position Identifier
BUSINESS_GROUP_ID NUMBER 38 0 Business Group identifier