GPMX_OVR_VW_LNG

(SQL View)
 Index Back

Overtime Shift Table REL LNG

Overtime Shift Related Language Table.

SELECT GP_PAYGROUP , BGN_DT , GPMX_SHIFT ,LANGUAGE_CD , DESCR , DESCRSHORT FROM PS_GPMX_OSHIFT_LNG

  • Related Language Record for GPMX_OVRSHIFT_V

  • Parent record: GPMX_OSHIFT_V_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP

    2 BGN_DT Date(10) DATE NOT NULL Begin Date

    Default Value: %DATE

    3 GPMX_SHIFT Character(1) VARCHAR2(1) NOT NULL Shift
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description