Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
Application Staff Identifier |
An Application Staff Identifier is a unique value that represents the intersection between the person in the organization and the application database that the individual is responsible for. |
INTEGER |
Yes |
Yes |
No |
Application Identifier |
An Application Identifier is a unique value assigned to represent a particular software application. |
INTEGER |
No |
No |
Yes |
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
Yes |
No |
Yes |
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 |
Start Date |
An (Application Staff) Start Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff member became associated with a unique piece of software. |
DATE |
Yes |
No |
No |
End Date |
An (Application Staff) End Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff memeber ceases to be associated with a unique piece of software. |
DATE |
No |
No |
No |