Bookshelf v8.0: Reviewing and Modifying Lists of Values (LOVs)

Before you enter information about an event, you may want to review the existing LOVs to determine whether the values meet the needs of your company and then add or modify LOVs to adapt them to your business processes.

NOTE: Certain registration status values, such as Confirmed, Pending, and Waitlisted, are used by the application to update event seat counts. Developers should excercise caution when changing the EVENT_REG_STATUS LOV values, and test the application to make sure that it works as expected after any changes.

Siebel Events Management screens contain fields that display available values from LOVs such as those listed in Table 2 and Table 3.

Table 2. List of Values (LOVs)
List of Values	Comments
EVENT_BILLING_BASIS	Indicates whether a venue or vendor rate is calculated hourly, daily, weekly, monthly, or on a per-item or per-person basis.
EVENT_COMMITMENT_TYPE	Displays a selection of contribution types a partner organization can make for an event, such as monetary, promotional, material, and so on.
EVT_FREQUENCY	Frequency with which the events occur within an event plan. For example, daily, monthly, or quarterly.
EVENT_FEE_TYPE	Indicates if a fee is required for the event. Values available by default include Registration, Voluntary, Donation, and None.
EVENT_FORMAT	Displays the format of the session featured, such as Keynote, Roundtable, Workshop, and so on.
EVENT_COMMITMENT_TYPE	Displays a selection of sponsorship commitment types, such as promotion or resources.
EVENT_ORG_TYPE	Displays a selection of vendor or partner for an organization type.
EVENT_PARTNER_ROLE	Identifies the role of a partner organization in an event, such as Exhibitor, Sponsor, Contributor, and so on.
EVENT_PARTNER_STATUS	Indicates the status of arrangements with a partner organization, such as Requested, Shipped, Fulfilled, and so on.
EVENT_REG_STATUS	Displays the registration status of a potential attendee, speaker, or staff member for an event or an individual session.
EVENT_REVENUE_TYPE	Displays a selection of revenue sources related to an event, such as Partners, Sponsors, Advertisers, and so on.
EVENT_ROOM_TYPE	Displays a selection of room types available at event venues, such as conference rooms, classrooms, auditoriums, and so on.
EVENT_STAFF_ROLE	Displays a selection of staff member roles or areas of responsibility, such as Set-Up, Moderator, Clean-Up, and so on.
EVENT_STATUS	Displays the registration status, such as in Planning, Launched, Scheduled, and so on.
EVENT_STATUS_CODE	Displays the status of an event or session, such as Planned, In Progress, Completed, and so on.
EVENT_TYPE	Displays the type of parent event plan or event featured, such as Seminar, Deal Roadshow, Non-Deal Roadshow, and so on.
EVENT_VENDOR_ROLE	Displays a selection of vendor roles or areas of responsibility, such as Caterer, Audio/Video, Security, and so on.
EVENT_VENUE_ROLE	Displays a selection of venues, such as Convention Center, Hotel, Office, and so on.
MKTG_PLAN_APPR_TYPE	Displays a list of approval status values, such as Rejected, Approved, and Submitted.
OFFER_MATERIAL_TYPE	Displays a selection of collateral and literature types, such as Brochure, Map, Hand-out, and so on. This LOV is used in other areas of your Siebel application.
PARTICIPANT_STATUS	Displays a selection of participant status types such as VIP and Guest.
SRC_ITEM_CATEGORY	Displays a list of expense categories, such as Creative, Furnishing, Vendors, Materials, and Venues.
SESSION_LOCATION_TYPE	Displays a list of session location types, such as Station or Table.
TRAVEL_TYPE_CODE	Displays a selection of travel types such as Air, Ground, and Hotel.

Table 3. Financial Services Customer-Specific List of Values (LOVs)
List of Values	Comments
EVENT_COM_REG_STATUS	Displays the registration status of an account for an event or an individual session. Values include Pending, Confirmed, Waitlisted, Restricted Invite, Invited, Cancelled, and so on.
EVENT_RECUR_FREQ_TYPE	Indicates the frequency of the auto-generated event of an event plan, such as Daily, Weekly, Quarterly, and so on.
EVENT_VENDOR_FUNCTION	Defines the service the vendor is providing. Values include Ads, Music, Lunch, Breakfast, Booths, Limo, Lodging, Publications, Sound, Table Set-up, Video, and so on.
EVT_PARTICIPANT_TYPE	Displays values for participant type, such as Analyst, Internal Participant, Competitor, and so on.
EVT_SIGNUP_STATUS	Displays the event registration status values, such as Open or Closed.
FINS_EVENTS_PROD_CAP_SIZE	Displays values for the market capitalization size to describe the featured financial product, such as Large Cap, Mid Cap, Small Cap, or Micro Cap.

NOTE: You use the S_REGION table to define the regions associated with the featured financial product, such as Asia, North America, Europe, and so on.