SSR_CRSGRP_SRCH

(SQL View)
 Index Back

Course Group Detail

Use this table to specify Course and Wild Card data for single courses included in a Course Set.

SELECT a.INSTITUTION , a.SSR_CRS_GRP_ID , a.EFFDT , a.EFF_STATUS , a.DESCR50 , b.SSR_SEQ_NBR , b.SUBJECT , b.ACAD_CAREER , b.ACAD_GROUP , b.ACAD_ORG , b.CAMPUS , b.RQMNT_DESIGNTN , b.CRSE_ATTR FROM PS_SSR_CRS_GRP_HDR a LEFT OUTER JOIN PS_SSR_CRS_GRP_DTL b ON a.INSTITUTION = b.INSTITUTION AND a.SSR_CRS_GRP_ID = b.SSR_CRS_GRP_ID AND a.EFFDT = b.EFFDT

  • Related Language Record: SSR_CRSGRP_SRLN

  • Parent record: SSR_CRS_GRP_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SSR_CRS_GRP_ID Character(9) VARCHAR2(9) NOT NULL Course Group ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
    7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    8 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

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

    Prompt Table: ACAD_GROUP_TBL

    10 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_SRCH

    11 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    12 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

    13 CRSE_ATTR Character(4) VARCHAR2(4) NOT NULL Course Attribute

    Prompt Table: CRSE_ATTR_TBL