RQ_GRP_DETL_VW

(SQL View)
 Index Back

Requirmnt Group Detl Tbl View

Use this view to read the Requirement Group Detail 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 Group Detail Table. The real key of the table is the "line key number" - it is used only by the database.

SELECT RQRMNT_GROUP , EFFDT , RQ_GRP_LINE_NBR , RQ_LINE_KEY_NBR , RQ_GRP_LINE_TYPE , MIN_UNITS_REQD , MIN_CRSES_REQD , REQUISITE_TYPE , REQUIREMENT , CONDITION_CODE , CONDITION_OPERATOR , CONDITION_DATA , INSTITUTION , ACAD_GROUP , SUBJECT , CATALOG_NBR , WILD_PATTERN_TYPE , CRSE_ID , TRNSFR_LVL_ALLOWD , TEST_CRDT_ALLOWD , OTHR_CRDT_ALLOWD , INCL_GPA_REQ , EXCL_IP_CREDIT , GRADE_POINTS_MIN , UNITS_MINIMUM , INCLUDE_EQUIVALENT , CRSVALID_BEGIN , CRSVALID_END , STRM , ASSOCIATED_CLASS , CRS_TOPIC_ID , RQMNT_DESIGNTN , RQ_CONNECT , PARENTHESIS , TEST_ID , TEST_COMPONENT , SCORE , SAA_MAX_VALID_AGE , SAA_BEST_TEST_OPT FROM PS_RQ_GRP_DETL_TBL

  • Parent record: RQ_GRP_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 RQ_GRP_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Group Line Nbr
    4 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key
    5 RQ_GRP_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Group Line Type
    COND=Condition
    CRSE=Course
    CRSW=Wild Card Course
    RQ=Requirement
    6 MIN_UNITS_REQD Number(7,2) DECIMAL(6,2) NOT NULL Minimum Units
    7 MIN_CRSES_REQD Number(6,2) DECIMAL(5,2) NOT NULL Minimum Courses
    8 REQUISITE_TYPE Character(4) VARCHAR2(4) NOT NULL Requisite Type
    CO=Co-Requisite
    PRE=Pre-Requisite
    9 REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: RQ_ENRL_SRCH

    10 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
    11 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
    12 CONDITION_DATA Character(10) VARCHAR2(10) NOT NULL Condition Data

    Prompt Table: %EDITTABLE

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

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: SUBJECT_TBL

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

    Prompt Table: CRSE_CATNO_SRCH

    17 WILD_PATTERN_TYPE Character(4) VARCHAR2(4) NOT NULL Wild Card Pattern Type
    CMPL=Complex
    SMPL=Simple
    18 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_R1_VW

    19 TRNSFR_LVL_ALLOWD Character(4) VARCHAR2(4) NOT NULL Transfer Level Allowed
    2YR=Two Year Institution only
    4YR=Four Year Institution only
    ALL=Always Allow
    NONE=Never Allow

    Default Value: ALL

    20 TEST_CRDT_ALLOWD Character(1) VARCHAR2(1) NOT NULL Test Credit is Allowed

    Y/N Table Edit

    Default Value: Y

    21 OTHR_CRDT_ALLOWD Character(1) VARCHAR2(1) NOT NULL Other Credit is Allowed

    Y/N Table Edit

    Default Value: N

    22 INCL_GPA_REQ Character(1) VARCHAR2(1) NOT NULL Course must be GPA material

    Y/N Table Edit

    Default Value: Y

    23 EXCL_IP_CREDIT Character(1) VARCHAR2(1) NOT NULL Exclude In-Progress Credit

    Y/N Table Edit

    Default Value: N

    24 GRADE_POINTS_MIN Number(10,2) DECIMAL(9,2) NOT NULL Minimum Grade Points
    25 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    26 INCLUDE_EQUIVALENT Character(1) VARCHAR2(1) NOT NULL Include Equivalent Courses

    Y/N Table Edit

    Default Value: N

    27 CRSVALID_BEGIN Date(10) DATE CourseValid Begin Date /Req
    28 CRSVALID_END Date(10) DATE Course Valid End Date /Req
    29 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    30 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class

    Prompt Table: RQ_CLS_ASN_SRCH

    31 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    32 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.

    Prompt Table: RQMNT_DESIG_TBL

    33 RQ_CONNECT Character(4) VARCHAR2(4) NOT NULL Detail Connector
    AND=And
    OR=Or
    34 PARENTHESIS Character(1) VARCHAR2(1) NOT NULL Parenthesis
    (=Left Parenthesis
    )=Right Parenthesis
    35 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID

    Prompt Table: SAA_CND_TST_VW

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

    Prompt Table: SA_TCMP_REL_TBL

    37 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    38 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.
    39 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