RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: RELATIONSHIP

Description Contains data that specifies the relationship between a person or organization and another person or organization.
Key & Frequency One row per entity per relation source or related cross reference per related entity.
Recommended Search Columns ENTITY_UID
ENTITY_UID,┐RELATED_UID
ENTITY_UID,┐RELATED_CROSS_REFERENCE
ENTITY_UID,┐MARRIAGE_STATUS_IND

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

CHILD_ORDER_NUMBER System generated internal sequence number assigned to the child record. Does not indicate the birth order of a child. NUMBER

APRCHLD

APRCHLD_SEQ_NO

COMBINED_MAILING_PRIORITY For spousal relations, designates the prioity order in which the cross reference and reverse cross reference names will display for combined mailings. Valid values are P for primary and S for secondary. VARCHAR2(63)

APRXREF

APRXREF_CM_PRI_IND

COMBINED_MAILING_PRIORITY_DESC Combined spousal mailing priority description. VARCHAR2(255)

CALCULATION

DECODE(APRXREF_CM_PRI_IND,'P','PRIMARY','S','SECONDARY')

EMPLOYER_IND Indicates if this cross reference code represents an employer relation. VARCHAR2(1)

APVXREF

APVXREF_EMPLOYER_IND

ENTITY_IND Indicates whether this entity is a person or organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

APRCHLD

APRCSPS

APRXREF

APRCHLD_PIDM

APRCSPS_PIDM

APRXREF_PIDM

HOUSEHOLD_IND Indicates if the person associated by this cross reference code resides in the same household as the reverse cross reference. VARCHAR2(1)

APRXREF

APRXREF_HOUSEHOLD_IND

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MARITAL_STATUS Current marital status of the relation. VARCHAR2(63)

SPBPERS

SPBPERS_MRTL_CODE

MARITAL_STATUS_DESC Marital status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MARRIAGE_END_DATE For spousal relations, date the marriage ended. DATE

APRCSPS

APRCSPS_MRTL_END_DATE

MARRIAGE_START_DATE For spousal relations, date of the marriage. DATE

APRCSPS

APRCSPS_MRTL_START_DATE

MATCHING_GIFT_IND Indicates if this cross referenced employer or organization matches gifts. VARCHAR2(1)

ATVXREF

ATVXREF_MATCH_GIFT_IND

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

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

RELATED_BIRTH_DATE Date of birth of the related person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

RELATED_CHILD_ADDR_TYPE For child relations only. If the child has a separate UID in the source system this indeicates the child's address associated to this record, as applicable. VARCHAR2(63)

APRCHLD

APRCHLD_ATYP_CODE

RELATED_CHILD_ADDR_TYPE_DESC Address type description for the related child. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

RELATED_CHILD_TAX_ID For child relations only. Identification assigned by the federal governtment for tax purposes. VARCHAR2(63)

APRCHLD

SPBPERS

APRCHLD_SSN

SPBPERS_SSN

RELATED_COMBINED_NAME Combined name of the related person (last name, first name, middle name/initial) or related organization. VARCHAR2(255)

APVCHLD

APVCSPS

APVXREF

APVCHLD_CHLD_NAME

APVCSPS_SPOUSE_NAME

APVXREF_XREF_FULL_NAME

RELATED_COMMENT Comments about the related child or spouse. VARCHAR2(4000)

APRCHLD

APRCSPS

APRCHLD_COMMENT

APRCSPS_SPS_COMMENT

RELATED_CROSS_REFERENCE Defines the relationship between the person or organization to the cross referenced person or organization. VARCHAR2(63)

APRCHLD

APRCSPS

APRXREF

APRCHLD_XREF_CODE

APRCSPS_XREF_CODE

APRXREF_XREF_CODE

RELATED_DECEASED_DATE Deceased date for the related person. DATE

APRCHLD

APRCSPS

SPBPERS

APRCHLD_DECEASED_DATE

APRCSPS_DEAD_DATE

SPBPERS_DEAD_DATE

RELATED_DECEASED_IND Deceased indicator, Y indicates the related person is deceased. VARCHAR2(1)

APRCHLD

APRCSPS

SPBPERS

APRCHLD_DECEASED_IND

APRCSPS_DEAD_IND

SPBPERS_DEAD_IND

RELATED_ENTITY_IND Indicates whether the related entity is a person or organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_FIRST_NAME First name of the related person. VARCHAR2(63)

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_FIRST_NAME

APRCSPS_FIRST_NAME

SPRIDEN_FIRST_NAME

RELATED_GENDER Gender of the related person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

RELATED_GENDER_DESC Gender description of the related person. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_ID Current identification number of the cross referenced person or organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_LAST_NAME Last name of the related person or the related organization name. VARCHAR2(63)

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_LAST_NAME

APRCSPS_LAST_NAME

SPRIDEN_LAST_NAME

RELATED_MAIDEN_NAME Maiden name of a spousal relation. VARCHAR2(63)

APRCSPS

SPRIDEN

APRCSPS_MAIDEN_NAME

SPRIDEN_LAST_NAME

RELATED_MATCHING_GIFT_ID Current identification number of the matching gift organization for the related organization. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_MATCHING_GIFT_NAME Name of the matching gift organization for the related organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_MATCHING_GIFT_UID System generated, unique, internal identification number assigned to the organization. For organizations that match gifts this will be either the organization's UID or the UID of an alternate/parent organization that matches gifts. NUMBER

AOBORGN

AOBORGN_MG_PIDM

RELATED_MIDDLE_INITIAL Middle name of the related person. VARCHAR2(63)

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_MI

APRCSPS_MI

SPRIDEN_MI

RELATED_PREFIX Prefix associated with the related person's name. VARCHAR2(63)

APRCSPS

SPBPERS

APRCSPS_NAME_PREFIX

SPBPERS_NAME_PREFIX

RELATED_REFERENCE_DESC Description of the cross reference relationship. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

RELATED_SUFFIX Suffix for the related person's name. VARCHAR2(63)

APRCSPS

SPBPERS

APRCSPS_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

RELATED_UID System generated, unique, internal identification number assigned to this cross referenced person or organization. NUMBER

APRCHLD

APRCSPS

APRXREF

APRCHLD_CHLD_PIDM

APRCSPS_SPS_PIDM

APRXREF_XREF_PIDM

RELATION_SOURCE Origin of the relationship in the source system. Assigned values include C for child, CX for combined child/cross reference, S for spouse, SX for combined spouse/cross reference and X for cross reference. VARCHAR2(63)

CONSTANT

SOURCE APRCHLD AND APRXREF THEN 'CX'; SOURCE APRCHLD THEN 'C'; SOURCE APRCSPS AND APRXREF THEN 'SX'; SOURCE APRCSPS THEN 'S'; SOURCE APRXREF THEN 'X'

RELATION_SOURCE_DESC Description of the origin of the relationship in the source system. VARCHAR2(255)

CONSTANT

SOURCE APRCHLD AND APRXREF THEN 'CHILD/CROSS REFERENCE'; APRCHLD THEN 'CHILD'; APRCSPS AND APRXREF THEN 'SPOUSE/CROSS REFERENCE'; APRCSPS THEN 'SPOUSE'; APRXREF THEN 'CROSS REFERENCE'

REVERSE_CROSS_REFERENCE Reverse relationship of the initial cross reference. For example if the cross reference from a person to an organization is employer, the reverse cross reference from the organization to the person is employee. VARCHAR2(63)

ATVXREF

ATVXREF_REVERSE_XREF

REVERSE_REFERENCE_DESC Description of the reverse cross reference relationship. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPOUSE_IND Indicates if this cross reference code represents a spousal relation. VARCHAR2(1)

ATVXREF

ATVXREF_SPOUSE_IND

SPOUSE_STATUS For spousal relations only. Valid values are for 'A' this is an active spousal relationship, or 'I' this is an inactive spousal relationship. VARCHAR2(63)

APRCSPS

APRCSPS_MARS_IND

SPOUSE_STATUS_DESC Spousal relation status description. VARCHAR2(255)

CALCULATION

DECODE(APRCSPS_MARS_IND,'A','ACTIVE','I','INACTIVE')



Ver: 3.1