BUSN

0505 (fall semester 2003)

09/20/03

BUSN

0518 (spring semester 2004)

02/01/04

LAW

0507 (fall quarter 2003)

09/15/03

LAW

0512 (spring quarter 2004)

01/30/04

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.

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.

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.

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.

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.

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.

Note. The field value is derived according to IPEDS reporting requirements if the academic statistics type is identified as IPEDS.

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.

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.

Consolidated Statistics

RUNCTL_CONS_STATS

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Process Consolidate Statistics, Consolidated Statistics

Consolidate students' academic statistics for an academic statistics period.

Academic Institution

Select the academic institution that contains the academic statistics period for which you want to run the process.

Academic Statistics Period

Select the academic statistics period for which you want to run the process.

Prev Stats NSC (previous statistics National Student Clearinghouse)

Select the academic statistics period used as the source for the previous NSC Extract report that your institution submitted to the NSC within the current reporting period.

The Prev Stats NSC field enables your institution to report enrollment status changes to the NSC throughout a reporting period so that student loan lenders know when a student's enrollment status declines. The field enables the Consolidate Academic Statistics process to perform a comparison of a student's current enrollment status to that which was previously reported to the NSC within the same reporting period. The current report thus includes only the key differences between it and the previous report.

Use the Prev Stats NSC field only if you have previously reported to the NSC for the current reporting period or term. Do not use this field for a first of term submission to the NSC.

Consolidation Mode

Select the consolidation mode to indicate how the process that you are running writes its results to the applicable table. The Take Term Statistics Snapshot and the Recurring Term Snapshot processes write results to a temporary holding table (PS_STDNT_CARTRM_PD). Each student has only one row for an academic career, term, and snapshot date combination. The Consolidate Academic Statistics process writes results to the consolidated statistics table (PS_STDNT_CONS_STAT). Each student has only one row for each academic institution and academic statistics period combination. Values for this field are delivered with your system as translate values. Do not modify these values in any way. Any modifications to these values require a substantial programming effort. Select from the following choices.

Insert: Select this option to have the Take Term Statistics Snapshot process and the Recurring Term Snapshot process insert only new rows into the temporary holding table and leave untouched the rows in the table where students already have data for the academic career, term, and snapshot date combination. Or, select this option to have the Consolidate Academic Statistics process insert only new rows into the consolidated statistics table and leave untouched the rows in the table where students already have data for the academic institution and the academic statistics period combination specified for this run of the process.

Overwrite: Select this option to have the Take Term Statistics Snapshot process and the Recurring Term Snapshot process delete all existing rows from the temporary holding table where students already have data for the academic career, term, and snapshot date combination, then insert new rows into the table for students that have data for the academic career, term, and snapshot date combination. Or, select this option to have the Consolidate Academic Statistics process delete all existing rows from the consolidated statistics table where students already have data for the academic institution and academic statistics period combination specified on this page, then insert new rows into the table for students that have data for the academic institution and academic statistics period combination.

Commit Frequency

The system sets the commit frequency to 1. For other processes this is generally the best option. However, for these processes, you should set the commit frequency higher, such as 300, for faster processing of the job due to the potentially large volume of records.

Academic Career

The system displays a grid on the lower portion of the page only if the academic statistics period that you select has Consolidation Date as its consolidation trigger. To populate the temporary holding table when you run the Take Term Statistics Snapshot process and the Recurring Term Snapshot process, enter the academic career, term, and snapshot date combinations for which you want the process to create student records in the temporary holding table. The combinations must be valid ones that your institution has defined for this academic statistics period on the Academic Statistics Period page.

In this field, select the academic career for which you want the Take Term Statistics Snapshot process or the Recurring Term Snapshot process to create student records in the temporary holding table.

Term

Select the term within the academic career for which you want the Take Term Statistics Snapshot process or the Recurring Term Snapshot process to create student records in the temporary holding table.

Overwrite

Select to have the Take Term Statistics Snapshot process or the Recurring Term Snapshot process delete all existing rows from the temporary holding table (STDNT_CARTRM_PD), where students already have data for the academic career, term, and snapshot date combination, then insert new rows into the table for students that have data for the academic career, term, and snapshot date combination. Selecting this check box enables you to rerun the Take Term Statistics Snapshot process without retaining the values in the temporary holding table that were generated from a previous run of the process.

If you set the Consolidation Mode field for the academic statistics period to Insert, then select the Overwrite check box for an individual row, the process deletes and replaces data records in the temporary holding table that match the academic institution, academic statistics period, academic career, and term for that individual row.

Student Consolidated Stats - Basic Data (student consolidated statistics - basic data)

STDNT_CONS_STATS0

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Student Consolidated Stats, Basic Data

View basic data about a student's consolidated academic statistics for an academic statistics period, such as the student's primary academic career, term, primary academic program, academic level and load determination, and academic program status. Also use this page to view the calculated results of the Consolidate Academic Statistics process (SRPCCONP) for the student's academic load, academic level, units, form of study, and GPA. If necessary, override the calculated results.

Student Consolidated Stats - Statistics (student consolidated statistics - statistics)

STDNT_CONS_STATS1

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Student Consolidated Stats, Statistics

View a student's consolidated term statistics and cumulative statistics for an academic statistics period.

Withdrawal/External Study

STDNT_CONS_STATS3

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Student Consolidated Stats, Withdrawal/External Study

View withdrawals and cancellations on a student-by-student basis for an academic statistics period. Also use this page to view consolidated external study programs that apply towards a student's academic career, such as study abroad.

Demographics/Last Action

STDNT_CONS_STATS6

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Student Consolidated Stats, Demographics/Last Action

View a student's age category, ethnic group, primary cohort, and latest consolidation status for the academic statistics period.

Calculate

If the academic statistics period for which you have calculated the student's consolidated academic statistics has As of Date or As of Today for its consolidation trigger, you can recalculate the student's consolidated statistics. Click this button to have the system rerun the Consolidate Academic Statistics process for this student's academic record in the academic institution and academic statistics period that you specify. If the academic statistics period has Consolidate Date for its consolidation trigger, then rerunning the Consolidate Academic Statistics process with the Calculate button has no bearing on the student's calculated results. This is because the process is retrieving statistics from the temporary holding table populated by either the Take Term Statistics Snapshot process (SRPCCONA) or the Recurring Term Snapshot process (SRPCCONU) rather than retrieving data from the student's records. The only way to recalculate a student's academic statistics in such a case is to first retake the term snapshots through the Term Statistics Snapshot process or the Recurring Term Snapshot process.

Reset Cum Stats at Term Start (reset cumulative statistics at term start)

If this check box is selected, all statistics have been reset to zero at the start of the given term. If this check box is cleared, statistics have been accumulated from previous terms and added to the given term. This check box is set on the Cumulative Statistics page of the Term History component.

Mass Consolidated Statistics

STDNT_CONS_MASS0

Records and Enrollment, Enrollment Reporting, Consolidated Statistics, Mass Consolidated Statistics, Mass Consolidated Statistics

Search for and view groups of students and update their consolidated academic statistics.

Multiple Academic Career

Select to have the system retrieve only those students who have multiple academic careers and also meet your search criteria.

Excluded Eligible Term Warn

Select to have the system retrieve only those students who meet your search criteria and also have been excluded from financial aid eligibility due to an insufficient number of units.

Search

Click to have the system retrieve and display the results meeting your selection criteria. The system pulls the statistics from the consolidated statistics table (PS_STDNT_CONS_STAT) and displays the results in the grid in the lower portion of the component. Select the tabs to move from one set of statistics to the next.

Veterans Report

RUNCTL_SRVETRPT

Records and Enrollment, Enrollment Reporting, Veterans Report, Veterans Report

Run the Veterans Report process to process veteran information and print a hard-copy report listing all students who receive veterans benefits.

As of Date

Enter the date through which the veterans benefits data is valid. This date appears on the Veterans report.

Academic Institution

Select the academic institution for which you are producing the report.

Academic Statistics Period

Select the academic statistics period for which you are producing the report.

Term

(Optional) Select the term that your institution is reporting to the Veterans Administration.

Session

(Optional) Select the session that your institution is reporting to the Veterans Administration. Values for this field are delivered with your system as translate values. You can modify these values.

Academic Program

(Optional) Select an academic program.

Sort Order

The system sets the sort order for the report to Name and sorts the names alphabetically. You can sort by academic program or Social Security number.

NSC Report National Student Clearinghouse report)

RUNCTL_SRNSLC

Records and Enrollment, Enrollment Reporting, NSC Report, NSC Report

Run the NSC Report process to generate a flat file extract of students enrolled during a specific period of time that you can then send electronically to the NSC.

Academic Institution

Select the academic institution for which you are producing the report.

Academic Statistics Period

Select the academic statistics period for which you are producing the report.

Use Graduate Level Indicator

If your institution participates in the NSC tax reporting service, select this check box to have the NSC Report process include a graduate level indicator in the NSC extract file. The report process looks in the ACAD_CAR_TBL record for the graduate level indicator for the student's primary academic career. Set the graduate level indicator on the Academic Career Table 2 page. If your institution has flagged the student's primary academic career as graduate level, the report process sets the graduate level indicator flag on the extract file to Y. Otherwise, the report process sets the graduate level indicator flag on the extract file to N. Institutions not participating in the NSC tax reporting service should clear this check box.

Note. If this check box remains cleared on this page, the NSC Report process does not write a graduate level indicator to the extract, regardless of whether your institution has set graduate level indicators on the Academic Career Table 2 page.

SSN Exclusions (social security number exclusions)

Use these fields to exclude school-generated Social Security numbers and identification numbers from the NSC Extract report, as required by the NSC. Enter into each field the first three digits of the series you want to exclude, such as the 000 series and the 999 series. The NSC Extract process excludes all Social Security numbers within the series. You can list anywhere from zero to five series.

Branch Code

Select the branch code for the NSC extract.

Report Type

Select from the following choices the report type for the NSC extract. Values for this field are delivered with your system as translate values. Do not modify these values in any way. Any modifications to these values require a substantial programming effort.

Graduates Only: The process includes only graduated students.

Non-Standard Report: The process includes only academic sessions not considered regular academic sessions, such as summer session.

Standard Report: The process includes only regular academic sessions.

Address Usage

Select the address usage that the NSC Extract process should follow. Address usage is how the process locates the address of students included in the extract.

FICE Code (Federal Interagency Committee on Education code)

Enter the FICE code to appear in the NSC extract for this academic institution. This value appears by default from the Academic Institution 3 page.

Output File

In addition to sending report output for this process to a file (through setting preferences in the Process Monitor), you can also send any additional output files created by this process to a file directory. To send the extract output to a file directory, enter a valid directory path that maps to a folder with appropriate read and write permission. If you cannot locate such a folder, consult your system administrator.