GPBR_STG_LPUNVW (SQL View)	Index Back
Labor Proceedings BRA Staging Record. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings.

GPBR_STG_LPUNVW

(SQL View)

Labor Proceedings BRA

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

SELECT LBR_UN.GPBR_DRIVER_SEQ , LBR_UN.GPBR_DRV_SPLIT_SEQ , LBR_UN.SEQNBR , LBR_UN.REG_ESOCIAL_BRA , LBR_UN.GPBR_LABOR_CAT_CD , LBR_UN.GPBR_HIRE_TSV_DT FROM %Table(GPBR_STG_LP_UN) LBR_UN, %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_UN.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_UN.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 REG_ESOCIAL_BRA Character(30) VARCHAR2(30) NOT NULL eSocial Reg. Number

5 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code

6 GPBR_HIRE_TSV_DT Date(10) DATE Hire TSV Date

#	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	REG_ESOCIAL_BRA	Character(30)	VARCHAR2(30) NOT NULL	eSocial Reg. Number
5	GPBR_LABOR_CAT_CD	Character(3)	VARCHAR2(3) NOT NULL	eSocial Labor Category Legal Code
6	GPBR_HIRE_TSV_DT	Date(10)	DATE	Hire TSV Date