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]

VIEW: APPS.IGS_DA_XML_CONTROL_V

Object Details

Object Name:	IGS_DA_XML_CONTROL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_DA_XML_CONTROL_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

XML element ControlType. View of the request configuration. Provides 3rd Party Software specific processing instructions.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTROL_BATCHID	NUMBER		Yes	Contains the Batch_Id of the request document number.
CONTROL_DEGREE_AUDIT_REQUESTOR	VARCHAR2	(30)	Yes	Contains the OSS or database userid of the person initiating the request
CONTROL_REQUEST_START_DATE	VARCHAR2	(10)		Contains the date on which the degree audit software should begin processing the request
CONTROL_REQUEST_START_TIME	VARCHAR2	(8)		Contains the time on which the degree audit software should begin processing the request.
CONTROL_REQUEST_SERVER_NAME	VARCHAR2	(30)		Contains the server name that the degree audit software should use to process the request.
CONTROL_RECORD	VARCHAR2	(30)		Contains an override run-time parameter for processing.
CONTROL_PRT_REQIRE_COMPLETION	VARCHAR2	(30)		Contains a value indicating what requirements are printed on the audit.
CONTROL_RPT_DEGR_REQIR_DETAILS	VARCHAR2	(30)		Contains a value indicating what level of detail is included on the audit.
CONTROL_RPT_REQ_COMPLETION	VARCHAR2	(30)		Contains a value indicating what audits will be printed based on requirement completion statuses
CONTROL_REQUEST_TYPE	VARCHAR2	(30)		Contains the type of request - Degree Audit, Transfer Evaluation, or both.
CONTROL_INCLUDE_TOP_TEXT	CHAR	(0)		Contains text to include on the top of a degree audit report.
CONTROL_INCLUDE_BOTTOM_TEXT	CHAR	(0)		Contains text to include on the bottom of a degree audit report.
CONTROL_VIEW_SECURITY_ID	CHAR	(0)		Contains a value for the secure operator ID for sharing reports.
CONTROL_REPORT_LINE_TYPE	VARCHAR2	(30)		Contains an indicator for the output to include a line type indicator.
CONTROL_DEBUG	VARCHAR2	(5)		Contains an indicator for the degree audit software to produce a detailed report containing the dump or debugging information
CONTROL_DPMASK	VARCHAR2	(30)		Control to invoke degree program specific transfer evaluation rules
CONTROL_REPORT_FORMAT	VARCHAR2	(30)		Contains the value indicating which style sheet the degree audit software will use to format the report
BATCH_ID	NUMBER		Yes	Contains the OSS generated Batch ID for tracking purposes.
LOCAL_INSTITUTION_CD	VARCHAR2	(30)	Yes	Describes an institution from which the transfer evaluation will be limited. The Institution is composed of the EntityID type. See this type for institution details.

Query Text

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


SELECT CONTROL_BATCHID
,      CONTROL_DEGREE_AUDIT_REQUESTOR
,      CONTROL_REQUEST_START_DATE
,      CONTROL_REQUEST_START_TIME
,      CONTROL_REQUEST_SERVER_NAME
,      CONTROL_RECORD
,      CONTROL_PRT_REQIRE_COMPLETION
,      CONTROL_RPT_DEGR_REQIR_DETAILS
,      CONTROL_RPT_REQ_COMPLETION
,      CONTROL_REQUEST_TYPE
,      CONTROL_INCLUDE_TOP_TEXT
,      CONTROL_INCLUDE_BOTTOM_TEXT
,      CONTROL_VIEW_SECURITY_ID
,      CONTROL_REPORT_LINE_TYPE
,      CONTROL_DEBUG
,      CONTROL_DPMASK
,      CONTROL_REPORT_FORMAT
,      BATCH_ID
,      LOCAL_INSTITUTION_CD
FROM APPS.IGS_DA_XML_CONTROL_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_CONTROL_V references the following:

APPS: HZ_PARTIES; IGS_DA_CNFG_REQ_TYP; IGS_DA_REQ_FTRS; IGS_DA_RQST; IGS_PE_HZ_PARTIES

APPS.IGS_DA_XML_CONTROL_V is not referenced by any database object