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_ACAD_IDX_INT_ALL

Object Details

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

Contains Academic Index details for each person to be imported into the IGS_AD_PS_APPL_INST table by the Admission Import process and the Academic Index Import process. Rows in this table must correspond to a batch in the IGS_AD_ACIDX_HDR_ALL table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Academic Index
Category: BUSINESS_ENTITY HZ_PERSON

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_ACAD_IDX_INT_ALL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ACADINDEX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACADINDEX_ID	NUMBER	(15)	Yes	Sequence generated unique number for every record
ACADINDEX_BATCH_ID	NUMBER	(15)	Yes	Batch identifier for this record
PERSON_ID	NUMBER	(15)	Yes	Person identifier or party identifier
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Application number for admission
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	Program code specified in the application
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence Number for Application
CALCULATION_DATE	DATE			Calculation Date
ADMISSION_INDEX	VARCHAR2	(10)	Yes	Admission Index for the application
RECORD_STATUS	VARCHAR2	(1)	Yes	Status of the Record.
ERROR_CODE	VARCHAR2	(6)		Error Code for the interface Record
ORG_ID	NUMBER	(15)		Operating Unit Identifier
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Columns
ERROR_TEXT	VARCHAR2	(2000)		Error Text

Query Text

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


SELECT ACADINDEX_ID
,      ACADINDEX_BATCH_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      CALCULATION_DATE
,      ADMISSION_INDEX
,      RECORD_STATUS
,      ERROR_CODE
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ERROR_TEXT
FROM IGS.IGS_AD_ACAD_IDX_INT_ALL;

Dependencies

[top of page]

IGS.IGS_AD_ACAD_IDX_INT_ALL does not reference any database object

IGS.IGS_AD_ACAD_IDX_INT_ALL is referenced by following:

APPS: IGS_AD_ACAD_IDX_INT_ALL