EXT_CRS_TRNS_VL

(SQL View)
 Index Back

External Courses transfer view

This record is used to view external course information from an outside school, by data source.

SELECT a.Emplid , a.Ext_Org_Id , a.LS_Data_Source , b.Language_Cd , b.Descr FROM PS_EXT_COURSE a , PS_EXT_COURSE_Lang b WHERE a.EMPLID = b.EMPLID AND a.EXT_ORG_ID = b.EXT_ORG_ID AND a.EXT_COURSE_NBR = b.EXT_COURSE_NBR

  • Related Language Record for EXT_CRS_TRNS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    3 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
    A8=TEAS Degree Information
    AAD=AADSAS
    ACT=American College Testing
    AE=Ad-Hoc Employee
    AMC=AMCAS
    AO=Ad-Hoc Organizational
    E=Extract
    ETS=Educational Testing Service
    GH=OLSAS Last Secondary-G2
    LSD=LSDAS
    PI=Prev/Post Secondary Info
    RS=OLSAS Postsecondary Info
    SCH=School
    SLF=Self-Reported Information
    WWW=World Wide Web
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description