GP_ABS_PGRPSRCH (SQL View)	Index Back
Abs Mgt Pay Group Search Rec Abs Mgt Pay Group Search Rec

GP_ABS_PGRPSRCH

(SQL View)

Abs Mgt Pay Group Search Rec

SELECT DISTINCT A.ABS_PAY_SYSTEM_CD ,B.XLATLONGNAME FROM PS_GP_ABS_PAYGROUP A , PSXLATITEM B WHERE B.FIELDNAME = 'ABS_PAY_SYSTEM_CD' AND B.FIELDVALUE = A.ABS_PAY_SYSTEM_CD

Related Language Record: GP_ABS_PGRP_LNG

# 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	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	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name