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.IGR_I_APPL_ALL

Object Details

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

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGR_I_APPL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID ENQUIRY_APPL_NUMBER
IGR_I_APPL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTERING_PERSON_ID
IGR_I_APPL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SALES_LEAD_ID
IGR_I_APPL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADM_CAL_TYPE ADM_CI_SEQUENCE_NUMBER ACAD_CAL_TYPE ACAD_CI_SEQUENCE_NUMBER
IGR_I_APPL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EDU_GOAL_ID
IGR_I_APPL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HOW_KNOWUS_ID
IGR_I_APPL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INQ_ENTRY_LEVEL_ID
IGR_I_APPL_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
IGR_I_APPL_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WHO_INFLUENCED_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	(15)	Yes	Number identifying the Inquiry made by a person
SALES_LEAD_ID	NUMBER	(15)	Yes	Foreign Key to Sales Leads table
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_DT	DATE		Yes	Describes the date the enquiry was made
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
ORG_ID	NUMBER	(15)		Organization ID
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
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.
PKG_REDUCT_IND	VARCHAR2	(1)		Package Reduction Indicator. It indicates whether the LOV in package item window wll show all the available package items or it will show only those package items corresponding to the academic interest category attached to the inquiry instance.

Query Text

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


SELECT PERSON_ID
,      ENQUIRY_APPL_NUMBER
,      SALES_LEAD_ID
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ENQUIRY_DT
,      REGISTERING_PERSON_ID
,      OVERRIDE_PROCESS_IND
,      INDICATED_MAILING_DT
,      LAST_PROCESS_DT
,      COMMENTS
,      ORG_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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PKG_REDUCT_IND
FROM IGS.IGR_I_APPL_ALL;

Dependencies

[top of page]

IGS.IGR_I_APPL_ALL does not reference any database object

IGS.IGR_I_APPL_ALL is referenced by following:

APPS: IGR_I_APPL_ALL