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