TEST_EXTR_VW

(SQL View)
 Index Back

Test Credit Extract View

This view is used to extract transfer test data to be used by the COBOL transcript and academic advisement processes.

SELECT A.EMPLID ,A.ACAD_CAREER ,A.INSTITUTION ,A.MODEL_NBR ,A.ARTICULATION_TERM ,A.TRNSFR_EQVLNCY_GRP ,A.TRNSFR_EQVLNCY_SEQ ,C.STRM ,A.UNT_TRNSFR ,A.GRADING_BASIS ,A.CRSE_GRADE_OFF ,B.CRSE_ID ,B.EFFDT ,F.ACAD_GROUP ,F.SUBJECT ,F.CATALOG_NBR ,B.DESCR ,B.EQUIV_CRSE_ID ,B.CRSE_COUNT ,A.EARN_CREDIT ,A.INCLUDE_IN_GPA ,A.UNITS_ATTEMPTED ,A.REPEAT_CODE ,A.RQMNT_DESIGNTN ,C.TERM_BEGIN_DT ,C.TERM_END_DT ,A.GRD_PTS_PER_UNIT ,A.VALID_ATTEMPT ,A.GRADE_CATEGORY ,A.CRSE_OFFER_NBR ,A.TEST_DT ,A.GRADING_SCHEME FROM PS_TRNS_TEST_DTL A , PS_CRSE_CATALOG B , PS_TERM_TBL C , PS_TRNS_TEST_MODEL D , PS_TRNS_TEST_TERM E , PS_CRSE_OFFER F WHERE A.INSTITUTION = C.INSTITUTION AND A.ACAD_CAREER = C.ACAD_CAREER AND A.ARTICULATION_TERM = C.STRM AND A.CRSE_ID = B.CRSE_ID AND B.EFFDT = ( SELECT MAX (B1.EFFDT) FROM PS_CRSE_CATALOG B1 WHERE B1.CRSE_ID = B.CRSE_ID AND B1.EFF_STATUS = 'A' AND B1.EFFDT <= C.TERM_BEGIN_DT) AND A.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND A.ACAD_CAREER = D.ACAD_CAREER AND A.MODEL_NBR = D.MODEL_NBR AND A.EMPLID = E.EMPLID AND A.INSTITUTION = E.INSTITUTION AND A.ACAD_CAREER = E.ACAD_CAREER AND A.MODEL_NBR = E.MODEL_NBR AND A.ARTICULATION_TERM = E.ARTICULATION_TERM AND A.TRNSFR_STAT = 'P' AND E.MODEL_STATUS = 'P' AND A.CRSE_ID = F.CRSE_ID AND F.EFFDT = ( SELECT MAX (F1.EFFDT) FROM PS_CRSE_OFFER F1 WHERE F1.CRSE_ID = F.CRSE_ID AND F1.EFFDT <= C.TERM_BEGIN_DT) AND A.CRSE_OFFER_NBR = F.CRSE_OFFER_NBR

  • Related Language Record: TEST_EXTR_LNVW

    • # 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 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 MODEL_NBR Number(3,0) SMALLINT NOT NULL Transfer Model Nbr
    5 ARTICULATION_TERM Character(4) VARCHAR2(4) NOT NULL Articulation Term
    6 TRNSFR_EQVLNCY_GRP Number(3,0) SMALLINT NOT NULL Transfer Equivalency Group
    7 TRNSFR_EQVLNCY_SEQ Number(3,0) SMALLINT NOT NULL Transfer Equivalency Seq
    8 STRM Character(4) VARCHAR2(4) NOT NULL Term
    9 UNT_TRNSFR Number(9,3) DECIMAL(8,3) NOT NULL Units Transferred
    10 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)
    11 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    12 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    13 EFFDT Date(10) DATE Effective Date
    14 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    15 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    16 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
    19 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    20 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    21 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    22 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    23 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    24 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
    25 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    26 TERM_END_DT Date(10) DATE Term Ending Date
    27 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    28 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    29 GRADE_CATEGORY Character(4) VARCHAR2(4) NOT NULL The default value of NONE is delivered with the system and should not be deleted.
    TXFR=Transfer Pass (Sample)
    30 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    31 TEST_DT Date(10) DATE Test Date
    32 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme