RQ_LN_TBLR_VW

(SQL View)
 Index Back

Req Line Table Ref View

Use this view to relate display the description after renaming REQUIREMENT to REF_REQUIREMENT and using the "line key number" to read the table.

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, Parenthesis, Descr254A from PS_RQ_LINE_TBL

  • Related Language Record: RQLNTBLRVW_LNG

  • Parent record: RQ_MAIN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_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 PARENTHESIS Character(1) VARCHAR2(1) NOT NULL Parenthesis
    (=Left Parenthesis
    )=Right Parenthesis
    26 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description