EXT_CRS_TRNS_VW

(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 , a.Begin_Dt , a.End_Dt , a.School_Subject , a.School_Crse_Nbr , a.Ext_Term_Type , a.Unt_Taken , a.Institution , a.Grading_Scheme , a.Grading_Basis , a.Crse_Grade_Input , a.Crse_Grade_Off , a.Descr , a.Course_Level , a.Ext_Career , a.Ext_Term , a.Term_Year , a.Ext_Crse_Type , a.Ext_Data_Nbr , a.Ext_Course_Nbr FROM PS_EXT_COURSE a

  • Related Language Record: EXT_CRS_TRNS_VL

    • # 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 BEGIN_DT Date(10) DATE Begin Date
    5 END_DT Date(10) DATE end date
    6 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHOOL_SUBJ_TBL

    7 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

    Prompt Table: SCHOOL_CRSE_TBL

    8 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown
    9 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    11 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    12 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)
    13 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    14 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
    11=Grade 11
    12=Grade 12
    AP=Advanced Placement
    DR=Graduate/Doctoral
    FR=Freshman
    GR=Graduate
    HN=Honors
    IB=International Baccalaureate
    JR=Junior
    LD=Lower Division
    MS=Graduate/Master
    RG=Regular
    SO=Sophomore
    SR=Senior
    UD=Upper Division
    17 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate
    18 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
    FALL=Fall
    SPR=Spring
    SUMR=Summer
    WINT=Winter
    19 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    20 EXT_CRSE_TYPE Character(3) VARCHAR2(3) NOT NULL External Course Type
    C=Challenge
    CRS=Course
    E=Equivalency
    EVT=Event or Summary
    N/A=Course - Not Applicable
    REP=Course - Repeated
    WTH=Course - Withdrawn
    21 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
    22 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number