06/19/1998 DRAFT

Employee "directory" Interface Data Elements from Local Campus Systems
Name Length Type Comments
1. Employee Location Code 2 character 01=BK, 02=SF, 03=DV, 04=LA, 05=RV, 06=SD, 07=SC, 08=SB, 09=IR
2. Employee ID 9 character
3. Social Security Number 9 character
4. Net ID 10 character optional; if none, then pad with values set to character blank
5. Last Name 40 character
6. First Name (middle) 40 character
7. Release Flag 2 character requires further discussion
8. Counter 1 character 1=1st Occurence, 2=2nd Occurence, 3=3rd Occurence

Reflects which occurence of the data elements below are to be loaded into the University Directory (database), e.g., 1st occurence of Working Title, 2nd Occurence of Work Phone Number

note: Data is processed as a complete replacement whether an "add" or "change" or "delete" function is intended, i.e., whatever values are listed in the data elements below, then those values are to be loaded into the University Directory

Thus, if multiple occurences for the same employee are to be sent on the same interface file, multiple interface records will be present on that same interface file
9. Working Title 60 character
10. Working Title Begin Date 8 character mmddyyyy format
11. Working Title End Date 8 character mmddyyyy format
12. Working Title Department 60 character
13. 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. Campus Mailing Address 1 30 character
15. Campus Mailing Address 2 30 character If none, then pad with values set to character blank
16. Campus Mailing Address - City 30 character
17. Campus Mailing Address - State Code 2 character
18. Campus Mailing Address - Zip Code 5 character
19. Campus Mailing Address - Plus 4 Zip Code 5 character optional; if none, then pad with values set to character blank
20. Campus Mailing Address - Campus Mail Code 6 character optional; if none, then pad with values set to character blank
21. Work Phone Number 20 character
22. Work Fax Number 20 character If none, then pad with values set to character blank
23. Work Pager Number 20 character If none, then pad with values set to character blank
24. Work Cell Phone Number 20 character If none, then pad with values set to character blank
25. Email Address 50 character If none, then pad with values set to character blank

Selection Criteria:

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

Sorting Criteria:

  1. by Employee ID

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