06/04/1999 "final version"

Employee "telecom" 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, 50=OP

note: additional values will be required (to be defined later) to allow for other values passed on a location's interface, e.g., 51=UC Regents is passed on the OP interface
2. Employee ID 9 character note: If none, then pad with values set to character blanks and also must pass a non-blank value in at least one of the following fields- Social Security Number, Campus ID, Net ID
3. Social Security Number 9 character optional; If none, then pad with values set to character blanks
4. Campus ID 32 character optional; left-justify if less than 32 characters and pad with trailing values with blanks, e.g., if actual number is 123456789, then value passed should be 123456789 followed by 23 blank characters

If none, then pad with values set to character blanks
5. 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
6. Release Flag - Telecom Name 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
7. Release Flag - Working Title 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
8. Release Flag - Campus Mailing Address 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
9. Release Flag - Work Phone 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
10. Release Flag - Work Fax 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
11. Release Flag - Work Pager 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
12. Release Flag - Work Cell Phone 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
13. Release Flag - Work Email Address 1 character 9, 5, 1, 0 - see below for generic definition of all Release Flag field values
14. Release Flag - All other telecom data elements (except for Social Security Number which is not displayed in applications to be developed using this telecom data 1 character 9, 5, 1. 0 - see below for generic definition of all Release Flag field values
15. Last Name 40 character
16. First Name (middle) 40 character
17. Suffix 4 character optional; If none, then pad with values set to character blanks
18. 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

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

note: for "delete" records, a counter value of 0 (zero) should be passed and all records for that person's location will be deleted
19. Working Title 60 character
20. Working Title Department 60 character any abbreviations used should not end with a period, e.g., "Chem" should be passed rather than "Chem."
21. Campus Mailing Address 1 32 character any abbreviations used should not end with a period, e.g., "St" should be passed rather than "St."
22. Campus Mailing Address 2 32 character If none, then pad with values set to character blanks
23. Campus Mailing Address - City 32 character
24. Campus Mailing Address - State Code 2 character
25. Campus Mailing Address - Zip Code 5 character
26. Campus Mailing Address - Plus 4 Zip Code 5 character optional; if none, then pad with values set to character blanks
27. Campus Mailing Address - Campus Mail Code 6 character optional; if none, then pad with values set to character blanks
28. Work Phone Number 21 character Format is: open parenthese, area code, closed parenthese, three number prefix, dash, four digit number, e.g., (510)987-0100
29. Work Fax Number 21 character Format is: open parenthese, area code, closed parenthese, three number prefix, dash, four digit number, e.g., (510)987-0100

If none, then pad with values set to character blanks
30. Work Pager Number 21 character Format is: open parenthese, area code, closed parenthese, three number prefix, dash, four digit number, e.g., (510)987-0100

If none, then pad with values set to character blanks
31. Work Cell Phone Number 21 character Format is: open parenthese, area code, closed parenthese, three number prefix, dash, four digit number, e.g., (510)987-0100

If none, then pad with values set to character blanks
32. Work Email Address 50 character If none, then pad with values set to character blanks

University Directory Telecom Release Flag Values:

note: all telecom data elements provided, however, will be allowed to be processed as part of Employee Self Service (ESS) applications to be developed, regardless of telecom release flag values; this is because only the actual individual employee is intended to use the ESS application, i.e., data is not intended for viewing besides by that individual employee whereas either the hardcopy, universitywide directory or the online universitywide directory will have a wider audience

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

  1. Telecom Name (Last, First, or Middle)
  2. Working Title
  3. Campus Mailing Address (Address 1, Address 2, City, State, Zip, Mail Code)
  4. Work Phone
  5. Work Fax
  6. Work Pager
  7. Work Cell Phone
  8. Work Email Address
  9. all other telecom data elements (except for student's Social Security Number which is not displayed in applications to be developed using that telecom data)

Selection Criteria:

Records for all non-students (unless a student employee) with assigned telephone numbers and/or email addresses

Sorting Criteria:

  1. by Employee ID

Interface File Transmission Information:

Data sent from a campus/OP to OP electronically on a daily basis, unless otherwise indicated by a campus

note: Only campuses and OP provide interface

All alpha character data should be passed in mixed case format and left-justified except for the following "code" fields which should only have its data passed in upper case format:

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

Return to Data Element Documents Page