SSR_CRSE_ID_V2

(SQL View)
 Index Back

Course ID View


SELECT a.crse_id , a.effdt , b.crse_offer_nbr , b.institution , a.eff_status , a.effdt , b.acad_group , b.subject , b.catalog_nbr , b.acad_career , b.campus , a.descr , a.course_title_long , b.ssr_crse_typoff_cd , a.units_minimum , a.units_maximum , a.rqmnt_designtn , b.course_approved , b.schedule_print , b.catalog_print , 'S' , CASE WHEN c.crs_topic_id IS NULL THEN 0 ELSE c.crs_topic_id END FROM ps_crse_catalog a JOIN PS_CRSE_OFFER b ON a.crse_id = b.crse_id AND a.effdt = b.effdt LEFT OUTER JOIN ps_crse_topics c ON a.crse_id = c.crse_id AND a.effdt = c.effdt

  • Related Language Record: SSR_CRSEID_V2LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: COURSE_TBL

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 ORIG_EFFDT Date(10) DATE Original Effdt
    7 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    8 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    9 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL
    10 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
    11 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 COURSE_TITLE_LONG Character(100) VARCHAR2(100) NOT NULL Long Course Title
    14 SSR_CRSE_TYPOFF_CD Character(10) VARCHAR2(10) NOT NULL Course Typically Offered

    Prompt Table: SSR_CRSE_TYPOFF

    15 UNITS_MINIMUM Number(6,2) DECIMAL(5,2) NOT NULL Minimum Units
    16 UNITS_MAXIMUM Number(6,2) DECIMAL(5,2) NOT NULL Maximum Units
    17 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.
    18 COURSE_APPROVED Character(1) VARCHAR2(1) NOT NULL Course Approved
    A=Approved
    D=Denied
    P=Pending
    19 SCHEDULE_PRINT Character(1) VARCHAR2(1) NOT NULL Schedule Print
    A=All
    N=No
    Y=Yes
    20 CATALOG_PRINT Character(1) VARCHAR2(1) NOT NULL Catalog Print
    21 SEL_MODE Character(1) VARCHAR2(1) NOT NULL Selection Mode
    22 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID