RQ_RLN_TBL_VW

(SQL View)
 Index Back

Req Ref Line Table View

Use this view to read the Requirement Line Table by the logical key, Line Number, renaming Requirement.

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: RQRLNTBLVW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_MAIN_TBL

    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