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_ST_SNAPSHOT

Object Details

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

IGS_EN_ST_SNAPSHOT describes a snapshot of the current enrollment statistics at the institution based on the census date and used for various reporting purposes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_ST_SNAPSHOT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ESS_ID
IGS_EN_ST_SNAPSHOT_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SNAPSHOT_DT_TIME CI_CAL_TYPE CI_SEQUENCE_NUMBER PERSON_ID COURSE_CD UNIT_CD SUA_CAL_TYPE SUA_CI_SEQUENCE_NUMBER TR_ORG_UNIT_CD TR_OU_START_DT DISCIPLINE_GROUP_CD GOVT_DISCIPLINE_GROUP_CD
IGS_EN_ST_SNAPSHOT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_EN_ST_SNAPSHOT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_TYPE_GROUP_CD
IGS_EN_ST_SNAPSHOT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNDING_SOURCE
IGS_EN_ST_SNAPSHOT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_FUNDING_SOURCE
IGS_EN_ST_SNAPSHOT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_ATTENDANCE_MODE
IGS_EN_ST_SNAPSHOT_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SNAPSHOT_DT_TIME PERSON_ID COURSE_CD
IGS_EN_ST_SNAPSHOT_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_REPORTABLE_IND

Columns

Name	Datatype	Length	Mandatory	Comments
ESS_ID	NUMBER	(9)	Yes	Unique identifier that represents a student snapshot. This is used for internal processing purpose.
SNAPSHOT_DT_TIME	DATE		Yes	Describes the date the enrolment statistics snapshot was captured.
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type of the calendar instance selected for inclusion within the enrolment statistics snapshot.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Sequence number of the calendar instance selected for inclusion within the enrolment statistics snapshot.
PERSON_ID	NUMBER	(15)	Yes	Person ID of the student selected for inclusion in the enrolment statistics snapshot. See also, element No. 307 higher education student data collection documentation 1997, DETYA. Person Identifier and foreign key to HZ_PARTIES.
COURSE_CD	VARCHAR2	(6)	Yes	Program code within that the student unit attempt selected for inclusion in the enrolment statistics snapshot was undertaken. See also element No. 307 higher education student data collection documentation 1997, DETYA.
CRV_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the program selected for inclusion in the enrolment statistics snapshot.
UNIT_CD	VARCHAR2	(10)	Yes	Unit code of the student unit attempt selected for inclusion in the enrolment statistics snapshot. See also, element No. 354 higher education student data collection documentation 1997, DETYA.
UV_VERSION_NUMBER	NUMBER	(3)	Yes	Version number of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
SUA_CAL_TYPE	VARCHAR2	(10)	Yes	Teaching calendar type of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
SUA_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar sequence number of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
TR_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Code of the organizational unit that has teaching responsibility for the unit selected for inclusion in the enrolment statistics snapshot. See also, element No. 333 higher education student data collection documentation 1997, DETYA.
TR_OU_START_DT	DATE		Yes	Start date of the organizational unit with teaching responsibility for the unit selected for inclusion in the enrolment statistics snapshot.
DISCIPLINE_GROUP_CD	VARCHAR2	(4)	Yes	Institution-defined discipline group code of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
GOVT_DISCIPLINE_GROUP_CD	VARCHAR2	(4)	Yes	Government discipline group code of the student unit attempt selected for inclusion in the enrolment statistics snapshot. See also element No. 336 higher education student data collection documentation 1997, DETYA.
CRV_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Code of the organizational unit that is responsible for the program selected for inclusion within the enrolment statistics snapshot.
CRV_OU_START_DT	DATE		Yes	Start date of the organizational unit that is responsible for the program selected for inclusion within the enrolment statistics snapshot.
COURSE_TYPE	VARCHAR2	(10)	Yes	Institution-defined program type within that the student unit attempt selected for inclusion in the enrolment statistics snapshot was undertaken.
GOVT_COURSE_TYPE	NUMBER	(2)	Yes	Government program type of the program selected for inclusion in the enrolment statistics snapshot. See also element No. 310 higher education student data collection documentation 1997, DETYA.
COURSE_TYPE_GROUP_CD	VARCHAR2	(10)		Institution-defined program type group code of the program selected for inclusion within the enrolment statistics snapshot.
SCA_LOCATION_CD	VARCHAR2	(10)	Yes	Location code of the program for the student unit attempt selected for inclusion in the enrolment statistics snapshot.
ATTENDANCE_MODE	VARCHAR2	(2)		Institution-defined attendance mode of the student's program within that the unit is being attempted.
GOVT_ATTENDANCE_MODE	VARCHAR2	(1)		Government attendance mode of the program within that the student unit attempt selected for inclusion in the enrolment statistics snapshot was undertaken. See also element No. 329 higher education student data collection documentation 1997, DETYA.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Institution-defined attendance type of the person selected for inclusion within the enrolment statistics snapshot.
GOVT_ATTENDANCE_TYPE	VARCHAR2	(1)	Yes	Government attendance type of the person selected for inclusion in the enrolment statistics snapshot. See also, element No. 330 higher education student data collection documentation 1997, DETYA.
FUNDING_SOURCE	VARCHAR2	(10)		Code of the institution-defined funding source of the program within the student unit attempt selected for inclusion within the enrolment statistics snapshot was undertaken.
GOVT_FUNDING_SOURCE	NUMBER	(2)		Government funding source of the program selected for inclusion in the enrolment statistics snapshot.
MAJOR_COURSE	NUMBER	(1)	Yes	Instances for that the student is concurrently enrolled in more than one program, this value identifies the student's major program.
COMMENCING_STUDENT_IND	VARCHAR2	(1)	Yes	Indicator that describes whether or not the student is classified as a commencing student within the program selected for inclusion in the enrolment statistics snapshot. Setting the checkbox identifies them as a commencing student.
SCHOOL_LEAVER	NUMBER	(1)	Yes	Describes whether or not the student selected for inclusion in the enrolment statistics snapshot is classified as a school leaver.
NEW_TO_HIGHER_EDUCATION	NUMBER	(1)	Yes	Value that describes whether or not the student is classified as new to higher education for the program of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
SUA_LOCATION_CD	VARCHAR2	(10)	Yes	Location Code of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit Class code of the student unit attempt selected for inclusion in the enrolment statistics snapshot. See also, element No. 354 higher education student data collection documentation 1997, DETYA.
UNIT_LEVEL	VARCHAR2	(4)	Yes	Unit Level of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
ENROLLED_DT	DATE		Yes	Enrolment date for the student unit attempt selected for inclusion in the enrolment statistics snapshot.
DISCONTINUED_DT	DATE			Enrolment discontinuation date for the student unit attempt selected for inclusion in the enrolment statistics snapshot.
EFTSU	NUMBER	(8)	Yes	Effective Full Time Student Unit (EFTSU) is a value of the student unit attempt selected for inclusion in the enrolment statistics snapshot. See also, element No. 339 higher education student data collection documentation 1997, DETYA.
WEFTSU	NUMBER	(8)	Yes	Weighted effective full time student unit( WEFTSU), is a value for the student unit attempt selected for inclusion in the enrolment statistics snapshot.
UNIT_INT_COURSE_LEVEL_CD	VARCHAR2	(10)		Code of the institution-defined unit internal program level used for calculating the weighted effective full time student unit value of the student unit attempt selected for inclusion in the enrolment statistics snapshot.
GOVT_REPORTABLE_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether or not the record should be reported to government in the higher education student data collection returns. Setting the checkbox includes the record.
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 ESS_ID
,      SNAPSHOT_DT_TIME
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      PERSON_ID
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      SUA_CAL_TYPE
,      SUA_CI_SEQUENCE_NUMBER
,      TR_ORG_UNIT_CD
,      TR_OU_START_DT
,      DISCIPLINE_GROUP_CD
,      GOVT_DISCIPLINE_GROUP_CD
,      CRV_ORG_UNIT_CD
,      CRV_OU_START_DT
,      COURSE_TYPE
,      GOVT_COURSE_TYPE
,      COURSE_TYPE_GROUP_CD
,      SCA_LOCATION_CD
,      ATTENDANCE_MODE
,      GOVT_ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      GOVT_ATTENDANCE_TYPE
,      FUNDING_SOURCE
,      GOVT_FUNDING_SOURCE
,      MAJOR_COURSE
,      COMMENCING_STUDENT_IND
,      SCHOOL_LEAVER
,      NEW_TO_HIGHER_EDUCATION
,      SUA_LOCATION_CD
,      UNIT_CLASS
,      UNIT_LEVEL
,      ENROLLED_DT
,      DISCONTINUED_DT
,      EFTSU
,      WEFTSU
,      UNIT_INT_COURSE_LEVEL_CD
,      GOVT_REPORTABLE_IND
,      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_ST_SNAPSHOT;

Dependencies

[top of page]

IGS.IGS_EN_ST_SNAPSHOT does not reference any database object

IGS.IGS_EN_ST_SNAPSHOT is referenced by following:

APPS: IGS_EN_ST_SNAPSHOT