EMPL_HA_IPE_BRA(SQL Table) |
Index Back |
---|---|
Hazard Table BRAHazard 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 |