GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQSEQNBRGPBR_DESCR254GPBR_STG_LPCOVW(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_COM.GPBR_DRIVER_SEQ , LBR_COM.GPBR_DRV_SPLIT_SEQ , LBR_COM.SEQNBR , LBR_COM.GPBR_DESCR254 FROM %Table(GPBR_STG_LP_COM) LBR_COM, %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_COM.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_COM.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 | GPBR_DESCR254 |
Character(254) | VARCHAR2(254) NOT NULL | Description. |