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 | Character(8) | VARCHAR2(8) NOT NULL | Incident Number | |
2 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
3 | Number(3,0) | SMALLINT NOT NULL | Empl Record | |
4 | Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID | |
5 | Date(10) | DATE NOT NULL |
Treatment Date
Default Value: INCIDENT_DATA.INCIDENT_DT |
|
6 | 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 |