CNTRIBFTRVW_LNG

(SQL View)
 Index Back

Rel Lang Look up view

This view will pop up the look up values for Contr. Factor.

SELECT A.INCIDENT_NBR , A.CONTRIB_FACTOR_CAN ,C.LANGUAGE_CD , C.DESCR50 FROM PS_INC_CONTFAC_CAN A , PS_CONTFAC_CAN_TBL B , PS_CONTFAC_CAN_LNG C , PS_INCIDENT_DATA I WHERE A.CONTRIB_FACTOR_CAN = B.CONTRIB_FACTOR_CAN AND A.INCIDENT_NBR = I.INCIDENT_NBR AND B.CONTRIB_FACTOR_CAN = C.CONTRIB_FACTOR_CAN AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CONTFAC_CAN_TBL B1 WHERE B1.CONTRIB_FACTOR_CAN = B.CONTRIB_FACTOR_CAN AND B1.EFFDT <= I.INCIDENT_DT) AND B.EFF_STATUS = 'A'

  • Related Language Record for CONTRIB_FTR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number
    2 CONTRIB_FACTOR_CAN Character(5) VARCHAR2(5) NOT NULL Contributing Factor Code

    Prompt Table: CONTFAC_CAN_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50