SAA_RPT_RQPL_VW

(SQL View)
 Index Back

Advising Required Plans View

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

SELECT EMPLID , ANALYSIS_DB_SEQ , SAA_CAREER_RPT , SAA_ENTRY_SEQ , SAA_RQDPLN_SEQ , RPT_DATE , TSCRPT_TYPE , SAA_RPT_IDENTIFIER , RQRMNT_GROUP , PLANS_NEEDED , ACAD_CAREER , ACAD_PROG , ACAD_PLAN , ACAD_SUB_PLAN , ' ' , ' ' FROM PS_SAA_ADB_RQDPLAN

  • 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_RQDPLN_SEQ Number(4,0) SMALLINT NOT NULL This field is used in the analysis database to sequence the required plan records.
    6 RPT_DATE Date(10) DATE NOT NULL Report Date
    7 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type
    8 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.
    9 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: RQ_GRP_TBL

    10 PLANS_NEEDED Number(3,0) SMALLINT NOT NULL Plans needed
    11 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

    12 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG

    13 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBL

    14 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLAN

    15 SAA_RQDPLHDR_DESCR Character(100) VARCHAR2(100) NOT NULL This field is used in advising report views for displaying the required plan header description to be displayed on the hard copy report.
    16 SAA_RQDPLDTL_DESCR Character(100) VARCHAR2(100) NOT NULL This field is used in advising report views for displaying the required plan detail description to be displayed on the hard copy report.