JOBCD_H_LOC_BRA(SQL Table) | 
Index Back | 
|---|---|
Job Code Hazard Locations BRAJob Code Hazard Locations Brazil | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
SetID
 Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_LOC_VLD_VW  | 
|
| 2 | Character(6) | VARCHAR2(6) NOT NULL | 
Job Code
 Prompt Table: JOBCODE_TBL  | 
|
| 3 | Character(5) | VARCHAR2(5) NOT NULL | 
Regulatory Region
 Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_HANDS_VW  | 
|
| 4 | Character(5) | VARCHAR2(5) NOT NULL | 
Hazard ID
 Prompt Table: HAZARD_TBL_BRA  | 
|
| 5 | Character(10) | VARCHAR2(10) NOT NULL | 
Location Code
 Prompt Table: LOCATION_TBL  |