ABS_PAY_SYSTEM_CDNA=Payroll for North America
PI=Payroll Interface
LANGUAGE_CDGP_ABS_ERDD_LNG(SQL View) |
Index Back |
|---|---|
Abs Mgt Ern Ded Map Search RecRelated Language record to GP_ABS_ERDDSRCH |
| SELECT DISTINCT A.ABS_PAY_SYSTEM_CD ,B.LANGUAGE_CD ,B.XLATLONGNAME FROM PS_GP_ABS_ERN_DED A , PSXLATITEMLANG B WHERE B.FIELDNAME = 'ABS_PAY_SYSTEM_CD' AND B.FIELDVALUE = A.ABS_PAY_SYSTEM_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ABS_PAY_SYSTEM_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Payroll System - used for Mapping purposes for Earnings/Deductions and Paygroups between Absence Management and Payroll for North America/Payroll Interface
NA=Payroll for North America PI=Payroll Interface |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |