HGA_PIN_LANG

(SQL View)
 Index Back

Pay Item Names - Rel Language

Global Payroll Pay Item Names Related Language Record

SELECT PIN_NUM , LANGUAGE_CD , PIN_CODE , PIN_NM , DESCR , DESCR , DESCR FROM PS_GP_PIN_LANG

  • Related Language Record for HGA_PIN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 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)
    4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ABS_NAME Character(40) VARCHAR2(40) NOT NULL Absence Name
    7 ABS_ENT_DESR Character(40) VARCHAR2(40) NOT NULL Absence Entitlement