This core table contains summary data for each student.
See Credit Hour Reporting Information for more tips on the proper use of this table.
Grade data is from Term History (Navigator > Records and Enrollment > Student Term Information > Student Grades > Term Statistics tab) or Student Grades page (Navigator > Records and Enrollment > Student Term Information > Student Grades > Term Statistics tab)
Some of data is from Term Activate a Student page (Navigator > Records and Enrollment > Student Term Information > Term Activate a Student > Term Activation or Enrollment Limit or Terms in Residence or Term Control Dates or External Study).
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| ACADEMIC_LOAD - Academic Load | Char1 | Acad Load | |||
| ACADEMIC_LOAD_DT - Academic Load Change Date | Date | Load Date | |||
| → | ACAD_CAREER - Academic Career | Char4 | Career | ||
| ACAD_CAREER_FIRST - First Time in Career | Char1 | First Time Car | |||
| ACAD_GROUP_ADVIS - Academic Group of Advisor | Char5 | Group | From Enrollment Limit | ||
| ACAD_LEVEL_BOT - Academic Level - Term Start | Char3 | Strt Level | |||
| ACAD_LEVEL_EOT - Academic Level - Term End | Char3 | End Level | Do not use | ||
| ACAD_LEVEL_PROJ - Academic Level - Projected | Char3 | Proj Level | |||
| ACAD_LOAD_APPR - Approved Academic Load | Char1 | N | Acad Load | From Enrollment Limit | |
| ACAD_PROG_PRIMARY - Primary Academic Program | Char5 | Prim Prog | |||
| ACAD_YEAR - Academic Year | Char4 | Acad Year | From Term Activation | ||
| BILLING_CAREER - Billing Career | Char4 | Bill Car | From Term Activation | ||
| CLASS_RANK_NBR - Class Rank Nbr | Num5.0 | Class Rank | |||
| CLASS_RANK_TOT - Class Rank Total | Num5.0 | Of | |||
| COUNTRY - Country | Char3 | Country | From External Study | ||
| CUM_GPA - Cumulative GPA | Num6.3 | GPA | |||
| CUM_RESIDENT_TERMS - Cumulative In Residence Terms | Num4.3 | Cum Res | From Terms in Residence | ||
| CUR_GPA - Current GPA | Num6.3 | GPA | From Student Grades | ||
| CUR_RESIDENT_TERMS - Current In Residence Terms | Num4.3 | Cur Res | From Terms in Residence | ||
| ELIG_TO_ENROLL - Eligible to Enroll | Char1 | Elig Enrl | From Term Activation Y or N (check box) | ||
| → | EMPLID - Empl ID | Char11 | ID | ||
| END_DATE - End Date | Date | End Date | From External Study | ||
| ENRL_ON_TRANS_DT - Show Enrollment on Transcript | Date | Enrl Trans | From Term Control Dates | ||
| EXT_ORG_ID - External Org ID | Char11 | Org ID | From External Study | ||
| FA_ELIGIBILITY - Program Eligibility Flag | Char1 | Eligible | |||
| FA_LOAD - Financial Aid Load | Char1 | N | FA Load |
| |
| FA_STATS_CALC_DTTM - FA Stats Calc Date Time | DateTm | FA DTTM | |||
| FA_STATS_CALC_REQ - FA Stats Calculation Required | Char1 | FA Calc | |||
| FORM_OF_STUDY - Form of Study | Char4 | N | Study Form | From Term Activation | |
| FULLY_ENRL_DT - Fully Enrolled Date | Date | Full Enrl | From Term Control Dates | ||
| FULLY_GRADED_DT - Fully Graded Date | Date | Full Grded | From Term Control Dates | ||
| GRADE_POINTS - Grade Points | Num7.3 | Grd Points | |||
| GRADE_POINTS_FA - Financial Aid Grade Points | Num7.3 | FA Grd Pt | |||
| → | INSTITUTION - Academic Institution | Char5 | Institution | From Term Activation | |
| LAST_DATE_ATTENDED - Last Date of Attendance | Date | Last Date | |||
| LOCK_IN_AMT - Lock In Amount | SNm15.2 | Amount | |||
| LOCK_IN_DT - Lock In Date | Date | Date | |||
| MAX_AUDIT_UNIT - Max Audit Units | Num4.2 | Max Audit | From Enrollment Limit | ||
| MAX_CRSE_COUNT - Max Total Courses | Num3.0 | Total Crse | From Enrollment Limit | ||
| MAX_NOGPA_UNIT - Max No GPA Units | Num4.2 | Max Grd Pt | From Enrollment Limit | ||
| MAX_TOTAL_UNIT - Max Total Units | Num4.2 | Max Units | From Enrollment Limit | ||
| MAX_WAIT_UNIT - Max Wait List Units | Num4.2 | Max Wait | From Enrollment Limit | ||
| MIN_TOTAL_UNIT - Min Total Units | Num4.2 | Min Units | From Enrollment Limit | ||
| NSLDS_LOAN_YEAR - NSLDS Loan Year | Char1 | N | Loan Year |
| |
| OVRD_ACAD_LVL_ALL - Override All Academic Levels | Char1 | Ovrd Lvls | From Term Activation Y or N (check box) | ||
| OVRD_ACAD_LVL_PROJ - Override Projected Level | Char1 | Ovrd Level | From Term Activation Y or N (check box) | ||
| OVRD_BILL_UNITS - Override Billing Units | Char1 | Ovrd Bill | |||
| OVRD_INIT_ADD_FEE - Override Initial Add Fees | Char1 | Override Fee | |||
| OVRD_INIT_ENR_FEE - Override Initial Enroll Fee | Char1 | Override Fee | |||
| OVRD_MAX_UNITS - Override Maximum Units | Char1 | Ovrd Units | From Enrollment Limit Y or N (check box) | ||
| OVRD_TUIT_GROUP - Override Tuition Group | Char10 | Ov Tuit Gp | |||
| OVRD_WDRW_SCHED - Override Withdrawal Schedule | Char8 | Ov Wd Schd | |||
| PROJ_BILL_UNT - Projected Bill Units | Num3.0 | Bill Units | |||
| PRO_RATA_ELIGIBLE - Pro-Rata Eligible | Char1 | Eligible | |||
| REFUND_PCT - Refund Percentage | Num4.2 | Refund % | |||
| REFUND_SCHEME - Refund Scheme | Char8 | Scheme | |||
| REGISTERED - Registered | Char1 | N | Registered |
| |
| REG_CARD_DATE - Registration Card Date | Date | Reg Card | |||
| RESET_CUM_STATS - Reset Cum Stats at Term Start | Char1 | Cum Reset | |||
| SEL_GROUP - Tuition Group | Char10 | Group | |||
| SSR_ACTIVATION_DT - Term Activation Date | Date | Activation Date | From Term Activation | ||
| SSR_COMB_CUR_GPA - Combined Current GPA | Num6.3 | GPA | From Student Grades | ||
| SSR_CUM_EN_GPA - Enrollment Cumulative GPA | Num6.3 | Enrl Cum GPA | |||
| SSR_CUM_TR_GPA - Transfer Credit Cumulative GPA | Num6.3 | Tr Cr Cum GPA | |||
| SSR_TOT_EN_GRDPTS - Enrollment Grade Points | Num7.3 | Grade Points | |||
| SSR_TOT_EN_TKNGPA - Units Taken Toward GPA | Num6.3 | Enrl Tot GPA | |||
| SSR_TOT_TR_GRDPTS - Transfer Credit Grade Points | Num7.3 | Grade Points | |||
| SSR_TOT_TR_TKNGPA - Units Taken Toward GPA | Num6.3 | Tr Cr Tot GPA | |||
| SSR_TRF_CUR_GPA - Transfer Credit Current GPA | Num6.3 | GPA | From Student Grades | ||
| START_DATE - Start Date for Gen Standing PO | Date | Start Date | From External Study | ||
| STATS_ON_TRANS_DT - Show Statistics on Transcript | Date | Stat Trans | From Term Control Dates | ||
| STDNT_CAR_NBR - Student Career Nbr | Num3.0 | Career Nbr | From Term Activation | ||
| → | STRM - Term | Char4 | Term | From Term Activation | |
| STUDY_AGREEMENT - Study Agreement | Char10 | Agreement | From External Study | ||
| TC_UNITS_ADJUST - TC Units Adjustment | Num6.3 | TC Units Adjust | From Terms in Residence | ||
| TERM_TYPE - Term Unit Type | Char1 | Term Type | |||
| TOT_AUDIT - Total Audited | Num6.3 | Audit | |||
| TOT_CUMULATIVE - Total Cumulative Units | Num6.3 | Total | |||
| TOT_GRADE_POINTS - Total Grade Points | Num7.3 | Grade Points | |||
| TOT_GRD_POINTS_FA - Total Fin Aid Grade Points | Num7.3 | Tot FA Grd | |||
| TOT_INPROG_GPA - Total In Progress - GPA | Num6.3 | In Pr GPA | |||
| TOT_INPROG_NOGPA - Total In Progress -Not for GPA | Num6.3 | InPr NoGPA | |||
| TOT_OTHER - Total from Other Credit | Num6.3 | Other | |||
| TOT_PASSD_FA - Total Fin Aid Units Passed | Num6.3 | Pass FA | |||
| TOT_PASSD_GPA - Total Passed Toward GPA | Num6.3 | Pass GPA | |||
| TOT_PASSD_NOGPA - Total Passed Not Toward GPA | Num6.3 | PassNoGPA | |||
| TOT_PASSD_PRGRSS - Total Passed for Progress | Num6.3 | Pass Prgrs | |||
| TOT_TAKEN_FA - Total Fin Aid Units Taken | Num6.3 | Take FA | |||
| TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPA | Num6.3 | Tot FA GPA | |||
| TOT_TAKEN_GPA - Total Taken Toward GPA | Num6.3 | Take GPA | From Student Grades | ||
| TOT_TAKEN_NOGPA - Total Taken Not Toward GPA | Num6.3 | TakeNoGPA | |||
| TOT_TAKEN_PRGRSS - Total Taken for Progress | Num6.3 | Take Prgrs | |||
| TOT_TEST_CREDIT - Total From Test Credit | Num6.3 | Test | |||
| TOT_TRNSFR - Total Transferred | Num6.3 | Transfer | |||
| TRF_GRADE_POINTS - Transfer Grade Points | Num7.3 | Trnsfr Grd Pts | From Student Grades | ||
| TRF_PASSED_GPA - Transfer Passed for GPA | Num6.3 | TrnPasGPA | From Student Grades | ||
| TRF_PASSED_NOGPA - Transfer Passed Not for GPA | Num6.3 | TrnPasNGPA | From Student Grades | ||
| TRF_RESIDENT_TERMS - Transfer In Residence Terms | Num4.3 | Trf Res | From Terms in Residence | ||
| TRF_TAKEN_GPA - Transfer Taken for GPA | Num6.3 | TrnTakGPA | |||
| TRF_TAKEN_NOGPA - Transfer Taken Not for GPA | Num6.3 | TrnTakNGPA | |||
| TUITION_RES_TERMS - Tuition Residency | Num4.3 | Tuition Res. | |||
| TUIT_CALC_DTTM - Tuit Calc Date Time | DateTm | TuitDTTM | |||
| TUIT_CALC_REQ - Tuition Calc Required | Char1 | Calc Req | |||
| UNIT_MULTIPLIER - Unit Multiplier | Num5.4 | Multiplier | |||
| UNTPRG_CHG_NSLC_DT - Unit Progrss Changed Date NSC | Date | Unit ChgDt NSC | |||
| UNT_AUDIT - Units Audited | Num6.3 | Audit | From Student Grades | ||
| UNT_INPROG_GPA - Units In Progress - GPA | Num6.3 | InPr GPA | From Student Grades | ||
| UNT_INPROG_NOGPA - Unit In Progress - Not for GPA | Num6.3 | InPr NoGPA | From Student Grades | ||
| UNT_OTHER - Units from Other Credit | Num6.3 | Other | |||
| UNT_PASSD_FA - Fin Aid Progress Units Passed | Num6.3 | FA Passed | |||
| UNT_PASSD_GPA - Units Passed Toward GPA | Num6.3 | Pass GPA | From Student Grades | ||
| UNT_PASSD_NOGPA - Units Passed Not Toward GPA | Num6.3 | PassNoGPA | From Student Grades | ||
| UNT_PASSD_PRGRSS - Units Passed for Progress | Num6.3 | Pass Prgrs | From Student Grades | ||
| UNT_TAKEN_FA - Fin Aid Progress Units Taken | Num6.3 | FA Taken | |||
| UNT_TAKEN_FA_GPA - FA Units Taken Toward GPA | Num6.3 | FA Units T | |||
| UNT_TAKEN_GPA - Units Taken Toward GPA | Num6.3 | Take GPA | From Student Grades | ||
| UNT_TAKEN_NOGPA - Units Taken Not Toward GPA | Num6.3 | TakeNoGPA | From Student Grades | ||
| UNT_TAKEN_PRGRSS - Units Taken for Progress | Num6.3 | Take Prgrs | From Student Grades | ||
| UNT_TERM_TOT - Total Term Units | Num6.3 | Total | From Student Grades | ||
| UNT_TEST_CREDIT - Units from Test Credit | Num6.3 | Test | |||
| UNT_TRNSFR - Units Transferred | Num6.3 | Transfer | |||
| WITHDRAW_CODE - Withdrawal \ Cancel | Char3 | N | Wdraw Code |
| |
| WITHDRAW_DATE - Withdrawal \ Cancel Date | Date | Wdraw Date | |||
| WITHDRAW_REASON - Withdrawal \ Cancel Reason | Char4 | N | WithdrlRsn |
|
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
Attachments:
image2022-9-21_15-17-57.png (image/png)
image2022-9-21_15-18-51.png (image/png)
image2022-9-21_15-20-8.png (image/png)
image2022-9-21_15-20-55.png (image/png)
image2022-9-21_15-21-35.png (image/png)
image2022-9-21_15-22-20.png (image/png)
image2022-9-21_15-22-59.png (image/png)