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 This column is for Oracle Internal use only. 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