EVENT - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
EVENT_ID |
SYSTEM GENERATED INTERNAL IDENTIFICATION NUMBER FOR THE EVENT. |
|
SLBEVNT |
SLBEVNT_CRN |
UNKNOWN |
EVENT_DESC |
DESCRIPTION OR NAME ASSIGNED TO THE EVENT. |
|
SLBEVNT |
SLBEVNT_DESC |
UNKNOWN |
EVENT_TYPE |
TYPE OF EVENT REPRESENTED BY THIS RECORD. THIS MIGHT BE A MEETING |
|
SLBEVNT |
SLBEVNT_ETYPE_CODE |
UNKNOWN |
EVENT_TYPE_DESC |
THIS COLUMN SPECIFIES THE EVENT TYPE DESCRIPTION. |
|
SLBEVNT |
SLBEVNT_DESC |
UNKNOWN |
AGENCY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SLBEVNT |
SLBEVNT_AGENCY_PIDM |
UNKNOWN |
AGENCY_DESC |
NAME OF THE AGENCY SPONSORING THE EVENT IF APPLICABLE. |
|
SLBEVNT |
SLBEVNT_DESC |
UNKNOWN |
CONTACT_UID |
SYSTEM INTERNALLY GENERATED NUMBER TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SLBEVNT |
SLBEVNT_PIDM |
UNKNOWN |
CONTACT_DESC |
NAME OF THE CONTACT AT THE AGENCY RESPONSIBLE FOR THE EVENT PLANNING. |
|
SLBEVNT |
SLBEVNT_CONTACT_NAME |
UNKNOWN |
CONTACT_ADDRESS_TYPE |
ADDRESS TYPE CODE OF THE AGENCY'S ADDRESS. |
|
SLBEVNT |
SLBEVNT_ATYP_CODE |
UNKNOWN |
CONTACT_ADDRESS_TYPE_DESC |
DESCRIPTION ASSOCIATED WITH THE AGENCY'S ADDRESS TYPE CODE. |
|
STVATYP |
STVATYP_DESC |
UNKNOWN |
CAMPUS |
IDENTIFIES THE CAMPUS ASSOCIATED WITH THE RECORD. |
|
SLBEVNT |
SLBEVNT_CAMP_CODE |
UNKNOWN |
CAMPUS_DESC |
NAME OF THE CAMPUS ASSOCIATED WITH THE RECORD. |
|
SLBEVNT |
STVCAMP_DESC |
UNKNOWN |
SITE |
INSTITUTION SITE WHERE THE EVENT TAKES PLACE. |
|
SLBEVNT |
SLBEVNT_SITE_CODE |
UNKNOWN |
SITE_DESC |
NAME OF THE SITE WHERE AN EVENT TAKES PLACE. |
|
STVSITE |
STVSITE_DESC |
UNKNOWN |
COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
SLBEVNT |
SLBEVNT_COLL_CODE |
UNKNOWN |
COLLEGE_DESC |
NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. |
|
SLBEVNT |
STVCOLL_DESC |
UNKNOWN |
DEPARTMENT |
SYSTEM GENERATED NUMBER THAT IS INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON. |
|
SLBEVNT |
SLBEVNT_DEPT_CODE |
UNKNOWN |
DEPARTMENT_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
SLBEVNT |
STVDEPT_DESC |
UNKNOWN |
DIVISION |
SECOND LAYER OF THE INSTITUTION ORGANIZATION. |
|
SLBEVNT |
SLBEVNT_DICD_CODE |
UNKNOWN |
DIVISION_DESC |
NAME OF THE SECOND LAYER (DIVISION) OF THE INSTITUTION ORGANIZATION. |
|
GTVDICD |
GTVDICD_DESC |
UNKNOWN |
PHONE_NUMBER_COMBINED |
ALL RECORDED PIECES OF THE TELEPHONE NUMBER COMBINED IN A SINGLE FIELD. INTERNATIONAL CODE, AREA CODE, NUMBER, EXTENSION. |
|
SUBSTR |
PHONE_NUMBER_COMBINED |
UNKNOWN |
PHONE_AREA |
AREA CODE OF THE REFERENCE. |
|
SLBEVNT |
SLBEVNT_PHONE_AREA |
UNKNOWN |
PHONE_NUMBER |
TELEPHONE NUMBER. |
|
SLBEVNT |
SLBEVNT_PHONE |
UNKNOWN |
PHONE_EXT |
TELEPHONE NUMBER EXTENSION. |
|
SLBEVNT |
SLBEVNT_PHONE_EXT |
UNKNOWN |
SYSTEM_IND |
|
|
SLBEVNT |
SLBEVNT_SYSI_CODE |
UNKNOWN |
COMMITTEE_IND |
EVENT IS ASSOCIATED WITH A COMMITTEE OR SERVICE INDICATOR. |
|
SLBEVNT |
SLBEVNT_COMM_IND |
UNKNOWN |
FUNCTION_CODE |
|
|
GEBFUNC |
GEBFUNC_FUNC_CODE |
UNKNOWN |
FUNCTION_DESC |
FORMAL NAME OF THE FUNCTION RECORDED FOR THE EVENT. |
|
GTVFUNC |
GTVFUNC_DESC |
UNKNOWN |
FUNCTION_TYPE |
TYPE ASSOCIATED WITH THE FUNCTION. EXAMPLES INCLUDE INTRODUCTION |
|
GEBFUNC |
GEBFUNC_ETYP_CODE |
UNKNOWN |
FUNCTION_TYPE_DESC |
DESCRIPTION ASSOCIATED WITH THE FUNCTION. |
|
STVETYP |
STVETYP_DESC |
UNKNOWN |
FUNCTION_STATUS |
STATUS CODE ASSOCIATED WITH THE FUNCTION. EXAMPLES INCLUDE PLANNED |
|
GEBFUNC |
GEBFUNC_FSTA_CODE |
UNKNOWN |
FUNCTION_STATUS_DESC |
DESCRIPTION ASSOCIATED WITH THE FUNCTION STATUS. |
|
GTVFSTA |
GTVFSTA_DESC |
UNKNOWN |
FUNCTION_PURPOSE |
INSTITUTION DEFINED PURPOSE ASSOCIATED WITH THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_PURP_CODE |
UNKNOWN |
FUNCTION_PURPOSE_DESC |
DESCRIPTION ASSOCIATED WITH THE FUNCTION PURPOSE. |
|
GTVPURP |
GTVPURP_DESC |
UNKNOWN |
FUNCTION_EMPHASIS |
INSTITUTION DEFINED EMPHASIS FOR THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_EMPH_CODE |
UNKNOWN |
FUNCTION_EMPHASIS_DESC |
DESCRIPTION ASSOCIATED WITH THE FUNCTION EMPHASIS. |
|
GTVEMPH |
GTVEMPH_DESC |
UNKNOWN |
FUNCTION_INVITATION_DATE |
INVITATION DATE ASSOCIATED WITH THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_INVITATION_DATE |
UNKNOWN |
FUNCTION_LETTER |
SYSTEM LETTER CODE ASSOCIATE WITH THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_LETR_CODE |
UNKNOWN |
FUNCTION_RSVP_CONFIRM_DATE |
RESERVATION CONFIRMATION DATE REQUIRED FOR THIS FUNCTION. |
|
GEBFUNC |
GEBFUNC_RSVP_CONFIRM_DATE |
UNKNOWN |
FUNCTION_SPONSOR_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
GEBFUNC |
GEBFUNC_SPNSR_ORGN_PIDM |
UNKNOWN |
FUNCTION_COMMITTEE_NAME |
COMMITTEE NAME ASSOCIATED WITH THE FUNCTION IF APPLICABLE. |
|
GEBFUNC |
GEBFUNC_COMMITTEE_NAME |
UNKNOWN |
FUNCTION_PLAN_ATTEND |
NUMBER OF PERSONS EXPECTED TO ATTEND THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_PLAN_ATTEND |
UNKNOWN |
FUNCTION_BRK_EVEN_ATTEND |
NUMBER OF PARTICIPANTS REQUIRED TO ATTEND THE FUNCTION TO BREAK EVEN. |
|
GEBFUNC |
GEBFUNC_BRK_EVEN_ATTEND |
UNKNOWN |
FUNCTION_LOCATION |
LOCATION OF THE FUNCTION. |
|
GEBFUNC |
GEBFUNC_LOCATION |
UNKNOWN |
FUNCTION_LOCATION_DATE |
LAST DATE THE LOCATION DETAIL WAS EDITED. |
|
GEBFUNC |
GEBFUNC_LOCATION_DATE |
UNKNOWN |
FUNCTION_START_DATE |
START DATE FOR THE FUNCTION. |
|
SSRMEET |
SSRMEET_BEGIN_DATE |
UNKNOWN |
FUNCTION_END_DATE |
END DATE FOR THE FUNCTION. |
|
SSRMEET |
SSRMEET_END_DATE |
UNKNOWN |
FUNCTION_BEGIN_TIME |
BEGIN TIME FOR THE FUNCTION. |
|
SSRMEET |
SSRMEET_BEGIN_TIME |
UNKNOWN |
FUNCTION_END_TIME |
END TIME FOR THE FUNCTION. |
|
SSRMEET |
SSRMEET_END_TIME |
UNKNOWN |
FUNCTION_BLDG |
BUILDING WHERE THE FUNCTION IS HELD. |
|
SSRMEET |
SSRMEET_BLDG_CODE |
UNKNOWN |
FUNCTION_ROOM |
ROOM WHERE THE FUNCTION IS HELD. |
|
SSRMEET |
SSRMEET_ROOM_CODE |
UNKNOWN |
FUNCTION_TARGET_AUDIENCE |
TARGET AUDIENCE FOR THE FUNCTION. |
|
GERFCON |
GERFCON_TARG_CODE |
UNKNOWN |