INJURY_ILL_AID(SQL Table) |
Index Back |
|---|---|
H&S - Injury First AidThis is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL_AID to record details about the first aid treatments the injured worker received |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 5 | TREATMENT_DT |
Date(10) | DATE NOT NULL |
Treatment Date
Default Value: INCIDENT_DATA.INCIDENT_DT |
| 6 | TREATMENT_TM |
Time(15) | TIMESTAMP NOT NULL | Treatment Time |
| 7 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Default Value: INJURY_ILL_VW.HS_TIMEZONE1 |
| 8 | TREATMENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Treatment Type
FA=First Aid MD=Medical NA=None Default Value: FA |
| 9 | AID_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
First Aider - Employee
Prompt Table: PERSON_NAME |
| 10 | AID_NON_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
First Aider - Non-Employee
Prompt Table: NE_PERS_NM_VW |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |