JOBCODE_HAZ_TBL (SQL Table)	Index Back
Hazard Codes identified by Job Use JOBCODE_HAZ_TBL to identify hazards in the workplace that are associated with a particular job. You must set up HAZARD_IDs on HAZ_CON_MAT_TBL before they can be used here. This data is part of the Health and Safety module.

JOBCODE_HAZ_TBL

(SQL Table)

Hazard Codes identified by Job

Use JOBCODE_HAZ_TBL to identify hazards in the workplace that are associated with a particular job. You must set up HAZARD_IDs on HAZ_CON_MAT_TBL before they can be used here. This data is part of the Health and Safety module.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_JOBC_VLD_VW

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

3 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
Default Value: OPR_DEF_TBL_HR.REG_REGION
Prompt Table: REG_HANDS_VW

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

5 DT_REPORTED Date(10) DATE NOT NULL Date Reported
Default Value: %date

6 DT_REMOVED Date(10) DATE Date Removed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_JOBC_VLD_VW
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
3	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_HANDS_VW
4	HAZARD_ID	Character(5)	VARCHAR2(5) NOT NULL	Hazard ID Prompt Table: HAZ_CON_MAT_TBL
5	DT_REPORTED	Date(10)	DATE NOT NULL	Date Reported Default Value: %date
6	DT_REMOVED	Date(10)	DATE	Date Removed