GPBR_DRIVER_SEQGPBR_EMP_LBR_VW(SQL View) |
Index Back |
|---|---|
Empl Data Based on CPF ViewThis view returns employe data based on the CPF stored in eSocial Labor Proceedings Cross Reference Table (S-2500 event). |
| SELECT A.GPBR_DRIVER_SEQ, A.GPBR_PRE_DRV_SEQ , A.GPBR_CPF_ID , B.EMPLID FROM PS_GPBR_DRVLBR_XRF A , PS_PERS_NID B WHERE B.COUNTRY = 'BRA' AND B.NATIONAL_ID_TYPE = 'CPF' AND B.NATIONAL_ID = A.GPBR_CPF_ID |
| # | 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_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |
| 3 | GPBR_CPF_ID | Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |