GPBR_STG_LPCAVW

(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_CA.GPBR_DRIVER_SEQ , LBR_CA.GPBR_DRV_SPLIT_SEQ , LBR_CA.SEQNBR , LBR_CA.PAYMENT_DT , LBR_CA.GPBR_VLREC , LBR_CA.CONT_SAL_TYPE_BRA , LBR_CA.GPBR_SAL_DESC FROM %Table(GPBR_STG_LP_CA) LBR_CA, %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_CA.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_CA.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 PAYMENT_DT Date(10) DATE Payment Date
5 GPBR_VLREC Number(17,2) DECIMAL(16,2) NOT NULL eSocial Payment
6 CONT_SAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Contract Salary Type Brazil
1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
7 GPBR_SAL_DESC Character(90) VARCHAR2(90) NOT NULL Salary Description