GPBR_LCAT_CD_VW

(SQL View)
 Index Back

Labor Category Code

eSocial Labor Category Legal Code prompt view

SELECT GPBR_LABOR_CAT_CD , EFFDT , DESCR50 FROM %Table(GPBR_L_CAT_CODE) WHERE EFF_STATUS = 'A'

  • Related Language Record: GPBR_LCCDVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50