GPBR_DRIVER_SEQGPBR_DRVJCD_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Job Codes Cross RefereeSocial Job Codes Cross Reference Table. This record is composed by fields that are common to events to Job Codes. Each event that shall be sent to the government has an entry on this table. |
| # | 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_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 6 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |