HS_SS_CONTEXT(SQL Table) |
Index Back |
|---|---|
Employee Context RecordHealth and Safety Employee Context Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | ACTION_DT_SS | Date(10) | DATE | Transaction Date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 6 | INCIDENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Incident Type
A=Accident B=Industrial Accident C=Contamination D=Industrial Accident (Official) E=Exposure H=Hazardous Condition I=Incident L=Illness M=Near Miss N=Injury O=Dangerous Occurrence P=Unsafe Practice R=Environmental S=Safety Violation V=Vehicle/Equipment Accident |