SAA_RPT_CRSU_VW

(SQL View)
 Index Back

Advising Report Courses Used

This view is used to retrieve and hold courses used in the results to be used in creating a hard copy report in academic advising.

SELECT A.EMPLID , A.ANALYSIS_DB_SEQ , A.SAA_CAREER_RPT , A.SAA_ENTRY_SEQ , A.SAA_COURSE_SEQ , A.CRSE_TAG , A.RPT_DATE , A.TSCRPT_TYPE , A.SAA_RPT_IDENTIFIER , A.RQRMNT_GROUP , A.RQ_GRP_LINE_NBR , A.REQUIREMENT , A.RQ_LINE_NBR , A.SEL_PROCESS_TYPE , A.SEL_MODE , B.CRSE_ID , B.SUBJECT , B.CATALOG_NBR , B.SAA_CRS_TTL_DESCR , B.STRM , B.SAA_TERM_DESCRSHRT , B.CRSE_GRADE_OFF , B.REPEAT_CODE , B.SAA_REPEAT_DESCR , B.CRS_TOPIC_ID , B.SAA_TOPIC_DESCR , B.RQMNT_DESIGNTN , B.SAA_RQ_DESGN_DESCR , B.CLASS_ENRL_TYPE , B.SAA_CRSE_TYPE , ' ' , A.IN_PROGRESS_GRD , A.UNT_TAKEN , A.UNT_EARNED , A.CRSE_COUNT , A.RQ_AA_OVERRIDE , A.ASOF_DATE , A.DIRCT_TYPE , A.SAA_DISPLAY_OPTION , A.SAA_OPRID_NAME , A.OPRID , A.DESCR254A FROM PS_SAA_ADB_CRSEUSE A , PS_SAA_RPT_CRSE_VW B WHERE A.EMPLID = B.EMPLID AND A.ANALYSIS_DB_SEQ = B.ANALYSIS_DB_SEQ AND A.SAA_CAREER_RPT = B.SAA_CAREER_RPT AND A.CRSE_TAG = B.CRSE_TAG

  • Parent record: SAA_ADB_RESULTS

    • # 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 SAA_ENTRY_SEQ Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to track the position of the output in the report.
    5 SAA_COURSE_SEQ Number(3,0) SMALLINT NOT NULL This field is used in the table SAA_ADB_CRSEUSE to track multiple occurances of a course at the same entry sequence position in the table.
    6 CRSE_TAG Character(4) VARCHAR2(4) NOT NULL Course Tag
    7 RPT_DATE Date(10) DATE NOT NULL Report Date
    8 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    9 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.
    10 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    11 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr
    12 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    13 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    14 SEL_PROCESS_TYPE Character(3) VARCHAR2(3) NOT NULL Selection process type
    15 SEL_MODE Character(1) VARCHAR2(1) NOT NULL Selection Mode
    16 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    17 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    18 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    19 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.
    20 STRM Character(4) VARCHAR2(4) NOT NULL Term
    21 SAA_TERM_DESCRSHRT Character(10) VARCHAR2(10) NOT NULL This field is used in the advising report views to display the short term description.
    22 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    23 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    24 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.
    25 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    26 SAA_TOPIC_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the topic.
    27 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.
    28 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.
    29 CLASS_ENRL_TYPE Character(1) VARCHAR2(1) NOT NULL Class enroll type
    30 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
    31 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
    32 IN_PROGRESS_GRD Character(1) VARCHAR2(1) NOT NULL In Progress Grade

    Y/N Table Edit

    33 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    34 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
    35 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    36 RQ_AA_OVERRIDE Character(9) VARCHAR2(9) NOT NULL Advisement Override
    37 ASOF_DATE Date(10) DATE This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
    38 DIRCT_TYPE Character(1) VARCHAR2(1) NOT NULL Course directive type
    S=Substitute
    X=Exclude
    39 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
    40 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.
    41 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    42 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.