The entity for holding campus-specified information and work location
for an
employee. The employee work location includes building,
room and phone numbers.
The data originates from the Employee
Data Base (EDB) and one record exists per
employee.
Unfortunately, this data is not currently kept up-to-date.
| Field Name |
Business Name |
Data Type |
Description |
| CAMPUS_ADDRESS |
CAMPUS ADDRESS |
VARCHAR2(4) |
The abbreviation of the campus where the employee is located (UCD). |
| CAMPUS_BLDG |
CAMPUS BUILDING |
VARCHAR2(10) |
The name or abbreviated name of the building in
which the
employees office
is located. |
| CAMPUS_DATA1 |
CAMPUS FIELD 1 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA10 |
CAMPUS FIELD 10 |
VARCHAR2(6) |
NOT USED |
| CAMPUS_DATA2 |
CAMPUS FIELD 2 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA3 |
CAMPUS FIELD 3 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA4 |
CAMPUS FIELD 4 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA5 |
CAMPUS FIELD 5 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA6 |
CAMPUS FIELD 6 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA7 |
CAMPUS FIELD 7 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA8 |
CAMPUS FIELD 8 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_DATA9 |
CAMPUS FIELD 9 |
VARCHAR2(30) |
NOT USED |
| CAMPUS_PHONE1 |
CAMPUS PHONE NUMBER 1 |
VARCHAR2(10) |
The primary office phone number at which
an employee can be reached (may or may not contain area code
and all seven digits). |
| CAMPUS_PHONE2 |
CAMPUS PHONE NUMBER 2 |
VARCHAR2(10) |
The secondary office phone number at which
an employee can be reached (may or may not contain area code
and all seven digits). |
| CAMPUS_ROOM |
CAMPUS ROOM |
VARCHAR2(6) |
The number of the room in which the employees office
is located. |
| EMPLOYEE_ID |
EMPLOYEE ID NUMBER |
VARCHAR2(9) |
The unique employee identification number. |
