GPBR_DRIVER_SEQGPBR_EVENT_CDEMPLIDEMPL_RCDPPP_EXAM_TYPE_BRAA=New Hire
D=Termination
M=Job/Position Change
P=Periodical according to PCMSO
R=Return to Work
S=Specific Monitoring
ASO_DT_BRAGPBR_DRVHS_XRF(SQL Table) |
Index Back |
|---|---|
eSocial HealthSafety CrosseSocial Health and Safety Cross Reference 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | PPP_EXAM_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
PPP Exam Type
A=New Hire D=Termination M=Job/Position Change P=Periodical according to PCMSO R=Return to Work S=Specific Monitoring |
| 6 | ASO_DT_BRA |
Date(10) | DATE NOT NULL | ASO date. |
| 7 | GPBR_ES_PS | Date(10) | DATE | eSocial on PeopleSoft Date |
| 8 | GPBR_RECT | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Ind Calculation |
| 9 | GPBR_PRE_DRV_SEQ | Number(30,0) | DECIMAL(30) NOT NULL | eSocial Pre Driver Sequence |