Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Common Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_RELATIONSHIP

Description Source composite view contains all of the persons and organizations that have a relationship to another person or organization stored within the system, such as employers, spouses and children.

Target Column Business Definition Database Data Type Source Name Source Column
CHILD_ORDER_NUMBER System generated internal sequence number assigned to the child record. Does not indicate the birth order of a child. NUMBER

APRCHLD

APVCHLD

APRCHLD_SEQ_NO

APVCHLD_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(1)

APRXREF

APRXREF_CM_PRI_IND

COMBINED_MAILING_PRIORITY_DESC Combined spousal mailing priority description. VARCHAR2(9)

CALCULATION

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

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

APVXREF

APVXREF_EMPLOYER_IND

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_PIDM

APVCSPS_PIDM

APVXREF_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)

ATVXREF

ATVXREF_HOUSEHOLD_IND

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

APVCSPS

APVXREF

APVCSPS_MRTL_CODE

APVXREF_XREF_MRTL_CODE

MARITAL_STATUS_DESC Marital status description. VARCHAR2(120)

STVMRTL

STVMRTL_DESC

MARRIAGE_END_DATE For spousal relations, date the marriage ended. DATE

APVCSPS

APVCSPS_MRTL_END_DATE

MARRIAGE_START_DATE For spousal relations, date of the marriage. DATE

APVCSPS

APVCSPS_MRTL_START_DATE

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

APVXREF

APVXREF_MATCH_GIFT_IND

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

RELATED_BIRTH_DATE Date of birth of the related person. DATE

APVCHLD

APVCSPS

APVXREF

APVCHLD_BIRTH_DATE

APVCSPS_BIRTH_DATE

APVXREF_XREF_BIRTH_DATE

RELATED_CHILD_ADDR_TYPE For child relations only. The address type of the reverse cross reference where the child resides or for use in corresponding with the child. VARCHAR2(8)

APRCHLD

APRCHLD_ATYP_CODE

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

STVATYP

STVATYP_DESC

RELATED_CHILD_TAX_ID Identification assigned by the federal governtment for tax purposes. For child relations only if the child does not have a separate UID in the source system. VARCHAR2(60)

APRCHLD

SPBPERS

APRCHLD_SSN

SPBPERS_SSN

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_CHLD_NAME

APVCSPS_SPOUSE_NAME

APVXREF_XREF_FULL_NAME

RELATED_COMMENT Comments about the relation. VARCHAR2(4000)

APVCHLD

APVCSPS

APVCHLD_COMMENT

APVCSPS_SPS_COMMENT

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_XREF_CODE

APVCSPS_XREF_CODE

APVXREF_XREF_CODE

RELATED_DECEASED_DATE Deceased date for the related person. DATE

APVCHLD

APVCSPS

APVXREF

APVCHLD_DEAD_DATE

APVCSPS_DEAD_DATE

APVXREF_XREF_DEAD_DATE

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_DEAD_IND

APVCSPS_DEAD_IND

APVXREF_XREF_DEAD_IND

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_FIRST_NAME

APVCSPS_FIRST_NAME

APVXREF_XREF_FIRST_NAME

RELATED_GENDER Gender of the related person. VARCHAR2(1)

APVCHLD

APVCSPS

APVXREF

APVCHLD_SEX

APVCSPS_SEX

APVXREF_XREF_SEX

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

CALCULATION

DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_LAST_NAME

APVCSPS_LAST_NAME

APVXREF_XREF_LAST_NAME

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_MAIDEN_NAME

APVCSPS_MAIDEN_NAME

APVXREF_XREF_MAIDEN_LAST_NAME

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 or initial of the related person. VARCHAR2(60)

APVCHLD

APVCSPS

APVXREF

APVCHLD_MI

APVCSPS_MI

APVXREF_XREF_MI

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

APVCHLD

APVCSPS

APVXREF

AVPCHLS_NAME_PREFIX

APVCSPS_NAME_PREFIX

APVXREF_XREF_NAME_PREFIX

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

ATVXREF

ATVXREF_DESC

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_NAME_SUFFIX

APVCSPS_NAME_SUFFIX

APVXREF_XREF_NAME_SUFFIX

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

APVCHLD

APVCSPS

APVXREF

APVCHLD_CHLD_PIDM

APVCSPS_SPS_PIDM

APVXREF_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(2)

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(22)

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(3)

APVXREF

APVXREF_REVERSE_XREF

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

ATVXREF

ATVXREF_DESC

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

APVXREF

APVXREF_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(1)

APRCSPS

APRCSPS_MARS_IND

SPOUSE_STATUS_DESC Spousal relation status description. VARCHAR2(8)

CALCULATION

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

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

NA

NA



Ver: 8.0