RQ_LN_DETL_TBL

(SQL Table)
 Index Back

Requirement Line Detail Table

Use this table to record pointers to Course Lists, or specifications of Dynamic Course Lists or Conditions belonging to a Requirement Line in the Requirement Datastore.

  • Related Language Record: RQ_LN_DETL_LNG

  • Parent record: RQ_LINE_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_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key
    4 RQ_LINE_DET_SEQ Number(3,0) SMALLINT NOT NULL Line Detail Sequence
    5 RQ_LINE_DET_TYPE Character(4) VARCHAR2(4) NOT NULL Line Detail Type
    CLST=Course List
    COND=Condition
    DLST=Derived Course List

    Prompt Table: %EDITTABLE2

    6 LIST_INCLUDE_MODE Character(1) VARCHAR2(1) NOT NULL List Include Mode
    C=Complement of
    I=Intersection with
    N=Subtract from
    Y=Union with

    Prompt Table: %EDITTABLE5

    7 LIST_RECALL_MODE Character(3) VARCHAR2(3) NOT NULL List Recall Mode
    ATT=Course Attributes
    BEF=Taken Before Term Number
    BFR=Taken Before Term In Resid Nbr
    CA1=Courses in Target Career
    CAT=Grade Category
    GPA=Include In GPA Courses
    GUS=Used by Requirement Group
    ITC=Internal Transfer Credit
    LGT=Taken In Last Graded (#Terms)
    LUT=Taken In Last (#Terms)
    NRD=Credit with no Designation
    NTS=Test Credit
    OTH=Other Credit
    PAS=All Courses
    PER=Taken In Consecutive (#Terms)
    PL=Used by Academic Plans
    PPL=Used by Primary Acad Plan
    PPR=Used by Primary Acad Program
    PR=Used by Academic Programs
    RES=Taken While In Residence
    TR2=2 Year Institutn Transfr Crses
    TR4=4 Year Institutn Transfr Crses
    TRA=Transfer Credit
    UNB=Taken Before Limit (#Units)
    UNL=Taken In Last (#Units)
    UNS=Taken After Limit (#Units)
    USD=All Courses used
    USE=Used by Requirement
    VAL=Valid Attempts
    8 LIST_INTERP Character(1) VARCHAR2(1) NOT NULL Recall Interpretation
    A=None
    E=Each Component
    G=Component With Max Courses
    U=All Components Combined

    Default Value: A

    9 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group

    Prompt Table: %EDITTABLE4

    10 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement

    Prompt Table: %EDITTABLE3

    11 RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr

    Prompt Table: RQ_RLN_TBL_VW

    12 REF_NUMBER Number(4,0) SMALLINT NOT NULL Reference Number
    13 REF_DATA Character(10) VARCHAR2(10) NOT NULL Reference Data

    Prompt Table: %EDITTABLE8

    14 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List

    Prompt Table: %EDITTABLE6

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

    Prompt Table: INSTITUTION_TBL

    16 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

    17 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

    18 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

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

    Prompt Table: %EDITTABLE

    20 IGNORE_MSNG_TGT Character(1) VARCHAR2(1) NOT NULL Checkbox for the Requirement Line Detail panel for DLST of Used By to override error handling if the target does not exist for a student.

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: SAA_CND_TST_VW

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

    Prompt Table: SA_TCMP_REL_TBL

    23 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    24 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.
    25 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
    26 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute

    Prompt Table: CRSE_ATTR_TBL

    27 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value

    Prompt Table: CRSE_ATTR_VALUE

    28 DESCR254A Character(254) VARCHAR2(254) NOT NULL Condition Description