SSFAPCTNDVWLNG

(SQL View)
Index Back

App Center Tender Lang View

Related Language for SSF_APCTRTND_VW.

SELECT A.INSTITUTION , A.ADM_APPL_CTR , A.EFFDT , L1.LANGUAGE_CD , L1.DESCR FROM PS_SSF_APCTRTNC_VW A , PS_SSFAPCTNCVWLNG L1 WHERE A.EFF_STATUS = 'A' AND %EffdtCheck( SSF_APCTRTNC_VW S1,A, %CurrentDateIn) AND A.INSTITUTION = L1.INSTITUTION AND A.ADM_APPL_CTR = L1.ADM_APPL_CTR AND A.EFFDT = L1.EFFDT UNION SELECT B.INSTITUTION , B.ADM_APPL_CTR , B.EFFDT , L2.LANGUAGE_CD , L2.DESCR FROM PS_SSF_APCTRTNE_VW B , PS_SSFAPCTNEVWLNG L2 WHERE B.EFF_STATUS = 'A' AND %EffdtCheck( SSF_APCTRTNE_VW S2,B, %CurrentDateIn) AND B.INSTITUTION = L2.INSTITUTION AND B.ADM_APPL_CTR = L2.ADM_APPL_CTR AND B.EFFDT = L2.EFFDT

  • Related Language Record for SSF_APCTRTND_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description