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: XNP.XNP_SV_AUDITS

Object Details

Object Name:	XNP_SV_AUDITS
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_SV_AUDITS
Subobject Name:
Status:	VALID

XNP_SV_AUDITS stores all the subscription audits issued from a service provider . When no target service provider is specified, all service provider's data will be audited.
In places where the product is installed as NP SMS or NP SOA for a service provider, this table has entries for the audits that were issued by that service provider.
In case of a service bureau, the entity holds all the audits that were issued by the member service providers.
An NRC installation holds all subscription audits from all service providers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_SV_AUDITS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SV_AUDIT_ID
XNP_SV_AUDITS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_REFERENCE
XNP_SV_AUDITS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	SP_ID STARTING_NUMBER
XNP_SV_AUDITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FOR_SP_ID
XNP_SV_AUDITS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUDIT_TYPE
XNP_SV_AUDITS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SV_AUDIT_ID	NUMBER		Yes	Audit identifier
OBJECT_REFERENCE	VARCHAR2	(80)	Yes	External Reference ID for an audit
SP_ID	NUMBER		Yes	Service provider identifier requesting the audit
AUDIT_NAME	VARCHAR2	(40)	Yes	Name of the audit
AUDIT_TYPE	VARCHAR2	(10)	Yes	Type of audit
STATUS_CODE	VARCHAR2	(10)	Yes	Current status of the audit
STARTING_NUMBER	VARCHAR2	(20)	Yes	Starting telephone number of a TN range
ENDING_NUMBER	VARCHAR2	(20)		Optional number indicating the ending telephone number of a telphone number range
FOR_SP_ID	NUMBER			Service provider identifier to be audited
NUMBER_OF_TN_AUDITED	NUMBER			Gives the number of TNs successfully audited
ACTIVATION_START_DATE	DATE			Activation start date
ACTIVATION_END_DATE	DATE			Activation end date
NOTES	VARCHAR2	(1996)		Notes for the audit
ROUTING_NUMBER_FLAG	VARCHAR2	(1)		Flag to indicate if Routing Number data should be audited
CNAM_FLAG	VARCHAR2	(1)		Flag to indicate if CNAM data should be audited
ISVM_FLAG	VARCHAR2	(1)		Flag to indicate if ISVM data should be audited
LIDB_FLAG	VARCHAR2	(1)		Flag to indicate if LIDB data should be audited
CLASS_FLAG	VARCHAR2	(1)		Flag to indicate if CLASS data should be audited
WSMSC_FLAG	VARCHAR2	(1)		Flag to indicate if WSMSC data should be audited
RN_FLAG	VARCHAR2	(1)		Flag to indicate if RN data should be audited
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
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT SV_AUDIT_ID
,      OBJECT_REFERENCE
,      SP_ID
,      AUDIT_NAME
,      AUDIT_TYPE
,      STATUS_CODE
,      STARTING_NUMBER
,      ENDING_NUMBER
,      FOR_SP_ID
,      NUMBER_OF_TN_AUDITED
,      ACTIVATION_START_DATE
,      ACTIVATION_END_DATE
,      NOTES
,      ROUTING_NUMBER_FLAG
,      CNAM_FLAG
,      ISVM_FLAG
,      LIDB_FLAG
,      CLASS_FLAG
,      WSMSC_FLAG
,      RN_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SV_AUDITS;

Dependencies

[top of page]

XNP.XNP_SV_AUDITS does not reference any database object

XNP.XNP_SV_AUDITS is referenced by following:

APPS: XNP_SV_AUDITS