RQ_LINE_TBL_VW

(SQL View)
 Index Back

Req Line Table View

Use this view to read the Requirement Line Table by the logical key. The line number (logical) key is the one to use when examining the logical relationship between records in the Requirement Line Table. The real key of the table is the "line key number" - it is used only by the database.

SELECT REQUIREMENT , EFFDT , RQ_LINE_NBR , RQ_LINE_KEY_NBR , DESCR , DESCRSHORT , FULL_SET_RPN , SPECIAL_PROCESSING , REQ_LINE_TYPE , RQ_CONNECT , CREDIT_INCL_MODE , REQ_CRSSELECT_METH , CT_COND_COMPLEMENT , MIN_UNITS_REQD , MIN_CRSES_REQD , MAX_UNITS_ALLOWD , MAX_CRSES_ALLOWD , GRADE_POINTS_MIN , GPA_REQUIRED , GPA_MAXIMUM , RQ_REPORTING , CONDITION_CODE , CONDITION_OPERATOR , CONDITION_DATA , COUNT_ATTEMPTS , ENABLE_SPLITTING , RQ_PRINT_CNTL , PARENTHESIS , SAA_COMPLEX_RQ_LN , TEST_ID , TEST_COMPONENT , SCORE , SAA_DESCR80 , DESCR254A , SAA_DESCR254 , SAA_DESCRLONG FROM PS_RQ_LINE_TBL

  • Related Language Record: RQLINETBLVW_LNG

  • Parent record: RQ_MAIN_TBL

    • # 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 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    4 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: RQ_LINE_TBL.DESCR

    7 FULL_SET_RPN Character(1) VARCHAR2(1) NOT NULL Override Standard Set Logic

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    9 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

    Default Value: MT

    10 RQ_CONNECT Character(4) VARCHAR2(4) NOT NULL Detail Connector
    AND=And
    OR=Or
    11 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

    12 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: BG

    13 CT_COND_COMPLEMENT Character(1) VARCHAR2(1) NOT NULL Complement of Line Conditions

    Y/N Table Edit

    Default Value: N

    14 MIN_UNITS_REQD Number(7,2) DECIMAL(6,2) NOT NULL Minimum Units
    15 MIN_CRSES_REQD Number(6,2) DECIMAL(5,2) NOT NULL Minimum Courses
    16 MAX_UNITS_ALLOWD Number(7,2) DECIMAL(6,2) NOT NULL Maximum Units Allowed
    17 MAX_CRSES_ALLOWD Number(7,2) DECIMAL(6,2) NOT NULL Maximum Courses Allowed
    18 GRADE_POINTS_MIN Number(10,2) DECIMAL(9,2) NOT NULL Minimum Grade Points
    19 GPA_REQUIRED Number(7,3) DECIMAL(6,3) NOT NULL Minimum GPA
    20 GPA_MAXIMUM Number(7,3) DECIMAL(6,3) NOT NULL Maximum GPA Allowed
    21 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

    22 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
    23 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
    24 CONDITION_DATA Character(10) VARCHAR2(10) NOT NULL Condition Data

    Prompt Table: %EDITTABLE

    25 COUNT_ATTEMPTS Character(1) VARCHAR2(1) NOT NULL Count Attempts

    Y/N Table Edit

    Default Value: N

    26 ENABLE_SPLITTING Character(1) VARCHAR2(1) NOT NULL Enable Splitting

    Y/N Table Edit

    Default Value: N

    27 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
    28 PARENTHESIS Character(1) VARCHAR2(1) NOT NULL Parenthesis
    (=Left Parenthesis
    )=Right Parenthesis
    29 SAA_COMPLEX_RQ_LN Character(1) VARCHAR2(1) NOT NULL This field is used to identify if the requirement line contains complex set logic used to select courses to be used in an advising report.

    Y/N Table Edit

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

    Prompt Table: SA_TEST_TBL

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

    Prompt Table: SA_TCMP_REL_TBL

    32 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    33 SAA_DESCR80 Character(80) VARCHAR2(80) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    34 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
    35 SAA_DESCR254 Character(254) VARCHAR2(254) NOT NULL This field is used to display information in the new student view for academic advisement reports.
    36 SAA_DESCRLONG Long Character CLOB This field is used to display information in the new student view for academic advisement reports.