EMPL_HA_IPE_BRA

(SQL Table)
Index Back

Hazard Table BRA

Hazard Table Brazil

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 HAZARD_ID Character(5) VARCHAR2(5) NOT NULL Hazard ID
6 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created
7 IPE_CODE_BRA Character(10) VARCHAR2(10) NOT NULL IPE Code BRA Value

Prompt Table: PROT_EQUPMT_BRA

8 IPE_INFO_BRA Character(1) VARCHAR2(1) NOT NULL IPE_INFO_BRA Information
9 IPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

10 IPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

11 IPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

12 IPE_INFO_QU4_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

13 IPE_INFO_QU5_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

14 IPE_INFO_QU6_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y

15 IPE_INFO_QU7_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes

Default Value: Y