08/31/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. Net ID 10 character optional; if none, then pad with values set to character blank

7. Release Flag - Student Name 1 character 9, 1, 0 - see below for generic definition of all Release Flag field values

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

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

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

11. 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, 1, 0 - see below for generic definition of all Release Flag field values

12. Student Last Name 40 character

13. Student First Name (middle) 40 character

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

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

16. Student Term Begin Date 8 character mmddyyyy format

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

18. Student College - 1st 38 character

19. Student Major - 1st 25 character

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

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

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

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

24. Student Local Address 1 30 character

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

26. Student Local Address - City 30 character

27. Student Local Address - State Code 2 character

28. Student Local Address - Zip Code 5 character

**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.	Net ID	10	character	optional; if none, then pad with values set to character blank
7.	Release Flag - Student Name	1	character	9, 1, 0 - see below for generic definition of all Release Flag field values
8.	Release Flag - Student Local Address	1	character	9, 1, 0 - see below for generic definition of all Release Flag field values
9.	Release Flag - Student ID	1	character	9, 1, 0 - see below for generic definition of all Release Flag field values
10.	Release Flag - Net ID	1	character	9, 1, 0 - see below for generic definition of all Release Flag field values
11.	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, 1, 0 - see below for generic definition of all Release Flag field values
12.	Student Last Name	40	character
13.	Student First Name (middle)	40	character
14.	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
15.	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
16.	Student Term Begin Date	8	character	mmddyyyy format
17.	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
18.	Student College - 1st	38	character
19.	Student Major - 1st	25	character
20.	Student College - 2nd	38	character	If none, then pad with values set to character blank
21.	Student Major - 2nd	25	character	If none, then pad with values set to character blank
22.	Student College - 3rd	38	character	If none, then pad with values set to character blank
23.	Student Major - 3rd	25	character	If none, then pad with values set to character blank
24.	Student Local Address 1	30	character
25.	Student Local Address 2	30	character	If none, then pad with values set to character blank
26.	Student Local Address - City	30	character
27.	Student Local Address - State Code	2	character
28.	Student Local Address - Zip Code	5	character

University Directory Student Release Flag Values:

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

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