ILL_ACTION_GER (SQL Table)	Index Back
Incident Correct/Prevnt Action This is one of several records used in the Health and Safety module to record in-depth information about a health/safety-related incident in the workplace. Use INCDNT_ACTN_TYP and INCIDENT_ACTION to specify actions that could have been taken to prevent the incident or could be taken afterward to correct the hazard and prevent a recurrence.

ILL_ACTION_GER

(SQL Table)

Incident Correct/Prevnt Action

This is one of several records used in the Health and Safety module to record in-depth information about a health/safety-related incident in the workplace. Use INCDNT_ACTN_TYP and INCIDENT_ACTION to specify actions that could have been taken to prevent the incident or could be taken afterward to correct the hazard and prevent a recurrence.

Parent record: INCDNT_ACTN_TYP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW

3 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
Prompt Table: NE_INCIDNT_SRCH

4 ILLNESS_NBR_GER Character(8) VARCHAR2(8) NOT NULL Illness Number

5 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
Prompt Table: HAZ_CON_MAT_TBL

6 INCIDENT_CAUSE Character(40) VARCHAR2(40) NOT NULL Incident Cause

7 CORRECTIVE_PREVENT Character(1) VARCHAR2(1) NOT NULL Corrective or Preventive Actn
C=Corrective Action
P=Preventive Action

8 ACTION_SEQUENCE Number(2,0) SMALLINT NOT NULL Action Sequence

9 ACTION_CATEGORY Character(3) VARCHAR2(3) NOT NULL Action Category
BAR=Install Protective Barrier
COM=Employee Communication
EQP=Utilize Safety Equipment
FIX=Fix or repair
INS=Conduct Inspections
PRO=Institute Safety Procedures
TRN=Safety Training
WRN=Warning signs

10 ACTION_STATUS Character(1) VARCHAR2(1) NOT NULL Action Status
C=Completed
I=In Progress
P=Planned
R=Recommended
V=Existing
Default Value: R

11 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
Prompt Table: PERSON

12 EST_COMPLETION_DT Date(10) DATE Estimated Completion Date

13 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date

14 PREVENT_ACT_CD_GER Character(3) VARCHAR2(3) NOT NULL Preventative Action Code
Prompt Table: PREVENT_ACT_GER

15 CORRECT_ACT_CD_GER Character(3) VARCHAR2(3) NOT NULL Corrective Actions
Prompt Table: CORRECT_ACT_GER

16 CORRECTIVE_ACTION Long Character CLOB Corrective Action

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: PER_ORG_ASGN_VW
3	NON_EMPLOYEE_ID	Character(11)	VARCHAR2(11) NOT NULL	Non-Employee ID Prompt Table: NE_INCIDNT_SRCH
4	ILLNESS_NBR_GER	Character(8)	VARCHAR2(8) NOT NULL	Illness Number
5	HAZARD_ID	Character(5)	VARCHAR2(5) NOT NULL	Hazard ID Prompt Table: HAZ_CON_MAT_TBL
6	INCIDENT_CAUSE	Character(40)	VARCHAR2(40) NOT NULL	Incident Cause
7	CORRECTIVE_PREVENT	Character(1)	VARCHAR2(1) NOT NULL	Corrective or Preventive Actn C=Corrective Action P=Preventive Action
8	ACTION_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Action Sequence
9	ACTION_CATEGORY	Character(3)	VARCHAR2(3) NOT NULL	Action Category BAR=Install Protective Barrier COM=Employee Communication EQP=Utilize Safety Equipment FIX=Fix or repair INS=Conduct Inspections PRO=Institute Safety Procedures TRN=Safety Training WRN=Warning signs
10	ACTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Action Status C=Completed I=In Progress P=Planned R=Recommended V=Existing Default Value: R
11	RESPONSIBLE_ID	Character(11)	VARCHAR2(11) NOT NULL	Responsible ID Prompt Table: PERSON
12	EST_COMPLETION_DT	Date(10)	DATE	Estimated Completion Date
13	ACT_COMPLETION_DT	Date(10)	DATE	Actual Completion Date
14	PREVENT_ACT_CD_GER	Character(3)	VARCHAR2(3) NOT NULL	Preventative Action Code Prompt Table: PREVENT_ACT_GER
15	CORRECT_ACT_CD_GER	Character(3)	VARCHAR2(3) NOT NULL	Corrective Actions Prompt Table: CORRECT_ACT_GER
16	CORRECTIVE_ACTION	Long Character	CLOB	Corrective Action