INC_ACTNCVW_LNG (SQL View)	Index Back
Incident Correct/Prevnt Action Related Language REcord for INC_ACTION_C_VW 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.

INC_ACTNCVW_LNG

(SQL View)

Incident Correct/Prevnt Action

Related Language REcord for INC_ACTION_C_VW 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.

SELECT INCIDENT_NBR , HAZARD_ID , INCIDENT_CAUSE , CORRECTIVE_PREVENT , ACTION_SEQUENCE , LANGUAGE_CD , CORRECTIVE_ACTION FROM PS_INC_ACTION_LNG A WHERE CORRECTIVE_PREVENT = 'C'

Related Language Record for INC_ACTION_C_VW

Parent record: INCDNT_ACTN_TYP

# 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 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
Prompt Table: HAZ_CON_MAT_TBL

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

4 CORRECTIVE_PREVENT Character(1) VARCHAR2(1) NOT NULL Corrective or Preventive Actn
C=Corrective Action
P=Preventive Action
Default Value: C

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

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 CORRECTIVE_ACTION Long Character CLOB Corrective Action

#	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	HAZARD_ID	Character(5)	VARCHAR2(5) NOT NULL	Hazard ID Prompt Table: HAZ_CON_MAT_TBL
3	INCIDENT_CAUSE	Character(40)	VARCHAR2(40) NOT NULL	Incident Cause
4	CORRECTIVE_PREVENT	Character(1)	VARCHAR2(1) NOT NULL	Corrective or Preventive Actn C=Corrective Action P=Preventive Action Default Value: C
5	ACTION_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Action Sequence
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	CORRECTIVE_ACTION	Long Character	CLOB	Corrective Action