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

TABLE: IGS.IGS_PR_SPA_COMPLETE_INT

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


Contains Student Program Attempt Completion details uploaded from external sources.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Student Program Completion
Category: BUSINESS_ENTITY IGS_STUDENT_PROGRAM


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PR_SPA_COMPLETE_INT_PK NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnPERSON_NUMBER
ColumnCOURSE_CD
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Batch ID used to process related records
PERSON_NUMBER VARCHAR2 (30) Yes Person Number of student
COURSE_CD VARCHAR2 (6) Yes Program Code of the student attempt
COMPLETE_DT DATE
Yes Date at which the Program completion requirements were met
ERROR_CODE VARCHAR2 (30)
Error Code generated by import process.
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
Query Text

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


SELECT BATCH_ID
,      PERSON_NUMBER
,      COURSE_CD
,      COMPLETE_DT
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_PR_SPA_COMPLETE_INT;

Dependencies

[top of page]

IGS.IGS_PR_SPA_COMPLETE_INT does not reference any database object

IGS.IGS_PR_SPA_COMPLETE_INT is referenced by following:

SchemaAPPS
SynonymIGS_PR_SPA_COMPLETE_INT