CONTRIB_FTR_VW

(SQL View)
 Index Back

Look up view

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

SELECT A.INCIDENT_NBR , A.CONTRIB_FACTOR_CAN , B.DESCR50 FROM PS_INC_CONTFAC_CAN A , PS_CONTFAC_CAN_TBL B , PS_INCIDENT_DATA I WHERE A.CONTRIB_FACTOR_CAN = B.CONTRIB_FACTOR_CAN AND A.INCIDENT_NBR = I.INCIDENT_NBR 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: CNTRIBFTRVW_LNG

    • # 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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50