Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
Yes |
Yes |
No |
First Name |
A First Name is the word by which an individual is generaly known by |
VARCHAR(50) |
No |
No |
No |
Last Name |
A Last Name is the word or words which makes up the last part of an individual's name. |
VARCHAR(50) |
No |
No |
No |
Staff Role Code |
A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. |
VARCHAR(10) |
Yes |
No |
Yes |
Work Telephone Number |
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier. This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
|
VARCHAR(14) |
No |
No |
No |
Cell Telephone Number |
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier. This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
|
VARCHAR(14) |
No |
No |
No |
Start Date |
A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff |
DATE |
Yes |
No |
No |
End Date |
An End Date denotes the specific 24 hour period on the Gregorian calendar that an individual ceased to be an active member of the staff. |
DATE |
No |
No |
No |
Team Code |
A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. |
VARCHAR(10) |
Yes |
No |
Yes |
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
Yes |
No |
Yes |