SAA_RPT_RSLT_VW

(SQL View)
 Index Back

Advising Report Results View

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

SELECT EMPLID , ANALYSIS_DB_SEQ , SAA_CAREER_RPT , SAA_ENTRY_SEQ , RPT_DATE , TSCRPT_TYPE , SAA_RPT_IDENTIFIER , ENTRY_R_TYPE , ACAD_CAREER , ACAD_PROG , ACAD_PLAN , ACAD_SUB_PLAN , RQ_DATE , RQRMNT_GROUP , RQ_GRP_LINE_NBR , REQUIREMENT , RQ_LINE_NBR , ' ' , ' ' , RQRMNT_LIST_SEQ , RQ_GRP_LINE_TYPE , REQ_LINE_TYPE , DISP_SELECT_LINE , PARTITION_FAIL , UNITS_REQUIRED , SAA_UNITS_USED , UNITS_NEEDED , CRSES_REQUIRED , SAA_CRSES_USED , CRSES_NEEDED , SAA_CRSE_COUNT , GPA_REQUIRED , GPA_ACTUAL , RQ_AA_OVERRIDE , ASOF_DATE , RQ_OVRD_ACTION , OLD_MIN_UNITS , NEW_MIN_UNITS , OLD_MAX_UNITS , NEW_MAX_UNITS , OLD_MIN_CRSES , NEW_MIN_CRSES , OLD_MAX_CRSES , NEW_MAX_CRSES , REF_RQMT_GROUP , REF_REQUIREMENT , ITEM_R_STATUS , ' ' , 0 , 0 , SAA_PRINT_CNTL , SAA_DISPLAY_OPTION , SAA_DISPLAY_GPA , SAA_DISPLAY_UNITS , SAA_DISPLAY_CRSCNT , SAA_HIDE_STATUS , OPRID , SAA_OPRID_NAME , DESCR254A , NULL FROM PS_SAA_ADB_RESULTS

  • 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 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 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 ENTRY_R_TYPE Character(6) VARCHAR2(6) NOT NULL Entry Type
    9 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

    10 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    11 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    12 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    13 RQ_DATE Date(10) DATE Requirement Date
    14 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    15 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr
    16 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    17 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    18 SAA_RESULT_DESCR Character(50) VARCHAR2(50) NOT NULL This field is used in advising report views for displaying the description of a specific result.
    19 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    20 RQRMNT_LIST_SEQ Number(3,0) SMALLINT NOT NULL This field contains the reporting sequence value used to process and display requirement groups in advisement reports.
    21 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
    COND=Condition
    CRSE=Course
    CRSW=Wild Card Course
    RQ=Requirement
    22 REQ_LINE_TYPE Character(3) VARCHAR2(3) NOT NULL Line Type
    CND=Condition Requirement
    GLM=Global Limit
    GSQ=Global Sequential Restriction
    LIM=Unit, Course or GPA Limit
    MT=Course Requirement
    SC=Specified Courses
    SEQ=Sequential Restriction
    23 DISP_SELECT_LINE Character(1) VARCHAR2(1) NOT NULL Display Select Line

    Y/N Table Edit

    24 PARTITION_FAIL Character(1) VARCHAR2(1) NOT NULL Partition fail

    Y/N Table Edit

    25 UNITS_REQUIRED Number(7,2) DECIMAL(6,2) NOT NULL Units required
    26 SAA_UNITS_USED Number(7,2) DECIMAL(6,2) NOT NULL This field is used in Academic Advisement to report the number of units used by a requirement.
    27 UNITS_NEEDED Number(7,2) DECIMAL(6,2) NOT NULL Units needed
    28 CRSES_REQUIRED Number(7,2) DECIMAL(6,2) NOT NULL Courses required
    29 SAA_CRSES_USED Number(7,2) DECIMAL(6,2) NOT NULL This field is used in Academic Advisement to report the number of courses used by a particular requirement.
    30 CRSES_NEEDED Number(7,2) DECIMAL(6,2) NOT NULL Courses needed
    31 SAA_CRSE_COUNT Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to report the number of courses used by a particular requirement.
    32 GPA_REQUIRED Number(7,3) DECIMAL(6,3) NOT NULL Minimum GPA
    33 GPA_ACTUAL Number(7,3) DECIMAL(6,3) NOT NULL GPA actual
    34 RQ_AA_OVERRIDE Character(9) VARCHAR2(9) NOT NULL Advisement Override
    35 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.
    36 RQ_OVRD_ACTION Character(4) VARCHAR2(4) NOT NULL This field is used to report the status of an override in academic advising. It contains the same values as are found in RQ_AA_OVRD_OPCODE.
    DRCT=Course Directive
    REQC=Requirement Change
    REQO=Requirement Override
    REQW=Requirement Waiver
    37 OLD_MIN_UNITS Number(7,2) DECIMAL(6,2) NOT NULL Old Minimum units
    38 NEW_MIN_UNITS Number(7,2) DECIMAL(6,2) NOT NULL New minimum units
    39 OLD_MAX_UNITS Number(7,2) DECIMAL(6,2) NOT NULL Old Maximum units
    40 NEW_MAX_UNITS Number(7,2) DECIMAL(6,2) NOT NULL New maximum units
    41 OLD_MIN_CRSES Number(7,2) DECIMAL(6,2) NOT NULL Old minimum courses
    42 NEW_MIN_CRSES Number(7,2) DECIMAL(6,2) NOT NULL New minimum courses
    43 OLD_MAX_CRSES Number(7,2) DECIMAL(6,2) NOT NULL Old maximum courses
    44 NEW_MAX_CRSES Number(7,2) DECIMAL(6,2) NOT NULL New maximum courses
    45 REF_RQMT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    46 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    47 ITEM_R_STATUS Character(4) VARCHAR2(4) NOT NULL Item Status
    COMP=Complete
    EXMP=Exempted
    FAIL=Fail
    48 SAA_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used in advising report views for displaying the description of the status.
    49 SAA_RPT_CRSE_CNT Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to report the number of courses used by the new on-line report.
    50 SAA_RPT_COND_CNT Number(4,0) SMALLINT NOT NULL This field is used in Academic Advisement to report the number of conditions used by the new on-line report.
    51 SAA_PRINT_CNTL Character(4) VARCHAR2(4) NOT NULL This field is used to control if certain reporting levels are to be displayed when creating an Academic Advisement Report.
    ALW=Print on audit reports
    IFDT=Print if there is line detail
    NCRS=Do not print line detail
    NVR=Do not print
    SKP=Skip printing of this level
    52 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
    53 SAA_DISPLAY_GPA Character(1) VARCHAR2(1) NOT NULL This field is used to track if the GPA is to be displayed on an Academic Advisement report if the processing level is satisfied.
    54 SAA_DISPLAY_UNITS Character(1) VARCHAR2(1) NOT NULL This field is used to track if the calculated units are to be displayed on an Academic Advisement report if the processing level is satisfied.
    55 SAA_DISPLAY_CRSCNT Character(1) VARCHAR2(1) NOT NULL This field is used to track if the calculated course counts are to be displayed on an Academic Advisement report if the processing level is satisfied.
    56 SAA_HIDE_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to determine if the status description is to print on AA reports for the processing level.
    57 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    58 SAA_OPRID_NAME Character(50) VARCHAR2(50) NOT NULL This field is used to display the name of the oprid when requesting advising reports.
    59 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.
    60 SAA_DESCRLONG Long Character CLOB This field is used to display information in the new student view for academic advisement reports.