[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_APPL_SETUP_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_APPL_SETUP_ALL |
Subobject Name: | |
Status: | VALID |
IGF_AP_APPL_SETUP_ALL describes the user-defined questions for each organization.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_APPL_SETUP_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | QUESTION_ID |
IGF_AP_APPL_SETUP_ALL_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CI_CAL_TYPE
CI_SEQUENCE_NUMBER QUESTION APPLICATION_CODE |
IGF_AP_APPL_SETUP_ALL_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CI_CAL_TYPE
CI_SEQUENCE_NUMBER ORG_ID QUESTION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUESTION_ID | NUMBER | (15) | Yes | Identifier for user-defined questions |
QUESTION | VARCHAR2 | (200) | Yes | Describes question set by institution |
ENABLED | VARCHAR2 | (1) | Yes | Key to identify whether question is enabled |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
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 | |
APPLICATION_CODE | VARCHAR2 | (30) | Identifier for an Application | |
APPLICATION_NAME | VARCHAR2 | (80) | The descriptive name for an application code | |
ACTIVE_FLAG | VARCHAR2 | (1) | To Enable and Disable the Application | |
ANSWER_TYPE_CODE | VARCHAR2 | (30) | Determines the type of response against the question | |
DESTINATION_TXT | VARCHAR2 | (80) | Determines the anticipated data to be populated by the response | |
LD_CAL_TYPE | VARCHAR2 | (10) | Calendar Type of the Term | |
LD_SEQUENCE_NUMBER | NUMBER | Calendar Sequence Number of the Term | ||
ALL_TERMS_FLAG | VARCHAR2 | (1) | Indicator for all terms selected for anticipated data | |
OVERRIDE_EXIST_ANT_DATA_FLAG | VARCHAR2 | (1) | Indicator to update the anticipated data | |
REQUIRED_FLAG | VARCHAR2 | (1) | Marks the question as mandatory to answer | |
MINIMUM_VALUE_NUM | NUMBER | (30) | Minimum value for a range of value | |
MAXIMUM_VALUE_NUM | NUMBER | (30) | Maximum value for a range of values | |
MINIMUM_DATE | DATE | Minimum date for a range of dates | ||
MAXIMIUM_DATE | DATE | Maximum date for a range of dates | ||
LOOKUP_CODE | VARCHAR2 | (30) | User defined lookup to be used. | |
HINT_TXT | VARCHAR2 | (30) | Hint text provided to the answer of the question |
Cut, paste (and edit) the following text to query this object:
SELECT QUESTION_ID
, QUESTION
, ENABLED
, ORG_ID
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPLICATION_CODE
, APPLICATION_NAME
, ACTIVE_FLAG
, ANSWER_TYPE_CODE
, DESTINATION_TXT
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, ALL_TERMS_FLAG
, OVERRIDE_EXIST_ANT_DATA_FLAG
, REQUIRED_FLAG
, MINIMUM_VALUE_NUM
, MAXIMUM_VALUE_NUM
, MINIMUM_DATE
, MAXIMIUM_DATE
, LOOKUP_CODE
, HINT_TXT
FROM IGF.IGF_AP_APPL_SETUP_ALL;
IGF.IGF_AP_APPL_SETUP_ALL does not reference any database object
IGF.IGF_AP_APPL_SETUP_ALL is referenced by following:
|
|
|