SSR_TRNSFR_LANG

(SQL View)
 Index Back

Source Transfer View

This view is used as a prompt for Transfer Source Id containing a list of External Organizations and Institutions which are valid sources of transfer credits. This is a related language record for SSR_TRNSFR_VW

SELECT a.EXT_ORG_ID ,a2.LANGUAGE_CD ,a.EFFDT ,a.EFF_STATUS ,a2.DESCR FROM PS_EXT_ORG_TBL_ADM a ,PS_EXT_ORG_LANG a2 WHERE a.OFFERS_COURSES = 'Y' AND a.EXT_ORG_ID = a2.EXT_ORG_ID AND a.EFFDT = a2.EFFDT UNION SELECT b.INSTITUTION ,b1.LANGUAGE_CD ,b.EFFDT ,b.EFF_STATUS ,b1.DESCR FROM PS_INSTITUTION_TBL b ,PS_INSTITUTION_LNG b1 WHERE b.INSTITUTION = b1.INSTITUTION AND b.EFFDT = b1.EFFDT

  • Related Language Record for SSR_TRNSFR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRNSFR_SRC_ID Character(11) VARCHAR2(11) NOT NULL Source ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description