GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQNATIONAL_IDGPBR_STG_LPDEVW(SQL View) |
Index Back |
|---|---|
Labor Proceedings BRAStaging Record. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings. |
| SELECT LBR_DEP.GPBR_DRIVER_SEQ , LBR_DEP.GPBR_DRV_SPLIT_SEQ , LBR_DEP.NATIONAL_ID , LBR_DEP.RELATIONSHIP , LBR_DEP.GPBR_DESCR1 FROM %Table(GPBR_STG_LP_DEP) LBR_DEP , %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_DEP.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_DEP.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 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 4 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 5 | GPBR_DESCR1 | Character(35) | VARCHAR2(35) NOT NULL | eSocial Events Monitor - generic description. |