VIEW: AMS.AMS_EVENT_REGISTRATIONS#

Source

View Text - Preformatted

select EVENT_REGISTRATION_ID EVENT_REGISTRATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, APPLICATION_ID APPLICATION_ID, OWNER_USER_ID OWNER_USER_ID, CONFIRMATION_CODE CONFIRMATION_CODE, EVENT_OFFER_ID EVENT_OFFER_ID, ACTIVE_FLAG ACTIVE_FLAG, DATE_REGISTRATION_PLACED DATE_REGISTRATION_PLACED, USER_STATUS_ID USER_STATUS_ID, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, LAST_REG_STATUS_DATE LAST_REG_STATUS_DATE, REG_SOURCE_TYPE_CODE REG_SOURCE_TYPE_CODE, REGISTRATION_SOURCE_ID REGISTRATION_SOURCE_ID, SOURCE_CODE SOURCE_CODE, REGISTRATION_GROUP_ID REGISTRATION_GROUP_ID, REGISTRANT_PARTY_ID REGISTRANT_PARTY_ID, REGISTRANT_ACCOUNT_ID REGISTRANT_ACCOUNT_ID, REGISTRANT_CONTACT_ID REGISTRANT_CONTACT_ID, ATTENDANT_PARTY_ID ATTENDANT_PARTY_ID, ATTENDANT_ACCOUNT_ID ATTENDANT_ACCOUNT_ID, ATTENDANT_CONTACT_ID ATTENDANT_CONTACT_ID, ORIGINAL_REGISTRANT_CONTACT_ID ORIGINAL_REGISTRANT_CONTACT_ID, PROSPECT_FLAG PROSPECT_FLAG, ATTENDED_FLAG ATTENDED_FLAG, CONFIRMED_FLAG CONFIRMED_FLAG, EVALUATED_FLAG EVALUATED_FLAG, ATTENDANCE_RESULT_CODE ATTENDANCE_RESULT_CODE, WAITLISTED_PRIORITY WAITLISTED_PRIORITY, TARGET_LIST_ID TARGET_LIST_ID, INBOUND_MEDIA_ID INBOUND_MEDIA_ID, INBOUND_CHANNEL_ID INBOUND_CHANNEL_ID, CANCELLATION_CODE CANCELLATION_CODE, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE, ATTENDANCE_FAILURE_REASON ATTENDANCE_FAILURE_REASON, ATTENDANT_LANGUAGE ATTENDANT_LANGUAGE, SALESREP_ID SALESREP_ID, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, DESCRIPTION DESCRIPTION, MAX_ATTENDEE_OVERRIDE_FLAG MAX_ATTENDEE_OVERRIDE_FLAG, INVITE_ONLY_OVERRIDE_FLAG INVITE_ONLY_OVERRIDE_FLAG, PAYMENT_STATUS_CODE PAYMENT_STATUS_CODE, AUTO_REGISTER_FLAG AUTO_REGISTER_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ATTENDEE_ROLE_TYPE ATTENDEE_ROLE_TYPE, NOTIFICATION_TYPE NOTIFICATION_TYPE, LAST_NOTIFIED_TIME LAST_NOTIFIED_TIME, EVENT_JOIN_TIME EVENT_JOIN_TIME, EVENT_EXIT_TIME EVENT_EXIT_TIME, MEETING_ENCRYPTION_KEY_CODE MEETING_ENCRYPTION_KEY_CODE from "AMS"."AMS_EVENT_REGISTRATIONS"

View Text - HTML Formatted

SELECT EVENT_REGISTRATION_ID EVENT_REGISTRATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, APPLICATION_ID APPLICATION_ID
, OWNER_USER_ID OWNER_USER_ID
, CONFIRMATION_CODE CONFIRMATION_CODE
, EVENT_OFFER_ID EVENT_OFFER_ID
, ACTIVE_FLAG ACTIVE_FLAG
, DATE_REGISTRATION_PLACED DATE_REGISTRATION_PLACED
, USER_STATUS_ID USER_STATUS_ID
, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, LAST_REG_STATUS_DATE LAST_REG_STATUS_DATE
, REG_SOURCE_TYPE_CODE REG_SOURCE_TYPE_CODE
, REGISTRATION_SOURCE_ID REGISTRATION_SOURCE_ID
, SOURCE_CODE SOURCE_CODE
, REGISTRATION_GROUP_ID REGISTRATION_GROUP_ID
, REGISTRANT_PARTY_ID REGISTRANT_PARTY_ID
, REGISTRANT_ACCOUNT_ID REGISTRANT_ACCOUNT_ID
, REGISTRANT_CONTACT_ID REGISTRANT_CONTACT_ID
, ATTENDANT_PARTY_ID ATTENDANT_PARTY_ID
, ATTENDANT_ACCOUNT_ID ATTENDANT_ACCOUNT_ID
, ATTENDANT_CONTACT_ID ATTENDANT_CONTACT_ID
, ORIGINAL_REGISTRANT_CONTACT_ID ORIGINAL_REGISTRANT_CONTACT_ID
, PROSPECT_FLAG PROSPECT_FLAG
, ATTENDED_FLAG ATTENDED_FLAG
, CONFIRMED_FLAG CONFIRMED_FLAG
, EVALUATED_FLAG EVALUATED_FLAG
, ATTENDANCE_RESULT_CODE ATTENDANCE_RESULT_CODE
, WAITLISTED_PRIORITY WAITLISTED_PRIORITY
, TARGET_LIST_ID TARGET_LIST_ID
, INBOUND_MEDIA_ID INBOUND_MEDIA_ID
, INBOUND_CHANNEL_ID INBOUND_CHANNEL_ID
, CANCELLATION_CODE CANCELLATION_CODE
, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE
, ATTENDANCE_FAILURE_REASON ATTENDANCE_FAILURE_REASON
, ATTENDANT_LANGUAGE ATTENDANT_LANGUAGE
, SALESREP_ID SALESREP_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, DESCRIPTION DESCRIPTION
, MAX_ATTENDEE_OVERRIDE_FLAG MAX_ATTENDEE_OVERRIDE_FLAG
, INVITE_ONLY_OVERRIDE_FLAG INVITE_ONLY_OVERRIDE_FLAG
, PAYMENT_STATUS_CODE PAYMENT_STATUS_CODE
, AUTO_REGISTER_FLAG AUTO_REGISTER_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ATTENDEE_ROLE_TYPE ATTENDEE_ROLE_TYPE
, NOTIFICATION_TYPE NOTIFICATION_TYPE
, LAST_NOTIFIED_TIME LAST_NOTIFIED_TIME
, EVENT_JOIN_TIME EVENT_JOIN_TIME
, EVENT_EXIT_TIME EVENT_EXIT_TIME
, MEETING_ENCRYPTION_KEY_CODE MEETING_ENCRYPTION_KEY_CODE
FROM "AMS"."AMS_EVENT_REGISTRATIONS"