02/10/1999 DRAFT

Employee "directory" Interface Data Elements from Local Campus Systems

	Name	Length	Type	Comments
1.	Record Code	1	character	A=Add, D=Delete Record Code A data is for new or updated/changed data as it 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, overlaying what may have been originally passed Record Code D data is for data originally sent erroneously
2.	Employee Location Code	2	character	01=BK, 02=SF, 03=DV, 04=LA, 05=RV, 06=SD, 07=SC, 08=SB, 09=IR
3.	Employee ID	9	character
4.	Social Security Number	9	character	if none, then pad with values set to character blank
5.	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
6.	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
7.	Release Flag	2	character	requires further discussion
8.	Last Name	40	character
9.	First Name (middle)	40	character
10.	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
11.	Working Title	60	character
12.	Working Title Begin Date	8	character	yyyymmdd format
13.	Working Title End Date	8	character	yyyymmdd format
14.	Working Title Department	60	character
15.	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
16.	Campus Mailing Address 1	32	character
17.	Campus Mailing Address 2	32	character	If none, then pad with values set to character blank
18.	Campus Mailing Address - City	32	character
19.	Campus Mailing Address - State Code	2	character
20.	Campus Mailing Address - Zip Code	5	character
21.	Campus Mailing Address - Plus 4 Zip Code	5	character	optional; if none, then pad with values set to character blank
22.	Campus Mailing Address - Campus Mail Code	6	character	optional; if none, then pad with values set to character blank
23.	Work Phone Number	20	character
24.	Work Fax Number	20	character	If none, then pad with values set to character blank
25.	Work Pager Number	20	character	If none, then pad with values set to character blank
26.	Work Cell Phone Number	20	character	If none, then pad with values set to character blank
27.	Email Address	50	character	If none, then pad with values set to character blank

Selection Criteria:

Sorting Criteria:

1. by Employee ID

Interface File Transmission Information:

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