| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
BIRTH_DATE
|
Date of birth for the person.
|
DATE
|
|
|
|
NO
|
|
|
CONFIDENTIALITY_IND
|
Specifies whether the person has requested the institution keep some of their information confidential.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
DECEASED_DATE
|
Date the person died.
|
DATE
|
|
|
|
NO
|
|
|
EMAIL_ADDRESS
|
Preferred email address of the person.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
FULL_NAME_LFMI
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
|
|
|
NO
|
|
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
|
|
|
NO
|
|
|
PHONE_NUMBER_COMBINED
|
All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.
|
VARCHAR2(63)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
|
|
|
NO
|
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
|
|
|
NO
|
|