Campus Community Data Mart

The Campus Community data mart enables you to analyze student information, service indicators, communications and checklists.

With the Campus Community data mart you can track and analyze:

service indicators, which enables you to identify which services should be available to a student.
communications to parties associated with your institution, which enables you to better understand the impact of recruitment events on student enrollment.
events, meetings, and attendees that are associated with an event.
checklists for students and external organizations, and enables you to analyze the relationship of checklists between the university admissions office and prospective or accepted students.

With the Campus Community Data Mart you can answer questions such as:

How many service indicators are outstanding for a particular service reason?
How many person communications have been created for an institution?
How many events for a given Campus event type?
How many organization checklists have been created for an institution?
How many service indicators are outstanding for a student?
How many organization communications have been created for a department?

Campus Community Data Mart Delivered Fact Tables

The following table describes the delivered Campus Community Data Mart fact tables.

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	PeopleSoft Source	Description	Helps Answer
Campus Events	F_CAMPUS_EVENT	PS_CAMPUS_EVENT	Contains information about events, such as when an event occurred or when it is planned, the number of meetings associated with an event, expected attendance, number of attendees, and so forth. The information can be analyzed by institution, event type, event manager, and so forth. There is one row of data per campus event.	Number of events an institution offered during the last academic year, by event type. Number of attendees an per event. Average number of meetings, by event, for an institution. Average number of attendees versus invited. Top 10 events by number of attendees.
Campus Event Meeting	F_CAMP_EVNT_MTG	PS_EVENT_MTG PS_CAMPUS_EVENT	This fact table enables you to analyze current credit history information and credit history trends for a given business unit, account type, student, external org, and so forth. Provides analysis of events, event meetings, and event attendees. Also provides lower level of granularity than the Campus Event fact table, since the Campus Event Meeting fact table provides information at the event meeting level, and it allows analysis of events and event meetings by institution, event type, coordinator, external organization, and department. There is one row of data per campus event and event meeting number.	Number of event meetings that occurred in the campus facilities in the last academic year. Number of event meetings that occurred outside the campus facilities in the last academic year. Number of campus events by institution, by campus event type. Number of meeting events occurring on specific dates, detailing projected attendance, number of people invited and number of attendees. Top 10 meeting events ranked by attendance and/or percentage of attendance attendees/invitations. And location of event and day of week it occurred.
Organization Check List	F_CHKLST_ORG	PS_PERSON_CHECKLST	Provides information about external organization checklists. Checklists may be lists of steps that must be performed, or documents that must be provided, or communications that are planned to occur, and so on. This table enables you to analyze external organization checklists by organization, admin function, institution, and related checklist items. There is one row of data per Organization ID and sequence number.	Number of external organizations with pending (incomplete) checklists for a specific admin function. Number of external organizations with past due checklists, by institution and admin function. Number of external organizations with specific checklist items that are still incomplete. And how many of them were created by a given user. Number of incomplete checklists for a given department.
Person Check List	F_CHKLST_PERSON	PS_PERSON_CHECKLST	Provides information about person (student) checklists. Checklists may be lists of steps that must be performed, or documents that must be provided, or communications that are planned to occur, and so on. This table enable you to analyze person organization checklists by student, admin function, institution, and related checklist items. There is one row of data per Person ID and sequence number.	Number of students with pending (incomplete) checklists for a specific admin function (such as admissions application). Number of students with past due checklists, by institution and admin function. Number of students with specific checklist items that are still incomplete. And how many of them were created by a given user.
Organization Communications	F_COMM_EXT_ORG	PS_COMMUNICATION	Provides analysis of external organization communications. This fact table enables you to analyze External Organization Communications by organization, administrative function, and related variable data, institution, and outcome reason. There is one row of data per external organization and sequence number.	Number of communications created for a given external organization during a given time period. Number of those that have been completed. Number of communications with enclosures for a given external organization. Top 10 external organizations ranked by total number of communications (both complete and incomplete) for a given time period.
Person Communications	F_COMM_PERSON	PS_COMMUNICATION	Provides analysis of person communications by person, administrative function, related variable data, institution and outcome reason. There is one row of data per person and sequence number.	Number of communications created for a given person for a given time period. Number that have been completed. Number of communications with enclosures for a given person. Top 10 people ranked by total number of communications (both complete and incomplete) for a given time period.
Service Indicators	F_SRVC_INDCTRS	PS_SRVC_IND_DATA	Provides analysis of service indicators and related impact values by student or external organization. Negative service indicators can be holds that prevent an individual or organization from receiving certain services and positive indicators can designate special services to be provided. Service indicators consist of one or more impact values that identify the types of specific services that are restricted or provided. There is one row of data per person and service indicator date/time stamp.	Number of outstanding service indicators for a student. Type of service indicator attached to a student. Number of outstanding service indicators for an institution. Number of outstanding service indicators for a particular service code or service reason. Users that have created a given service indicator and when. Which service impacts are attached to a given service indicator. Number of students with service indicators that are for a given service impact. Which service indicators have been released (deleted).

Campus Community Data Mart Delivered Dimension Tables

The following table describes the delivered Campus Community Data Mart dimension tables.

Dimension Name	Dimension Record Name	Description
Admin Function	D_ADMIN_FUNC	Lists administrative functions.
Aging Category	D_AGING_SF	Contains a list of aging set and aging category descriptions.
Campus Event	D_CAMPUS_EVENT	Lists campus events.
Checklist Code	D_CHKLST_CD	Contains a list of available checklist codes.
Checklist Status	D_CHKLST_STAT	Contains a list of checklist statuses.
Campus Event Attendee	D_CMP_EVNT_ATND	Contains a lists campus event attendees.
Communication Category	D_COMM_CATGRY	Contains a list of available communication categories.
Communication Context	D_COMM_CTXT	Contains a list of communication context.
Communication Direction	D_COMM_DIR	Contains a list of available communication directions.
Communication Method	D_COMM_MTHD	Contains a list of available communication methods.
Event Meeting	D_EVENT_MTG	Contains details of campus event meetings.
Checklist Item	D_ITEM_CD	Contains a list of checklist item codes.
Letter Code	D_LTR_CODE	Contains a list of available letter codes.
Outcome Reason	D_OUTCM_RSN	Contains a list of available communication outcome reasons.
Service Impact	D_SRVC_IMPACT	Maintains information about the impact entities in a campus community and includes several attributes about a service impact like description, institution code, and service impact code fields.
Service Indicator	D_SRVC_IND	Stores information about service indicator codes by institution.
Service Indicator Reason	D_SRVC_IND_RSN	Stores service indicator reasons by institution and service indicator code.
Variable Data	D_VAR_DATA	Provides details of variable data based on administrative function.
Checklist Item (Relationship Table)	R_CHKLST_ITEM	Bridges the one to many relationships of person and organization checklist facts to the corresponding checklist item code dimension.
Campus Event Attendee (Relationship Table)	R_CMP_EVNT_ATND	Links the one to many relationships between one-to-many relationships between event meetings and the event attendees.
Service Impact (Relationship Table)	R_SRVC_IMPACT	Links the one to many relationship between the Service Indicator (D_SRVC_IND) fact and Service Impact (D_SRVC_IMPACT) dimension.