INCIDENT_NBRPrompt Table: INCIDENT_DATA
PROPERTY_IDPrompt Table: VEH_EQUIP_VW
TAGSER_NUM_MEXEMPLIDPrompt Table: PERSON_NAME
NON_EMPLOYEE_IDPrompt Table: NE_INCIDNT_SRCH
B=Bystander/Pedestrian
D=Driver|Operator
P=Passenger
INC_VEH_EMP_MEX(SQL Table) |
Index Back |
|---|---|
Vehic/Equip Empls Invol MexicoEmployees details for Vehicle/Equipment Involved Mexico |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: INCIDENT_DATA |
| 2 | PROPERTY_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Property Code
Prompt Table: VEH_EQUIP_VW |
| 3 | TAGSER_NUM_MEX |
Character(25) | VARCHAR2(25) NOT NULL | Tag/Serial Number Mexico |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 5 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH |
| 6 | EMPLOYEE_ROLE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Role
B=Bystander/Pedestrian D=Driver|Operator P=Passenger |