06/04/1999 "final version"

Student Interface Data Elements from Local Campus Student Systems
Name Length Type Comments
1. Student Location Code 2 character 01=BK, 02=SF, 03=DV, 04=LA, 05=RV, 06=SD, 07=SC, 08=SB, 09=IR
2. Student ID (a.k.a. Registration Number) 40 character

This field value should have a one-way hash algorithm applied to it by the campus; see below for further information

note: this field utilizes a one-way hash because some campuses use social security number as their Student ID value

3. UC Student Vendor ID 7 character For Undergraduate students, set to value of UC Student Vendor-specific Identification Number (currently, this vendor is the Educational Testing Service (ETS))

For non-Undergraduate students, then pad with values set to character blanks

4. Social Security Number 40 character

This field value should have a one-way hash algorithm applied to it by the campus; see below for further information

If none, then pad with values set to character blanks

note: campuses using "invalid" or "temporary" SSN values should not have those values passed (hashed) on this interface as they may well result in reconciliation/matching algorithm errors; see the SSA for a list of ranges of legal values

5. Campus ID 32 character optional; left-justify if less than 32 characters and pad with trailing values set to character blanks, e.g., if actual number is 123456789, then value passed should be 123456789 followed by 23 blank characters

If none, then pad with values set to character blanks

6. Net ID 10 character optional; left-justify if less than 10 characters and pad with trailing values set to character blanks, e.g., if actual number is 1234567, then value passed should be 1234567 followed by 3 blank characters

If none, then pad with values set to character blank

7. Attribute Services Release Flag 1 character Y=Yes, N=No - indicates whether attribute services are permitted (Y) or not (N) for the following fields: Location Code, Net ID, Student Type, Student Status, and Student Term date fields (4); see below for further information
8. Student Last Name 40 character note: data may be passed in mixed case format
9. Student First Name (middle) 40 character note: data may be passed in mixed case format
10. Student Type 1 character U=Undergraduate, G=Graduate, P=Professional Schools, e.g., DDS, JD, MD, E=Extension, X=other

note: Post Docs, Medical Residents (health science campuses), and Official On-Leave would be identified as X

11. Student Status 1 character A=Admitted includes those students who have been admitted to a campus, but who are not yet defined as being "registered"; this would thus include students "with an Intent to Register"

R=Registered includes those students who have paid their registration fees for the current term, but may also include other criteria, e.g., enrolled, has no registration blocks

B=Blocked includes those students who may have been originally defined as "registered", but who have subsequently had a "block" or "hold" placed

W=Withdrawn includes those students who may have been originally defined as "registered", but who have subsequently withdrawn

F=Filing fee includes those students not technically defined as "registered", but who are also entitled to similar services

12. Student Term Begin Date 8 character yyyymmdd format

note: this should reflect the date for the student's applicable term which may not necessarily be simply the current term of the day of transmission

13. Student Term End Date 8 character yyyymmdd format

note: this should reflect the date for the student's applicable term which may not necessarily be simply the current term of the day of transmission

14. Student Term Eligibility Begin Date 8 character yyyymmdd format

This field will allow campuses who wish to effect a "grace period" for potential services to be started prior to the official start of the term; this may most commonly be used for newly entering students rather than continuing students; for those campuses not wishing to effect such a "grace period", then the same value passed in the Student Term Begin Date field should be passed here

15. Student Term Eligibility End Date 8 character yyyymmdd format

This field will allow campuses who wish to effect a "grace period" for potential services to be extended, though the term may have actually ended; this may most commonly be used for continuing students rather than for newly entering students; for those campuses not wishing to effect such a "grace period", then the same value passed in the Student Term End Date field should be passed here

one-way hash algorithm:

A one-way hash algorithm will be utilized to encrypt the fields on this student interface that may include a student's social security number; the algorithm to be employed is the SHA-1 algorithm

attribute services:

attribute services with respect to this student interface will be utilized to support library-related applications, e.g., MelWeb, access to published materials; for example, suppose a publisher, external to UC, signed an agreement with UC San Diego and UC Irvine to allow their registered students access to their materials via the web; rather than using ranges of IP addresses or new logins/passwords for authentication, a web application to access the materials could be developed whereby a UC San Diego or UC Irvine student would access the publisher's web application and then "submit" the appropriate digital certificate; the publisher's application would glean the Net ID from the certificate and execute a query to the appropriate attribute server (basically keyed by Net ID) that would return a confirmation that the holder of that certificate was eligible (or not) to access the materials based on his/her status as a UC San Diego or UC Irvine registered student. Anonymity beyond that level of information would thus be retained as well, i.e., the only things that the publisher might know is that Net ID belongs to a registered student at one of the eligible campuses; the publisher would not know the student's name. Other fields would be used to support similar types of queries.

Selection Criteria:

Those students who have at least been admitted to the campus

note: See Student Status field above for further information

Sorting Criteria:

  1. by Student ID (a.k.a. Registration Number) which has the one-way hash algorithm applied to it

Interface File Transmission Information:

Data sent from a campus to OP electronically on a daily basis, unless otherwise indicated by a campus

note: Only campuses provide interface

Except for the Student Last Name and Student FIrst Name fields which may optionally be passed in mixed case format, all other alpha character data should be passed in upper case format only and left-justified unless otherwise indicated

File Transfer Protocol(FTP) specifications, e.g., contacts, data set names, remains to be determined (TBD)


Return to Data Element Documents Page