HS_SS_PEOPL_LNG

(SQL Table)
 Index Back

SS Incident People

Incident People workflow record for self service.

  • Related Language Record for HS_SS_PEOPL_DAT

  • Parent record: INCIDENT_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ACTION_DT_SS Date(10) DATE Transaction Date
    3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    4 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    5 HS_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID for Health and Safety
    6 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 COMMENTS Long Character CLOB Comment