SAA_RPT_CRSE_VW

(SQL View)
 Index Back

Advising Report Courses View

This view is used to retrieve and hold course data to be used in creating a hard copy report in academic advising.

SELECT A.EMPLID ,A.ANALYSIS_DB_SEQ ,A.SAA_CAREER_RPT ,A.CRSE_TAG ,A.RPT_DATE ,A.TSCRPT_TYPE ,A.SAA_RPT_IDENTIFIER ,A.INSTITUTION ,A.SRC_INSTITUTION ,A.ACAD_CAREER ,A.SRC_CAREER ,A.CRSE_CAREER ,A.STRM ,B.DESCRSHORT ,A.APPLIED_TERM ,A.TERM_TAKEN ,A.CLASS_NBR ,A.STDNT_ENRL_STATUS ,A.UNT_TAKEN ,A.UNT_EARNED ,A.UNT_PRGRSS ,A.GRADING_BASIS_ENRL ,A.CRSE_GRADE_OFF ,A.REPEAT_CODE ,' ' ,A.ASSOCIATED_CLASS ,A.AUDIT_GRADE_BASIS ,A.EARN_CREDIT ,A.INCLUDE_IN_GPA ,A.UNITS_ATTEMPTED ,A.GRADE_POINTS ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_GROUP ,A.SUBJECT ,A.CATALOG_NBR ,A.DESCR ,A.SSR_COMPONENT ,A.CRS_TOPIC_ID ,A.SAA_DISPLAY_TOPIC ,' ' ,A.EQUIV_CRSE_ID ,A.OVRD_CRSE_EQUIV_ID ,A.START_DT ,A.END_DT ,A.CRSE_COUNT ,A.CLASS_ENRL_TYPE ,A.SAA_CRSE_TYPE ,' ' ,A.RQ_SCHOOL_TYPE ,A.GRADE_CATEGORY ,A.VALID_ATTEMPT ,A.GRD_PTS_PER_UNIT ,A.RQMNT_DESIGNTN ,' ' ,A.SUB_ACAD_GROUP ,A.SUB_CRSE_ID ,A.SUB_SUBJECT ,A.SUB_CATLG_NBR ,A.SAA_SUB_DESCR ,A.OPRID ,A.SAA_OPRID_NAME ,A.SAA_DISPLAY_OPTION ,A.STDNT_SUB_NBR ,A.DESCR254A FROM PS_SAA_ADB_COURSES A , PS_TERM_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STRM = B.STRM

  • Parent record: SAA_ADB_REPORT

    • # 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 ANALYSIS_DB_SEQ Number(4,0) SMALLINT NOT NULL Analysis DB Sequence
    3 SAA_CAREER_RPT Character(4) VARCHAR2(4) NOT NULL This field is used in academic advisement as a key to the results tables.

    Prompt Table: ACAD_CAR_TBL

    4 CRSE_TAG Character(4) VARCHAR2(4) NOT NULL Course Tag
    5 RPT_DATE Date(10) DATE NOT NULL Report Date
    6 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    7 SAA_RPT_IDENTIFIER Character(10) VARCHAR2(10) NOT NULL This field is used to identify a specific run of Academic Advisement Reports within a report type.
    8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    9 SRC_INSTITUTION Character(5) VARCHAR2(5) NOT NULL Source Institution

    Prompt Table: INSTITUTION_TBL

    10 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

    Prompt Table: ACAD_CAR_TBL

    11 SRC_CAREER Character(4) VARCHAR2(4) NOT NULL Source Career

    Prompt Table: ACAD_CAR_TBL

    12 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career

    Prompt Table: ACAD_CAR_TBL

    13 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    14 SAA_TERM_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL This field is used in the advising report views to display the short term description.
    15 APPLIED_TERM Character(4) VARCHAR2(4) NOT NULL Applied term

    Prompt Table: TERM_VAL_TBL

    16 TERM_TAKEN Character(4) VARCHAR2(4) NOT NULL Term Taken

    Prompt Table: TERM_VAL_TBL

    17 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: ACAD_CAR_TBL

    18 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    19 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    20 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
    21 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
    22 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

    Prompt Table: GRADE_BASIS_TBL

    23 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    24 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment

    Prompt Table: REPEAT_CODE_TBL

    25 SAA_REPEAT_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the repeat code.
    26 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    27 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis

    Prompt Table: GRADE_BASIS_TBL

    28 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit

    Y/N Table Edit

    29 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA

    Y/N Table Edit

    30 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    31 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    32 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CLASS_TBL

    33 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    34 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    35 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    36 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    37 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    38 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    39 SAA_CRS_TTL_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the course.
    40 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    41 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    42 SAA_DISPLAY_TOPIC Character(1) VARCHAR2(1) NOT NULL This field is used in the setup table TRANSCRIPT_TYPE to determine if course topics are to be displayed for the specific transcript type record for Academic Advisement reports.
    43 SAA_TOPIC_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the topic.
    44 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group

    Prompt Table: CLASS_TBL

    45 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course

    Y/N Table Edit

    46 START_DT Date(10) DATE Start Date
    47 END_DT Date(10) DATE end date
    48 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    49 CLASS_ENRL_TYPE Character(1) VARCHAR2(1) NOT NULL Class enroll type
    50 SAA_CRSE_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used to identify what-if and planned courses in the advisement results tables.
    N=Normal Course
    P=Planned Course
    S=Shopping Cart Course
    W=What-If Course

    Default Value: N

    51 SAA_CRSE_TYPE_DSP Character(2) VARCHAR2(2) NOT NULL This field is used to identify what-if and planned courses in the advisement results tables and display the correct value in the new report.
    EN=Enrolled Course
    IT=Internal Transfer Credit
    OT=Other Transfer Credit
    PL=Planner Course
    SC=Shopping Cart Course
    TC=Transfer Credit
    TE=Transfer Test Credit
    WH=What-If Course
    52 RQ_SCHOOL_TYPE Character(4) VARCHAR2(4) NOT NULL Advisement School Type
    2YR=Two Year School
    4YR=Four Year School
    UKN=Unknown
    53 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)
    54 VALID_ATTEMPT Character(1) VARCHAR2(1) NOT NULL Valid Attempted Grade
    55 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    56 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.
    57 SAA_RQ_DESGN_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the requirement designation code.
    58 SUB_ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    59 SUB_CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course Id
    60 SUB_SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    61 SUB_CATLG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    62 SAA_CRS_SUB_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of a substituted course.
    63 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    64 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.
    65 SAA_DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL This field will control if items will print/display in Academic Advisement Reports
    N=Display Name
    O=Display Operator
    X=Do Not Display
    66 STDNT_SUB_NBR Character(4) VARCHAR2(4) NOT NULL Substitution Seq
    67 SAA_OVRD_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is used by the analysis database results views and displays the description to display from an override.