STDNT_CAR_TERM - Student Career Term Table

 

WARNING: Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

This core table contains summary data for each student

Detailed Information

Data Systems

  • PeopleSoft Campus Solutions Production CSPRD
  • PeopleSoft Campus Solutions Reporting CSRPT

See Credit Hour Reporting Information for more tips on the proper use of this table.

PeopleSoft Navigation Paths

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  
Key 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
F - Full-Time, P - Part-Time
  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

 
  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)
Key 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 
Financial Aid Load
F - Enrolled Full-Time
H - Enrolled Half-Time
L - Less than Half-Time
N - No Unit Load
T - Three Quarter Time
  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 
Form of Study    
From Term Activation
CAND - Advanced to Candidacy
APPL - Applied for Degree
AWAY - Away
ENRL - Class Enrollment
DTCH - Detached Study
INTS - Internship
MULT - Multi-Campus
NSE  - National Student Exchange
SPEC - Special
ABRD - Study Abroad
DIST - UMS Other
  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  
Key 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 Credit Hours 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 Credit Hours Num4.2   Max Grd Pt From Enrollment Limit
  MAX_TOTAL_UNIT - Max Total Credit Hours Num4.2   Max Credit Hours From Enrollment Limit
  MAX_WAIT_UNIT - Max Wait List Credit Hours Num4.2   Max Wait From Enrollment Limit
  MIN_TOTAL_UNIT - Min Total Credit Hours Num4.2   Min Credit Hours From Enrollment Limit
  NSLDS_LOAN_YEAR - NSLDS Loan Year Char1 N Loan Year 
NSLDS Loan Year
0 - 1st Year - Never Attended
1 - 1st Year - Previously Attended
2 - 2nd Year
3 - 3rd Year
4 - 4th Year
5 - 5th Year+
A - 1st Year Graduate
B - 2nd Year Graduate
C - 3rd Year Graduate
D - 4th or more Graduate
G - Graduate/Professional
  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_Credit Hours - Override Billing Credit Hours 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_Credit Hours - Override Maximum Credit Hours Char1   Ovrd Credit Hours

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 Credit Hours Num3.0   Bill Credit Hours  
  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

R - Registered
N - Not Registered
Y - 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 - Credit Hours Taken Toward GPA Num6.3   Enrl Tot GPA  
  SSR_TOT_TR_GRDPTS - Transfer Credit Grade Points Num7.3   Grade Points  
  SSR_TOT_TR_TKNGPA - Credit Hours 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
Key STRM - Term Char4   Term From Term Activation
  STUDY_AGREEMENT - Study Agreement Char10   Agreement From External Study
  TC_Credit Hours_ADJUST - TC Credit Hours Adjustment Num6.3   TC Credit Hours Adjust From Terms in Residence
  TERM_TYPE - Term Unit Type Char1   Term Type  
  TOT_AUDIT - Total Audited Num6.3   Audit  
  TOT_CUMULATIVE - Total Cumulative Credit Hours 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 Credit Hours 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 Credit Hours 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 - Credit Hours Audited Num6.3   Audit From Student Grades
  UNT_INPROG_GPA - Credit Hours 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 - Credit Hours from Other Credit Num6.3   Other  
  UNT_PASSD_FA - Fin Aid Progress Credit Hours Passed Num6.3   FA Passed  
  UNT_PASSD_GPA - Credit Hours Passed Toward GPA Num6.3   Pass GPA From Student Grades
  UNT_PASSD_NOGPA - Credit Hours Passed Not Toward GPA Num6.3   PassNoGPA From Student Grades
  UNT_PASSD_PRGRSS - Credit Hours Passed for Progress Num6.3   Pass Prgrs From Student Grades
  UNT_TAKEN_FA - Fin Aid Progress Credit Hours Taken Num6.3   FA Taken  
  UNT_TAKEN_FA_GPA - FA Credit Hours Taken Toward GPA Num6.3   FA Credit Hours T  
  UNT_TAKEN_GPA - Credit Hours Taken Toward GPA Num6.3   Take GPA From Student Grades
  UNT_TAKEN_NOGPA - Credit Hours Taken Not Toward GPA Num6.3   TakeNoGPA From Student Grades
  UNT_TAKEN_PRGRSS - Credit Hours Taken for Progress Num6.3   Take Prgrs From Student Grades
  UNT_TERM_TOT - Total Term Credit Hours Num6.3   Total From Student Grades
  UNT_TEST_CREDIT - Credit Hours from Test Credit Num6.3   Test  
  UNT_TRNSFR - Credit Hours Transferred Num6.3   Transfer  
  WITHDRAW_CODE - Withdrawal \ Cancel Char3 N Wdraw Code

CAN - Cancelled
WDR - Withdrew
  WITHDRAW_DATE - Withdrawal \ Cancel Date Date   Wdraw Date  
  WITHDRAW_REASON - Withdrawal \ Cancel Reason Char4 N WithdrlRsn 
Withdrawal \ Cancel Reason
AD00 - Administrative Decision 0%
ADM  - Administrative Decision 100%
AD25 - Administrative Decision 25%
AD33 - Administrative Decision 33%
AD50 - Administrative Decision 50%
AD75 - Administrative Decision 75%
CVXW - COVID Vaccine Non-Compliance
NOSH - Did Not Attend
MEDI - Medical
NPAY - Non-Payment of Fees
RETR - Retroactive
STRQ - Student Request
ADTU - Tuition Only 100%
WITH - Withdrawal
Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)