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

Banner Operational Data Store
Reporting View Target: EVENT

Description Contains all data for a scheduled event.
Key & Frequency One row per event.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
AGENCY_DESC Name of the agency associated with the event. VARCHAR2(255)

FUNCTION

F_FORMAT_NAME

NO

NO
AGENCY_ID Current identification number for the agency sponsering this event. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
AGENCY_UID System generated unique internal identification number assigned to this organization entity. NUMBER

SLBEVNT

SLBEVNT_AGENCY_PIDM

NO

NO
CAMPUS Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

SLBEVNT

SLBEVNT_CAMP_CODE

NO

NO
CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

NO

NO
COLLEGE First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SLBEVNT

SLBEVNT_COLL_CODE

NO

NO
COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

STVCOLL

STVCOLL_DESC

NO

NO
COMMITTEE_IND Indicates whether a committee is associated with this event. VARCHAR2(1)

SLBEVNT

SLBEVNT_COMM_IND

NO

NO
CONTACT_ADDRESS_TYPE Address type code of the contact associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_ATYP_CODE

NO

NO
CONTACT_ADDRESS_TYPE_DESC Address type description. VARCHAR2(255)

STVATYP

STVATYP_DESC

NO

NO
CONTACT_DESC Contact type description. VARCHAR2(255)

FUNCTION

F_FORMAT_NAME

NO

NO
CONTACT_ID Current identification number for the contact peron assigned to this event. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

NO

NO
CONTACT_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

SLBEVNT

SLBEVNT_CONTACT_PIDM

NO

NO
DEPARTMENT Department responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SLBEVNT

SLBEVNT_DEPT_CODE

NO

NO
DEPARTMENT_DESC Department name. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

NO

NO
DIVISION District or division code associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_DICD_CODE

NO

NO
DIVISION_DESC Name of the division. VARCHAR2(255)

GTVDICD

GTVDICD_DESC

NO

NO
EVENT_DESC Event description. VARCHAR2(255)

SLBEVNT

SLBEVNT_DESC

NO

NO
EVENT_ID Internal event identification number. VARCHAR2(63)

SLBEVNT

SLBEVNT_CRN

NO

NO
EVENT_TYPE Type for the event. This might include meeting, conferences, field trips, advancement event, etc. VARCHAR2(63)

SLBEVNT

SLBEVNT_ETYP_CODE

NO

NO
EVENT_TYPE_DESC Description for the event type. VARCHAR2(255)

STVETYP

STVETYP_DESC

NO

NO
FUNCTION_BEGIN_TIME Begin time of the function. VARCHAR2(63)

SSRMEET

SSRMEET_BEGIN_TIME

NO

NO
FUNCTION_BLDG Building code associated with the function. VARCHAR2(63)

SSRMEET

SSRMEET_BLDG_CODE

NO

NO
FUNCTION_BRK_EVEN_ATTEND Break-even attendance at the function. NUMBER

GEBFUNC

GEBFUNC_BRK_EVEN_ATTEND

NO

NO
FUNCTION_CODE Function code associated with the event. VARCHAR2(63)

GEBFUNC

GEBFUNC_FUNC_CODE

NO

NO
FUNCTION_COMMITTEE_NAME Committee associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_COMMITTEE_NAME

NO

NO
FUNCTION_DESC Function code description. VARCHAR2(255)

GTVFUNC

GTVFUNC_DESC

NO

NO
FUNCTION_EMPHASIS Emphasis code associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_EMPH_CODE

NO

NO
FUNCTION_EMPHASIS_DESC Emphasis code description. VARCHAR2(255)

GTVEMPH

GTVEMPH_DESC

NO

NO
FUNCTION_END_DATE End date of the function. DATE

SSRMEET

SSRMEET_END_DATE

NO

NO
FUNCTION_END_TIME End time of the function. VARCHAR2(63)

SSRMEET

SSRMEET_END_TIME

NO

NO
FUNCTION_INVITATION_DATE Date of the invitation to the function. DATE

GEBFUNC

GEBFUNC_INVITATION_DATE

NO

NO
FUNCTION_LETTER Letter code of the letter associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_LETR_CODE

NO

NO
FUNCTION_LOCATION Location of the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_LOCATION

NO

NO
FUNCTION_LOCATION_DATE Date when the location detail was last edited. DATE

GEBFUNC

GEBFUNC_LOCATION_DATE

NO

NO
FUNCTION_PLAN_ATTEND Planned attendance at the function. NUMBER

GEBFUNC

GEBFUNC_PLAN_ATTEND

NO

NO
FUNCTION_PURPOSE Purpose code associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_PURP_CODE

NO

NO
FUNCTION_PURPOSE_DESC Purpose code description. VARCHAR2(255)

GTVPURP

GTVPURP_DESC

NO

NO
FUNCTION_ROOM Room code associated with the function. VARCHAR2(63)

SSRMEET

SSRMEET_ROOM_CODE

NO

NO
FUNCTION_RSVP_CONFIRM_DATE Deadline date for the RSVP confirmation. DATE

GEBFUNC

GEBFUNC_RSVP_CONFIRM_DATE

NO

NO
FUNCTION_SPONSOR_UID Id of the event sponsor. NUMBER

GEBFUNC

GEBFUNC_SPNSR_ORGN_PIDM

NO

NO
FUNCTION_START_DATE Start date for this function. DATE

SSRMEET

SSRMEET_START_DATE

NO

NO
FUNCTION_STATUS Status code associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_FSTA_CODE

NO

NO
FUNCTION_STATUS_DESC Status code description. VARCHAR2(255)

GTVFSTA

GTVFSTA_DESC

NO

NO
FUNCTION_TARGET_AUDIENCE Target audience associated with the function. VARCHAR2(63)

GERFCON

GERFCON_TARG_CODE

NO

NO
FUNCTION_TYPE Type code associated with the function. VARCHAR2(63)

GEBFUNC

GEBFUNC_ETYP_CODE

NO

NO
FUNCTION_TYPE_DESC Event type code description. VARCHAR2(255)

STVETYP

STVETYP_DESC

NO

NO
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 Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
PHONE_AREA Area code of the contact associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_PHONE_AREA

NO

NO
PHONE_EXT Telephone extension of the contact associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_PHONE_EXT

NO

NO
PHONE_NUMBER Telephone number of the contact associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_PHONE

NO

NO
PHONE_NUMBER_COMBINED All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension. VARCHAR2(63)

CALCULATION

SLBEVNT_PHONE_AREA||SLBEVNT_PHONE||SLBEVNT_PHONE_EXT

NO

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

NA

NA

NO

NO
SITE Site or location associated with the event. VARCHAR2(63)

SLBEVNT

SLBEVNT_SITE_CODE

NO

NO
SITE_DESC Site or location name. VARCHAR2(255)

STVSITE

STVSITE_DESC

NO

NO
SYSTEM_IND Identifies the system in use when the event was created. VARCHAR2(63)

SLBEVNT

SLBEVNT_SYSI_CODE

NO

NO


Ver: 9.2