eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.EDW_BIM_EVNT_EVENTS_LTC#

Source

View Text - Preformatted


select EVENT_PK EVENT_PK, EVENT_PK_KEY EVENT_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, EVENT_DP EVENT_DP, NAME NAME, EVENT_HEADER_ID EVENT_HEADER_ID, PARENT_EVENT_HEADER_ID PARENT_EVENT_HEADER_ID, EVENT_LEVEL EVENT_LEVEL, EVENT_TYPE_CODE EVENT_TYPE_CODE, USER_STATUS_ID USER_STATUS_ID, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, LAST_STATUS_DATE LAST_STATUS_DATE, REG_REQUIRED_FLAG REG_REQUIRED_FLAG, REG_INVITED_ONLY_FLAG REG_INVITED_ONLY_FLAG, REG_CHARGE_FLAG REG_CHARGE_FLAG, EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG, REG_MINIMUM_CAPACITY REG_MINIMUM_CAPACITY, REG_MAXIMUM_CAPACITY REG_MAXIMUM_CAPACITY, SOURCE_CODE SOURCE_CODE, DURATION DURATION, DURATION_UOM_CODE DURATION_UOM_CODE, DAY_OF_EVENT DAY_OF_EVENT, COORDINATOR_ID COORDINATOR_ID, OWNER_USER_ID OWNER_USER_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORG_ID ORG_ID, CERT_CREDIT_TYPE_CODE CERT_CREDIT_TYPE_CODE, CERTIFICATION_CREDITS CERTIFICATION_CREDITS, STREAM_TYPE_CODE STREAM_TYPE_CODE, PARTNER_FLAG PARTNER_FLAG, OVERFLOW_FLAG OVERFLOW_FLAG, MAIN_LANGUAGE_CODE MAIN_LANGUAGE_CODE, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE, PRIORITY_TYPE_CODE PRIORITY_TYPE_CODE, AGENDA_START_TIME AGENDA_START_TIME, AGENDA_END_TIME AGENDA_END_TIME, ACTIVE_FROM_DATE ACTIVE_FROM_DATE, ACTIVE_TO_DATE ACTIVE_TO_DATE, INBOUND_SCRIPT_NAME INBOUND_SCRIPT_NAME, EMAIL EMAIL, PHONE PHONE, URL URL, EVENT_MKTG_MESSAGE EVENT_MKTG_MESSAGE, EVENT_HEADER_NAME EVENT_HEADER_NAME, DESCRIPTION DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, SECURITY_GROUP_ID SECURITY_GROUP_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "BIM"."EDW_BIM_EVNT_EVENTS_LTC"

View Text - HTML Formatted

SELECT EVENT_PK EVENT_PK
, EVENT_PK_KEY EVENT_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, EVENT_DP EVENT_DP
, NAME NAME
, EVENT_HEADER_ID EVENT_HEADER_ID
, PARENT_EVENT_HEADER_ID PARENT_EVENT_HEADER_ID
, EVENT_LEVEL EVENT_LEVEL
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, USER_STATUS_ID USER_STATUS_ID
, SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, LAST_STATUS_DATE LAST_STATUS_DATE
, REG_REQUIRED_FLAG REG_REQUIRED_FLAG
, REG_INVITED_ONLY_FLAG REG_INVITED_ONLY_FLAG
, REG_CHARGE_FLAG REG_CHARGE_FLAG
, EVENT_STANDALONE_FLAG EVENT_STANDALONE_FLAG
, REG_MINIMUM_CAPACITY REG_MINIMUM_CAPACITY
, REG_MAXIMUM_CAPACITY REG_MAXIMUM_CAPACITY
, SOURCE_CODE SOURCE_CODE
, DURATION DURATION
, DURATION_UOM_CODE DURATION_UOM_CODE
, DAY_OF_EVENT DAY_OF_EVENT
, COORDINATOR_ID COORDINATOR_ID
, OWNER_USER_ID OWNER_USER_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORG_ID ORG_ID
, CERT_CREDIT_TYPE_CODE CERT_CREDIT_TYPE_CODE
, CERTIFICATION_CREDITS CERTIFICATION_CREDITS
, STREAM_TYPE_CODE STREAM_TYPE_CODE
, PARTNER_FLAG PARTNER_FLAG
, OVERFLOW_FLAG OVERFLOW_FLAG
, MAIN_LANGUAGE_CODE MAIN_LANGUAGE_CODE
, CANCELLATION_REASON_CODE CANCELLATION_REASON_CODE
, PRIORITY_TYPE_CODE PRIORITY_TYPE_CODE
, AGENDA_START_TIME AGENDA_START_TIME
, AGENDA_END_TIME AGENDA_END_TIME
, ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, ACTIVE_TO_DATE ACTIVE_TO_DATE
, INBOUND_SCRIPT_NAME INBOUND_SCRIPT_NAME
, EMAIL EMAIL
, PHONE PHONE
, URL URL
, EVENT_MKTG_MESSAGE EVENT_MKTG_MESSAGE
, EVENT_HEADER_NAME EVENT_HEADER_NAME
, DESCRIPTION DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "BIM"."EDW_BIM_EVNT_EVENTS_LTC"