What can we help you with?
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.