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_AS_LGCY_STC_INT

Object Details

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

Contains Transcript Comments to be imported into the IGS_AS_STU_TRN_CMTS table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Legacy Transcript Comment
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AS_LGCY_STC_INT_PK	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LEGACY_CMTS_INT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEGACY_CMTS_INT_ID	NUMBER		Yes	A value to uniquely identify each record in the interface table. To be generated from a sequence.
BATCH_ID	NUMBER		Yes	Batch Identifier for the row
COMMENT_TYPE_CODE	VARCHAR2	(30)	Yes	One of six type of transcript comment.
COMMENT_TXT	VARCHAR2	(1000)	Yes	Transcript comment.
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number
PROGRAM_CD	VARCHAR2	(6)		Course code (optional) based on the comment type
PROGRAM_TYPE	VARCHAR2	(10)		Course type (optional) based on the comment type
AWARD_CD	VARCHAR2	(10)		Award code (optional) based on the comment type
LOAD_CAL_ALTERNATE_CD	VARCHAR2	(10)		Load calendar (optional) based on the comment type.
UNIT_SET_CD	VARCHAR2	(10)		Unit set code (optional) based on the comment type
US_VERSION_NUMBER	NUMBER	(3)		Unit set version number (optional) based on the comment type
UNIT_CD	VARCHAR2	(10)		Unique identifier of the unit (optional) based on the comment type.
VERSION_NUMBER	NUMBER	(3)		Version number of the unit. (optional) based on the comment type.
TEACH_CAL_ALTERNATE_CD	VARCHAR2	(10)		Teach calendar (optional) based on the comment type.
LOCATION_CD	VARCHAR2	(10)		Institution-defined location code, typically of a campus, at that a unit offering option is offered (optional) based on the comment type.
UNIT_CLASS	VARCHAR2	(10)		Institution-defined code that identifies a unit class (optional) based on the comment type.
IMPORT_STATUS	VARCHAR2	(1)		Import Status -Either of 'U' - Unprocessed (Default) ,'R' - Ready for Reprocessing ,'E' - Error ,'W' - Warning ,'I' - Imported ,
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
REQUEST_ID	NUMBER	(15)		Request Id
PROGRAM_ID	NUMBER	(15)		Program Id
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program Application Id
PROGRAM_UPDATE_DATE	DATE			Program Update Date

Query Text

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


SELECT LEGACY_CMTS_INT_ID
,      BATCH_ID
,      COMMENT_TYPE_CODE
,      COMMENT_TXT
,      PERSON_NUMBER
,      PROGRAM_CD
,      PROGRAM_TYPE
,      AWARD_CD
,      LOAD_CAL_ALTERNATE_CD
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_CD
,      VERSION_NUMBER
,      TEACH_CAL_ALTERNATE_CD
,      LOCATION_CD
,      UNIT_CLASS
,      IMPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_AS_LGCY_STC_INT;

Dependencies

[top of page]

IGS.IGS_AS_LGCY_STC_INT does not reference any database object

IGS.IGS_AS_LGCY_STC_INT is referenced by following:

APPS: IGS_AS_LGCY_STC_INT