GPBR_STG_LPCHVW

(SQL View)
 Index Back

Labor Proceedings BRA

Staging Record. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings.

SELECT LBR_CHG.GPBR_DRIVER_SEQ , LBR_CHG.GPBR_DRV_SPLIT_SEQ , LBR_CHG.SEQNBR , LBR_CHG.DECIS_DATE_BRA , LBR_CHG.GPBR_LABOR_CAT_CD , LBR_CHG.GPBR_NAT_ACTV FROM %Table(GPBR_STG_LP_CHG) LBR_CHG, %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_CHG.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_CHG.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.GPBR_STATUS = 'XRDY'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
4 DECIS_DATE_BRA Date(10) DATE Desicion Date Legal Proceedings table
5 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
6 GPBR_NAT_ACTV Character(1) VARCHAR2(1) NOT NULL eSocial Nature of Activity
0=Not Applicable
1=URBAN
2=RURAL