Hey, what answers do you need?
< All Topics
Print

Name Computed Columns

Note: The following fields (computed columns) are available for use in reporting.


X.PERSON.CHOSEN.FIRST.NAME:

Use PERSON.CHOSEN.FIRST.NAME if on file, otherwise, use NICKNAME.  Use FIRST.NAME if others are blank.


X.PERSON.CHOSEN.MIDDLE.NAME:

Use PERSON.CHOSEN.MIDDLE.NAME if on file, otherwise use MIDDLE.NAME but only if both PERSON.CHOSEN.FIRST.NAME and NICKNAME are either blank or match FIRST.NAME. 


X.PERSON.CHOSEN.LAST.NAME:

Use the PERSON.CHOSEN.LAST.NAME if on file, otherwise use LAST.NAME.


X.PERSON.CHOSEN.SUFFIX:

Return SUFFIX only if both PERSON.CHOSEN.FIRST.NAME and NICKNAME are either blank or match FIRST.NAME.


X.PERSON.CHOSEN.NAME.FML:

Name in first middle last, suffix format using fields above.


X.PERSON.CHOSEN.NAME.LFM:

Name in last, first middle, suffix format using fields above.

Table of Contents