Reporting View Target: GIFT

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

SGHE Banner Operational Data Store
Reporting View Target: GIFT_MATCHING

Description Contains designation level detail for each anticipated matching gift associated with an eligible donor gift or pledge payment.
Key & Frequency One row per entity per gift number per campaign per designation per match employer UID.
Recommended Search Columns CAMPAIGN_TYPE
DESIGNATION
DESG_TYPE
DESG_GROUP
ENTITY_UID, GIFT_NUMBER
MATCH_EMPLOYER_UID, GIFT_NUMBER

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ACTIVE_IND Active Indicator Indicates if the matching gift is active (Y = active, N = inactive). VARCHAR2(1)
AGBMGID

AGBMGID_DELETE_IND

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CAMPAIGN Campaign Campaign associated with the gift or pledge payment that was the source of this anticipated matching gift. VARCHAR2(63)
AGRGDES

AGRGDES_CAMPAIGN

CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)
AFBCAMP

AFBCAMP_NAME

CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)
AFBCAMP

AFBCAMP_CMTP_CODE

CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_COLLEGE Designation College College code associated with the designation. VARCHAR2(63)
ADBDESG

ADBDESG_COLL_CODE

DESG_COLLEGE_DESC Designation College Description College, faculty or school name. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_DEPARTMENT Designation Department Department associated with the designation. VARCHAR2(63)
ADBDESG

ADBDESG_DEPT_CODE

DESG_DEPARTMENT_DESC Designation Department Description Name of the department. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_GROUP Designation Group User defined attribute for associating designations of similar purpose or function. VARCHAR2(63)
ADBDESG

ADBDESG_DGRP_CODE

DESG_GROUP_DESC Designation Group Description Description of the designation group. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_STATUS Designation Status The current status of the designation. VARCHAR2(63)
ADBDESG

ADBDESG_DSTA_CODE

DESG_STATUS_DESC Designation Status Description Description of the designation status. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_TYPE Designation Type Designation type for a specific designation. VARCHAR2(63)
ADBDESG

ADBDESG_DSTP_CODE

DESG_TYPE_DESC Designation Type Description Designation type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESG_VSE Designation VSE - Voluntary Support of Education Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting. VARCHAR2(63)
ADBDESG

ADBDESG_CFAE_CODE

DESG_VSE_DESC Designation VSE - Voluntary Support of Education Description Voluntary support of education code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

DESIGNATION Designation Designation associated with the gift/payment number that was the source of this anticipated matching gift. VARCHAR2(63)
AGRGDES

AGRGDES_DESG

DESIGNATION_ACTIVITY_DATE Designation Activity Date Date the designation record was entered or last updated in the system. DATE
AGRMDES

AGRMDES_ACTIVITY_DATE

DESIGNATION_NAME Designation Name Designation description. VARCHAR2(255)
ADBDESG

ADBDESG_NAME

ENTITY_IND Entity Indicator Indicates whether the entity is a person or an organization. VARCHAR2(1)
CONSTANT
CONSTANT

'O'
'P'

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to the donor whose gift/payment was the source of this anticipated matching gift. NUMBER
AGRMGIF

AGRMGIF_PIDM

GIFT_NUMBER Gift Number Gift/payment number that was the source of this anticipated matching gift. VARCHAR2(63)
AGRGDES

AGRGDES_GIFT_NO

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_DESIGNATION_ANTICIPATED Match Designation Anticipated Anticipated amount for the matching gift designation. NUMBER
AGRMDES

AGRMDES_AMT

MATCH_EMPLOYER_ID Match Employer ID Matching gift employer or organization's current identification number. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_NAME Match Employer Name Name of the matching gift employer or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_EMPLOYER_UID Match Employer UID Internal identification number for the matching gift employer or organziation. NUMBER
AGRMGIF

AGRMGIF_EMPR_PIDM

MATCH_FORM_SENT_IND Match Form Sent Indicator Indicates if the match form has been sent. VARCHAR2(1)
AGBMGID

AGBMGID_MG_FORMSENT_IND

MATCH_GIFT_STATUS Match Gift Status Status of the anticipated matching gift; values are W, I, P or N. VARCHAR2(63)
CALCULATION

DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'W','P','P','I','I'),'N'),

MATCH_GIFT_STATUS_DESC Match Gift Status Description Description of the anticipated matching gift status. W = Waiting, no payments; I = Waiting, partial payment received; P = Paid in full; N = No payment expected. VARCHAR2(255)
CALCULATION

DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I','WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),

MATCH_SPOUSE_ID Match Spouse ID Current identification number for the spouse of the person making the gift to be matched. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_SPOUSE_NAME Match Spouse Name Name (LFMI) of the spouse of the person making the gift to be matched. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

MATCH_SPOUSE_UID Match Spouse UID Internal identification number for the spouse of the person making the gift to be matched. NUMBER
AGBMGID

AGBMGID_SPOUSE_PIDM

MATCH_VEHICLE Match Vehicle Vehicle code associated with the matching gift. VARCHAR2(63)
AGBMGID

AGBMGID_PGVE_CODE

MATCH_VEHICLE_DESC Match Vehicle Description Description of the vehicle code. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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 (LFMI) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER Pledge Number Pledge number associated to the donor payment that was the source of the anticipated matching gift. VARCHAR2(63)
NA

NA

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

NA

Ver: 9.0

Description	Contains designation level detail for each anticipated matching gift associated with an eligible donor gift or pledge payment.
Key & Frequency	One row per entity per gift number per campaign per designation per match employer UID.
Recommended Search Columns	CAMPAIGN_TYPE DESIGNATION DESG_TYPE DESG_GROUP ENTITY_UID, GIFT_NUMBER MATCH_EMPLOYER_UID, GIFT_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTIVE_IND	Active Indicator	Indicates if the matching gift is active (Y = active, N = inactive).	VARCHAR2(1)	AGBMGID	AGBMGID_DELETE_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CAMPAIGN	Campaign	Campaign associated with the gift or pledge payment that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_CAMPAIGN
CAMPAIGN_NAME	Campaign Name	Campaign name.	VARCHAR2(255)	AFBCAMP	AFBCAMP_NAME
CAMPAIGN_TYPE	Campaign Type	Type of campaign recorded.	VARCHAR2(63)	AFBCAMP	AFBCAMP_CMTP_CODE
CAMPAIGN_TYPE_DESC	Campaign Type Description	Campaign type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_COLLEGE	Designation College	College code associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_COLL_CODE
DESG_COLLEGE_DESC	Designation College Description	College, faculty or school name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_DEPARTMENT	Designation Department	Department associated with the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DEPT_CODE
DESG_DEPARTMENT_DESC	Designation Department Description	Name of the department.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_GROUP	Designation Group	User defined attribute for associating designations of similar purpose or function.	VARCHAR2(63)	ADBDESG	ADBDESG_DGRP_CODE
DESG_GROUP_DESC	Designation Group Description	Description of the designation group.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_STATUS	Designation Status	The current status of the designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTA_CODE
DESG_STATUS_DESC	Designation Status Description	Description of the designation status.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_TYPE	Designation Type	Designation type for a specific designation.	VARCHAR2(63)	ADBDESG	ADBDESG_DSTP_CODE
DESG_TYPE_DESC	Designation Type Description	Designation type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESG_VSE	Designation VSE - Voluntary Support of Education	Voluntary support of education code associated with the designation. Specifies why gifts or grants have been made for VSE reporting.	VARCHAR2(63)	ADBDESG	ADBDESG_CFAE_CODE
DESG_VSE_DESC	Designation VSE - Voluntary Support of Education Description	Voluntary support of education code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DESIGNATION	Designation	Designation associated with the gift/payment number that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_DESG
DESIGNATION_ACTIVITY_DATE	Designation Activity Date	Date the designation record was entered or last updated in the system.	DATE	AGRMDES	AGRMDES_ACTIVITY_DATE
DESIGNATION_NAME	Designation Name	Designation description.	VARCHAR2(255)	ADBDESG	ADBDESG_NAME
ENTITY_IND	Entity Indicator	Indicates whether the entity is a person or an organization.	VARCHAR2(1)	CONSTANT CONSTANT	'O' 'P'
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to the donor whose gift/payment was the source of this anticipated matching gift.	NUMBER	AGRMGIF	AGRMGIF_PIDM
GIFT_NUMBER	Gift Number	Gift/payment number that was the source of this anticipated matching gift.	VARCHAR2(63)	AGRGDES	AGRGDES_GIFT_NO
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_DESIGNATION_ANTICIPATED	Match Designation Anticipated	Anticipated amount for the matching gift designation.	NUMBER	AGRMDES	AGRMDES_AMT
MATCH_EMPLOYER_ID	Match Employer ID	Matching gift employer or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_EMPLOYER_NAME	Match Employer Name	Name of the matching gift employer or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_EMPLOYER_UID	Match Employer UID	Internal identification number for the matching gift employer or organziation.	NUMBER	AGRMGIF	AGRMGIF_EMPR_PIDM
MATCH_FORM_SENT_IND	Match Form Sent Indicator	Indicates if the match form has been sent.	VARCHAR2(1)	AGBMGID	AGBMGID_MG_FORMSENT_IND
MATCH_GIFT_STATUS	Match Gift Status	Status of the anticipated matching gift; values are W, I, P or N.	VARCHAR2(63)	CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'W','P','P','I','I'),'N'),
MATCH_GIFT_STATUS_DESC	Match Gift Status Description	Description of the anticipated matching gift status. W = Waiting, no payments; I = Waiting, partial payment received; P = Paid in full; N = No payment expected.	VARCHAR2(255)	CALCULATION	DECODE(AGBMGID_DELETE_IND,NULL, DECODE(AGBMGID_STATUS,NULL,'WAITING, NO PAYMENT','P','PAID IN FULL','I','WAITING, PARTIAL PAYMENT'),'NO PAYMENT EXPECTED'),
MATCH_SPOUSE_ID	Match Spouse ID	Current identification number for the spouse of the person making the gift to be matched.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_SPOUSE_NAME	Match Spouse Name	Name (LFMI) of the spouse of the person making the gift to be matched.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MATCH_SPOUSE_UID	Match Spouse UID	Internal identification number for the spouse of the person making the gift to be matched.	NUMBER	AGBMGID	AGBMGID_SPOUSE_PIDM
MATCH_VEHICLE	Match Vehicle	Vehicle code associated with the matching gift.	VARCHAR2(63)	AGBMGID	AGBMGID_PGVE_CODE
MATCH_VEHICLE_DESC	Match Vehicle Description	Description of the vehicle code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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 (LFMI) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLEDGE_NUMBER	Pledge Number	Pledge number associated to the donor payment that was the source of the anticipated matching gift.	VARCHAR2(63)	NA	NA
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA