| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
MARITAL_STATUS
|
Marital status of the person.
|
VARCHAR2(63)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
MARITAL_STATUS_LD
|
Marital status long description.
|
VARCHAR2(255)
|
STVMRTL
|
STVMRTL_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
MARITAL_STATUS_SD
|
Marital status short description.
|
VARCHAR2(255)
|
STVMRTL
|
STVMRTL_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
NON_ENTITY_RELATION_KEY
|
|
NUMBER
|
|
|
|
NO
|
|
|
PERSON_IND
|
Indicates that this entity is a person or an organization.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
PERSON_IND_LD
|
Person indicator long description.
|
VARCHAR2(255)
|
PERSON_IND_EXPR
|
PERSON_IND_LD_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
PERSON_IND_SD
|
Person indicator short description.
|
VARCHAR2(255)
|
PERSON_IND_EXPR
|
PERSON_IND_SD_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATED_ENTITY_ID
|
The ID number of the relation.
|
VARCHAR2(400)
|
EMPLOYER_EXPR
|
RELATED_ENTITY_ID_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_BIRTH_DATE
|
Date of birth for the person.
|
DATE
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_BIRTH_DATE_PARTIAL
|
Person's birth date.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_CLASS_YEAR
|
Relation's class year.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_DECEASED_DATE
|
Date the person died.
|
DATE
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_DECEASED_DATE_PARTIAL
|
Person's deceased date.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_DECEASED_IND
|
Indicates whether a person is deceased.
|
NUMBER
|
DECEASED_EXPRESSIONS
|
RELATION_DECEASED_IND_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_DECEASED_IND_LD
|
Deceased indicator long description.
|
VARCHAR2(255)
|
DECEASED_EXPRESSIONS
|
RELATION_DECEASED_IND_LD_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_DECEASED_IND_SD
|
Deceased indicator short description.
|
VARCHAR2(255)
|
DECEASED_EXPRESSIONS
|
RELATION_DECEASED_IND_SD_EXPRESSION
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_FIRST_NAME
|
Relation's first name.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_GENDER
|
Identifies the gender of the person.
|
VARCHAR2(63)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_GENDER_LD
|
Gender long description.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_GENDER_SD
|
Gender short description.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_LAST_NAME
|
Relation's last name.
|
VARCHAR2(255)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_MI
|
Relation's middle initial.
|
VARCHAR2(63)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_MIDDLE_NAME
|
Relation's middle name.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_NAME
|
Combination of the person's last, first, and middle initial into one value.
|
VARCHAR2(255)
|
APREHIS
|
APREHIS_EMPR_NAME
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_PREFIX
|
Relation's prefix.
|
VARCHAR2(63)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
RELATION_SCHOOL
|
Relation's school.
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_SCHOOL_LD
|
Relation's school long description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_SCHOOL_SD
|
Relation's school short description.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_SORT_NAME
|
Name used for sorting purposes all in upper case. For a person, it contains last name, comma, first name, comma, and the middle name.������������ For an organization, it is the organization long name.
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
RELATION_SUFFIX
|
Relation's suffix.
|
VARCHAR2(63)
|
CONSTANT
|
NULL
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
STANDARD_INDUSTRIAL_CODE
|
Specifies the organization's standard industry code.
|
VARCHAR2(63)
|
APREHIS
|
APREHIS_SICC_CODE
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
STANDARD_INDUSTRIAL_CODE_LD
|
Organization's standard industry code long description.
|
VARCHAR2(255)
|
ATVSICC
|
ATVSICC_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
STANDARD_INDUSTRIAL_CODE_SD
|
Organization's standard industry code short description.
|
VARCHAR2(255)
|
ATVSICC
|
ATVSICC_DESC
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
SYSTEM_LOAD_PROCESS
|
'NON_ENTITY_RELATION_D1B'
|
NO
|
NO
|
ANALYZE FUNDRAISING, CONSTITUENT EMPLOYMENT, MANAGE PROSPECT PIPELINE, RELATIONSHIP
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_01_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_02_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_03_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_04_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05
|
|
VARCHAR2(63)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05_LD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|
|
USER_ATTRIBUTE_05_SD
|
|
VARCHAR2(255)
|
NO SOURCE
|
NO SOURCE
|
NO
|
NO
|
|