RQ_LN_DETL_VW

(SQL View)
 Index Back

Requirement Line Detail Tbl Vw

Use this view to read the Requirement Line Detail Table when using RQ_LINE_TBL_VW to read the Requirement Line Table.

SELECT A.REQUIREMENT ,A.EFFDT ,B.RQ_LINE_NBR ,A.RQ_LINE_DET_SEQ ,A.RQ_LINE_KEY_NBR ,A.RQ_LINE_DET_TYPE ,A.LIST_INCLUDE_MODE ,A.LIST_RECALL_MODE ,A.LIST_INTERP ,A.RQRMNT_GROUP ,A.REF_REQUIREMENT ,A.RQ_LINE_NBR ,A.REF_NUMBER ,A.REF_DATA ,A.COURSE_LIST ,A.INSTITUTION ,A.ACAD_CAREER ,A.CONDITION_CODE ,A.CONDITION_OPERATOR ,A.CONDITION_DATA ,A.IGNORE_MSNG_TGT ,A.TEST_ID ,A.TEST_COMPONENT ,A.SCORE ,A.SAA_MAX_VALID_AGE ,A.SAA_BEST_TEST_OPT ,A.CRSE_ATTR ,A.CRSE_ATTR_VALUE ,A.DESCR254A FROM PS_RQ_LN_DETL_TBL A , PS_RQ_LINE_TBL B WHERE A.REQUIREMENT = B.REQUIREMENT AND A.EFFDT = B.EFFDT AND A.RQ_LINE_KEY_NBR = B.RQ_LINE_KEY_NBR

  • Parent record: RQ_LINE_TBL_VW

    • # 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_DET_SEQ Number(3,0) SMALLINT NOT NULL Line Detail Sequence
    5 RQ_LINE_KEY_NBR Character(4) VARCHAR2(4) NOT NULL Background Key
    6 RQ_LINE_DET_TYPE Character(4) VARCHAR2(4) NOT NULL Line Detail Type
    CLST=Course List
    COND=Condition
    DLST=Derived Course List
    7 LIST_INCLUDE_MODE Character(1) VARCHAR2(1) NOT NULL List Include Mode
    C=Complement of
    I=Intersection with
    N=Subtract from
    Y=Union with
    8 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
    9 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

    10 RQRMNT_GROUP Character(6) VARCHAR2(6) NOT NULL Requirement Group
    11 REF_REQUIREMENT Character(9) VARCHAR2(9) NOT NULL Academic Requirement
    12 REF_RQ_LINE_NBR Character(4) VARCHAR2(4) NOT NULL Line Nbr
    13 REF_NUMBER Number(4,0) SMALLINT NOT NULL Reference Number
    14 REF_DATA Character(10) VARCHAR2(10) NOT NULL Reference Data
    15 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    17 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

    18 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
    19 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

    Prompt Table: %EDITTABLE7

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

    Prompt Table: %EDITTABLE

    21 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.
    22 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    23 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component
    24 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    25 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.
    26 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
    27 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute
    28 CRSE_ATTR_VALUE Character(10) VARCHAR2(10) NOT NULL Course Attribute Value
    29 DESCR254A Character(254) VARCHAR2(254) NOT NULL Condition Description