Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
Staff Calendar Event Identifier |
A Staff Calendar Event Identifier is the unique value assigned to represent a particular event that a certain individual within the organization is involved in. |
INTEGER |
Yes |
Yes |
No |
Start Event Date |
A (Staff Calendar) Start Event Date is a particular 24 hour period on the Gregorian calendar where something relating to a given Staff member begins. |
DATE |
Yes |
No |
No |
End Event Date |
An (Staff Calendar) End Event Date is the particular 24 hour period on the Gregorian calendar that denotes the conclusion of something relating to a given Staff member. |
DATE |
Yes |
No |
No |
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 |
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
Yes |
No |
Yes |
Calendar Event Code
|
A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. |
VARCHAR(10) |
Yes |
No |
Yes |