Reporting View Target: ASC_PA

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

SGHE Banner Operational Data Store
Reporting View Target: ASC_PA_DONORS

Description ASC PA Donors was created to facilitate a report that needed historical degree information for a person and his or her spouse. It is a custom view that goes against the ASC Gift, ASC Constituent, Constituent, Special Activity, and Degree folders.
Key & Frequency Each person has only one entry in the table, uniquely identified by ENTITY_UID. ID is the NEU identifier visible to end-users.

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

ALUMNUS_TYPE ALUMNUS_TYPE ALUMNUS DESIGNATION CODE CHAR

DESIG_NAME DESIGNATION NAME DESIGNATION NAME CHAR

ENTITY_UID Entity_UID Key identifier used for table/folder joins IDENTIFIER

MIN_CNST_TYPE Entity Type Code CHAR

NEU_TOC_IND NORTHEASTERN SPECIFIC ENTITY toc CODE CHAR

SP_ALUMNUS_TYPE SPOUSE ALUMNUS TYPE SPOUSE ALUMNUS TYPE CHAR

SP_MIN_CNST_TYP SPOUSE CONSTITUENT TYPE SPOUSE CONSTITUENT TYPE CHAR

SP_PR_DG SPOUSE PRIMARY DEGREE CODE SPOUSE PRIMARY DEGREE CODE CHAR

SP_PR_DG_MAJ_NM SPOUSE PRIMARY DEGREE MAJOR NAME SPOUSE PRIMARY DEGREE MAJOR NAME CHAR

SP_PR_DG_SCH_NM SPOUSE PRIMARY DEGREE SCHOOL NAME SPOUSE PRIMARY DEGREE SCHOOL NAME CHAR

SP_PR_DG_YR SPOUSE PRIMARY DEGREE COMPLETION YEAR SPOUSE PRIMARY DEGREE COMPLETION YEAR CHAR

TYPE GIFT CLASS TYPE GIFT CLASS TYPE CHAR

Ver: 9.0

Description	ASC PA Donors was created to facilitate a report that needed historical degree information for a person and his or her spouse. It is a custom view that goes against the ASC Gift, ASC Constituent, Constituent, Special Activity, and Degree folders.
Key & Frequency	Each person has only one entry in the table, uniquely identified by ENTITY_UID. ID is the NEU identifier visible to end-users.

Target Column	Business Name	Business Definition	Database Data Type
ALUMNUS_TYPE	ALUMNUS_TYPE	ALUMNUS DESIGNATION CODE	CHAR
DESIG_NAME	DESIGNATION NAME	DESIGNATION NAME	CHAR
ENTITY_UID	Entity_UID	Key identifier used for table/folder joins	IDENTIFIER
MIN_CNST_TYPE		Entity Type Code	CHAR
NEU_TOC_IND		NORTHEASTERN SPECIFIC ENTITY toc CODE	CHAR
SP_ALUMNUS_TYPE	SPOUSE ALUMNUS TYPE	SPOUSE ALUMNUS TYPE	CHAR
SP_MIN_CNST_TYP	SPOUSE CONSTITUENT TYPE	SPOUSE CONSTITUENT TYPE	CHAR
SP_PR_DG	SPOUSE PRIMARY DEGREE CODE	SPOUSE PRIMARY DEGREE CODE	CHAR
SP_PR_DG_MAJ_NM	SPOUSE PRIMARY DEGREE MAJOR NAME	SPOUSE PRIMARY DEGREE MAJOR NAME	CHAR
SP_PR_DG_SCH_NM	SPOUSE PRIMARY DEGREE SCHOOL NAME	SPOUSE PRIMARY DEGREE SCHOOL NAME	CHAR
SP_PR_DG_YR	SPOUSE PRIMARY DEGREE COMPLETION YEAR	SPOUSE PRIMARY DEGREE COMPLETION YEAR	CHAR
TYPE	GIFT CLASS TYPE	GIFT CLASS TYPE	CHAR