[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_EVNT_EVENTS_LTC# |
---|---|
Object Type: | VIEW |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_PK | VARCHAR2 | (320) | ||
EVENT_PK_KEY | NUMBER | |||
ALL_FK | VARCHAR2 | (40) | ||
ALL_FK_KEY | NUMBER | |||
EVENT_DP | VARCHAR2 | (240) | ||
NAME | VARCHAR2 | (320) | ||
EVENT_HEADER_ID | NUMBER | |||
PARENT_EVENT_HEADER_ID | NUMBER | |||
EVENT_LEVEL | VARCHAR2 | (40) | ||
EVENT_TYPE_CODE | VARCHAR2 | (40) | ||
USER_STATUS_ID | NUMBER | |||
SYSTEM_STATUS_CODE | VARCHAR2 | (40) | ||
LAST_STATUS_DATE | DATE | |||
REG_REQUIRED_FLAG | VARCHAR2 | (20) | ||
REG_INVITED_ONLY_FLAG | VARCHAR2 | (20) | ||
REG_CHARGE_FLAG | VARCHAR2 | (20) | ||
EVENT_STANDALONE_FLAG | VARCHAR2 | (20) | ||
REG_MINIMUM_CAPACITY | NUMBER | |||
REG_MAXIMUM_CAPACITY | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (40) | ||
DURATION | NUMBER | |||
DURATION_UOM_CODE | VARCHAR2 | (20) | ||
DAY_OF_EVENT | VARCHAR2 | (40) | ||
COORDINATOR_ID | NUMBER | |||
OWNER_USER_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORG_ID | NUMBER | |||
CERT_CREDIT_TYPE_CODE | VARCHAR2 | (40) | ||
CERTIFICATION_CREDITS | NUMBER | |||
STREAM_TYPE_CODE | VARCHAR2 | (40) | ||
PARTNER_FLAG | VARCHAR2 | (20) | ||
OVERFLOW_FLAG | VARCHAR2 | (20) | ||
MAIN_LANGUAGE_CODE | VARCHAR2 | (20) | ||
CANCELLATION_REASON_CODE | VARCHAR2 | (320) | ||
PRIORITY_TYPE_CODE | VARCHAR2 | (320) | ||
AGENDA_START_TIME | DATE | |||
AGENDA_END_TIME | DATE | |||
ACTIVE_FROM_DATE | DATE | |||
ACTIVE_TO_DATE | DATE | |||
INBOUND_SCRIPT_NAME | VARCHAR2 | (320) | ||
VARCHAR2 | (320) | |||
PHONE | VARCHAR2 | (320) | ||
URL | VARCHAR2 | (4000) | ||
EVENT_MKTG_MESSAGE | VARCHAR2 | (4000) | ||
EVENT_HEADER_NAME | VARCHAR2 | (320) | ||
DESCRIPTION | VARCHAR2 | (4000) | ||
INSTANCE | VARCHAR2 | (40) | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
SECURITY_GROUP_ID | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_PK
, EVENT_PK_KEY
, ALL_FK
, ALL_FK_KEY
, EVENT_DP
, NAME
, EVENT_HEADER_ID
, PARENT_EVENT_HEADER_ID
, EVENT_LEVEL
, EVENT_TYPE_CODE
, USER_STATUS_ID
, SYSTEM_STATUS_CODE
, LAST_STATUS_DATE
, REG_REQUIRED_FLAG
, REG_INVITED_ONLY_FLAG
, REG_CHARGE_FLAG
, EVENT_STANDALONE_FLAG
, REG_MINIMUM_CAPACITY
, REG_MAXIMUM_CAPACITY
, SOURCE_CODE
, DURATION
, DURATION_UOM_CODE
, DAY_OF_EVENT
, COORDINATOR_ID
, OWNER_USER_ID
, INVENTORY_ITEM_ID
, ORG_ID
, CERT_CREDIT_TYPE_CODE
, CERTIFICATION_CREDITS
, STREAM_TYPE_CODE
, PARTNER_FLAG
, OVERFLOW_FLAG
, MAIN_LANGUAGE_CODE
, CANCELLATION_REASON_CODE
, PRIORITY_TYPE_CODE
, AGENDA_START_TIME
, AGENDA_END_TIME
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, INBOUND_SCRIPT_NAME
, EMAIL
, PHONE
, URL
, EVENT_MKTG_MESSAGE
, EVENT_HEADER_NAME
, DESCRIPTION
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, SECURITY_GROUP_ID
, CREATION_DATE
, LAST_UPDATE_DATE
FROM BIM.EDW_BIM_EVNT_EVENTS_LTC#;
|
|
|