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]

VIEW: APPS.IGS_AD_ACAD_IDX_INT

Object Details

Object Name:	IGS_AD_ACAD_IDX_INT
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_ACAD_IDX_INT
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Admission Interface Academic Index View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
ACADINDEX_ID	NUMBER	(15)	Yes	Sequuence generated unique no. for every record
ACADINDEX_BATCH_ID	NUMBER	(15)	Yes	Bach 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			Calclation Date
ADMISSION_INDEX	VARCHAR2	(10)	Yes	Admission Index for the application
RECORD_STATUS	VARCHAR2	(1)	Yes	Status of the record 1-Pending 2-Completed 3-Error
ERROR_CODE	VARCHAR2	(6)		Error Code for the interface Record
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
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT ROW_ID
,      ACADINDEX_ID
,      ACADINDEX_BATCH_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      CALCULATION_DATE
,      ADMISSION_INDEX
,      RECORD_STATUS
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM APPS.IGS_AD_ACAD_IDX_INT;

Dependencies

[top of page]

APPS.IGS_AD_ACAD_IDX_INT references the following:

APPS: IGS_AD_ACAD_IDX_INT_ALL

APPS.IGS_AD_ACAD_IDX_INT is not referenced by any database object