RQ_MAIN_TBL

(SQL Table)
 Index Back

Requirement Table

Use this table to record and maintail all Requirements in the Requirement Datastore.

  • Related Language Record: RQ_MAIN_LANG

  • Parent Record Of RQLINETBLVW_LNG RQLNTBLRVW_LNG RQ_LINE_TBL RQ_LINE_TBL_VW RQ_LN_TBLR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: RQ_MAIN_TBL.DESCR

    6 RQRMNT_USEAGE Character(4) VARCHAR2(4) NOT NULL This field is used to specify how the requirement will be used. The value 'SHR1' is reserved for use in a future release.
    ADV=Academic Advisement
    ENR=Requisite/Restriction
    PLNR=Student Planner Report
    SHR=Rq Course Share Restrictn
    SHR1=Entity Course Share Restrictn
    STD=Student Individualized Plan

    Prompt Table: %EDITTABLE8

    7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    8 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

    9 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: ACAD_PROG_CARVW

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

    Prompt Table: ACAD_PLAN_TBL

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

    Prompt Table: ACAD_SUBPLN_TBL

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

    Prompt Table: SUBJECT_TBL

    14 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Prompt Table: CRSE_CATNO_SRCH

    15 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.

    Default Value: 1

    16 RQ_CONNECT_TYPE Character(3) VARCHAR2(3) NOT NULL Connector Type
    AND=AND
    OR=OR

    Default Value: AND

    17 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    18 MIN_UNITS_REQD Number(7,2) DECIMAL(6,2) NOT NULL Minimum Units
    19 MIN_CRSES_REQD Number(6,2) DECIMAL(5,2) NOT NULL Minimum Courses
    20 GRADE_POINTS_MIN Number(10,2) DECIMAL(9,2) NOT NULL Minimum Grade Points
    21 GPA_REQUIRED Number(7,3) DECIMAL(6,3) NOT NULL Minimum GPA
    22 REQ_CRSSELECT_METH Character(3) VARCHAR2(3) NOT NULL Course Ranking Scheme
    BG=Grade Points
    CN=Course Catalog
    CR=Chronological
    LST=Course List Order (future use)
    RCN=Reverse Course Catalog
    RCR=Reverse Chronological

    Default Value: CR

    Prompt Table: XRF_SEL_METH_VW

    23 CREDIT_INCL_MODE Character(4) VARCHAR2(4) NOT NULL Credit Include Mode
    ALL=Include In All Statistics
    NGPA=Exclude From GPA
    VER=Verify Only, Never Include

    Default Value: ALL

    24 RQ_REPORTING Character(4) VARCHAR2(4) NOT NULL Reporting
    ALL=Always Report
    NSAT=Report Only when NOT satisfied
    SAT=Report only when satisfied

    Default Value: ALL

    25 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.

    Y/N Table Edit

    Default Value: N

    26 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.

    Y/N Table Edit

    Default Value: N

    27 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.

    Y/N Table Edit

    Default Value: N

    28 CONDITION_CODE Character(3) VARCHAR2(3) NOT NULL This field is used to track which type of condition will be used as either a condition or pre-condition in Academic Advisement.
    AST=Academic Standing
    CGA=Cumulative Grade Point Avg.
    GRP=Student Group
    GRS=Student Groups
    LVL=Academic Level
    NA=None
    PL=Academic Plan
    PLS=Academic Plans
    PPL=Primary Academic Plan
    PPR=Primary Academic Program
    PR=Academic Program
    PRS=Academic Programs
    SPL=Academic Sub Plan
    SPS=Academic Sub Plans
    TBL=Dynamic Condition
    TST=Test Score

    Default Value: NA

    29 CONDITION_OPERATOR Character(2) VARCHAR2(2) NOT NULL Condition Operator
    EQ=Equal
    GE=Greater or Equal
    GT=Greater Than
    IN=In
    LE=Less or Equal
    LT=Less Than
    NE=Not Equal
    NI=Not In

    Default Value: EQ

    30 CONDITION_DATA Character(10) VARCHAR2(10) NOT NULL Condition Data

    Prompt Table: %EDITTABLE

    31 REQCH_RESOLV_METH Character(3) VARCHAR2(3) NOT NULL Choice Resolution Method
    ALL=Investigate All Combinations
    ORD=Satisfy in Sequential Order

    Default Value: ORD

    32 REQCH_STOP_RULE Character(4) VARCHAR2(4) NOT NULL Number of Lines Stop Rule
    ALL=Satisfy Maximal Lines
    MIN=Stop At Minimum Lines

    Default Value: MIN

    33 RQ_MIN_LINES Number(4,0) SMALLINT NOT NULL Min Partitions to Complete

    Default Value: 1

    34 RQ_MAX_LINES Number(4,0) SMALLINT NOT NULL Max Partitions to Allow Credit
    35 RQ_PARTITION_SHR Character(1) VARCHAR2(1) NOT NULL Partition Sharing

    Y/N Table Edit

    Default Value: N

    36 RQ_PRINT_CNTL Character(4) VARCHAR2(4) NOT NULL Print Control
    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

    Default Value: ALW

    Prompt Table: XRF_RQPRTCTL_VW

    37 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SAA_CND_TST_VW

    38 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component

    Prompt Table: SA_TCMP_REL_TBL

    39 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    40 SAA_MAX_VALID_AGE Number(3,0) SMALLINT NOT NULL This field is used to track the maximum age of a test score in months for Academic Advisement.
    41 SAA_BEST_TEST_OPT Character(2) VARCHAR2(2) NOT NULL This field is used to track the method to select the correct test score in Academic Advisement when multiple versions of the same test are found.
    AV=Average of All Scores Taken
    FT=First Test Taken
    HS=Highest Score
    LS=Lowest Score
    LT=Last Test Taken
    42 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.

    Y/N Table Edit

    Default Value: N

    43 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    44 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
    45 SAA_DESCRLONG Long Character CLOB NOT NULL This field is used to display information in the new student view for academic advisement reports.