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_TXCPT_INT

Object Details

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

Contains Transcript details for each person to be imported into the IGS_AD_TRANSCRIPT table by the Transcript Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Transcript Detail
Category: BUSINESS_ENTITY IGS_PREV_EDUCATION

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_TXCPT_INT_ALL_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	INTERFACE_TRANSCRIPT_ID
IGS_AD_TXCPT_INT_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_ACADHIS_ID
IGS_AD_TXCPT_INT_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	STATUS
IGS_AD_TXCPT_INT_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_RUN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_TRANSCRIPT_ID	NUMBER	(15)	Yes	Unique identifier for the transcript record
TRANSCRIPT_STATUS	VARCHAR2	(30)	Yes	Indicates the transcript status
TRANSCRIPT_TYPE	VARCHAR2	(30)	Yes	Indicates the transcript type
TRANSCRIPT_SOURCE	NUMBER	(15)	Yes	Indicates the source of the transcript details.
INTERFACE_ACADHIS_ID	NUMBER	(15)	Yes	Refers to the link with Academic History table
STATUS	VARCHAR2	(1)	Yes	Status of the interface record after processing.1 - Completed 2 - Pending 3 - Error 4 - Warning
ENTERED_GS_ID	NUMBER	(15)	Yes	Holds the entered grading schema ID
CONV_GS_ID	NUMBER	(15)	Yes	Holds the converted grading schema ID
TERM_TYPE	VARCHAR2	(1)	Yes	Holds the term type
TRANSCRIPT_ID	NUMBER	(15)		Holds the unique identifier of the table which is populated by the interface table.
DATE_OF_RECEIPT	DATE			Indicates the date on which the record was received
ENTERED_GPA	VARCHAR2	(30)		Indicated the entered grade point average
CONV_GPA	VARCHAR2	(30)		Holds the converted grade point average
RANK_IN_CLASS	NUMBER	(5)		Rank in class for the student
CLASS_SIZE	NUMBER	(5)		Indicates the class size
APPROXIMATE_RANK	VARCHAR2	(1)		Indicates the approximate rank of the student
WEIGHTED_RANK	VARCHAR2	(1)		Indicates the weighted rank
DECILE_RANK	NUMBER			Indicates the decile rank
QUARTILE_RANK	NUMBER			Indicates the quartile rank
QUINTILE_RANK	NUMBER			Indicates the quintile rank
PERCENTILE_RANK	NUMBER			Indicates the percentile rank
MATCH_IND	VARCHAR2	(2)		Indicates the match between the interface record and record present in the system.
ERROR_CODE	VARCHAR2	(30)		Indicates the error that occurred during the import process.
DUP_TRANSCRIPT_ID	NUMBER	(15)		Holds the duplicate transcript ID
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)		Standard who column for concurrent programs
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard who column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard who column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard who column for concurrent programs
DATE_OF_ISSUE	DATE		Yes	Date on which the transcript is issued
INTERFACE_RUN_ID	NUMBER			Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
PERSON_ID	NUMBER	(15)		Person Identifier. This column will be populated by the import process.
EDUCATION_ID	NUMBER	(15)		Education Identifier. This column will be populated by the import process
OVERRIDE_IND	VARCHAR2	(1)		Override Indicator
ERROR_TEXT	VARCHAR2	(2000)		Error Text
UPDATE_TRANSCRIPT_ID	NUMBER	(15)		Unique identifier to identify the OSS record which will map to EDUCATION_ID

Query Text

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


SELECT INTERFACE_TRANSCRIPT_ID
,      TRANSCRIPT_STATUS
,      TRANSCRIPT_TYPE
,      TRANSCRIPT_SOURCE
,      INTERFACE_ACADHIS_ID
,      STATUS
,      ENTERED_GS_ID
,      CONV_GS_ID
,      TERM_TYPE
,      TRANSCRIPT_ID
,      DATE_OF_RECEIPT
,      ENTERED_GPA
,      CONV_GPA
,      RANK_IN_CLASS
,      CLASS_SIZE
,      APPROXIMATE_RANK
,      WEIGHTED_RANK
,      DECILE_RANK
,      QUARTILE_RANK
,      QUINTILE_RANK
,      PERCENTILE_RANK
,      MATCH_IND
,      ERROR_CODE
,      DUP_TRANSCRIPT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DATE_OF_ISSUE
,      INTERFACE_RUN_ID
,      PERSON_ID
,      EDUCATION_ID
,      OVERRIDE_IND
,      ERROR_TEXT
,      UPDATE_TRANSCRIPT_ID
FROM IGS.IGS_AD_TXCPT_INT;

Dependencies

[top of page]

IGS.IGS_AD_TXCPT_INT does not reference any database object

IGS.IGS_AD_TXCPT_INT is referenced by following:

APPS: IGS_AD_TXCPT_INT