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_PLAN_UNITS

Object Details

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

Contains the student planning sheet unit attempt details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_EN_PLAN_UNITS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID CART_ERROR_FLAG
IGS_EN_PLAN_UNITS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TERM_CAL_TYPE TERM_CI_SEQUENCE_NUMBER PERSON_ID COURSE_CD CART_ERROR_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence-generated value.
COURSE_CD	VARCHAR2	(6)	Yes	Code used to identify the program in that the student is enrolled. See also, element 307 higher education student data collection documentation 1997, DETYA.
UOO_ID	NUMBER	(7)	Yes	Unique identifier for a unit offering option.
TERM_CAL_TYPE	VARCHAR2	(10)	Yes	Term calendar type in which this unit has been planned
TERM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Term calendar instance sequence number in which this unit has been planned
NO_ASSESSMENT_IND	VARCHAR2	(1)	Yes	An indicator which specifies whether or not the student is seeking a formal grade for the student unit attempt. Setting the checkbox ticked signifies that the student is simply auditing the unit
SUP_UOO_ID	NUMBER	(7)		Unit section identifier of the superior unit section. This will be populated if the current unit section is a subordinate unit section
OVERRIDE_ENROLLED_CP	NUMBER	(6)		This field describes the enrolled credit point value which applies to the student unit attempt. This value will override that contained in the unit entity.
GRADING_SCHEMA_CODE	VARCHAR2	(10)		Code that describes the grading schema for the program
GS_VERSION_NUMBER	NUMBER	(3)		Holds the Version Number of the Grading Schema
CORE_INDICATOR_CODE	VARCHAR2	(30)		The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. - For future use for admin
ALTERNATIVE_TITLE	VARCHAR2	(90)		This field describes the alternative title for the student unit - For future use for admin
CART_ERROR_FLAG	VARCHAR2	(1)	Yes	Value Y for cart errors of special permission, audit permission, waitlist, other errors. Value N for Planning sheet record. The planning sheet table is being used to store both the planning sheet records and the enrollment cart records, which couldn't take seats but need to be shown and validated in the enrollment/swap cart.To differentiate between these two kinds of records, this column has been added.
SESSION_ID	NUMBER		Yes	Stores the self service session which created this 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

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      UOO_ID
,      TERM_CAL_TYPE
,      TERM_CI_SEQUENCE_NUMBER
,      NO_ASSESSMENT_IND
,      SUP_UOO_ID
,      OVERRIDE_ENROLLED_CP
,      GRADING_SCHEMA_CODE
,      GS_VERSION_NUMBER
,      CORE_INDICATOR_CODE
,      ALTERNATIVE_TITLE
,      CART_ERROR_FLAG
,      SESSION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_EN_PLAN_UNITS;

Dependencies

[top of page]

IGS.IGS_EN_PLAN_UNITS does not reference any database object

IGS.IGS_EN_PLAN_UNITS is referenced by following:

APPS: IGS_EN_PLAN_UNITS