Reporting View Target: ACTIVITY

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

Banner Operational Data Store
Reporting View Target: ACTIVITY

Description Contains all of the activity and leadership combinations recorded for the person by the institution, including academic period related activities when the person was a student as well as subsequent activities stored for an alumnus of the institution.
Key & Frequency One row per person per activity and leadership role or per activity and academic period.
Recommended Search Columns ENTITY_UID

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

ACADEMIC_PERIOD Academic Period Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)
SGRSACT

SGRSACT_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)
STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period. VARCHAR2(63)
STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)
STVACYR

STVACYR_DESC

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
SGRSACT

APRACTY_ACTC_CODE
SGRSACT_ACTC_CODE

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

STVACTC_ACCG_CODE

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

STVACCG_DESC

ACTIVITY_COMMENT Activity Comment Comments that describe anything special or unique about this person's participation in this activity. VARCHAR2(255)
APRACTY

APRACTY_COMMENT

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

STVACTC_DESC

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

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

STVACTP_DESC

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

NA

ADVANCEMENT_ACTIVITY_IND Advancement Activity Indicator Indicates that this data is from Advancement. CHAR(1)
CONSTANT
CONSTANT

'N'
'Y'

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

APRACTY_PIDM
SGRSACT_PIDM

FIRST_YEAR First Year Initial or earliest year of participation in this activity. NUMBER
FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

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

LAST_YEAR Last Year Last or most recent year of participation in this activity. NUMBER
FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

LEADERSHIP_ACTIVITY_BEGIN_DATE Leadership Activity Begin Date Date the activity participation began. DATE
APRACLD

APRACLD_BEGIN_DATE

LEADERSHIP_ACTIVITY_END_DATE Leadership Activity End Date Date the activity participation ended. DATE
APRACLD

APRACLD_END_DATE

LEADERSHIP_COMMENT Leadership Comment Comments that describe anything special or unique about this person's participation in this activity. VARCHAR2(400)
APRACLD

APRACLD_COMMENT

LEADERSHIP_ROLE Leadership Role Specifies the activity to represent a type of leadership activity. VARCHAR2(63)
APRACLD
STVACTC

APRACLD_LEAD_CODE
STVACTC_LEAD_CODE

LEADERSHIP_ROLE_DESC Leadership Role Description Type of leadership description. VARCHAR2(255)
STVLEAD

STVLEAD_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 (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)
NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)
NA

NA

TOTAL_YEARS Total Years Total number of years associated with a particular special activity. NUMBER
FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

Ver: 9.2

Description	Contains all of the activity and leadership combinations recorded for the person by the institution, including academic period related activities when the person was a student as well as subsequent activities stored for an alumnus of the institution.
Key & Frequency	One row per person per activity and leadership role or per activity and academic period.
Recommended Search Columns	ENTITY_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	SGRSACT	SGRSACT_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
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 SGRSACT	APRACTY_ACTC_CODE SGRSACT_ACTC_CODE
ACTIVITY_CATEGORY	Activity Category	Specifies a grouping of activities that can be used for reporting like activites together.	VARCHAR2(63)	STVACTC	STVACTC_ACCG_CODE
ACTIVITY_CATEGORY_DESC	Activity Category Description	Activity category description.	VARCHAR2(255)	STVACCG	STVACCG_DESC
ACTIVITY_COMMENT	Activity Comment	Comments that describe anything special or unique about this person's participation in this activity.	VARCHAR2(255)	APRACTY	APRACTY_COMMENT
ACTIVITY_DESC	Activity Description	Student activity description.	VARCHAR2(255)	STVACTC	STVACTC_DESC
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
ACTIVITY_TYPE_DESC	Activity Type Description	Activity type description.	VARCHAR2(255)	STVACTP	STVACTP_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ADVANCEMENT_ACTIVITY_IND	Advancement Activity Indicator	Indicates that this data is from Advancement.	CHAR(1)	CONSTANT CONSTANT	'N' 'Y'
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person.	NUMBER	APRACTY SGRSACT	APRACTY_PIDM SGRSACT_PIDM
FIRST_YEAR	First Year	Initial or earliest year of participation in this activity.	NUMBER	FUNCTION	AOKODSF.F_GET_ACTIVITY_YEAR_COUNT
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
LAST_YEAR	Last Year	Last or most recent year of participation in this activity.	NUMBER	FUNCTION	AOKODSF.F_GET_ACTIVITY_YEAR_COUNT
LEADERSHIP_ACTIVITY_BEGIN_DATE	Leadership Activity Begin Date	Date the activity participation began.	DATE	APRACLD	APRACLD_BEGIN_DATE
LEADERSHIP_ACTIVITY_END_DATE	Leadership Activity End Date	Date the activity participation ended.	DATE	APRACLD	APRACLD_END_DATE
LEADERSHIP_COMMENT	Leadership Comment	Comments that describe anything special or unique about this person's participation in this activity.	VARCHAR2(400)	APRACLD	APRACLD_COMMENT
LEADERSHIP_ROLE	Leadership Role	Specifies the activity to represent a type of leadership activity.	VARCHAR2(63)	APRACLD STVACTC	APRACLD_LEAD_CODE STVACTC_LEAD_CODE
LEADERSHIP_ROLE_DESC	Leadership Role Description	Type of leadership description.	VARCHAR2(255)	STVLEAD	STVLEAD_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 (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SUB_ACADEMIC_PERIOD	Sub Academic Period	A session, portion or part of the academic period.	VARCHAR2(63)	NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub Academic Period Description	Sub academic period description.	VARCHAR2(255)	NA	NA
TOTAL_YEARS	Total Years	Total number of years associated with a particular special activity.	NUMBER	FUNCTION	AOKODSF.F_GET_ACTIVITY_YEAR_COUNT