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_EN_INSESS_SPSHT

Object Details

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

IGS_EN_INSESS_SPSHT is a temporary table used by the process that creates the enrollment statistics snapshot.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_INSESS_SPSHT_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	PERSON_ID COURSE_CD

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the person ID that the enrolment statistics snapshot is for. DETYA element 313. Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
COURSE_CD	VARCHAR2	(6)	Yes	Describes the program code of the student unit attempt that the enrolment statistics snapshot is for. DETYA element 307.
CRV_VERSION_NUMBER	NUMBER	(3)	Yes	Describes the version number of the program for the student unit attempt that the enrolment statistics snapshot is for.
SCA_LOCATION_CD	VARCHAR2	(10)	Yes	Describes the location code of the program for the student unit attempt that the enrolment statistics snapshot is for.
FUNDING_SOURCE	VARCHAR2	(10)		Describes the user-defined funding source of the program of the student unit attempt that the enrolment statistics snapshot is for.
GOVT_FUNDING_SOURCE	NUMBER	(2)		Describes the government funding source of the program of the student unit attempt that the enrolment statistics snapshot is for.
COMMENCEMENT_DT	DATE		Yes	Describes the commencement date of the student program attempt.
COMMENCING_STUDENT_IND	VARCHAR2	(1)	Yes	Describes whether or not a student is classified as a commencing student for the program of the student unit attempt that the enrolment statistics snapshot is for.
SCHOOL_LEAVER	NUMBER	(1)	Yes	Describes whether or not a student is classified as a school leaver for the program of the student unit attempt that the enrolment statistics snapshot is for.
NEW_TO_HIGHER_EDUCATION	NUMBER	(1)	Yes	Describes whether or not a student is classified as a new to higher education for the program of the student unit attempt that the enrolment statistics snapshot is for.
SCA_CP_TOTAL	NUMBER		Yes	Describes the credit points passed for the student in a student program attempt.
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)		Request identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      SCA_LOCATION_CD
,      FUNDING_SOURCE
,      GOVT_FUNDING_SOURCE
,      COMMENCEMENT_DT
,      COMMENCING_STUDENT_IND
,      SCHOOL_LEAVER
,      NEW_TO_HIGHER_EDUCATION
,      SCA_CP_TOTAL
,      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_INSESS_SPSHT;

Dependencies

[top of page]

IGS.IGS_EN_INSESS_SPSHT does not reference any database object

IGS.IGS_EN_INSESS_SPSHT is referenced by following:

APPS: IGS_EN_INSESS_SPSHT