Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Common Reporting View Reports

Banner 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 Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
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

NO

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

NO

NO
COMBINED_MAILING_PRIORITY_DESC Combined spousal mailing priority description. VARCHAR2(255)

CALCULATION

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

NO

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

APVXREF

APVXREF_EMPLOYER_IND

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

APRCHLD

APRCSPS

APRXREF

APRCHLD_PIDM

APRCSPS_PIDM

APRXREF_PIDM

NO

NO

NO

NO
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

NO

NO
ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

SPBPERS

SPBPERS_MRTL_CODE

NO

NO
MARITAL_STATUS_DESC Marital status description. VARCHAR2(255)

STVMRTL

STVMRTL_DESC

NO

NO
MARRIAGE_END_DATE For spousal relations, date the marriage ended. DATE

APRCSPS

APRCSPS_MRTL_END_DATE

NO

NO
MARRIAGE_START_DATE For spousal relations, date of the marriage. DATE

APRCSPS

APRCSPS_MRTL_START_DATE

NO

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

ATVXREF

ATVXREF_MATCH_GIFT_IND

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

NA

NA

NO

NO
RELATED_BIRTH_DATE Date of birth of the related person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

NO

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

APRCHLD

APRCHLD_ATYP_CODE

NO

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

STVATYP

STVATYP_DESC

NO

NO
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

NO

NO

NO
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

NO

NO

NO

NO
RELATED_COMMENT Comments about the related child or spouse. CLOB

APRCHLD

APRCSPS

APRCHLD_COMMENT

APRCSPS_SPS_COMMENT

NO

NO

NO
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

NO

NO

NO

NO
RELATED_DECEASED_DATE Deceased date for the related person. DATE

APRCHLD

APRCSPS

SPBPERS

APRCHLD_DECEASED_DATE

APRCSPS_DEAD_DATE

SPBPERS_DEAD_DATE

NO

NO

NO

NO
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

NO

NO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_FIRST_NAME

APRCSPS_FIRST_NAME

SPRIDEN_FIRST_NAME

NO

NO

NO

NO
RELATED_GENDER Gender of the related person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
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

NO

NO

NO

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

APRCSPS

SPRIDEN

APRCSPS_MAIDEN_NAME

SPRIDEN_LAST_NAME

NO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
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

NO

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

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_MI

APRCSPS_MI

SPRIDEN_MI

NO

NO

NO

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

APRCSPS

SPBPERS

APRCSPS_NAME_PREFIX

SPBPERS_NAME_PREFIX

NO

NO

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

ATVXREF

ATVXREF_DESC

NO

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

APRCSPS

SPBPERS

APRCSPS_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

NO

NO

NO
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

NO

NO

NO

NO
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'

NO

NO
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'

NO

NO
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

NO

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

ATVXREF

ATVXREF_DESC

NO

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

ATVXREF

ATVXREF_SPOUSE_IND

NO

NO
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

NO

NO
SPOUSE_STATUS_DESC Spousal relation status description. VARCHAR2(255)

CALCULATION

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

NO

NO


Ver: 9.2