GPGB_PIN_VW

(SQL View)
 Index Back

Pay Item Name Definition

This is the main record for setting up/maintaining Pay Item Name elements in the Global Payroll system.

SELECT DISTINCT C.OPRID ,GP.PIN_CODE ,GP.PIN_TYPE ,GP.DESCR ,C.COUNTRY FROM PS_GP_PIN GP , PS_GP_OPR_RULE_PRF C WHERE GP.PIN_TYPE IN ('DD','ER') AND (GP.USED_BY = 'A' OR (GP.USED_BY = 'C' AND C.USED_BY= 'A') OR (GP.USED_BY = 'C' AND GP.COUNTRY = C.COUNTRY))

  • Related Language Record: GPGB_PIN_LNGVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

    Default Value: GP_PIN.PIN_NM

    3 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY_VW