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: QRM.QRM_ANALYSIS_SETTINGS

Object Details

Object Name:	QRM_ANALYSIS_SETTINGS
Object Type:	TABLE
Owner:	QRM
FND Design Data:	QRM.QRM_ANALYSIS_SETTINGS
Subobject Name:
Status:	VALID

QRM_ANALYSIS_SETTINGS contains the setup data for analyses. Each row corresponds to a single analysis and its state, which is either "current" or "saved." Risk analysis displays results based on the saved rows but bases its calculations on the current rows. This table stores all analysis settings information except those that are tied to deal attributes. Such analysis attributes information is stored in QRM_ANALYSIS_ATTS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QRM_ANALYSIS_SETTINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ANALYSIS_NAME HISTORY_FLAG ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ANALYSIS_NAME	VARCHAR2	(20)	Yes	Name of the analysis.
HISTORY_FLAG	VARCHAR2	(1)	Yes	Indicates if the state of the analysis settings is current 'C' or saved 'S'.
ANALYSIS_TYPE	VARCHAR2	(1)	Yes	Type of analysis: Gap, Maturity, Position.
STYLE	VARCHAR2	(1)	Yes	Style of the analysis: Table 'T', Aggregated Table 'A', Crosstab 'C', Crosstab with Time Buckets 'X'
DATE_TYPE	VARCHAR2	(1)	Yes	Indicates if date is relative or fixed.
CURRENCY_SOURCE	VARCHAR2	(1)	Yes	Indicates where the results' currency comes from: Deal Currency 'D', Set of Books Currency 'B', Reporting Currency 'R'
UNITS	NUMBER		Yes	Number of units displayed in analysis results.
STATUS	VARCHAR2	(1)	Yes	Indicates current status of analysis results: Completed Successfully '0', Completed with warnings '1', Error '2', In progress '3', Never run '4', No results '5'
DIRTY	VARCHAR2	(1)	Yes	Indicates level of changes to settings since the last analysis was run: Not dirty 'N', Small changes 'S', Currency Changes 'C', Major Changes 'D'
BUSINESS_WEEK	VARCHAR2	(1)	Yes	Indicates what type of calendar week is being used when creating the time buckets structure.
DESCRIPTION	VARCHAR2	(50)		Description of the analysis.
FILTER_NAME	VARCHAR2	(20)		Filter for the analysis. Corresponds to the FILTER_NAME column in QRM_FILTERS.
MD_SET_CODE	VARCHAR2	(20)		Code corresponds to the market data set used in analysis. Corresponds to the SET_CODE column in XTR_RM_MD_SETS.
THRESHOLD_NUM	NUMBER			Number of units for the recalculation threshold.
THRESHOLD_TYPE	VARCHAR2	(20)		Unit type for the recalculation threshold: Days 'D', Hours 'H', Minutes 'M'
TB_LABEL	VARCHAR2	(1)		Indicates the type of label displayed when analysis results contain time buckets: Display Date 'D', User specified Label 'L'
TB_NAME	VARCHAR2	(20)		Name of the set of time buckets used in a Crosstab with Time Buckets style analysis. Corresponds to TB_NAME column in QRM_TIME_BUCKETS.
START_DATE	DATE			Fixed start date.
END_DATE	DATE			Fixed end date.
START_DATE_REF	VARCHAR2	(20)		Reference point for relative start date: Beginning of week 'BW', Beginning of month 'BM', Beginning of year 'BY', End of week 'EW', End of month 'EM', End of year 'EY', System Date 'S'
END_DATE_REF	VARCHAR2	(20)		Reference point for relative end date:Beginning of week 'BW', Beginning of month 'BM', Beginning of year 'BY', End of week 'EW', End of month 'EM', End of year 'EY', System Date 'S'
START_DATE_OFFSET	NUMBER			Unit offset for relative start date.
END_DATE_OFFSET	NUMBER			Unit offset for relative end date.
START_OFFSET_TYPE	VARCHAR2	(20)		Offset type for relative start date: Day(s) 'D', Week(s) 'W', Month(s) 'M', Year(s) 'Y'
END_OFFSET_TYPE	VARCHAR2	(20)		Offset type for relative end date:Day(s) 'D', Week(s) 'W', Month(s) 'M', Year(s) 'Y'
SHOW_TOTALS	VARCHAR2	(1)		Indicates whether to show totals (Y) or not (N) for Table style analysis.
CURR_REPORTING	VARCHAR2	(15)		Reporting currency input by user. Corresponds to XTR_MASTER_CURRENCIES.CURRENCY
CURRENCY_USED	VARCHAR2	(1)		Currency used in results. Corresponds to XTR_MASTER_CURRENCIES.CURRENCY
DEC_PLACES	NUMBER			Number of decimal places displayed in analysis results.
PROCESS_ID	NUMBER			Process ID of most recent time analysis was run. (concurrent ID)
LAST_RUN_DATE	DATE			Date of most recent time analysis was run.
GL_CALENDAR_ID	NUMBER	(15)		ID of calendar selected. Corresponds to L_TRANSACTION_CALENDAR.TRANSACTION_CALENDAR_ID
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ANALYSIS_NAME
,      HISTORY_FLAG
,      ANALYSIS_TYPE
,      STYLE
,      DATE_TYPE
,      CURRENCY_SOURCE
,      UNITS
,      STATUS
,      DIRTY
,      BUSINESS_WEEK
,      DESCRIPTION
,      FILTER_NAME
,      MD_SET_CODE
,      THRESHOLD_NUM
,      THRESHOLD_TYPE
,      TB_LABEL
,      TB_NAME
,      START_DATE
,      END_DATE
,      START_DATE_REF
,      END_DATE_REF
,      START_DATE_OFFSET
,      END_DATE_OFFSET
,      START_OFFSET_TYPE
,      END_OFFSET_TYPE
,      SHOW_TOTALS
,      CURR_REPORTING
,      CURRENCY_USED
,      DEC_PLACES
,      PROCESS_ID
,      LAST_RUN_DATE
,      GL_CALENDAR_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM QRM.QRM_ANALYSIS_SETTINGS;

Dependencies

[top of page]

QRM.QRM_ANALYSIS_SETTINGS does not reference any database object

QRM.QRM_ANALYSIS_SETTINGS is referenced by following:

QRM: QRM_ANALYSIS_SETTINGS#