Enrollment Manager User Guide

Search this site
  • EM Knowledge Base
  • Events
  • System Status
  • Editing the Wiki
  • EM Knowledge Base
    • 2016-17 Click Dimensions Email Transition Information
      • FAQ
    • Advanced Find
      • Advanced Find Results
      • Creating a new Advanced Find
      • Exporting Advanced Find Results
      • Modifying Advanced Find Columns
      • Sharing, Deactivating and Deleting Advanced Finds
      • Tips for working with Search Criteria
      • Training Exercises: Advanced Find
    • Data Entry Forms
    • Descriptive Analytics
      • Default Behavior in Descriptive Analytics
      • Descriptive Analytics Comparison Report
      • Descriptive Analytics Conversion Report
      • Descriptive Analytics Crosstab Report
      • Descriptive Analytics Dashboard Report
      • Descriptive Analytics Date Report
      • Descriptive Analytics Detail Report
      • Descriptive Analytics Pivot Table Report
      • Descriptive Analytics Profile Report
      • Descriptive Analytics Term Report
      • Navigating in Analytics
      • Saving Settings in Analytics
    • Domain Values
    • Duplicate Detection
      • Duplicate Activity Clean-Up
      • Duplicate Detection Jobs
      • Duplicate Detection Rules
    • Email Marketing
      • Email Advanced Options
      • Email Bounces
      • Email Content
        • Dynamic Email Content
      • Email HTML Editor
        • Email Merge Fields
        • Improper Syntax
      • Email Interactions
      • Email Scheduling
      • Email Statistics
      • Email Testing
        • Email A/B Split Testing
      • Email Validation and Preview
      • Email Web Page Views
      • Heat Map
      • Initial Email Setup
      • Mailgun Interactions
      • Mailing Definitions
      • Mailing Subscriptions
      • Saving Email Content
      • Webinar: Intro to Email Marketing and Web Intelligence
      • Whitelisting Overview
    • Entities
      • Activities
        • Activity Category & Value
        • Duplicate Activities
        • First Activity
      • Competitors
      • Interests
      • Opportunities
        • Merging Opportunities
      • Organizations and Groups
      • Outreach Lists
        • Advanced Record Selector
      • Person ID's
      • Person Organizations
        • Primary Organization
      • Person Records
        • Merging Persons
      • Relationships/Connections
        • Connections FAQ
      • Scores
    • Facebook Posts
    • Implementation
      • Analytics
        • Dashboard and Descriptive Analytics
      • Campaigns
        • Generate Applications
      • Enrollment Operations Manager
      • Tools-Getting Started
      • Tools-Manage Applications
      • Tools-Manage Communications
        • Advanced Find
      • Tools-Manage Data Integration
      • Tools-Manage Events
      • Tools-Manage Travel
      • Tools-Web Interactions
      • Training Resources
        • Adding a Person Organization Record
        • Adding a Person Record
        • Adding a Test Score Record
        • Adding an Opportunity Record
        • Events - Adding Event Details Part 1
        • Events - Adding Event Details Part 2
        • Events - Adding or Removing Messages
        • Events - Adding Registration Fields
        • Events - AF Example Attends for Phone Call Follow Up
        • Events - AF Example No-Shows for Postcard Mailing
        • Events - AF Example Registrants for Email Follow Up
        • Events - Creating an Event Message
        • Events - Creating an Event Message with Merge Fields
        • Events - Customizing the Online Calendar
        • Events - Finding and viewing Event Registrations
        • Events - Finding the Calendar URL on the Event Category
        • Events - Manual Event Registration from the Event
        • Events - Manual Event Registration from the Person Record
        • Events - Student Registration Existing Profile
        • Events - Student Registration New Profile
        • Events - Using the Check In Application
        • Events - Viewing an Event on the Online Calendar
        • Events- Creating and Scheduling an Event
        • Webinar - Document Management
        • Webinar - Email Deliverability
        • Webinar - Performance
    • Integration
      • Exports
        • Advanced Export
      • Imports
        • Bulk Imports
        • File Import Upload Utility
        • Import Data Wizard
        • Import Exceptions
        • Third Party Imports
        • Upload Import Files using Secure FTP
      • Web Services
        • 2013 Web Service
    • Navigation and Command Bar
      • Customizing the Workplace
      • Microsoft Office Outlook Client
        • Installing the Outlook Client
        • Outlook Client Troubleshooting
        • Using the Outlook Client
      • Searching for Records
    • Processes
      • Address Verification and Correction
      • Application Processing
      • Capitalization Rules
      • Creation and Completion of Opportunity Requirements
      • Direct and Tracked Email
      • End of Cycle
      • High Score Calculation
      • Letter Generation
      • Staff Assignments
      • Workflow
    • Product Updates
      • 2009 Product Updates
      • 2010 Product Updates
      • 2011 Product Updates
      • 2012 Product Updates
      • 2012 User Workshop
      • 2013 Product Updates
      • Enrollment Manager 2011 Upgrade FAQ
        • Enrollment Manager 2011: New Features and Functions
      • Spring 2012 Update FAQ
    • Queues
    • Quick Campaigns
    • Ruffalo Noel Levitz Dashboards, Reports and Exports
      • CIM Campaign Exports
      • RC – Campaign Comments
      • RNL Exports: Responders and Non Responders
      • TAG Student Data Export
    • Security
    • Standard Reports
    • Student Gateway
      • Student Gateway Style
    • Sunset FAQ for stand-alone EM Users
    • Telerecruiting
    • Travel Management
      • Travel Calendar
      • Travel Communication
      • Travel Events
      • Travel Reports
      • Trips
    • Troubleshooting
      • Browser and Software Compatibility
      • Browser Warnings
      • Document Management Actions
      • General Browser Issues
      • Outlook Client
      • Performance
      • Scheduled Workflow Troubleshooting
      • Workflow Troubleshooting
    • User Access and Management
      • Password Management
    • User Built Reports
    • Web Content
      • Landing Pages
      • Web Forms
        • Admission Response Form
        • Application Form
          • Web Application Lifecycle
        • Inquiry Form
      • Web Forms Manager
        • Application Data Fed to Enrollment Manager
        • Links to Web Forms
        • List View Columns
        • Web Forms Export
        • Web Forms Overview View
        • Web Forms Reports
        • Web Forms Search
    • Web Intelligence
      • Web Page Views
      • Web Pages
      • Web Sessions
  • Internal
    • 2015 Upgrade
      • 2015 Quick Reference Guide
      • 2015 Upgrade FAQs
      • Upgrade Webinars & Training Videos
    • Advanced Export Troubleshooting
    • Bulk Delete
    • Bulk Import to Leads
    • Case Resolution and Internal Processes
      • Basic Troubleshooting
      • Outreach Lists
        • Mail Merge
        • Reviewing Activity Postings
      • Updating Service Account Passwords
    • Client Questionnaires
    • Comcast Bounces
    • CRM 2011 Transition Status
      • Enrollment Manager Build Status
      • Enrollment Manager Performance Profile
      • Enrollment Manager Performance Tips
    • CRM Import Error Reporting
    • CRM Import Setup
    • CRM Workflow Training Videos
    • Custom Project Requests
    • Decommissioning a Client
    • Deployment
      • New Org Deployment Workflow
    • Document Management
    • Editing the Wiki
    • Event Management
      • _Event Management FAQs
      • _Getting Started
      • Creating an Event
        • Adding Requests to an Event
        • Adding Sessions to an Event
      • Event Calendar
        • Deploying the Event Calendar
        • Event Calendar Style
      • Event Categories
      • Event Check In at the Event
      • Event Definitions
      • Event Forms Styles
      • Event Locations
      • Event Messages
        • Editing Messages
        • Message Types
      • Event Registrations
        • Cancel, Deactivate or Delete a Registration
        • Editing a Registration
          • Manually add a Registrant to a Session
          • Manually add a Special Request to a Registration
        • Guest Registrations
        • Registration Fields
        • Staff Registering Students for Events
        • Web Registration
          • Student Profile
          • Student Profile Login and Password
      • Event Reports
      • Event Sessions
        • Event Session Times
        • Event Session Types
        • Registrant Sessions
      • Event Status: Active and Inactive Events
      • Event Types
      • Events: Bugs and Enhancement Requests
      • Hosts
      • Modifying an Event
      • Recurring Events
      • Special Requests
        • Managing Registrant Special Requests
        • Registrant Special Requests
        • Special Request Types
      • Training Webinars
      • Waitlisting
    • Event Registration Manager
      • Event Administrator
        • Configure Calendar Style
        • Configure Department Header
        • Configure Form Styles
        • Data Export
        • Data Import
        • Deploying Enrollment Manager Events
        • Event Locations
        • Event Messages
          • Editing Event Messages
          • Event E-mail Messages
          • Message Types
          • Unassigned Messages
        • Managing Events with Multiple Departments
      • Event Reports
        • Event Daily Roster
        • Event Details Report
        • Event Roster Report
        • Itinerary Report
        • Registration Card Report
      • Manage Events
        • Default Events
        • Event Capacity Handling
        • Event Tab 1: New Event
        • Event Tab 2: Event Scheduler
        • Event Tab 3: Customization
        • Event Tab 4: Registration Fields
        • Event Tab 5: Follow Up: Capacity, Guests, Messages and URL
        • Make an Event Inactive
        • Online Event Registration Check-In
        • Planning an Event
        • Public, Featured, and Active Events
        • Recurring Events
        • Requests
        • Restore an Inactive Event to Active
        • Search, Edit and View Events
        • Sessions
      • Manage Registrations
        • Cancel, Inactivate or Delete a Registration
        • Confirm a Registration
        • Create a New Registration
        • Edit a Registration
        • Manual Registration Tab 1: Contact Info
        • Manual Registration Tab 2: Other Info
        • Manual Registration Tab 3: Requests
        • Manual Registration Tab 4: Sessions
        • Manual Registration Tab 5: Guests
        • Restore an Inactive Registration to Active
        • Search and View Registrations
      • Training Exercises
    • Events
      • Events: Bugs and Enhancements Archive
    • Extraction process to the warehouse
      • Advanced Export Tables
      • Org_Warehouse table definitions
        • Export base table: Xport
        • Export Secondary: vw Export Scores
        • Extract table: XEntryTerm
        • Extract table: XStaging
        • Metadata table: Versions
        • Warehouse base tables: OpportunityPerson
        • Warehouse table: Activities
        • Warehouse table: Addresses
        • Warehouse table: Awards
        • Warehouse table: FinAidProfile
        • Warehouse table: Ids
        • Warehouse Table: Interests
        • Warehouse table: Notes
        • Warehouse table: OpportunityRequirements
        • Warehouse table: PersonOrgs
        • Warehouse table: Races
        • Warehouse table: Relationships
        • Warehouse table: Scores
        • Warehouse table: StaffAssignment
        • Warehouse table: StatusChange
      • Per-client customizations
        • Brenau: Custom Royall Export
        • Lipscomb: midday bridge
        • Loyola: custom Royall export
        • Loyola: nonstandard export
        • OWU: custom modeling
        • Ozarks: custom export
        • Puget Sound: Custom Export
        • Puget Sound: custom modeling
        • Puget Sound: nonstandard extract
        • Susquehanna: custom export
      • Technical specifications
        • Current: 5.x jobs
        • Standard Export packages
        • zzArchive: Old extract processes
          • Outdated: 3.1 jobs
          • Outdated: Stage I jobs
          • Outdated: Stage II jobs
          • Outdated: Stage IIa jobs
          • Outdated: Transfer from old extraction process to Stage I
          • Previous: Stage III jobs
      • Troubleshooting Analytics
      • Troubleshooting the extract process
    • Files
    • High CPU/Slowness due to Outreach Lists
    • IS Import Folder Job
    • Managing Leads
      • Step 1: Import your Data List
      • Step 2: Add records to an Outreach List by source
      • Step 3: Create Email Content and Send
    • Mobile Express
      • Mobile Analytics
      • Mobile Express Data
    • Mobile Express Setup
    • Predictive Modeling
    • Product Roadmap
    • RC Roles for Internal Teams
    • Relationships (Opportunities)
    • Resetting Oracle Passwords
    • Scribe Overiew
    • SearchTrack
    • Set up: Enable or disable a user account
    • Set up: Event Registration Manager
    • Set up: High Score Calculation
    • Set Up: SharePoint Document Connection
    • SMS Messaging
    • SQL Scripts for common tasks
      • Delete Duplicate Tasks
      • Duplicate opportunity merging en masse
      • No Matching Subrecord
      • Remove Ineligible First Activity values from Opportunities
      • Set First Activity for Opportunities Where Null
      • Staff Assignment Trigger
      • Staff Assignments - Reset with Term Change
    • System Status Archive
    • Test Accounts in Client Environments
    • To-Dos
    • User Group Meeting 2014
    • Web Forms Manager Permissions in Enrollment Manager
    • Webinars Summer 2014
  • System Status
    • Security Updates
    • Status Archive
  • Sitemap

Can't find an answer?

If you have any difficulty finding the answer to your question, please send a quick note to emsupport@ruffalocody.com and let us know. We're constantly updating content and want to make sure you can find answers quickly.

Recent site activity

  • System Status
    edited by Susan Silverman
  • FAQ
    edited by Tina Bishop
  • System Status
    edited by Tina Bishop
  • 2016-17 Click Dimensions Email Transition Information
    edited by Tina Bishop
  • FAQ
    edited by Tina Bishop
  • View All
Internal‎ > ‎

SQL Scripts for common tasks

Subpage Listing

  • Delete Duplicate Tasks
  • Duplicate opportunity merging en masse
  • No Matching Subrecord
  • Remove Ineligible First Activity values from Opportunities
  • Set First Activity for Opportunities Where Null
  • Staff Assignment Trigger
  • Staff Assignments - Reset with Term Change

Subpages (7): Delete Duplicate Tasks Duplicate opportunity merging en masse No Matching Subrecord Remove Ineligible First Activity values from Opportunities Set First Activity for Opportunities Where Null Staff Assignments - Reset with Term Change Staff Assignment Trigger
Comments

Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites