Special Characters

BI Tools do not like special characters. 

In the Activity Hubs we do not use special characters in the field names where possible.

! @ # $ % ^ & * ( ) +

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

Display Name

First Last

Minerva Mouse

Middle name is not displayed

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.