Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_EN_LGCY_BAT_INT

Object Details
Object Name: IGS_EN_LGCY_BAT_INT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_EN_LGCY_BAT_INT
Subobject Name:
Status: VALID


Contains the batch details for Enrollments and Records legacy data import. This table is the logical parent of all other Enrollment and Records legacy tables, and is required for each batch prior to running the concurrent program.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Enrollment Legacy Information Batch
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_EN_LGCY_BAT_INT_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Unique Batch Identifier
DESCRIPTION VARCHAR2 (80)
Description about the batch
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)
Standard Concurrent program who column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Concurrent program who column
PROGRAM_ID NUMBER (15)
Standard Concurrent program who column
PROGRAM_UPDATE_DATE DATE

Standard Concurrent program who column
Query Text

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


SELECT BATCH_ID
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_EN_LGCY_BAT_INT;

Dependencies

[top of page]

IGS.IGS_EN_LGCY_BAT_INT does not reference any database object

IGS.IGS_EN_LGCY_BAT_INT is referenced by following:

SchemaAPPS
SynonymIGS_EN_LGCY_BAT_INT