GPBR_DRIVER_SEQGPBR_EMP_LPT_VW(SQL View) |
Index Back |
|---|---|
Empl Data Based on CPF ViewThis view returns employe data based on the CPF stored in Labor Proceeding Tax BRA - Employee and reported thru eSocial Labor Proceeding Tax Cross Reference Table (S-2501 event). |
| SELECT A.GPBR_DRIVER_SEQ, A.GPBR_PRE_DRV_SEQ , B.GPBR_CPF_ID , C.EMPLID FROM PS_GPBR_DRVLPT_XRF A , PS_GPBR_ES_LPT_EMP B , PS_PERS_NID C WHERE B.COMPANY = A.COMPANY AND B.GPBR_PROC_NUM = A.GPBR_PROC_NUM AND B.GPBR_ESOC_YEAR = A.GPBR_ESOC_YEAR AND B.GPBR_ESOC_MONTHCD = A.GPBR_ESOC_MONTHCD AND C.COUNTRY = 'BRA' AND C.NATIONAL_ID_TYPE = 'CPF' AND C.NATIONAL_ID = B.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 |