SIS Data Changes

Data Element

Old:
Example

New:
Example

Student ID (SID)

8 character

24324324
 

10 numeric characters beginning with “303”

3032424242

Term Code

 

4 digit year +
1 character alpha

2015D

A=Winter (not used)
B=Spring
C=Summer
D=Fall

 

4 numeric characters

2158

drop second character of year, append term:
2 = Spring
5 = Summer
8 = Fall

Term Name = four digit year + "Spring," "Summer," or "Fall."
Term Category Code/Description:
"R/Regular" for fall and spring
"S/Summer" for summer sessions

Reg Status Cd

1 character

N = New
C = Continuing
R = Returning
V = Visitor
W = Withdrawn
D = Dismissed
X = Cancelled
Z = Deceased

Various

N =  Registration.registered = true and Registration.new = true
C = Registration.registered = true and Registration.new = false
R = (not used)
V = Student.studentPlan.academicPlan.plan.code contains "V" or Student.studentPlan.academicPlan.academicProgram.program.code = "UNDG"
W = Registration.withdrawalCancel.type.code = "WDR" or Registration.withdrawalCancel.type.description = "Withdrew"
D = Registration.academicStanding.status = "Dismissed"
X = Registration.withdrawalCancel.type.code = "CAN" or Registration.withdrawalCancel.type.description = "Cancelled"
Z = if Student.death exists
Blank =  Registration.registered = false

U/G Flag

 

Single character 

U

 

Academic Career:

UGRD-Undergraduate

SIR Status (mBA): Y, N
Represented as Affiliation in Student API
"Student-SIR Complete"