HS_SS_INCDT_DAT

(SQL Table)
 Index Back

SS Incident Details

Incident Details workflow record for self service.

  • Related Language Record: HS_SS_INCDT_LNG

  • Parent Record Of HS_SS_INCDT_ATT HS_SS_INJRY_DAT HS_SS_OTHER_DAT HS_SS_OTHER_LNG HS_SS_PEOPL_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 ACTION_DT_SS Date(10) DATE NOT NULL Transaction Date

    Default Value: %date

    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Default Value: 00000000

    5 OSHA_UNDETERMINED Character(1) VARCHAR2(1) NOT NULL Time Undetermined

    Y/N Table Edit

    Default Value: N

    6 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
    7 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_HANDS_VW

    8 DANGER_OCC_CD Character(4) VARCHAR2(4) NOT NULL Dangerous Occurrence Code

    Prompt Table: DANGER_OCC_TBL

    9 INCIDENT_DT Date(10) DATE Incident Date
    10 INCIDENT_TIME Time(15) TIMESTAMP Incident Time
    11 HS_TIMEZONE1 Character(9) VARCHAR2(9) NOT NULL Health and Safety Time Zone Field 1

    Prompt Table: PSTIMEZONE_VW

    12 RECURRENCE Character(1) VARCHAR2(1) NOT NULL Is This a Recurrence

    Y/N Table Edit

    Default Value: N

    13 RESULT_INJURY_ILL Character(1) VARCHAR2(1) NOT NULL Resulted in Injury or Illness

    Y/N Table Edit

    Default Value: N

    14 REPORTED_BY_EMPL Character(11) VARCHAR2(11) NOT NULL Reported By Empl ID

    Prompt Table: PERSON_NAME

    15 REPORTED_BY_NONEMP Character(11) VARCHAR2(11) NOT NULL Reported By Non-Empl ID

    Prompt Table: NE_INCIDNT_SRCH

    16 REPORTED_TO Character(11) VARCHAR2(11) NOT NULL Reported To Empl ID

    Prompt Table: PERSON_NAME

    17 DT_REPORTED Date(10) DATE Date Reported

    Default Value: %date

    18 TIME_REPORTED Time(15) TIMESTAMP Time Reported
    19 DT_RECORDED Date(10) DATE Date Recorded

    Default Value: %date

    20 TIME_RECORDED Time(15) TIMESTAMP Time Recorded
    21 INVESTIGATED Character(1) VARCHAR2(1) NOT NULL Investigated

    Y/N Table Edit

    Default Value: N

    22 EMPLOYER_PREMISES Character(1) VARCHAR2(1) NOT NULL Occurred on Employer Premises

    Y/N Table Edit

    Default Value: Y

    23 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SET_VLD_HR_03

    24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HS_LOCATION_VW

    25 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: %EDITTABLE

    26 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name
    27 EXACT_LOCATION Character(240) VARCHAR2(240) NOT NULL Exact Location
    28 ROAD_CONDITION Character(1) VARCHAR2(1) NOT NULL Road Condition
    D=Dry
    I=Icy
    L=Loose Sand/Gravel
    M=Muddy
    N=Not Applicable
    S=Snow
    W=Wet
    29 WEATHER_CONDITION Character(2) VARCHAR2(2) NOT NULL Weather Condition
    CL=Cloudy
    EQ=Earthquake
    FF=Flash Flood
    FL=Flood
    FO=Foggy
    HU=Hurricane
    NA=Not Applicable
    RA=Rain
    SL=Sleet
    SN=Snow
    SU=Sunny/Clear
    TO=Tornado
    UN=Unclassified
    30 DESCRLONG Long Character CLOB Long Description
    31 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    32 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    33 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    34 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    35 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    36 CITY Character(30) VARCHAR2(30) NOT NULL City
    37 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    38 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    39 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    40 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    41 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    42 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    43 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    44 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    45 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    46 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    47 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    48 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    49 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    50 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    51 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    52 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    53 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    54 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    55 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    56 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    57 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    58 HS_SS_STATUS Character(1) VARCHAR2(1) NOT NULL Health and Safety self-service status
    A=Received
    D=Employee Declined
    M=More Information Requested
    N=Request Denied
    P=In Progress
    R=Approved
    S=Submitted
    V=Recorded

    Default Value: P

    59 AGC_LIST_ID Character(31) VARCHAR2(31) NOT NULL Activity Guide Composer List Id

    Prompt Table: AGC_TMPL_TBL

    60 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    61 HS_DATA_SOURCE Character(1) VARCHAR2(1) NOT NULL Data Source
    1=Employee Self Service
    2=Manager Self Service

    Default Value: 1