DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_IN_ENQUIRY_APPL_ALL

Object Details
Object Name: IGS_IN_ENQUIRY_APPL_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_IN_ENQUIRY_APPL_ALL
Subobject Name:
Status: VALID


IGS_IN_ENQUIRY_APPL_ALL describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, for example, faculty of education accomodation information - Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_IN_ENQUIRY_APPL_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnENQUIRY_APPL_NUMBER
IGS_IN_ENQUIRY_APPL_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREGISTERING_PERSON_ID
Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ENQUIRY_APPL_NUMBER NUMBER (7) Yes Number identifying the enquiry made by a person
ACAD_CAL_TYPE VARCHAR2 (10) Yes Describes the academic calendar type that the admission enquiry application relates
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes A unique number that identifies the academic calendar instance that the enquiry application refers to
ADM_CAL_TYPE VARCHAR2 (10)
Describes the admission calendar type that the admission enquiry application applies
ADM_CI_SEQUENCE_NUMBER NUMBER (6)
A unique number that identifies the admission calendar instance that the enquiry application refers to
ENQUIRY_STATUS VARCHAR2 (10) Yes Describes the user-defined status of the enquiry
ENQUIRY_DT DATE
Yes Describes the date the enquiry was made
ENQUIRY_SOURCE_TYPE VARCHAR2 (10) Yes Describes the type of source responsible for an admission enquiry being made. Examples newspaper advertisement, school liaison activity.
REGISTERING_PERSON_ID NUMBER (15)
Person who registered the enquiry
OVERRIDE_PROCESS_IND VARCHAR2 (1) Yes Describes if the to force the processing of an incomplete package for the person. If selected, it will override any limitations placed on the processing routine.
INDICATED_MAILING_DT DATE

Describes the promised mailing date of the enquiry to be used as an alert when packages are not mailed in satisfactory time frames
LAST_PROCESS_DT DATE

Describes the latest processing date of the enquiry
COMMENTS VARCHAR2 (2000)
Additional information relating to the enquiry
INQ_ENTRY_STAT_ID NUMBER (15)
Unique Identifier for Entry Status
INQ_ENTRY_LEVEL_ID NUMBER (15)
Unique Identifier for Entry Level
EDU_GOAL_ID NUMBER (15)
Unique Identifier for Educational Goal
PARTY_ID NUMBER (15)
Unique Identifier for Organization Unit related to Inquiry School of Interest
HOW_KNOWUS_ID NUMBER (15)
Unique Identifier for How Do You Know Us
WHO_INFLUENCED_ID NUMBER (15)
Unique Identifier for Who Influenced your decision
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category For Descriptive Flex field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flex Field Column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flex Field Column
ORG_ID NUMBER (15)
Operating unit identifier.
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
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record.
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program.
Query Text

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


SELECT PERSON_ID
,      ENQUIRY_APPL_NUMBER
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ENQUIRY_STATUS
,      ENQUIRY_DT
,      ENQUIRY_SOURCE_TYPE
,      REGISTERING_PERSON_ID
,      OVERRIDE_PROCESS_IND
,      INDICATED_MAILING_DT
,      LAST_PROCESS_DT
,      COMMENTS
,      INQ_ENTRY_STAT_ID
,      INQ_ENTRY_LEVEL_ID
,      EDU_GOAL_ID
,      PARTY_ID
,      HOW_KNOWUS_ID
,      WHO_INFLUENCED_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_IN_ENQUIRY_APPL_ALL;

Dependencies

[top of page]

IGS.IGS_IN_ENQUIRY_APPL_ALL does not reference any database object

IGS.IGS_IN_ENQUIRY_APPL_ALL is referenced by following:

SchemaAPPS
SynonymIGS_IN_ENQUIRY_APPL_ALL