HS_SS_INCDT_LVW

(SQL View)
Index Back

SS Incident Details Language

Related language Incident Details workflow record for self service.

SELECT L1.EMPLID , L1.ACTION_DT_SS , L1.EFFSEQ , L1.INCIDENT_NBR , L1.LANGUAGE_CD , L1.LOCATION_NAME , L1.EXACT_LOCATION , L1.DESCRLONG FROM PS_HS_SS_INCDT_LNG L1

  • Related Language Record for HS_SS_INCDT_VW
  • # 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
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name
    7 EXACT_LOCATION Character(240) VARCHAR2(240) NOT NULL Exact Location
    8 DESCRLONG Long Character CLOB Long Description