| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INCIDENT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Incident Type
A=Accident
B=Industrial Accident
C=Contamination
D=Industrial Accident (Official)
E=Exposure
H=Hazardous Condition
I=Incident
L=Illness
M=Near Miss
N=Injury
O=Dangerous Occurrence
P=Unsafe Practice
R=Environmental
S=Safety Violation
V=Vehicle/Equipment Accident
|
| 2 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_HANDS_VW
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
HS_ESS_AVAIL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Self-Service flag
Y/N Table Edit
Default Value: N
|
| 6 |
HS_MSS_AVAIL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Self-Service flag
Y/N Table Edit
Default Value: N
|
| 7 |
HS_APPR_REQ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Required flag
Y/N Table Edit
Default Value: N
|
| 8 |
HS_EMAIL_NOTIF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Email Notification flag
Y/N Table Edit
Default Value: N
|
| 9 |
HS_PUSH_NOTIF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Push Notification flag
Y/N Table Edit
Default Value: N
|
| 10 |
HS_ENABLE_AWE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Approval Workflow Engine (AWE) Flag
Y/N Table Edit
Default Value: N
|
| 11 |
EOAWPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table:
HS_AWE_PRCS_VW
|
| 12 |
EOAWDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table:
HS_AWE_DEFN_VW
|
| 13 |
AGC_TEMPLATE_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
Activity Guide Composer Template Id
Prompt Table:
AGC_TMPL_CAT_VW
|
| 14 |
HS_EMPL_NOTIF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Notification flag
Y/N Table Edit
Default Value: N
|
| 15 |
HS_ADMIN_NOTIF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Administrator Notification flag
Y/N Table Edit
Default Value: N
|
| 16 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N
|