04/30/1999 DRAFT

Student Interface Data Elements from Local Campus Student Systems
Name Length Type Comments
1. Record Code 1 character A=Add, C=Change, D=Delete

C records sent for changes in any of the data elements below

note: Change data is utilized for "continuing" students; thus, continuing students do not receive a new Net ID for each continuing term, but may possibly only have their Student Term Begin/End Date and Student Term Eligibility Begin/End Date data element values revised (assuming all other values remain the same); nothing prohibits other data element values from concurrently being revised, too

Data processed via a C Record Code is processed as a complete replacement, i.e., whatever values are listed in the corresponding data elements below, then those values are to be loaded into the University Directory

D records only sent for records erroneously sent

2. Student Location Code 2 character 01=BK, 02=SF, 03=DV, 04=LA, 05=RV, 06=SD, 07=SC, 08=SB, 09=IR
3. Student ID (a.k.a. Registration Number) TBD 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

4. 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

5. Social Security Number TBD 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

6. 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

7. 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

8. 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
9. Student Last Name 40 character
10. Student First Name (middle) 40 character
11. 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

12. 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"

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

13. Student Term Begin Date 8 character yyyymmdd format
14. Student Term End Date 8 character yyyymmdd format
15. 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

16. 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 remains to be determined (TBD)

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 Record Code
  2. within Record Code, 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

note: Only campuses provide interface

All 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