GPBR_DRIVER_SEQGPBR_DRVSHF_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Shifts Cross ReferenceeSocial Shifts Cross Reference Table. This record is composed by fields that are common to events to Shifts. 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 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL | Shift ID |
| 5 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 6 | GPBR_PRV_DT | Date(10) | DATE | eSocial Previous Date |