University Directory (aka Demographic Database)
Proposed phase I Data Elements for Discussion at 02/19/1998 Meeting
| Data Elements | Format | Size | Data Initialization Source |
|---|---|---|---|
| 1) Net ID | integer | N/A | DBMS - unique value (1 to 2,147,483,647) |
| 2) Last Name | char | 40 | Derived from Payroll/Student Systems+ |
| 3) First Name (middle) | char | 40 | Derived from Payroll/Student Systems+ |
| 4) Home Address Line 1 | char | 30 | Payroll/Student Systems+ |
| 5) Home Address Line 2 | char | 30 | Payroll/Student Systems+ |
| 6) Home Address Line 3 | char | 30 | Payroll/Student Systems+ |
| 7) Home Address State | char | 2 | Payroll/Student Systems+ |
| 8) Home Address Zip | char | 9 | Payroll/Student Systems+ |
| 9) Home Address Country | char | 30 | Payroll/Student Systems+ |
| 10) Work Address Line 1* | char | 30 | Payroll/Student Systems+ |
| 11) Work Address Line 2* | char | 30 | Payroll/Student Systems+ |
| 12) Work Address Line 3* | char | 30 | Payroll/Student Systems+ |
| 13) Work Address State* | char | 2 | Payroll/Student Systems+ |
| 14) Work Address Zip* | char | 9 | Payroll/Student Systems+ |
| 15) Work Email Address* | char | 60 | initialize as blanks |
| 16) Work Phone Number* | char | 20 | initialize as blanks |
| 17) Work Fax Number* | char | 20 | initialize as blanks |
| 18) Social Security Number | char | 9 | Payroll |
| 19) Birthdate | date | N/A | Payroll/Student Systems+ |
| 20) Alternate Address Type* | char | 1 | DBMS |
| 21) Alternate Address Counter | integer | N/A | DBMS - 0 to 255 |
| 22) Alternate Address Line 1* | char | 30 | DBMS |
| 23) Alternate Address Line 2* | char | 30 | DBMS |
| 24) Alternate Address Line 3* | char | 30 | DBMS |
| 25) Alternate Address State* | char | 2 | DBMS |
| 26) Alternate Address Zip* | char | 9 | DBMS |
| 27) Location Code* | char | 2 | Payroll/Student Systems+ |
| 28) Student ID Number* | char | 10 | Student System |
| 29) Employee ID Number* | char | 9 | Payroll System |
| 30) Student Type* | char | 1 | Student System |
| 31) Student College* | char | 25 | Student System |
| 32) Student Major* | char | 38 | Student System |
| 33) Student Coll/Major Counter | integer | N/A | DBMS - 0 to 255 |
| 34) Student Term Begin Date* | date | N/A | Student System |
| 35) Student Term End Date* | date | N/A | Student System |
| 36) Appointment Name* | char | 50 | Payroll System |
| 37) Appointment Begin Date* | date | N/A | Payroll System |
| 38) Appointment End Date* | date | N/A | Payroll System |
| 39) Academic* | char | 1 | Payroll System - Y or N |
| 40) Department Name* | char | 50 | Payroll System |
| 41) Public Key Directory Host | char | 50 | initialize as null |
| 42) Public Key Search Index | char | 20 | initialize as null |
| 43) Public Key Search Term | char | 30 | initialize as null |
| 44) Record Creation Date* | date | N/A | DBMS |
| 45) Record Last Update Date* | date | N/A | DBMS |
| 46) Record Last Update Source* | char | 30 | DBMS |
* - indicates may hold multiple values per University Member
+ - payroll data is planned to be loaded prior to student data