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_PS_USEC_CPS

Object Details

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

IGS_PS_USEC_CPS captures the credit points for a unit section.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PS_USEC_CPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_SEC_CREDIT_POINTS_ID
IGS_PS_USEC_CPS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	UOO_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_SEC_CREDIT_POINTS_ID	NUMBER		Yes	Unique identifier of credit points for a unit section.
UOO_ID	NUMBER	(7)	Yes	Unit section identifier
MINIMUM_CREDIT_POINTS	NUMBER	(6)		Minimum credit points
MAXIMUM_CREDIT_POINTS	NUMBER	(6)		Maximum credit points
VARIABLE_INCREMENT	NUMBER	(6)		Variable increment of credit points
LECTURE_CREDIT_POINTS	NUMBER	(6)		Lecture credit points
LAB_CREDIT_POINTS	NUMBER	(6)		Laboratory credit points
OTHER_CREDIT_POINTS	NUMBER	(6)		Any other credit points
CLOCK_HOURS	NUMBER	(6)		Number of clock hours
BILLING_CREDIT_POINTS	NUMBER			Audit Credit Points
WORK_LOAD_CP_LECTURE	NUMBER	(6)		Work load credit points on lecture
WORK_LOAD_CP_LAB	NUMBER	(6)		Work load credit point for laboratory
CONTINUING_EDUCATION_UNITS	NUMBER	(6)		Units for continuing education
ACHIEVABLE_CREDIT_POINTS	NUMBER	(6)		Number of credit points awarded upon successful completion of the unit section.
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
WORK_LOAD_OTHER	NUMBER	(5)		Work load for any component other than lecture and laboratory
CONTACT_HRS_LECTURE	NUMBER	(5)		Contacts hours for Lecture
CONTACT_HRS_LAB	NUMBER	(5)		Contacts hours for Laboratory
CONTACT_HRS_OTHER	NUMBER	(5)		Contact hours for any component other than lecture and laboratory
BILLING_HRS	NUMBER			Billable Credit Points
NON_SCHD_REQUIRED_HRS	NUMBER	(5)		Non Scheduled Required Hours
FIN_AID_CP	NUMBER	(5)		Financial Aid Credit Points - Obsolete
FIN_AID_HRS	NUMBER	(5)		Financial Aid Hours - Obsolete
EXCLUDE_FROM_MAX_CP_LIMIT	VARCHAR2	(1)		Excludes a unit's achievable credit points from counting in a student's maximum credit points limit.
CLAIMABLE_HOURS	NUMBER	(7)		The maximum hours that a student in a class can claim
ENROLLED_CREDIT_POINTS	NUMBER	(6)		Number of credit points in which the student is considered to be enrolled.

Query Text

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


SELECT UNIT_SEC_CREDIT_POINTS_ID
,      UOO_ID
,      MINIMUM_CREDIT_POINTS
,      MAXIMUM_CREDIT_POINTS
,      VARIABLE_INCREMENT
,      LECTURE_CREDIT_POINTS
,      LAB_CREDIT_POINTS
,      OTHER_CREDIT_POINTS
,      CLOCK_HOURS
,      BILLING_CREDIT_POINTS
,      WORK_LOAD_CP_LECTURE
,      WORK_LOAD_CP_LAB
,      CONTINUING_EDUCATION_UNITS
,      ACHIEVABLE_CREDIT_POINTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WORK_LOAD_OTHER
,      CONTACT_HRS_LECTURE
,      CONTACT_HRS_LAB
,      CONTACT_HRS_OTHER
,      BILLING_HRS
,      NON_SCHD_REQUIRED_HRS
,      FIN_AID_CP
,      FIN_AID_HRS
,      EXCLUDE_FROM_MAX_CP_LIMIT
,      CLAIMABLE_HOURS
,      ENROLLED_CREDIT_POINTS
FROM IGS.IGS_PS_USEC_CPS;

Dependencies

[top of page]

IGS.IGS_PS_USEC_CPS does not reference any database object

IGS.IGS_PS_USEC_CPS is referenced by following:

APPS: IGS_PS_USEC_CPS