Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_SPECIAL_ACTIVITY

Description Source composite view contains information on any special activities in which a person or organization has participated.

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_CATEGORY Category associated with the activity so that like activities can be grouped for reporting. VARCHAR2(5)

STVACTC

STVACTC_ACCG_CODE

ACTIVITY_CATEGORY_DESC Activities category description. VARCHAR2(30)

STVACCG

STVACCG_DESC

ACTIVITY_TYPE Specifies a broad type of activity in which the specific activity can be grouped (for example, Sports, Cultural, or Volunteer). VARCHAR2(5)

STVACTC

STVACTC_ACTP_CODE

ACTIVITY_TYPE_DESC Activity type description. VARCHAR2(30)

STVACTP

STVACTP_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)

APRACTY

APRACTY_PIDM

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

CALCULATION

MIN(APRACYR_YEAR)

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

CALCULATION

MAX(APRACYR_YEAR)

LEADERSHIP_ACTIVITY_BEGIN_DATE This field specifies the date the activity participation began. DATE

APRACLD

APRACLD_BEGIN_DATE

LEADERSHIP_ACTIVITY_END_DATE This field specifies the date the activity participation ended. DATE

APRACLD

APRACLD_END_DATE

LEADERSHIP_COMMENT This field specifies the comments that describe anything special or unique about this person's participation in this activity. VARCHAR2(60)

APRACLD

APRACLD_COMMENT

LEADERSHIP_ROLE This field specifies the activity to represent a type of leadership activity. VARCHAR2(5)

APRACLD

APRACLD_LEAD_CODE

LEADERSHIP_ROLE_DESC This field specifies the description of the type of leadership. VARCHAR2(30)

STVLEAD

STVLEAD_DESC

MIF_DESC Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

SPECIAL_ACTIVITY Special activity code. VARCHAR2(8)

APRACTY

APRACTY_ACTC_CODE

SPECIAL_ACTIVITY_COMMENT Comments which further define the constituent's activities. VARCHAR2(60)

APRACTY

APRACTY_COMMENT

SPECIAL_ACTIVITY_DESC Student activity description. VARCHAR2(30)

STVACTC

STVACTC_DESC

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

FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

ZONE_VALUE Institution value of the process-oriented identifier for the record used to determine access authorization to this record. VARCHAR2(6)

NA

NA



Ver: 8.0