Reporting View Target: ASC_CONSTITUENT

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

SGHE Banner Operational Data Store
Reporting View Target: ASC_CONSTITUENT - ASC_Constituent

Description ASC Constituent was created in order to contain commonly-referenced items from both Person and Organization constituents in one folder. More items from several related Person and Organization folders can be acquired by using existing, or by creating new, joins to those folders.
Key & Frequency Entity_UID

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

ENTITY_TYPE Differentiates people (P) and organization (O) constituents CHAR P,O

ENTITY_UID ENTITY_UID Northeastern University generated, unique identification number assigned to an entity (typically and individual). NUMBER

NC_CODE NC_CODE Exclusion value if exists CHAR

NC_EXT_IND NC_EXT_IND Indicates exclusion value of NC, NE, NS, CA1, NSP, NSF, NSC, NI, or NM CHAR

NC_IND NC_IND Indicates exclusion value of NC CHAR

STAFF_NAME STAFF_NAME Name of staff member assigned to this entity CHAR

TOC_CODE TOC_CODE Special purpose group of T, O, C, HT, LTE, or OE, if exists CHAR T, O, C, HT, LTE, OR OE

TOC_IND TOC_IND Indicates special purpose group values of T, O, C, HT, LTE, or OE CHAR Y,N

Ver: 9.0

Description	ASC Constituent was created in order to contain commonly-referenced items from both Person and Organization constituents in one folder. More items from several related Person and Organization folders can be acquired by using existing, or by creating new, joins to those folders.
Key & Frequency	Entity_UID

Target Column	Business Name	Business Definition	Database Data Type	Domain Value
ENTITY_TYPE		Differentiates people (P) and organization (O) constituents	CHAR	P,O
ENTITY_UID	ENTITY_UID	Northeastern University generated, unique identification number assigned to an entity (typically and individual).	NUMBER
NC_CODE	NC_CODE	Exclusion value if exists	CHAR
NC_EXT_IND	NC_EXT_IND	Indicates exclusion value of NC, NE, NS, CA1, NSP, NSF, NSC, NI, or NM	CHAR
NC_IND	NC_IND	Indicates exclusion value of NC	CHAR
STAFF_NAME	STAFF_NAME	Name of staff member assigned to this entity	CHAR
TOC_CODE	TOC_CODE	Special purpose group of T, O, C, HT, LTE, or OE, if exists	CHAR	T, O, C, HT, LTE, OR OE
TOC_IND	TOC_IND	Indicates special purpose group values of T, O, C, HT, LTE, or OE	CHAR	Y,N