DW_PAY_RUN_BALANCE_ASG_D (Preview)

This table requires activation of Payroll Balances functional area. Load Payroll Balances assignment. Identifies unique inactive primary assignment for a person id for a date.

Details

Module: Global Payroll

Key Columns

ANCHOR_DATE, PERSON_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PERSON_ID NUMBER 38 0 True Person Identifier DW_PERSON_D PERSON_ID
ANCHOR_DATE DATE True Anchoring Date
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier, This column contains RUN_BALANCE_ID
HR_ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
HR_ASSIGNMENT_ID_ACTIVE NUMBER 38 0 Assignment Identifier
ACTIVE_ASG NUMBER 38 0 Assignment Identifier