AH Naming Standards
- Saparnell
Views
View names start with the Activity Hub that sources the majority of the data in that view. The name of the view is based on the lowest level of detail contained in that view.
Fields
Field names are largely sources from the AH Steering Committee. Field names are designed to be as clear and intuitive as possible. Fields definitions are added to the Information Governance Catalog (IGC) as they are defined.
| Field name contains... | Format | Example | Note |
|---|---|---|---|
| Special Characters | BI Tools do not like special characters. In the Activity Hubs we do not use special characters in the field names. | ! @ # $ % ^ & * ( ) + | The only special character that can be used is an under score. |
| First Name | Preferred first name if available, legal first name if preferred is not available | Minerva | Not all data sources offer a preferred name option |
| Middle Name | Preferred middle name if available, legal middle name if preferred is not available | Flowers | Not all data sources offer a preferred name option |
| Last Name | Preferred last name if available, legal last name if preferred is not available | Mouse | Not all data sources offer a preferred name option |
| Name Full | Last, First Middle | Mouse, Minerva Flowers | Middle name is not always available |
| ID And Name | #-Last, First Middle | 12345-Mouse, Minerva Flowers | Middle name is not always available |
| ID | ####### | 987654 | Numeric value that is distinct and used to connect sets of data |
| Code | Any combination of numbers and letters | ABC234567 | Where possible, descriptions are available where codes are provided |
| Code and Name | Concatenation of field code and field name | ABC234 Desk | Not all data sources offer a code and name |
| Start Date | YYYY-MM-DD | 2019-01-01 | Used in place of Begin Date BI tools can reformat dates in your display |
| End Date | YYYY-MM-DD | 2019-12-31 | BI tools can reformat dates in your display |
| Date | YYYY-MM-DD | 2021-06-24 | BI tools can reformat dates in your display |
| DateTime | YYYY-MM-DD HH:MM:SS.MMM | 2021-06-24 11:09:23.105 | BI tools can reformat dates in your display |
Flag with matching Count | Yes, No 1=Yes, 0=No | Yes, No 1, 0 | |
| Amount | ####.## | 123456.98 | BI tools can be used to reformat amounts as needed |
| ...Current | Indicates that the data in the field(s) is as of today. Does not look into future dates. Aka, most recent value for a field. | Used in SAH & EAH | |
| ...Census | Indicates that the data in the view(s) stops loads as of the Census date of each term. | Used in SAH | |
| ...Term | Indicates that the data in the field(s) corresponds to a specific Term. | Used in SAH | |
| ...AsOf | Indicates that the data in the field(s) corresponds to a date. | Used in EAH | |
| Year (YYYY) | Year displayed as a 4 digit integer. | 1991, 1992, 1993 | |
| Quarter (Q) | Quarter displayed as a 1 digit integer. | 1, 2, 3, 4 | |
| Month (MM) | Month of the year displayed as a 1 or 2 digit integer. | 1, 2...11, 12 | |
| Week (WW) | Week of the year displayed as a 1 or 2 digit integer. | 1, 2...51, 52, 53 | |
| ...Derived... | Logic in the field has been provided by the business and created in the Activity Hub. |