06/19/1998 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 including Student ID; Student ID changes are facilitated via a Corrected Student ID field below and so, such transactions should have the old, incorrect Student ID value in the Student ID field (data element #3) while the new, correct Student ID value is in the Corrected Student ID field (data element #24) note: Change data is thus 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 Date and Student Term End Date data element values revised (assuming all other values remain the same); nothing prohibits other data element values, e.g., 1st Student Major, from concurrently being revised, too further note that 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)	10	character	Left-justify if less than 10 characters and pad with trailing values with blanks, e.g., if actual number is 12345678, then value passed should be 12345678 followed by 2 blank characters
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, set to character blanks
5.	Net ID	10	character	optional; if none, then pad with values set to character blank
6.	Student Last Name	40	character
7.	Student First Name (middle)	40	character
8.	Release Flag	2	character	requires further discussion
9.	Student Type	1	character	U=Undergraduate, M=Masters Candidate, D=Doctoral Candidate, X=other Post Docs, Residents (health science campuses), and Official On-Leave would thus be identified as X
10.	Student Status	1	character	requires further discussion
11.	Student Term Begin Date	8	character	mmddyyyy format
12.	Student Term End Date	8	character	mmddyyyy format pass a value equal to the Term Begin Date if a student withdraws before completing the term
13.	Student College - 1st	38	character
14.	Student Major - 1st	25	character
15.	Student College - 2nd	38	character	If none, then pad with values set to character blank
16.	Student Major - 2nd	25	character	If none, then pad with values set to character blank
17.	Student College - 3rd	38	character	If none, then pad with values set to character blank
18.	Student Major - 3rd	25	character	If none, then pad with values set to character blank
19.	Student Local Address 1	30	character
20.	Student Local Address 2	30	character	If none, then pad with values set to character blank
21.	Student Local Address - City	30	character
22.	Student Local Address - State Code	2	character
23.	Student Local Address - Zip Code	5	character
24.	Corrected Student ID (a.k.a. Registration Number)	10	character	This is the new, corrected value; the old, incorrect value should still be passed in the regular Student ID field (data element #3) Left-justify if less than 10 characters and pad with trailing values with blanks, e.g., if actual number is 12345678, then value passed should be 12345678 followed by 2 blank characters If none, then pad with values set to character blank Student ID values passed in this data element should have a corresponding Record Code value of C

Selection Criteria:

Sorting Criteria:

1. by Record Code
2. within Record Code, by Student ID (a.k.a. Registration Number)

Interface File Transmission Information:

NOTE: Only campuses provide interface

All alpha character data should be passed in upper case format only and left-justified

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