Understanding Consolidate Academic Statistics Process Calculations

EMPLID

(EmplID)

Populated from the corresponding field on the STDNT_CAR_TERM record for the student's primary academic program.

INSTITUTION

(Academic Institution)

Originated from input through the Consolidated Statistics process page.

ACAD_STATS_PERIOD

(Academic Statistics Period)

Originated from input through the Consolidated Statistics process page.

CONS_STATUS

(Consolidation Status)

Result of the Consolidate Academic Statistics process (SRPCCONS). If successful, then the program logic sets the status to S (success).

ACAD_CAREER

(Academic Career)

Populated from the corresponding field on the STDNT_CAR_TERM record.

If the academic statistics period has As of Date or As of Today (system date) for its trigger, then that date triggers the cut-off for the admit term.

If the academic statistics period has Consolidation Date for its trigger, then that date triggers the cut off for the admit term (same as the As of Date or As of Today trigger).

If more than one academic career passes these criteria, then the program logic locates the active academic career.

If two academic careers are active on the same date, then the program logic looks at the primacy number. The lowest number takes precedence.

If the academic careers have the same primacy number, then the program logic will compare the effective dates (EFFDT). The later date takes precedence.

STRM

(Term)

Populated with values from the corresponding field on the STDNT_CAR_TERM record.

If the academic statistics period has As of Date or As of Today for its trigger, then the program logic reports the term from the student's primary academic program.

If the academic statistics period has Consolidation Date for its trigger, then the program logic reports the term from the student's primary academic program in relation to the consolidation as of date. For example, if you take snapshots for terms 0330, 0350, and 0370 but your consolidation as of date falls within term 0350, then the program logic reports term 0350.

WITHDRAW_CODE

(Withdrawal/Cancel)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

WITHDRAW_REASON

(Withdrawal/Cancel Reason)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

WITHDRAW_DATE

(Withdrawal/Cancel Date)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

LAST_DATE_ATTENDED

(Last Date of Attendance)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

STDNT_CAR_NBR

(Student Career Number)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

ACAD_PROG_PRIMARY

(Primary Academic Program)

Calculated from the corresponding field on the STDNT_CAR_TERM record. If a student has two or more active academic programs, the program logic calculates the primary academic program according to the primacy value of the academic programs. It is the calculated academic program that will be reported.

ACAD_LOAD_APPR

(Approved Academic Load)

Populated from the corresponding field on the STDNT_CAR_TERM record.

ACADEMIC_LOAD

(Academic Load)

Computed by the SRPCRULE/SRPCLOAD process based on units in progress and using academic load rules according to the academic statistics period.

See the logic description for the OVRD_ACADEMIC_LOAD field.

See Understanding Consolidated Statistics Processes.

OVRD_ACADEMIC_LOAD

(Override Academic Load)

The system sets this field value to N, indicating that the Academic Load field (ACADEMIC_LOAD) contains the value of the calculated academic load (ACADEMIC_LOAD_CL). You can override the calculated academic load (ACADEMIC_LOAD_CL) by selecting the Override Academic Load check box (OVRD_ACADEMIC_LOAD) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the Academic Load field (ACADEMIC_LOAD). Selecting this check box sets the OVRD_ACADEMIC_LOAD field value to Y.

ACADEMIC_LOAD_CL

(Academic Load Calculated)

Computed by the SRPCRULE/SRPCLOAD process, based on units in progress and using academic load rules according to the academic statistics period.

See the logic description for the OVRD_ACADEMIC_LOAD field.

See Understanding Consolidated Statistics Processes.

FA_LOAD

(Financial Aid Load)

Computed by SRPCRULE/SRPCLOAD.

ACADEMIC_LOAD_NSLC

(NSC Academic Load)

Calculated from units in progress and using NSC academic load rules (PS_ACAD_LOAD2_TBL) according to the academic statistics period. You can override the calculated result by selecting the Override Academic Load check box in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for this field.

See Understanding Consolidated Statistics Processes.

ACAD_LOAD_NSLC_CL

(NSC Academic Load Calculated)

Calculated from units in progress and using NSC academic load rules (PS_ACAD_LOAD2_TBL) according to the academic statistics period.

See Understanding Consolidated Statistics Processes.

ACAD_LEVEL_PROJ

(Academic Level - Projected)

Computed by SRPCRULE/SRPCLVL.

ACAD_LEVEL_PROJ_CL

(Academic Level Proj Calculated)

Computed by SRPCRULE/SRPCLVL.

ACAD_LEVEL_BOT

(Academic Level - Term Start)

Computed by the SRPCRULE/SRPCLVL process based on cumulative units and using the academic level rules according to the Academic Level Table page.

ACAD_LEVEL_BOT_CL

(Academic Level BOT Calculated)

Computed by the SRPCRULE/SRPCLVL process based on cumulative units and using the academic level rules according to the Academic Level Table page.

ACAD_LEVEL_EOT

(Academic Level - Term End)

Computed by SRPCRULE/SRPCLVL.

See the logic description for the OVRD_ACAD_LVL_ALL field.

ACAD_LEVEL_EOT_CL

(Academic Level EOT Calculated)

Computed by SRPCRULE/SRPCLVL.

See the logic description for the OVRD_ACAD_LVL_ALL field.

ACAD_LEVEL_IPEDS

(IPEDS Academic Level)

Calculated from cumulative units at the end of the term or using academic level and IPEDS academic level mapping according to the Level/Load Rules Table page. You can override the calculated result by selecting the Override All Academic Levels check box in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for this field.

See the logic description for the OVRD_ACAD_LVL_ALL field.

ACAD_LEVEL_IPED_CL

(IPEDS Academic Level Calculated)

Calculated from cumulative units and using academic level and IPEDS academic level mapping according to the Level/Load Rules Table page.

See the logic description for the OVRD_ACAD_LVL_ALL field.

SSR_NSC_CRD_LVL

(NSC Class Credential Level)

Consolidate Academic Statistics reports the NSC Classification from the Academic Plan Table. If the process finds a NSC Classification value of Bachelor’s Degree in the Academic Plan Table component, then, based on the calculated academic level, it retrieves the appropriate NSC Level Category value.

SSR_NSC_CRD_LVL_CL

Calculated NSC Class Credential Level

See the logic description for SSR_NSC_CRD_LVL

SSR_OVRD_NSC_CRLVL

(Override Calculated NSC Class Credential Level)

The system sets this field value to N, indicating that the NSC Class Credential Level field (SSR_NSC_CRD_LVL) contains the value of the calculated class credential level (SSR_NSC_CRD_LVL_CL). To override the calculated class credential level, select the Override NSC Class Credential Level check box (SSR_OVRD_NSC_CRLVL) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then select a new value for the NSC Class Credential Level field. Selecting the check box sets the SSR_NSC_CRD_LVL_CL field value to Y.

NSLDS_LOAN_YEAR

(NSLDS Loan Year)

Computed by SRPCRULE/SRPCLVL.

OVRD_ACAD_LVL_PROJ

(Override Projected Level)

Populated from the corresponding field on the STDNT_CAR_TERM record.

OVRD_ACAD_LVL_ALL

(Override All Academic Levels)

Populated from the corresponding field on the STDNT_CAR_TERM record.

The system sets this field value to N, indicating that the IPEDS Academic Level field (ACAD_LEVEL_IPEDS) and the Academic Level - Term End field (ACAD_LEVEL_EOT) contain the value of the respective calculated academic levels (ACAD_LEVEL_IPED_CL and ACAD_LEVEL_EOT_CL).

You can override the calculated academic levels (ACAD_LEVEL_IPED_CL) and (ACAD_LEVEL_EOT_CL) by selecting the Override Units For Progress check box (OVRD_ACAD_LVL_ALL) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the IPEDS Academic Level field (ACAD_LEVEL_IPEDS) and Academic Level - Term End field (ACAD_LEVEL_EOT).

Selecting this check box sets the OVRD_ACAD_LVL_ALL field value to Y.

ELIG_TO_ENROLL

(Eligible to Enroll)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_TAKEN_PRGRSS

(Units Taken for Progress)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

See the logic description for the OVRD_UNT_TAKEN_PRG field.

UNT_TAKEN_PRGRS_CL

(Calculated Progress Units)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

See the logic description for the OVRD_UNT_TAKEN_PRG field.

OVRD_UNT_TAKEN_PRG

(Override Units for Progress)

The system sets this field value to N, indicating that the Units Taken For Progress field (UNT_TAKEN_PRGRSS) contains the value of the calculated progress units (UNT_TAKEN_PRGRS_CL). You can override the calculated progress units (UNT_TAKEN_PRGRS_CL) by selecting the Override Units For Progress check box (OVRD_UNT_TAKEN_PRG) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the Units Taken for Progress field (UNT_TAKEN_PRGRSS). Selecting this check box sets the OVRD_UNT_TAKEN_PRG field value to Y.

UNT_PASSD_PRGRSS

(Units Passed for Progress)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_TAKEN_GPA

(Units Taken Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_PASSD_GPA

(Units Passed Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_TAKEN_NOGPA

(Units Taken Not Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_PASSD_NOGPA

(Units Passed Not Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_INPROG_GPA

(Units In Progress - GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_INPROG_NOGPA

(Units In Progress - Not for GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

GRADE_POINTS

(Grade Points)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_AUDIT

(Units Audited)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_TRNSFR

(Units Transferred)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_TAKEN_GPA

(Transfer Taken for GPA)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_TAKEN_NOGPA

(Transfer Taken Not for GPA)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_PASSED_GPA

(Transfer Passed for GPA)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_PASSED_NOGPA

(Transfer Passed Not for GPA)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_GRADE_POINTS

(Transfer Grade Points)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_TEST_CREDIT

(Units From Test Credit)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_OTHER

(Units From Other Credit)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_TAKEN_FA

(Fin Aid Progress Units Taken)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_PASSD_FA

(Fin Aid Progress Units Passed)

Populated from the corresponding field on the STDNT_CAR_TERM record.

UNT_TAKEN_FA_GPA

(FA Units Taken Toward GPA)

Populated from the corresponding field on the STDNT_CAR_TERM record.

GRADE_POINTS_FA

(Financial Aid Grade Points)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

UNT_TERM_TOT

(Total Term Units)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

RESET_CUM_STATS

(Reset Cum Stats at Term Start)

Currently not in use.

TOT_TAKEN_PRGRSS

(Total Taken for Progress)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_PASSD_PRGRSS

(Total Passed for Progress)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TAKEN_GPA

(Total Taken Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_PASSD_GPA

(Total Passed Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TAKEN_NOGPA

(Total Taken Not Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_PASSD_NOGPA

(Total Passed Not Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_INPROG_GPA

(Total In Progress - GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_INPROG_NOGPA

(Total In Progress - Not for GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_AUDIT

(Total Audited)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TRNSFR

(Total Transferred)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TEST_CREDIT

(Total From Test Credit)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_OTHER

(Total From Other Credit)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_CUMULATIVE

(Total Cumulative Units)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

See the logic description for the OVRD_TOT_CUM field.

TOT_CUMULATIVE_CL

(Total Cumulative Units Calculated)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

See the logic description for the OVRD_TOT_CUM field.

OVRD_TOT_CUM

(Override Total Cumulative Unit)

The system sets this field value to N, indicating that the Total Cumulative Units field (TOT_CUMULATIVE) contains the value of the calculated total cumulative units (TOT_CUMULATIVE_CL). You can override the calculated total cumulative units (TOT_CUMULATIVE_CL) by selecting the Override Total Cumulative Unit check box (OVRD_TOT_CUM) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the Total Cumulative Units field (TOT_CUMULATIVE). Selecting this check box sets the OVRD_TOT_CUM field value to Y.

TOT_GRADE_POINTS

(Total Grade Points)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TAKEN_FA

(Total Fin Aid Units Taken)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_PASSD_FA

(Total Fin Aid Units Passed)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_TAKEN_FA_GPA

(Total Fin Aid Taken Toward GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

TOT_GRD_POINTS_FA

(Total Fin Aid Grade Points)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

FORM_OF_STUDY

(Form of Study)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

See the logic description for the OVRD_FORM_OF_STUDY field.

FORM_OF_STUDY_PD

(Form of Study for Period)

Used in the United States, specifically for IRS reporting in a delivered report in the database. When you have an academic statistics period that consolidates several terms:

If the latest term form of study equals Enrollment and units equals 0, then the program logic populates FORM_OF_STUDY_PD with the prior term's form of study value.

If the latest term form of study equals Enrollment and units are greater than 0, then the program logic populates FORM_OF_STUDY_PD with the latest term's form of study value.

FORM_OF_STUDY_CL

(Form of Study Calculated)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program.

See the logic description for the OVRD_FORM_OF_STUDY field.

OVRD_FORM_OF_STUDY

(Override Form of Study)

The system sets this field value to N, indicating that the Form of Study field (FORM_OF_STUDY) contains the value of the calculated form of study (FORM_OF_STUDY_CL). You can override the calculated form of study (FORM_OF_STUDY_CL) by selecting the Override Form of Study check box (OVRD_FORM_OF_STUDY ) in the Mass Consolidated Statistics component or the Basic Data page in the Student Consolidated Stats component, then selecting a new value for Form of Study field (FORM_OF_STUDY). Selecting this check box sets the OVRD_FORM_OF_STUDY field value to Y.

TERM_TYPE

(Term Type)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic career.

CLASS_RANK_NBR

(Class Rank Nbr)

Populated from the corresponding field on the STDNT_CAR_TERM record.

CLASS_RANK_TOT

(Class Rank Total)

Populated from the corresponding field on the STDNT_CAR_TERM record.

SEL_GROUP

(Tuition Group)

Populated from the corresponding field on the STDNT_CAR_TERM record.

BILLING_CAREER

(Billing Career)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic career and primary academic program.

UNIT_MULTIPLIER

(Unit Multiplier)

Populated from the corresponding field on the STDNT_CAR_TERM record.

ACAD_YEAR

(Academic Year)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic career and primary academic program.

CUR_RESIDENT_TERMS

(Current In Residence Terms)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TRF_RESIDENT_TERMS

(Transfer In Residence Terms)

Populated from the corresponding field on the STDNT_CAR_TERM record.

CUM_RESIDENT_TERMS

(Cumulative In Residence Terms)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

REFUND_PCT

(Refund Percentage)

Populated from the corresponding field on the STDNT_CAR_TERM record.

REFUND_SCHEME

(Refund Scheme)

Populated from the corresponding field on the STDNT_CAR_TERM record.

PRO_RATA_ELIGIBLE

(Pro-rata Eligible)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic career and primary academic program.

FULLY_ENRL_DT

(Fully Enrolled Date)

Populated from the corresponding field on the STDNT_CAR_TERM record.

FULLY_GRADED_DT

(Fully Graded Date)

Populated from the corresponding field on the STDNT_CAR_TERM record.

EXT_ORG_ID

(External Org ID)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program. Relates to external study only, as entered through the External Study page in the Term Activation component.

COUNTRY

(Country)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program. Relates to external study only, as entered through the External Study page in the Term Activation component.

STUDY_AGREEMENT

(Study Agreement)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program. Relates to external study only, as entered through the External Study page in the Term Activation component.

START_DATE

(Start Date)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program. Relates to external study only, as entered through the External Study page in the Term Activation component.

END_DATE

(End Date)

Populated with values from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic program. Relates to external study only, as entered through the External Study page in the Term Activation component.

CUR_GPA

(Current GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

If the academic statistics period has As of Date or As of Today for its trigger, then the program logic uses the current GPA.

If the academic statistics period has Consolidation Date for its trigger, the program logic uses the current term GPA.

If a student is active in multiple programs and careers with different grading bases (for example, a 100-point scale and a 4-point scale), then the program logic reports only the student's primary career and program GPA.

See the logic description for the OVRD_GPA field.

GPA_CL

(GPA Calculated)

Computed by the Consolidate Academic Statistics process (SRPCCONS).

If the academic statistics period has As of Date or As of Today for its trigger, then the program logic uses the current GPA.

If the academic statistics period has Consolidation Date for its trigger, the program logic uses the current term GPA.

If a student is active in multiple programs and careers with different grading bases (for example, a 100-point scale and a 4-point scale), then the program logic reports only the student's primary career and program GPA.

See the logic description for the OVRD_GPA field.

OVRD_GPA

(Override GPA)

The system sets this field value to N, indicating that the Current GPA field (CUR_GPA) contains the value of the calculated GPA (GPA_CL). You can override the calculated GPA (GPA_CL) by selecting the Override GPA check box (OVRD_GPA) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the Current GPA field (CUR_GPA). Selecting this check box sets the OVRD_GPA field value to Y.

CUM_GPA

(Cumulative GPA)

Computed by the Consolidate Academic Statistics process (SRPCCONS). Total grade points divided by total units. If the student is active in multiple programs and careers with different grading bases (for example, 100-point scale and 4-point scale), then the program logic reports only the student's primary career and program GPA.

See the logic description for the OVRD_CUM_GPA field.

CUM_GPA_CL

(Cumulative GPA Calculated)

Computed by the Consolidate Academic Statistics process (SRPCCONS). Total grade points divided by total units. If the student is active in multiple programs and careers with different grading bases (for example, 100-point scale and 4-point scale), then the program logic reports only the student's primary career and program GPA.

See the logic description for the OVRD_CUM_GPA field.

OVRD_CUM_GPA

(Override Cum GPA)

The system sets this field value to N, indicating that the Cumulative GPA field (CUM_GPA) contains the value of the calculated GPA (CUM_GPA_CL). You can override the calculated cumulative GPA (CUM_GPA_CL) by selecting the Override Cum GPA check box (OVRD_CUM_GPA) in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component, then selecting a new value for the Cumulative GPA field (CUM_GPA). Selecting this check box sets the OVRD_CUM_GPA field value to Y.

OVRD_TUIT_GROUP

(Override Tuition Group)

Populated from the corresponding field on the STDNT_CAR_TERM record.

OVRD_WDRW_SCHED

(Override Withdrawal Schedule)

Populated from the corresponding field on the STDNT_CAR_TERM record based on the student's primary academic career and primary academic program.

TUITION_RES_TERMS

(Tuition Residency)

Populated from the corresponding field on the STDNT_CAR_TERM record.

TC_UNITS_ADJUST

(TC Units Adjustment)

Populated from the corresponding field on the STDNT_CAR_TERM record.

STDNT_COHORT_PRIM

(Primary Student Cohort)

The Consolidate Academic Statistics process (SRPCCONS) reports one student attribute only for cohort processing. Define student attributes and their valid values on the Student Attributes Table page. Define the student attribute for cohort reporting at your institution on the Institution 3 page. When you run the process, it calls, for each student, a routine to retrieve the student's most primary student attribute value for the specific student attribute for cohort value that you define on the Institution 3 page. Assign student attributes and values to students on the Student Attributes page of the Student Program/Plan component.

ETHNIC_GROUP_SR

(Ethnic Group)

Populated from joining the ETHNICITY_DTL record which contains the ETHNIC_GRP_CD against the ETHNIC_GRP_TBL which contains ETHNIC_GROUP, which is reported.

See Setting Up Statistic Period Types.

AGE_CATEGORY_SR

(Age Category)

Populated from the corresponding field on the PERSON record. Age categories are defined per IPEDS rules. The program logic calculates age by using a student's birth date from personal data (based on system date) and comparing their birth date to the as of date, as of today date (system date), or consolidation as of date.

DEGREE

(Degree)

Populated from the ACAD_DEGR record if the ACAD_PLAN for the ACAD_PROG being reported matches the ACAD_PLAN in the ACAD_DEGR_PLAN record.

EXP_GRAD_TERM

(Expected Graduation Term)

Populated from corresponding field on the ACAD_PROG record based on the student's primary academic program.

COMPLETION_TERM

(Completion Term)

Populated from the corresponding field on the ACAD_PROG record based on the student's primary academic program.

If the statistics type includes the academic program status Completed, the process selects those students who have a completion term that is greater than or equal to the consolidated statistics term (STRM), and those whose effective date of the student's completion row is greater than or equal to the term start date and less than or equal to the term end date.

DEGR_CONFER_DT

(Confer Date)

Populated from the ACAD_DEGR record if the ACAD_PLAN for the ACAD_PROG being reported matches the ACAD_PLAN in the ACAD_DEGR_PLAN record.

ENRL_STAT_CHG_DT

(Enrollment Status Change Date)

Populated based on the program action on the ACAD_PROG record. If the program status is CM and the program action is COMP, the DEGR_CONFER_DT is reported. If the program status is CM and the program action is not COMP, the EFFDT of the ACAD_PROG record is reported. If the program status is active or waitlisted, and during the term a program or NSC reporting unit change has occurred, the date of the change is reported. Otherwise, no date is reported. If any other program status is reported, the EFFDT of the ACAD_PROG record is reported.

See Understanding Consolidated Statistics Processes.

ACAD_PROG_MAIN

(Academic Program)

Populated with the student's primary academic program (ACAD_PROG) within the student's primary academic career based on the STDNT_CAR_TERM record.

STDNT_CAR_NBR_MAIN

(Student Career Number)

Populated with the student career number (STDNT_CAR_NBR ) based on the student's primary academic career and primary academic program as found on the STDNT_CAR_TERM record.

ACAD_PLAN

(Academic Plan)

Calculated from the corresponding field on the ACAD_PLAN record based on the student's calculated primary academic program.

ACAD_SUB_PLAN

(Academic Subplan)

Populated from the corresponding field on the ACAD_SUBPLAN record based on the student's primary academic program.

EXTRA_ACTIVITY

(Extracurricular Activity)

Populated from the corresponding field on the EXTRACUR_ACTVTY record. Primacy is taken into consideration by joining PS_EXTR_ACTVTY_TBL on common keys.

SF_1098_GRAD_FLG

(1098 Grad Flag)

Currently not in use, reported as N.

SF_1098_HLFTME_FLG

(1098 Half Time Flag)

Currently not in use, reported as N.

CORRECTION_STATUS

(Correction Status)

Currently not in use, reported as 1.

SF_CORRECTION_DTTM

(Correction Date Time)

Currently not in use, reported as NULL.

SF_OVERRIDE_GRAD

(Override Grad Flag)

Currently not in use, reported as N.

SF_OVERRIDE_HALF

(Override Half Flag)

Currently not in use, reported as N.

SF_ORIGINAL_SENTDT

(Original Sent Date)

Currently not in use, reported as NULL.

SF_ORIGINAL_PRT_DT

(Original Print Date)

Currently not in use, reported as NULL.

ATHLETIC_AID

(Athletic Aid)

Populated from FIN_AID_TYPE field found on the financial aid record ITEM_TYPE_FA. If the FIN_AID_TYPE value equals A (athletic), then the program sets the ATHLETIC_AID flag for consolidated statistics to Y (yes). You can override this value with the Athletic Aid check box in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component.

PROG_STATUS

(Program Status)

This is the student's status within her or his primary academic program.

MULTI_ACAD_CAREER

(Multiple Academic Career)

The program logic sets this flag to Y (yes) if the program is consolidating multiple careers and programs for a student regardless of a student's enrollment status. You can override this value with the Multiple Academic Career check box in the Mass Consolidated Statistics component or on the Basic Data page in the Student Consolidated Stats component.

FA_UNIT_WARNING

(Excluded FA eligible Term Warn)

SRPCCONS currently does not calculate the value for the FA_UNIT_WARNING flag. The program logic sets this field value to N (no).

CAMPUS

(Campus)

Populated from the corresponding field on the ACAD_PROG record based on the student's primary academic program.

LEVEL_LOAD_RULE

(Level Load Rule)

The academic level and load rule that the SRPCCONS process uses to calculate the student's academic level and academic load.

OPRID

(Operator ID)

Populated from the corresponding field on the run control table PS_RUN_CNTL_CONS, based on the user who saved the Consolidated Statistics process page.

LASTNAME_RPTD_NSLC

(Last name Reported NSLC)

Populated from input through the Consolidated Statistics process page provided that a value was entered into the Prev Stat NSC (pervious statistics NSC) field on the page.

The program will use the EMPLID, INSTITUTION, and ACAD_STATS_PERIOD to pull up the STDNT_CONS_STAT record from the previous NSC run and pull the data from the record. STDNT_CONS_STAT record will have the Last Name field populated when SRNSLCEX.SQR is run (Manage Academic Records, Reports, NSC).

SSN_RPTD_NSLC

(SSN Reported NSLC)

Populated from input through the Consolidated Statistics process page provided that a value was entered into the Prev Stat NSC field on the page.

The program will use the EMPLID, INSTITUTION, and ACAD_STATS_PERIOD to pull up the STDNT_CONS_STAT record from the previous NSC run and pull the data from the record. STDNT_CONS_STAT record will have the SSN field populated when SRNSLCEX.SQR is run (Manage Academic Records, Reports, NSC).

PREV_STATSPER_NSLC

(Prev Acad Stats Period NSLC)

Originated from data on the Consolidated Statistics process page when the process is run.

SSR_NSC_PRG_IND

(Program Indicator)

If a student has at least one valid academic plan(for the reporting period) that has been identified on the Academic Plan table as a plan that should be reported as an "NSC Program" (ACAD_PLAN_TBL.SSR_NSC_INCL_PLAN = Y), then this value is set to Yes.

SSR_NSC_PRG1_CIPCD

(Program CIP Code)

The Consolidated Statistics process reports the CIP code for the academic plan. The value is retrieved from the table ACAD_PLAN_TBL and the column CIP_CODE.

See Setting Up Taxonomy

SSR_NSC_PRG1_CIPYR

(CIP Year)

The year in which the CIP code being reported was published. Because this value can change over time, the value is attached to the Statistics Type definition.

The data is retrieved from the table ACD_STAT_TP_TBL and the column SSR_NSC_PRG_CIPYR.

See Setting Up Statistic Period Types

SSR_NSC_PRG1_CRLVL

(Program Credential Level)

The credential level of the program required by the NSC. The Code and Description values are:

• 01: Undergraduate Certificate of Diploma Program

• 02: Associate’s Degree

• 03: Bachelor’s Degree

• 04: Post Baccalaureate Certificate

• 05: Master’s Degree

• 06: Doctoral Degree

• 07: First Professional Degree

• 08: Graduate / Professional Certificate

• 99: Non Credential Program (Preparatory Coursework / Teacher Certification

These values are mapped from the NSC Credential Level values attached to the student’s academic plan. The values are defined by Aid Year on the Financial Aid Credential Level Cross Reference page. The Consolidated Statistics process retrieves this value from the table SFA_CRDLVL_XREF and the column SFA_COD_CRED_LVL.

See Setting Up Taxonomy

See Setting Up 150 Percent Direct Subsidized Loan Limit (SULA)

SSR_NSC_PRG1_LNGTH

(Published Program Length)

The length of the instructional program in weeks, months, or years. The value in the extract is represented by six digits, with a decimal implied between the third and fourth digit. For example, an NSC report value of 036000 is 36 and 000500 is 0.5.

The value is retrieved from the table ACAD_PLAN_TBL and the column is SSR_PROG_LENGTH.

See Setting Up Taxonomy

SSR_NSC_PRG1_LENCD

(Published Length Measurement)

The code that defines the length of measurement for the Published Program Length. The Code and Description values are:

• Y: Year

• M: Month

• W: Week

The value is retrieved from the table ACAD_PLAN_TBL and the column is SSR_PROG_LEN_TYPE.

See Setting Up Taxonomy

SSR_NSC_PRG1_TT4YR

(Weeks Program Title IV Academic Year)

The number of weeks of instruction in the program’s academic year. This value is reported only if the Published Program Length is reported as either Months or Weeks. Because the value can be overridden at the student level, the Consolidated Statistics process uses the following logic to report this data:

• If the student’s academic program overrides the default value, it is reported. The value is retrieved from the table STDNT_PELL_RULE and the column is BASE_WEEKS_ACAD. See Reviewing the Student's Packaging Status

• If the default program value is not overridden, the value is used from the Aid Processing Rule setup defined for the academic program for the current aid year. The value is retrieved from the table FA_DFLT_RUL_SET and the column is BASE_WEEKS_ACAD. See Creating Aid Processing Rule Sets

• If neither value is found, the default value from the FA installation table is used. The value is retrieved from the table INSTALLATION_FA and the column is ACAD_WEEKS_BASE. See Defining Installation Level Defaults

SSR_NSC_PRG1_BGNDT

(Program Begin Date)

The date on which the student began the program. This value is calculated based on when the student became active in the current academic program from the EFFDT of the ACAD_PROG table. The valid academic program statuses used for reporting are defined on the Academic Statistics Type page. The value is retrieved from the table ACAD_PROG and the column is EFFDT.

See Setting Up Statistic Period Types

SSR_NSC_PRG1_SPIND

(Special Program Indicator)

This code is used to identify whether the program belongs to one of a select special group. The Code and Description values are:

• A: Special Admission Associate Degree Program

• B: Bachelor’s Degree Completion Program

• N: Not Applicable

• P: Preparatory Coursework Graduate/Professional

• T: Non Credential Teacher Certification

• U: Preparatory Coursework Undergraduate

The value is retrieved from the table ACAD_PLAN_TBL and the column is SFA_SPEC_PROG_FLG.

See Setting Up Taxonomy

SSR_NSC_PRG1_ENRST

(Program Enrollment Status)

The student’s enrollment status for this program in the reporting period. The Code and Description values are:

• F: Full Time

• Q: Three Quarter Time

• H: Half Time

• L: Less Than Half Time

• A: Leave of Absence

• G: Graduated

• W: Withdrawn

• D: Deceased

Different calculation methods are used, depending on the status:

• For actively enrolled students: use the number of units enrolled for the current program and get the NSC academic load. The value is retrieved from the table ACAD_LOAD_TBL and the column is ACADEMIC_LOAD_NSLC.

• Leave of Absence is reported if the academic program has a program status of LA.

• Graduated is reported if the academic program has a program status of CM.

• Deceased is reported if the academic program has a program status of DE.

• Withdrawn is reported if the:

  • Current STDNT_CAR_ TERM record has a WITHDRAW_CODE not equal to NWD and the LAST_DATE_ATTENDED is populated, or

  • Student changes plan during the reporting period. When this is the case, the student is reported in Withdrawn status for the change from plan.

SSR_NSC_PRG1_ENRDT

Program Enrollment Status Effective Date

The effective date of the current program enrollment status. The value reported here can change depending on whether enrollment status has changed since the last reporting period.

• If this is the first NSC submission of the term or there has been no change in the students enrollment status, the date is equal to the term begin date.

  Effective Update Image 28, if the Enrollment Status Date Option on the Academic Institution 3 page is set to Use the Date the Enrollment Status was Determined and there hasn't been any change in the student's enrollment status, the process reports the last enrollment status effective date that was calculated for the student. For example, if a student that starts in Fall 2022 sustains full-time enrollment throughout that term and enrolls for Spring 2023 as full-time, then the enrollment status effective date for the first Spring 2023 submission would be the start date of the Fall 2022 term.

• If the Enrollment Status has changed since the previous statistics period the date is calculated as follows:

  If the status changes to F, Q, H or L, then the date reported is the enrollment status change date from STDNT_CAR_TERM, column UNTPRG_CHG_NSLC_DT.

  If the status changes to W, then the date will be sourced differently depending on whether the student has withdrawn completely or if they have changed (or removed) a plan:

  • Withdrawal (STDNT_CAR_TERM record has a WITHDRAW_CODE not equal to NWD)

    The date reported is the LAST_DATE_ATTENDED value from the STDNT_CAR_TERM row.

  • Plan Change (student changed plans during the reporting period)

    The date reported is the date the student changed from the plan, that is, the effective date of the change row on the student’s program stack (ACAD_PROG.EFFDT).

  If the status changes to G, then the date reported is the effective date from the program stack Completed row (ACAD_PROG.EFFDT).

SSR_NSC_PRG1_DTADJ

Enrollment Data Adjusted: Y/N

This field will be populated if the Enrollment Status Date Option on the Academic Institution 3 page (delivered in Update Image 28) is enabled. When enabled, the value will be set to Yes if the enrollment status date has been adjusted based on an evaluation of the student’s consolidated statistics history. That is, the date has been determined not only by statistics periods that were run, but also any prior statistics period data generated for the student.

If the value was set to Yes, then the first time the process was run with the new option enabled, the Yes value is carried over to subsequent statistics periods but the process will not reevaluate the student’s entire consolidated statistics history

SSR_NSC_PRG1_USEDT

Use Adjusted Date: Y/N

This field will be populated if the Enrollment Status Date Option on the Academic Institution 3 page (delivered in Update Image 28) is enabled and indicates that the Enrollment Status Effective Date was adjusted using the student’s consolidated statistics history rather than the Term Begin Date.

SSR_NSC_PRG1_STAT

Status

• S: Success

• I: Incomplete Data

• Date Adjusted: The enrollment status effective date was adjusted using historical consolidated statistics data.

• Same CIP Merged: This status is assigned if Consolidate by NSC Five-Point Match Criteria is enabled and two or more plans are matched.

• Same CIP Found: This value will be returned if Consolidate by NSC Five-Point Match Criteria isn't enabled and is intended as a warning message to alert the user to possible duplicates.

• Date Based On Enrollment Data: This status is used when the process finds discrepancies in the historical statistics data and used STDNT_CAR_TERM or STDNT_ENRL data to calculate a revised enrollment status effective date.

• Date Based on As Of Date: The process was unable to calculate a revised enrollment status date using historical statistics data or by evaluating STDNT_CAR_TERM or STDNT_ENRL data and therefore used the Statistics Period.