| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: HS_SS_INCDT_DAT.EMPLID
Prompt Table:
PERSON
|
| 2 |
ACTION_DT_SS |
Date(10) |
DATE NOT NULL |
Transaction Date
Default Value: HS_SS_INCDT_DAT.ACTION_DT_SS
|
| 3 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: HS_SS_INCDT_DAT.EFFSEQ
|
| 4 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Default Value: HS_SS_INCDT_DAT.INCIDENT_NBR
|
| 5 |
HS_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID for Health and Safety
Prompt Table:
HS_SS_JOB_SRCH
|
| 6 |
NON_EMPLOYEE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Non-Employee ID
Prompt Table:
NE_INCIDNT_SRCH
|
| 7 |
INCIDENT_ROLE |
Character(2) |
VARCHAR2(2) NOT NULL |
Incident Role
BP=Bystander/Pedestrian
DO=Driver/Operator Of Vehicle
EW=Eyewitness
IN=Investigator
IW=Witness
OP=Other Party
PA=Passenger In Vehicle
PO=Property Owner
PW=Pet Owner
VO=Vehicle Owner
|
| 8 |
RESPONSIBLE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Responsible For Incident
Y/N Table Edit
Default Value: N
|
| 9 |
TRUSTWORTHY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Trustworthy Person
Y/N Table Edit
Default Value: N
|
| 10 |
ABLE_TO_ANSWER_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Able To Answer Questions
Y/N Table Edit
Default Value: N
|
| 11 |
CONFIRM_STATEMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirm Statement
N=Does not confirm statement
U=Unknown confirmation
Y=Confirms statements
|
| 12 |
DRUG_INFLUENCE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Under The Influence Of Drugs
Y/N Table Edit
Default Value: N
|
| 13 |
DRUG_CLASS_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Drug Class
A=Alcohol
H=Hard Drugs
M=Medication
O=Other Drugs
S=Soft Drugs
|
| 14 |
COMMENTS |
Long Character |
CLOB |
Comment
|