GPFR_DA_2SIT_VW

(SQL View)
 Index Back

Situation Begin Code

DADS related record: returns situation begin codes that work by pairs

SELECT DISTINCT A.GPFR_DA_OVR_B_SIT , A.GPFR_DA_DESCR , B.GPFR_DA_CODE FROM PS_GPFR_DA_CD_VW2 A , PS_GPFR_DA_CODE B WHERE A.GPFR_DA_DATTYP = 'STREAS' AND B.GPFR_DA_DATTYP = 'ENDREAS' AND A.GPFR_DA_STATUS = 'A' AND B.GPFR_DA_STATUS = 'A' AND A.GPFR_DA_DESCR = B.GPFR_DA_DESCR AND A.GPFR_DA_OVR_B_SIT <> '097'

  • Related Language Record: GPFR_DA_2SITLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPFR_DA_OVR_B_SIT Character(3) VARCHAR2(3) NOT NULL DADS related field.
    2 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field
    3 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field