GPFR_DA_2SITLNG

(SQL View)
 Index Back

Begin Situation Code Rel Lang

DADS related record: GPFR_DA_2SIT_VW Related Language record

SELECT A.GPFR_DA_OVR_B_SIT , B.LANGUAGE_CD , B.GPFR_DA_DESCR FROM PS_GPFR_DA_CD_VW2 A , PS_GPFR_DA_COD_LNG B WHERE A.GPFR_DA_DATTYP = B.GPFR_DA_DATTYP AND A.GPFR_DA_OVR_B_SIT = B.GPFR_DA_CODE AND A.GPFR_DA_DATTYP = 'STREAS' AND A.GPFR_DA_STATUS = 'A'

  • Related Language Record for GPFR_DA_2SIT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 GPFR_DA_DESCR Character(60) VARCHAR2(60) NOT NULL DADS related field