DW_PAY_RELATIONSHIP_D (Preview)

This table requires activation of Payroll Balances functional area. It stores information about payroll relationship

Details

Module: Global Payroll

Key Columns

PAY_RELATIONSHIP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PAY_RELATIONSHIP_ID NUMBER 38 0 True Pay Relationship Key    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier with establishment id    
PAY_RELATIONSHIP_NUMBER VARCHAR2 32     Pay Relationship Number    
START_DATE DATE       Start Date    
END_DATE DATE       End Date    
PERSON_ID NUMBER 38 0   Person Identifier    
PAYROLL_STAT_UNIT_ID NUMBER 38 0   Payroll Statutory Unit Identifier    

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