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_AD_SBMAO_FN_UITT

Object Details

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

IGS_AD_SBMAO_FN_UITT describes academic organizational unit targets set by
planning for a particular funding source and unit internal program level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_AD_SBMAO_FN_UITT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_YR SUBMISSION_NUMBER ORG_UNIT_CD OU_START_DT FUNDING_SOURCE UNIT_INT_COURSE_LEVEL_CD INTAKE_TARGET_TYPE
IGS_AD_SBMAO_FN_UITT_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_UNIT_CD OU_START_DT
IGS_AD_SBMAO_FN_UITT_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTAKE_TARGET_TYPE
IGS_AD_SBMAO_FN_UITT_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNDING_SOURCE
IGS_AD_SBMAO_FN_UITT_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UNIT_INT_COURSE_LEVEL_CD

Columns

Name	Datatype	Length	Mandatory	Comments
SUBMISSION_YR	NUMBER	(4)	Yes	The Higher Education Student Data Collection submission year for target collection.
SUBMISSION_NUMBER	NUMBER	(1)	Yes	The Higher Education Student Data Collection submission number<1,2 or 3> for target collection.
ORG_UNIT_CD	VARCHAR2	(30)	Yes	Describes the organizational unit code for the submission period funding source target
OU_START_DT	DATE		Yes	Describes the organizational unit start date for the submission period funding source unit internal program level target
FUNDING_SOURCE	VARCHAR2	(10)	Yes	Describes the funding source for the submission period organizational unit internal program level target
UNIT_INT_COURSE_LEVEL_CD	VARCHAR2	(10)	Yes	Describes the unit internal program level code for the submission period organizational unit funding source target
INTAKE_TARGET_TYPE	VARCHAR2	(10)	Yes	Describes the type of student target required
TARGET	NUMBER	(8)	Yes	Student intake target. If maximum target exists, then this defines the minimum. The amount type of the target is defined by intake target type definition or can be overridden.
MAX_TARGET	NUMBER	(8)		Shows the maximum target figure
OVERRIDE_S_AMOUNT_TYPE	VARCHAR2	(30)		Allows an override of the amount type of the target. If the target is typically measured as, for example, persons, then the intake target type will define this. The override allows this to be changed to, for example, EFTSU for an individual setting of target.
ACTUAL_ENROLMENT	NUMBER	(8)		Is included so that historical enrollment actual figures can be retained
ACTUAL_ENR_EFFECTIVE_DT	DATE			Contains the date and time when the actual enrollment figures were calculated
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 SUBMISSION_YR
,      SUBMISSION_NUMBER
,      ORG_UNIT_CD
,      OU_START_DT
,      FUNDING_SOURCE
,      UNIT_INT_COURSE_LEVEL_CD
,      INTAKE_TARGET_TYPE
,      TARGET
,      MAX_TARGET
,      OVERRIDE_S_AMOUNT_TYPE
,      ACTUAL_ENROLMENT
,      ACTUAL_ENR_EFFECTIVE_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AD_SBMAO_FN_UITT;

Dependencies

[top of page]

IGS.IGS_AD_SBMAO_FN_UITT does not reference any database object

IGS.IGS_AD_SBMAO_FN_UITT is referenced by following:

APPS: IGS_AD_SBMAO_FN_UITT