This table requires activation of Payroll Balances functional area. It stores information about payroll relationship
Module: Global Payroll
PAY_RELATIONSHIP_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.