GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQEMPLIDEMPL_RCDEXAM_TYPE_BRAH=Hire
P=Professional Driver
T=Termination
EXAM_DTGPBR_DRVTOX_XRF(SQL Table) |
Index Back |
|---|---|
eSocial Toxicological CrossRefeSocial Toxicological Exam Cross Reference Table This record is composed by fields that are common to events of Toxicological Exam (S-2221). 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_DRV_SPLIT_SEQ |
Number(20,0) | DECIMAL(20) NOT NULL | eSocial - Split Sequence |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | EXAM_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Exam type.
H=Hire P=Professional Driver T=Termination |
| 6 | EXAM_DT |
Date(10) | DATE | Exam Date |
| 7 | GPBR_EVENT_CD | Character(6) | VARCHAR2(6) NOT NULL | eSocial - Event Code |
| 8 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 9 | GPBR_RECT | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Ind Calculation |
| 10 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |