[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGS.IGS_DA_RQST does not reference any database object
IGS.IGS_DA_RQST is referenced by following:
|
|
|