Definition

Record Count is the raw number of records included in the CBIL Enrollment Report (or rows in the CBIL_HISTORY_FACTS table) for a given term. Record Count includes any student enrolled in at least one course in the table CF_STDNT_ENRL where the field STDNT_ENRL_STATUS = 'E', even if the student is only registered in message courses. The data point "IR Record Count" in the CBIL Enrollment Report is calculated using the aggregate function COUNT on the field CF_EMPLID in the table CBIL_HISTORY_FACTS.

Also see Headcount

SQL

The following SQL code is used to detemine which students are included in the tables CBIL_HISTORY_FACTS and CBIL_HISTORY_COURSE_FACTS:

create table IR.CBIL_CF_STDNT_ENRL
as select CART.EMPLID,
CART.INSTITUTION,
CART.ACAD_CAREER,
CART.STRM,
ENRL.SESSION_CODE,
TERM.TERM_BEGIN_DT,
TERM.TERM_END_DT,
TERM.WEEKS_OF_INSTRUCT,
CLAS.CLASS_NBR,
CLAS.SUBJECT,
CLAS.CATALOG_NBR,
CLAS.CLASS_SECTION,
CLAS.SSR_COMPONENT,
CLAS.DESCR as CLASS_DESCR,
ENRL.STDNT_ENRL_STATUS,
ENRL.STATUS_DT,
ENRL.ENRL_ADD_DT,
ENRL.ENRL_DROP_DT,
ENRL.CRSE_COUNT,
ENRL.UNT_TAKEN,
ENRL.UNT_PRGRSS,
ENRL.UNT_PRGRSS_FA,
ENRL.UNT_BILLING,
ENRL.UNT_EARNED,
ENRL.GRADING_BASIS_ENRL,
ENRL.CRSE_GRADE_OFF,
ENRL.GRADE_DT,
ENRL.REPEAT_CODE,
ENRL.REPEAT_DT,
ENRL.TSCRPT_NOTE_ID,
ENRL.EARN_CREDIT,
ENRL.INCLUDE_IN_GPA,
ENRL.UNITS_ATTEMPTED,
ENRL.GRADE_POINTS,
ENRL.GRADE_POINTS_FA,
ENRL.GRD_PTS_PER_UNIT,
ENRL.RQMNT_DESIGNTN as CF_ENRL_RQMNT_DESIGNTN,
ENRL.RQMNT_DESIGNTN_OPT as CF_ENRL_RQMNT_DESIGNTN_OPT,
ENRL.RQMNT_DESIGNTN_GRD as CF_ENRL_RQMNT_DESIGNTN_GRD,
CTLG.CRSE_ID,
CTLG.CRSE_CONTACT_HRS,
CTLG.RQMNT_DESIGNTN,
CTLG.COURSE_TITLE_LONG,
CLAS.INSTRUCTION_MODE,
CLAS.LOCATION,
CLAS.CAMPUS,
CLAS.ACAD_GROUP,
CLAS.ACAD_ORG,
CLAS.ENRL_CAP,
CLAS.WAIT_CAP,
CLAS.MIN_ENRL,
CLAS.ENRL_TOT,
CLAS.WAIT_TOT,
CLAS.START_DT as CF_CLASS_START_DT,
CLAS.END_DT as CF_CLASS_END_DT
from ERP.CF_STDNT_ENRL ENRL
inner join ERP.CF_STDNT_CAR_TERM CART
on CART.EMPLID = ENRL.EMPLID
and CART.INSTITUTION = ENRL.INSTITUTION
and CART.ACAD_CAREER = ENRL.ACAD_CAREER
and CART.STRM = ENRL.STRM
inner join ERP.CF_TERM_TBL TERM
on TERM.INSTITUTION = ENRL.INSTITUTION
and TERM.ACAD_CAREER = ENRL.ACAD_CAREER
and TERM.STRM = ENRL.STRM
inner join ERP.CF_CLASS_TBL CLAS
on CLAS.INSTITUTION = ENRL.INSTITUTION
and CLAS.STRM = ENRL.STRM
and CLAS.CLASS_NBR = ENRL.CLASS_NBR
inner join ERP.CF_CRSE_CATALOG CTLG
on CTLG.CRSE_ID = CLAS.CRSE_ID
and CTLG.EFFDT = (select max(X.EFFDT)
from IR.CF_CRSE_CATALOG X
where X.CRSE_ID = CTLG.CRSE_ID
and X.EFF_STATUS = 'A'
and X.EFFDT < TERM.TERM_END_DT)
where ENRL.STDNT_ENRL_STATUS = 'E'
and ENRL.STRM > '1122';