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: IGS.IGS_DA_RQST

Object Details

Object Name:	IGS_DA_RQST
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_DA_RQST
Subobject Name:
Status:	VALID

IGS_DA_RQST describes the parent table for storage of all Degree Audit Requests made.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_DA_RQST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BATCH_ID
IGS_DA_RQST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_TYPE_ID
IGS_DA_RQST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_STATUS
IGS_DA_RQST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Batch number of request
REQUEST_TYPE_ID	NUMBER	(15)	Yes	New relation to configuration template
REQUEST_MODE	VARCHAR2	(30)	Yes	Indicates whether Single or Batch Request and if batch request then there is a batch record.
PROGRAM_COMPARISON_TYPE	VARCHAR2	(30)	Yes	Holds the program comparison information
REQUEST_STATUS	VARCHAR2	(30)	Yes	Status of outgoing request -- informs software of readiness for DEGAUD API to begin processing outgoing data. Value of the request status can be N( new), N(x) where x represents the screen number that the user was on after each stage, P (Processing), C (complete) and E (exception)
PERSON_ID_GROUP_ID	NUMBER	(6)		Holds the person ID group used for multiple student selections
PERSON_ID	NUMBER	(15)		Holds the person ID used for single student selection
REPORT_INDICATOR	VARCHAR2	(1)		Indicates to user the completion status of the report's requirements. --Obsoleted
REQUESTOR_ID	NUMBER	(15)	Yes	Person ID that made the request
STUDENT_RELEASE_IND	VARCHAR2	(1)	Yes	Indicates if the reports have been released to students
REQUESTOR_NUMBER	VARCHAR2	(30)		-Obsoleted
NUM_REPORTS	NUMBER	(4)		-Obsoleted
REQUESTOR_TYPE	VARCHAR2	(30)		Person type code for person making the request. --Obsoleted
REPORT_STATUS	VARCHAR2	(1)		Status of incoming report. Informs Return OSS API to begin processing incoming data. Value of the report status from the 3rd party. Values are N (New Request), S (Success), F (Failure) --Obsoleted
REQUESTOR_SURNAME	VARCHAR2	(30)		Person's Surname who is making the request --Obsoleted
REQUESTOR_GIVENNAME	VARCHAR2	(30)		Person's Given name who is making the request --Obsoleted
REQUEST_TYPE	VARCHAR2	(30)		Request Type value associated with Request --Obsoleted
REQUEST_TYPE_COM1	VARCHAR2	(255)		Unique Request Type Comment associated with Request Mode and Person Type of requestor and request Type --Obsoleted
REQUEST_TYPE_COM2	VARCHAR2	(255)		Freeform Comment inserted by User hook which has the meaning for third party software --Obsoleted
REQUEST_TYPE_COM3	VARCHAR2	(255)		Freeform Comment inserted by User hook which has the meaning for third party software --Obsoleted
REQUEST_TYPE_COM4	VARCHAR2	(255)		Freeform Comment inserted by User hook which has the meaning for third party software
DECL_PROGRAM	VARCHAR2	(6)		Declared program code value selected from the Request screen. --Obsoleted
DECL_PROG_VERSION	NUMBER			Declared program version of the program code selected from the Request Screen --Obsoleted
DECL_PROG_CATALOG	VARCHAR2	(30)		Declared program catalog of the program code selected from the Request screen. --Obsoleted
DECL_PROG_CAL_TYPE	VARCHAR2	(10)		Calendar Type associated to the catalog chosen for the program catalog on the Request Screen. --Obsoleted
DECL_PROG_SEQ_NUM	NUMBER	(6)		Sequence Number associated with the catalog chosen for the program catalog on the Request Screen. --Obsoleted
WHATIF_ORG_UNIT	VARCHAR2	(10)		Organizational unit selected for defining the What-if program on Request Screen. --Obsoleted
SPECIAL_PROGRAM	VARCHAR2	(30)		Freeform, user-defined value representing software program code which is provided during the request or pre-selected as part of the request configuration
SPECIAL_PROGRAM_CATALOG	VARCHAR2	(30)		Freeform, user-defined value representing software catalog associated with above software program code which is provided during the request or pre-selected as part of the request configuration
IDGROUP_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates ID Group Region used as part of request, N indicates it is not used. --Obsoleted
ACTIVITIES_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Activities region used as part of request, N indicates it is not used. --Obsoleted
ADMISSION_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Admission Region used as part of request, N indicates it is not used. --Obsoleted
PROGRAM_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Program Region used as part of request, N indicates it is not used. --Obsoleted
GRADUATION_REGION	VARCHAR2	(1)		Grouping of student characteristics for batch request student selection. Y indicates Graduation Region used as part of request, N indicates it is not used. --Obsoleted
ENROLLMENT_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Enrollment Region used as part of request, N indicates it is not used. --Obsoleted
TEST_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Test Region used as part of request, N indicates it is not used. --Obsoleted
SORT_REGION	VARCHAR2	(1)		Grouping of student characterisitcs for batch request student selection. Y indicates Sort Region used as part of request, N indicates it is not used. --Obsoleted
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		Request Type DFF Attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Request Type DFF Attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Request Type DFF Attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Request Type DFF Attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Request Type DFF Attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Request Type DFF Attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Request Type DFF Attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Request Type DFF Attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Request Type DFF Attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Request Type DFF Attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Request Type DFF Attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Request Type DFF Attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Request Type DFF Attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Request Type DFF Attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Request Type DFF Attribute 15
ATTRIBUTE16	VARCHAR2	(150)		Request Type DFF Attribute 16
ATTRIBUTE17	VARCHAR2	(150)		Request Type DFF Attribute 17
ATTRIBUTE18	VARCHAR2	(150)		Request Type DFF Attribute 18
ATTRIBUTE19	VARCHAR2	(150)		Request Type DFF Attribute 19
ATTRIBUTE20	VARCHAR2	(150)		Request Type DFF Attribute 20
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT BATCH_ID
,      REQUEST_TYPE_ID
,      REQUEST_MODE
,      PROGRAM_COMPARISON_TYPE
,      REQUEST_STATUS
,      PERSON_ID_GROUP_ID
,      PERSON_ID
,      REPORT_INDICATOR
,      REQUESTOR_ID
,      STUDENT_RELEASE_IND
,      REQUESTOR_NUMBER
,      NUM_REPORTS
,      REQUESTOR_TYPE
,      REPORT_STATUS
,      REQUESTOR_SURNAME
,      REQUESTOR_GIVENNAME
,      REQUEST_TYPE
,      REQUEST_TYPE_COM1
,      REQUEST_TYPE_COM2
,      REQUEST_TYPE_COM3
,      REQUEST_TYPE_COM4
,      DECL_PROGRAM
,      DECL_PROG_VERSION
,      DECL_PROG_CATALOG
,      DECL_PROG_CAL_TYPE
,      DECL_PROG_SEQ_NUM
,      WHATIF_ORG_UNIT
,      SPECIAL_PROGRAM
,      SPECIAL_PROGRAM_CATALOG
,      IDGROUP_REGION
,      ACTIVITIES_REGION
,      ADMISSION_REGION
,      PROGRAM_REGION
,      GRADUATION_REGION
,      ENROLLMENT_REGION
,      TEST_REGION
,      SORT_REGION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM IGS.IGS_DA_RQST;

Dependencies

[top of page]

IGS.IGS_DA_RQST does not reference any database object

IGS.IGS_DA_RQST is referenced by following:

APPS: IGS_DA_RQST