HD_360_GP_CNTRY

(SQL View)
 Index Back

GP Country Config for HRHD

Returns the GP country tied to the GP paygroup if that country has been configured for the HR Help Desk GP List Sets: CRM_PAYMENTS or CRM_ABSENCE.

SELECT PE.COUNTRY , PG.GP_PAYGROUP , LS.GP_ELN_SET FROM PS_GP_PYGRP PG , PS_GP_PYENT PE , PS_GP_ELN_SET LS WHERE PE.PAY_ENTITY = PG.PAY_ENTITY AND LS.COUNTRY = PE.COUNTRY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
3 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set