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

PERSON_ID, ANCHOR_DATE

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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.