CLST_DETL_VW

(SQL View)
 Index Back

Static Course List view

Use this view to display Course and Wild Card data for single courses included in a Course List.

SELECT B.COURSE_LIST ,B.EFFDT ,A.R_COURSE_SEQUENCE ,A.WILDCARD_IND ,A.CRSVALID_BEGIN ,A.CRSVALID_END ,A.TRNSFR_LVL_ALLOWD ,A.TEST_CRDT_ALLOWD ,A.OTHR_CRDT_ALLOWD ,A.INCL_GPA_REQ ,A.EXCL_IP_CREDIT ,A.GRADE_POINTS_MIN ,A.UNITS_MINIMUM ,A.INSTITUTION ,A.ACAD_GROUP ,A.SUBJECT ,A.CATALOG_NBR ,A.CRSE_ID ,A.INCLUDE_EQUIVALENT ,A.STRM ,A.ASSOCIATED_CLASS ,A.CRS_TOPIC_ID ,A.RQMNT_DESIGNTN ,A.DESCR FROM PS_CLST_DETL_TBL A ,PS_CLST_MAIN_TBL B WHERE A.COURSE_LIST = B.COURSE_LIST AND A.EFFDT = B.EFFDT

  • Related Language Record: CLSTDETLVW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE_LIST Character(9) VARCHAR2(9) NOT NULL Course List
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 R_COURSE_SEQUENCE Number(7,0) INTEGER NOT NULL Course Sequence
    4 WILDCARD_IND Character(1) VARCHAR2(1) NOT NULL WildCard Indicator

    Y/N Table Edit

    5 CRSVALID_BEGIN Date(10) DATE CourseValid Begin Date /Req
    6 CRSVALID_END Date(10) DATE NOT NULL Course Valid End Date /Req
    7 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
    8 TEST_CRDT_ALLOWD Character(1) VARCHAR2(1) NOT NULL Test Credit is Allowed

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    Default Value: N

    12 GRADE_POINTS_MIN Number(10,2) DECIMAL(9,2) NOT NULL Minimum Grade Points
    13 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    14 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: SUBJECT_TBL

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

    Prompt Table: CRSE_CATNO_SRCH

    18 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_R2_VW

    19 INCLUDE_EQUIVALENT Character(1) VARCHAR2(1) NOT NULL Include Equivalent Courses

    Y/N Table Edit

    Default Value: N

    20 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

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

    Prompt Table: RQ_CLS_ASN_SRCH

    22 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID

    Prompt Table: RQ_CRS_TOPIC_VW

    23 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

    24 DESCR Character(30) VARCHAR2(30) NOT NULL Description