RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: SALUTATION

Description Contains all salutations.
Key & Frequency One row per person per salutation type.
Recommended Search Columns ENTITY_UID
ENTITY_UID, SALUTATION_TYPE

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

APRSALU

APRSALU_PIDM

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

SALUTATION Salutation. VARCHAR2(63)

APRSALU

APRSALU_SALUTATION

SALUTATION_TYPE Type of salutation. VARCHAR2(63)

APRSALU

APRSALU_SALU_CODE

SALUTATION_TYPE_DESC Salutation type code description. VARCHAR2(255)

ATVSALU

ATVSALU_DESC



Ver: 3.1