[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_DA_CNFG_REQ_TYP |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_DA_CNFG_REQ_TYP
|
| Subobject Name: | |
| Status: | VALID |
Storage of Degree Audit configurations on Run Types allowed on the Request Screen
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_DA_CNFG_REQ_TYP_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_TYPE_ID
|
| IGS_DA_CNFG_REQ_TYP_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_TYPE
|
| IGS_DA_CNFG_REQ_TYP_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_MODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REQUEST_CONFIG_ID | NUMBER | Request configuration id link back to the configuration parent table - Obsolete | ||
| REQUEST_TYPE_ID | NUMBER | (15) | Yes | Sequence on table for each request type configured. |
| REQUEST_NAME | VARCHAR2 | (100) | Yes | User defined name given to the report. |
| REQUEST_TYPE | VARCHAR2 | (30) | Yes | Configuration required Select one or more values to link to request_mode and person_type combination.For each request type selected, one or more request features must be selected and configured. Validations should occur during the configuration to ensure that the mandatory items are completed. Pop-up text should be displayed if the configuration screen is trying to be saved without the mandatory items having been configured.NOTE: From one to many request types may be associated with each request mode + person type combination. Each request mode + person type + request type combination along with its associated request feature settings are unique |
| REQUEST_MODE | VARCHAR2 | (30) | Yes | Holds the student selection mode - single, batch, or both |
| REQUEST_TYPE_DISPLAY | VARCHAR2 | (1) | Y or N value. Indicates whether the request type value will be displayed in the request type LOV on the degree audit/transfer evaluation request screen. - Obsolete | |
| CLOSED_IND | VARCHAR2 | (1) | Yes | Closed Request template do not appear in self-service |
| PURGABLE_IND | VARCHAR2 | (1) | Yes | Indicator for purge process |
| REQUEST_TYPE_COMMENT | VARCHAR2 | (255) | Comment of config user. Meaning to Third Party Software - freeform text which is specific to the request type + person type + request mode combination. | |
| WIF_IND | VARCHAR2 | (1) | Yes | Holds the program comparisons details for the request. Indicates whether the program comparison type is what if. |
| WIF_PROGRAM_CODE | VARCHAR2 | (6) | Holds the program code of the program comparison comparisons details for the request if comparison is of type Special program. | |
| WIF_PROGRAM_MOD_IND | VARCHAR2 | (1) | Yes | Indicates if the what if the user in self-service pages can modify details. |
| WIF_CATALOG_CAL_TYPE | VARCHAR2 | (10) | Holds the catalog cal type for the What if program comparison type. | |
| WIF_CATALOG_CI_SEQ_NUM | NUMBER | (6) | Holds the catalog cal sequence number for the What if program comparison type. | |
| WIF_CATALOG_MOD_IND | VARCHAR2 | (1) | Yes | Indicates if the what if the user in self-service pages can modify details (Program catalog). |
| SPECIAL_IND | VARCHAR2 | (1) | Yes | Indicates whether the program comparison type is Special |
| SPECIAL_PROGRAM_CODE | VARCHAR2 | (30) | Holds the program code if the comparisons is of type 'Special program'. | |
| SPECIAL_PROGRAM_MOD_IND | VARCHAR2 | (1) | Yes | Indicates if the user in self-service pages can modify the special programdetail. |
| SPECIAL_CATALOG | VARCHAR2 | (30) | Holds the catalog information if the program comparison is special program | |
| SPECIAL_CATALOG_MOD_IND | VARCHAR2 | (1) | Yes | Indicates if the user in self-service pages can modify the special program catalog detail. |
| ENROLLED_IND | VARCHAR2 | (1) | Yes | Indicates if the user in self-service pages can modify the special program catalog detail. |
| SPA_COMPLETE_IND | VARCHAR2 | (1) | Indicates whether Program is completed or not. | |
| SUSA_COMPLETE_IND | VARCHAR2 | (1) | Indicates whether Unit Sets is completed or not. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute Category | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 1 | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 2 | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 3 | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 4 | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 5 | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 6 | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 7 | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 8 | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 9 | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 10 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 11 | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 12 | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 13 | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 14 | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 15 | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 16 | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 17 | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 18 | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 19 | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Degree Audit/Transfer Request Configuration DFF Attribute 20 | |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_CONFIG_ID
, REQUEST_TYPE_ID
, REQUEST_NAME
, REQUEST_TYPE
, REQUEST_MODE
, REQUEST_TYPE_DISPLAY
, CLOSED_IND
, PURGABLE_IND
, REQUEST_TYPE_COMMENT
, WIF_IND
, WIF_PROGRAM_CODE
, WIF_PROGRAM_MOD_IND
, WIF_CATALOG_CAL_TYPE
, WIF_CATALOG_CI_SEQ_NUM
, WIF_CATALOG_MOD_IND
, SPECIAL_IND
, SPECIAL_PROGRAM_CODE
, SPECIAL_PROGRAM_MOD_IND
, SPECIAL_CATALOG
, SPECIAL_CATALOG_MOD_IND
, ENROLLED_IND
, SPA_COMPLETE_IND
, SUSA_COMPLETE_IND
, 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_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_CNFG_REQ_TYP;
IGS.IGS_DA_CNFG_REQ_TYP does not reference any database object
IGS.IGS_DA_CNFG_REQ_TYP is referenced by following:
APPS
IGS_DA_CNFG_REQ_TYP
|
|
|
|