Reporting View Target: SPECIAL_ACTIVITY

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

Banner Operational Data Store
Reporting View Target: SPECIAL_ACTIVITY_YEAR

Description Contains the years of participation in a special advancement activity for an alumnus. Data will include all of the years recorded for a person's participation in the activity.
Key & Frequency One row per entity per activity per participation year.
Recommended Search Columns ACTIVITY
PARTICIPATION_YEAR
ENTITY_UID

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

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person. NUMBER
APRACTY

APRACTY_PIDM

NO
NO

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO
NO

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

MGKFUNC.F_GET_PERSON_INFO

NO
NO

ACTIVITY Activity Activity recorded for the student or alumnus. Activities may include leadership councils, seminars, fraternity or sorority, chess or debate clubs, etc. VARCHAR2(63)
APRACTY

APRACTY_ACTC_CODE

NO
NO

ACTIVITY_DESC Activity Description Student activity description. VARCHAR2(255)
STVACTC

STVACTC_DESC

NO
NO

ACTIVITY_TYPE Activity Type Specifies a type of activity that is used to group like activites together for reporting. VARCHAR2(63)
STVACTC

STVACTC_ACTP_CODE

NO
NO

ACTIVITY_TYPE_DESC Activity Type Description Activity type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

ACTIVITY_CATEGORY Activity Category Specifies a grouping of activities that can be used for reporting like activites together. VARCHAR2(63)
STVACTC

STVACTC_ACCG_CODE

NO
NO

ACTIVITY_CATEGORY_DESC Activity Category Description Activity category description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

NO
NO

PARTICIPATION_YEAR Participation Year Year that the person or organization participated in the activity recorded. VARCHAR2(63)
APRACYR

APRACYR_YEAR

NO
NO

PARTICIPATION_YEAR_DESC Participation Year Description Participation year description. VARCHAR2(255)
NA

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NA

NO
NO

Ver: 9.2

Description	Contains the years of participation in a special advancement activity for an alumnus. Data will include all of the years recorded for a person's participation in the activity.
Key & Frequency	One row per entity per activity per participation year.
Recommended Search Columns	ACTIVITY PARTICIPATION_YEAR ENTITY_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APRACTY	APRACTY_PIDM	NO	NO
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ACTIVITY	Activity	Activity recorded for the student or alumnus. Activities may include leadership councils, seminars, fraternity or sorority, chess or debate clubs, etc.	VARCHAR2(63)	APRACTY	APRACTY_ACTC_CODE	NO	NO
ACTIVITY_DESC	Activity Description	Student activity description.	VARCHAR2(255)	STVACTC	STVACTC_DESC	NO	NO
ACTIVITY_TYPE	Activity Type	Specifies a type of activity that is used to group like activites together for reporting.	VARCHAR2(63)	STVACTC	STVACTC_ACTP_CODE	NO	NO
ACTIVITY_TYPE_DESC	Activity Type Description	Activity type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACTIVITY_CATEGORY	Activity Category	Specifies a grouping of activities that can be used for reporting like activites together.	VARCHAR2(63)	STVACTC	STVACTC_ACCG_CODE	NO	NO
ACTIVITY_CATEGORY_DESC	Activity Category Description	Activity category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PARTICIPATION_YEAR	Participation Year	Year that the person or organization participated in the activity recorded.	VARCHAR2(63)	APRACYR	APRACYR_YEAR	NO	NO
PARTICIPATION_YEAR_DESC	Participation Year Description	Participation year description.	VARCHAR2(255)	NA	NA	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO