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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BIM.BIM_R_RRSN_DAILY_FACTS

Object Details

Object Name:	BIM_R_RRSN_DAILY_FACTS
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Stores invalid response reasons information daily

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_RRSN_DAILY_FACTS_N2	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESPONSE_REGION RESPONSE_COUNTRY OBJECT_ID OBJECT_TYPE WEEKEND_DATE
BIM_R_RRSN_DAILY_FACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_CREATE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
REASON_DAILY_TRANSACTION_ID	NUMBER		Yes	Unique Identifier
CREATION_DATE	DATE			Who column
LAST_UPDATE_DATE	DATE			Who column
CREATED_BY	NUMBER			Who column
LAST_UPDATED_BY	NUMBER			Who column
LAST_UPDATE_LOGIN	NUMBER			Who column
OBJECT_ID	NUMBER			object identifier
OBJECT_STATUS	VARCHAR2	(30)		object status
OBJECT_TYPE	VARCHAR2	(30)		object type
SOURCE_CODE	VARCHAR2	(30)		source code
SOURCE_CODE_ID	NUMBER			source code identifier
RESPONSE_COUNTRY	VARCHAR2	(30)		country where the response is from
RESPONSE_REGION	VARCHAR2	(30)		region where the response is from
BUSINESS_UNIT_ID	NUMBER			business unit id of object
INVALID_REASON	VARCHAR2	(30)		invalid reason
INVALID_RESPONSES	NUMBER			number of invalid responses
SURVEY_COMPLETED	NUMBER			number of survey completed
LANDING_PAD_HITS	NUMBER			number of landing pad hits
YEAR	VARCHAR2	(30)		Year
QTR	VARCHAR2	(30)		Quarter
MONTH	VARCHAR2	(30)		Month
TRANSACTION_CREATE_DATE	DATE			record created date
WEEKEND_DATE	DATE			weekend date of transaction_create_date
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
METRIC1	NUMBER			Future Usage
METRIC2	NUMBER			Future Usage
METRIC3	NUMBER			Future Usage
METRIC4	NUMBER			Future Usage
METRIC5	NUMBER			Future Usage
METRIC6	NUMBER			Future Usage
METRIC7	NUMBER			Future Usage
METRIC8	NUMBER			Future Usage
METRIC9	NUMBER			Future Usage
METRIC10	NUMBER			Future Usage
METRIC11	NUMBER			Future Usage
METRIC12	NUMBER			Future Usage
METRIC13	NUMBER			Future Usage
METRIC14	NUMBER			Future Usage
METRIC15	NUMBER			Future Usage

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REASON_DAILY_TRANSACTION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      OBJECT_STATUS
,      OBJECT_TYPE
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      RESPONSE_COUNTRY
,      RESPONSE_REGION
,      BUSINESS_UNIT_ID
,      INVALID_REASON
,      INVALID_RESPONSES
,      SURVEY_COMPLETED
,      LANDING_PAD_HITS
,      YEAR
,      QTR
,      MONTH
,      TRANSACTION_CREATE_DATE
,      WEEKEND_DATE
,      SECURITY_GROUP_ID
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
FROM BIM.BIM_R_RRSN_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_RRSN_DAILY_FACTS does not reference any database object

BIM.BIM_R_RRSN_DAILY_FACTS is referenced by following:

APPS: BIM_R_RRSN_DAILY_FACTS