06/01/1998 DRAFT

Employee "directory" Interface Data Elements from Local Campus 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; all data element values and not just the changed value

D records only sent for records erroneously sent
2. Social Security Number 9 character
3. Employee Location Code 2 character 01=BK, 02=SF, 03=DV, 04=LA, 05=RV, 06=SD, 07=SC, 08=SB, 09=IR
4. 1st Working Title 60 character
5. 1st Working Title Begin Date 8 character mmddyyyy format
6. 1st Working Title End Date 8 character mmddyyyy format
7. 1st Working Title Department 60 character
8. 1st Working Title - Appointment Academic 1 character Y=yes, corresponding Working Title is an academic appointment or N=no, corresponding Working Title is not an academic appointment
9. 2nd Working Title 60 character
10. 2nd Working Title Begin Date 8 character mmddyyyy format
11. 2nd Working Title End Date 8 character mmddyyyy format
12. 2nd Working Title Department 60 character
13. 2nd Working Title - Appointment Academic 1 character Y=yes, corresponding Working Title is an academic appointment or N=no, corresponding Working Title is not an academic appointment
14. 3rd Working Title 60 character
15. 3rd Working Title Begin Date 8 character mmddyyyy format
16. 3rd Working Title End Date 8 character mmddyyyy format
17. 3rd Working Title Department 60 character
18. 3rd Working Title - Appointment Academic 1 character Y=yes, corresponding Working Title is an academic appointment or N=no, corresponding Working Title is not an academic appointment
19. Campus Mailing Address 1 30 character
20. Campus Mailing Address 2 30 character If none, then pad with values set to character blank
21. Campus Mailing Address - City 30 character
22. Campus Mailing Address - State Code 2 character
23. Campus Mailing Address - Zip Code 5 character
24. Release Flag 1 character Process to be discussed
25. Net ID??? 10 character Process to be discussed
26. Phone Number??? 20 character Process to be discussed
27. Email Address??? 50 character Process to be discussed

Selection Criteria:

Process to be discussed, e.g., requires one-to-one correspondence with PPSIVR data?

Sorting Criteria:

  1. by Record Code
  2. within Record Code, by Employee Location Code
  3. within Employee Location Code, by Social Security Number

Interface File Transmission Information:

Data may be sent from a campus to OP electronically on a daily basis

NOTE: Only 9 UC campuses provide interface

All alpha character data is stored in the database in upper case format only

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

Return to Data Element Documents Page