TEST_EXTR_LNVW

(SQL View)
 Index Back

Test Credit Extract View

This related language 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 ,B.LANGUAGE_CD ,B.DESCR FROM PS_TEST_EXTR_VW A , PS_CRSE_CATLG_LNG B WHERE A.CRSE_ID = B.CRSE_ID AND A.EFFDT = B.EFFDT

  • Related Language Record for TEST_EXTR_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 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description