GPCH_P_UNIT_VW

(SQL View)
 Index Back

Payroll Unit prompt table

This view retrieves data from Group List table to show them as Payroll Unit.

SELECT GROUP_LIST_ID , DESCR , DESCRSHORT , OPRID FROM PS_GP_GRP_LIST

  • Related Language Record: GPCH_PU_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCH_PAYROLL_UNIT Character(10) VARCHAR2(10) NOT NULL Type of Absence
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).