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

SGHE 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_IND
ENTITY_IND
ENTITY_UID, RELATED_UID
ENTITY_UID, RELATED_CROSS_REFERENCE
ENTITY_UID, SPOUSE_STATUS

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP 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 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 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 Mailing Priority Description Combined spousal mailing priority description. VARCHAR2(255)  

CALCULATION

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

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

APVXREF

APVXREF_EMPLOYER_IND

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ENTITY_UID 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 Household Indicator 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 ID Person's or organization's current identification number. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SPBPERS

SPBPERS_MRTL_CODE

MARITAL_STATUS_DESC Related Marital Status Description Marital status description. VARCHAR2(255)  

STVMRTL

STVMRTL_DESC

MARRIAGE_END_DATE Marriage End Date For spousal relations, date the marriage ended. DATE  

APRCSPS

APRCSPS_MRTL_END_DATE

MARRIAGE_START_DATE Marriage Start Date For spousal relations, date of the marriage. DATE  

APRCSPS

APRCSPS_MRTL_START_DATE

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

ATVXREF

ATVXREF_MATCH_GIFT_IND

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PROCESS_GROUP 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 Related Birth Date Date of birth of the related person. DATE  

SPBPERS

SPBPERS_BIRTH_DATE

RELATED_CHILD_ADDR_TYPE Related Child Address 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

RELATED_CHILD_ADDR_TYPE_DESC Related Child Address Type Description Address type description for the related child. VARCHAR2(255)  

STVATYP

STVATYP_DESC

RELATED_CHILD_TAX_ID 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 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 Related Comment Comments about the related child or spouse. CLOB  

APRCHLD

APRCSPS

APRCHLD_COMMENT

APRCSPS_SPS_COMMENT

RELATED_CROSS_REFERENCE 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 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 Related Deceased Indicator 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 Related Entity Indicator Indicates whether the related entity is a person or organization. VARCHAR2(63)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_FIRST_NAME 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 Related Gender Gender of the related person. VARCHAR2(63)  

SPBPERS

SPBPERS_SEX

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_LAST_NAME 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 Related Maiden Name Maiden name of a spousal relation. VARCHAR2(63)  

APRCSPS

SPRIDEN

APRCSPS_MAIDEN_NAME

SPRIDEN_LAST_NAME

RELATED_MATCHING_GIFT_ID Related Matching Gift Organization 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 Related Matching Gift Organziation Name Name of the matching gift organization for the related organization. VARCHAR2(255)  

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

RELATED_MATCHING_GIFT_UID Related Matching Gift Organization 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 Related Middle Initial Middle name of the related person. VARCHAR2(63)  

APRCHLD

APRCSPS

SPRIDEN

APRCHLD_MI

APRCSPS_MI

SPRIDEN_MI

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

APRCSPS

SPBPERS

APRCSPS_NAME_PREFIX

SPBPERS_NAME_PREFIX

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

ATVXREF

ATVXREF_DESC

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

APRCSPS

SPBPERS

APRCSPS_NAME_SUFFIX

SPBPERS_NAME_SUFFIX

RELATED_UID 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 Relationship 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 Relationship Source Description 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 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 Reverse Cross Reference Description Description of the reverse cross reference relationship. VARCHAR2(255)  

ATVXREF

ATVXREF_DESC

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

ATVXREF

ATVXREF_SPOUSE_IND

SPOUSE_STATUS 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 Spouse Status Description Spousal relation status description. VARCHAR2(255)  

CALCULATION

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



Ver: 9.0