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

Object Details

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

Contains Offer Response details for each person to be imported into the IGS_AD_PS_APPL_INST table by the Offer Response Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Offer Response
Category: BUSINESS_ENTITY IGS_ADM_APPLICATION

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_OFFRESP_INT_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	OFFRESP_INT_ID
IGS_AD_OFFRESP_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OFFRESP_INT_ID	NUMBER	(15)	Yes	An identifier to uniquely identify this row
BATCH_ID	NUMBER	(15)	Yes	Batch Identifier
PERSON_ID	NUMBER	(15)	Yes	Person identifier
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Admission application number
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	Program code for the admission application
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence number for the admission application
ADM_OFFER_RESP_STATUS	VARCHAR2	(10)	Yes	Offer Response Status
ACTUAL_OFFER_RESPONSE_DT	DATE			Offer Response Date
ATTENT_OTHER_INST_CD	VARCHAR2	(30)		Attend other institution code
APPLICANT_ACPTNCE_CNDTN	VARCHAR2	(2000)		Offer Response Comments
DEF_ACAD_CAL_TYPE	VARCHAR2	(10)		Deferred Academic Calendar Type
DEF_ACAD_CI_SEQUENCE_NUMBER	NUMBER	(6)		Deferred Academic Calendar sequence number
DEF_ADM_CAL_TYPE	VARCHAR2	(10)		Deferred Admission Calendar Type
DEF_ADM_CI_SEQUENCE_NUMBER	NUMBER	(6)		Deferred Admission Calendar sequence number
STATUS	VARCHAR2	(1)	Yes	'1' - Completed '2' - Pending '3' - Error When the interface record is initially populated by the user, the status should be set to '2'.
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
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of the last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
REQUEST_ID	NUMBER	(15)		Request id of the last concurrent program to update this record
PRPSD_COMMENCEMENT_DATE	DATE			Proposed Commencement Date
DECLINE_OFR_REASON	VARCHAR2	(60)		Reason for declining offer

Query Text

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


SELECT OFFRESP_INT_ID
,      BATCH_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      ADM_OFFER_RESP_STATUS
,      ACTUAL_OFFER_RESPONSE_DT
,      ATTENT_OTHER_INST_CD
,      APPLICANT_ACPTNCE_CNDTN
,      DEF_ACAD_CAL_TYPE
,      DEF_ACAD_CI_SEQUENCE_NUMBER
,      DEF_ADM_CAL_TYPE
,      DEF_ADM_CI_SEQUENCE_NUMBER
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRPSD_COMMENCEMENT_DATE
,      DECLINE_OFR_REASON
FROM IGS.IGS_AD_OFFRESP_INT;

Dependencies

[top of page]

IGS.IGS_AD_OFFRESP_INT does not reference any database object

IGS.IGS_AD_OFFRESP_INT is referenced by following:

APPS: IGS_AD_OFFRESP_INT