1 / 12

Reporting Changes

Reporting Changes. Summer Sessions CIP Codes. New Fields for Reporting by Summer Session. Summer Sessions. New derived fields which indicate into which summer session a class falls, and a units bucket for reporting on units by session.

etoile
Download Presentation

Reporting Changes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Reporting Changes Summer Sessions CIP Codes

  2. New Fields for Reporting by Summer Session

  3. Summer Sessions • New derived fields which indicate into which summer session a class falls, and a units bucket for reporting on units by session. • New fields will be populated for rows with terms ending in ‘5’ • They are in production now!

  4. New Fields for Summer Reporting • cls_drvd_sesn_cd • cls_drvd_sesn_desc • Added to datagroups sr_cls_gt, sr_enrl_st, and any sr_cmb_cls_* and sr_enrl_* views • Values for cls_drvd_sesn_cd = ‘SS1’ or ‘SS2’ • What about the existing cls_sesn_cd field? This field and the new, derived field will generally match, although the derived code also looks at first class meeting date, and so for a very few cases, cls_sesn_cd and cls_drvd_sesn_cd are different.

  5. More New Fields for your Summer Reporting Pleasure…. • acad_drvd_term_smmr1(2)_ind • enrollment status by session • acad_drvd_term_smmr1(2)_unts • enrolled units (for progress) by session • acad_drvd_term_smmr1(2)_desc • session descriptor • acad_drvd_term_smmr1(2)_aud_unts • hours enrolled as “audit” by session • Acad_drvd_term_smmr1(2)_load_ind • load status (full time/part time) by session

  6. New Fields for Summer Reporting (cont.) • These fields have been added to datagroups sr_stu_term_st and any sr_stu_term_* views and sr_enrl_* views • These fields are calculated for rows with acad_term_cd ending in ‘5’, so don’t count on them having values for non-summer terms.

  7. Field values…. • acad_drvd_term_smmr_1_ind (smmr_2_ind) The logic behind this field matches the derived enrollment indicator, stu_drvd_enrl_stat_ind and has values ‘E’, ‘A’, ‘W’, etc. It indicates the students enrollment status for that session.

  8. Field Values… • acad_drvd_term_smmr_1_unts (smmr_2_unts) If cls_drvd_sesn_cd = ‘SS1’ (‘SS2’) and student is enrolled and class is not audit, withdrawn, non-graded etc, Then acad_unt_tkn is added to derived units field for the summary (term) row, and equals acad_unt_tkn for individual course (enrollment) rows.

  9. Questions about summer session reporting fields before moving on?

  10. CIP Code Table • CIP codes will not be added to the existing PS program and plan tables • A separate table of CIP codes and Legacy Major codes will be maintained in the data warehouse. • CIP codes required for reporting to IPEDS, ICHE, etc., will be added to the appropriate datagroups in IUIE.

  11. Status of CIP Code Table The CIP table has been loaded and moved to the data warehouse. The current CIP data was edited against the program and plan tables, and SES is currently determining CIPs for any missing program/plan combinations. The CIP codes have been added to the sr_stu_term_* and the ir_cen_term_* datagroups for plans 1, 2 and 3. SES will update the CIP code table as new program/plans are added.

  12. CIP Code Table Layout • INST_CD NOT NULL VARCHAR2(6) • ACAD_PGM NOT NULL VARCHAR2(10) • ACAD_PLAN NOT NULL VARCHAR2(15) • ACAD_PLAN_DESC VARCHAR2(40) • ACAD_PLAN_TYP_CD VARCHAR2(4) • ICHE_CIP_CD VARCHAR2(6) • ICHE_CIP_DESC VARCHAR2(40) • IPEDS_CIP_CD VARCHAR2(6) • IPEDS_CIP_DESC VARCHAR2(40) • ACAD_IU_CIP_2000_CD VARCHAR2(6) • ACAD_IU_CIP_2000_DESC VARCHAR2(40) • ACAD_LGCY_MJR_CD VARCHAR2(3) • ACAD_LGCY_MJR_DESC VARCHAR2(40) • ACAD_LGCY_SCH_CD VARCHAR2(10) • ACAD_DEGR_CD VARCHAR2(10) • ACAD_DEGR_DESC VARCHAR2(40) • ACAD_DEGR_CIP_2000_CD VARCHAR2(6) • ACAD_DEGR_CIP_2000_DESC VARCHAR2(40) • ACAD_EDUC_LVL_CD VARCHAR2(1) • STU_HLTH_IND VARCHAR2(1)

More Related