HS_AWE_INCDT_LV

(SQL View)
 Index Back

Incident Details for AWE

Incident Details related language record for AWE.

SELECT HS1.EMPLID , HS1.ACTION_DT_SS , HS1.EFFSEQ , HS1.INCIDENT_NBR , HS1.LANGUAGE_CD , XL.XLATLONGNAME , NM.NAME_DISPLAY , HS1.LOCATION_NAME , HS1.EXACT_LOCATION , HS1.DESCRLONG FROM PS_HS_SS_INCDT_LNG HS1 , PS_HS_SS_INCDT_DAT HS2 , PSXLATITEM XL LEFT OUTER JOIN PSXLATITEMLANG XL1 ON XL1.FIELDNAME = XL.FIELDNAME , PS_PERSON_NAME NM LEFT OUTER JOIN PS_PERSON_NAME_LNG NML ON NML.EMPLID = NM.EMPLID WHERE HS1.EMPLID = HS2.EMPLID AND HS1.ACTION_DT_SS = HS2.ACTION_DT_SS AND HS1.EFFSEQ = HS2.EFFSEQ AND HS1.INCIDENT_NBR = HS2.INCIDENT_NBR AND XL.FIELDNAME = 'INCIDENT_TYPE' AND XL.FIELDVALUE = HS2.INCIDENT_TYPE AND %EffdtCheck(PSXLATITEM XL2, XL, %CurrentDateIn) AND NM.EMPLID = HS1.EMPLID AND XL1.LANGUAGE_CD = HS1.LANGUAGE_CD AND NML.LANGUAGE_CD = HS1.LANGUAGE_CD

  • Related Language Record for HS_AWE_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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    7 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    8 LOCATION_NAME Character(30) VARCHAR2(30) NOT NULL Location Name
    9 EXACT_LOCATION Character(240) VARCHAR2(240) NOT NULL Exact Location
    10 DESCRLONG Long Character CLOB Long Description