09/30/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
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. Social Security Number 9 character

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

7. Net ID 10 character optional; left-justify if less than 10 characters and pad with trailing values with 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. Release Flag - Student Name 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values

9. Release Flag - Student Local Address 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values

10. Release Flag - Student ID 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values

11. Release Flag - Net ID 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values

12. Release Flag - All other student data elements (except for student's Social Security Number which is not displayed or "prompted for" in student applications to be developed) 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values

13. Student Last Name 40 character

14. Student First Name (middle) 40 character

15. Student Type 1 character U=Undergraduate, M=Masters Candidate, D=Doctoral Candidate, P=Professional Schools (DDS, JD, MD), X=other
Post Docs, Residents (health science campuses), and Official On-Leave would thus be identified as X

16. Student Status 1 character A=Admitted which includes those students who have at least been admitted to a campus, but who are not yet defined as being "registered"; thus, this would include those students who have paid their "intent to register" fees, but who again are not yet defined as actually being "registered"
R=Registered which includes those students who have paid their registration fees for the current term, but which may also include other criteria, e.g., enrolled, has no registration blocks
B=Blocked students who may have been originally defined as "registered", but who has been subsequently had a "block" or "hold" placed
F=Filing fee students to address those students not technically defined as "registered", but who are also entitled to similar services
W=Withdrawn students who may have been originally defined as "registered", but who have subsequently withdrawn

17. Student Term Begin Date 8 character mmddyyyy format

18. Student Term End Date 8 character mmddyyyy format

19. Student Term Eligibility End Date 8 character mmddyyyy 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; for those campuses not wishing to effect such a "grace period", then the same value as passed in the Student Term Eligibility End Date field should be passed here
note: the eligibility "begin date" would simply be the same date passed in the Student Term Begin Date field

20. Student College - 1st 50 character

21. Student Major - 1st 50 character

22. Student College - 2nd 50 character If none, then pad with values set to character blank

23. Student Major - 2nd 50 character If none, then pad with values set to character blank

24. Student College - 3rd 50 character If none, then pad with values set to character blank

25. Student Major - 3rd 50 character If none, then pad with values set to character blank

26. Student Local Address 1 32 character

27. Student Local Address 2 32 character If none, then pad with values set to character blank

28. Student Local Address - City 32 character

29. Student Local Address - State Code 2 character

30. Student Local Address - Zip Code 5 character

31. Student Local Address - Plus 4 Zip Code 5 character optional; if none, then pad with values set to character blank

**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 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.	Social Security Number	9	character
6.	Campus ID	15	character	optional; left-justify if less than 15 characters and pad with trailing values with blanks, e.g., if actual number is 123456789, then value passed should be 123456789 followed by 6 blank characters if none, then pad with values set to character blank
7.	Net ID	10	character	optional; left-justify if less than 10 characters and pad with trailing values with 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.	Release Flag - Student Name	1	character	9, 5, 1, 0 - see below for generic definition of all Release Flag field values
9.	Release Flag - Student Local Address	1	character	9, 5, 1, 0 - see below for generic definition of all Release Flag field values
10.	Release Flag - Student ID	1	character	9, 5, 1, 0 - see below for generic definition of all Release Flag field values
11.	Release Flag - Net ID	1	character	9, 5, 1, 0 - see below for generic definition of all Release Flag field values
12.	Release Flag - All other student data elements (except for student's Social Security Number which is not displayed or "prompted for" in student applications to be developed)	1	character	9, 5, 1, 0 - see below for generic definition of all Release Flag field values
13.	Student Last Name	40	character
14.	Student First Name (middle)	40	character
15.	Student Type	1	character	U=Undergraduate, M=Masters Candidate, D=Doctoral Candidate, P=Professional Schools (DDS, JD, MD), X=other Post Docs, Residents (health science campuses), and Official On-Leave would thus be identified as X
16.	Student Status	1	character	A=Admitted which includes those students who have at least been admitted to a campus, but who are not yet defined as being "registered"; thus, this would include those students who have paid their "intent to register" fees, but who again are not yet defined as actually being "registered" R=Registered which includes those students who have paid their registration fees for the current term, but which may also include other criteria, e.g., enrolled, has no registration blocks B=Blocked students who may have been originally defined as "registered", but who has been subsequently had a "block" or "hold" placed F=Filing fee students to address those students not technically defined as "registered", but who are also entitled to similar services W=Withdrawn students who may have been originally defined as "registered", but who have subsequently withdrawn
17.	Student Term Begin Date	8	character	mmddyyyy format
18.	Student Term End Date	8	character	mmddyyyy format
19.	Student Term Eligibility End Date	8	character	mmddyyyy 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; for those campuses not wishing to effect such a "grace period", then the same value as passed in the Student Term Eligibility End Date field should be passed here note: the eligibility "begin date" would simply be the same date passed in the Student Term Begin Date field
20.	Student College - 1st	50	character
21.	Student Major - 1st	50	character
22.	Student College - 2nd	50	character	If none, then pad with values set to character blank
23.	Student Major - 2nd	50	character	If none, then pad with values set to character blank
24.	Student College - 3rd	50	character	If none, then pad with values set to character blank
25.	Student Major - 3rd	50	character	If none, then pad with values set to character blank
26.	Student Local Address 1	32	character
27.	Student Local Address 2	32	character	If none, then pad with values set to character blank
28.	Student Local Address - City	32	character
29.	Student Local Address - State Code	2	character
30.	Student Local Address - Zip Code	5	character
31.	Student Local Address - Plus 4 Zip Code	5	character	optional; if none, then pad with values set to character blank

University Directory Student Release Flag Values:

9 - data element "display" permitted and "application services" permitted
5 - data element "display" permitted, but "application services" not permitted
1 - data element "display" not permitted, but "application services" permitted
0 - data element "display" not permitted and "application services" not permitted

These values will be applied to student data elements housed in the University Directory as follows:

Student Name (Last, First, or Middle)
Student Local Address (1st line, 2nd line, City, State, Zip Code)
Student ID (a.k.a Registration Number)
Net ID (for students)
all other student data elements (except for student's Social Security Number which is not displayed or "prompted for" in student applications to be developed)

Selection Criteria:

Those students who have at least been admitted to the campus

NOTE: See Student Status field above for further information

Sorting Criteria:

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

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

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

Return to Data Element Documents Page