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]

VIEW: APPS.IGS_AD_ADM_UT_STT_LD_V

Object Details

Object Name:	IGS_AD_ADM_UT_STT_LD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_AD_ADM_UT_STT_LD_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Describes the load calendar type relationship to administrative unit status to determine load incurred

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique identifier for each row
MEANING	VARCHAR2	(80)	Yes	Meaning associated is the unit attempt status. This field is choosed from IGS_LOOKUPS where LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'.
DESCRIPTION	VARCHAR2	(60)	Yes	Describes the administrative unit status, AUS. Each AUS is mapped to a system unit attempt status and enables further definition of unit attempt statuses. For example, withdrawn early, withdrawn late.
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)	Yes	The name of the system defined unit attempt status that is mapped to the specified administrative unit status. Unit attempt statuses are applied to student unit attempts by the system when defined processes occur. For example, the status discontin is applied when a unit attempt is discontinued.
CLOSED_IND	VARCHAR2	(1)	Yes	Indicator that specifies whether or not the administrative unit status AUS is closed. Setting the checkbox, ticked closes the AUS, making it unavailable for use in new records such as administrative unit status load.
ADMINISTRATIVE_UNIT_STATUS	VARCHAR2	(10)	Yes	An administrative unit status, AUS associated with the specified load calendar instance or teaching calendar combination. AUS is assigned to a unit attempt when it is discontinued, that adds further definition to the unit attempt status. The AUS assigned is dependent on the discontinuation date. The link between AUS and load calendar instance or teaching period is used to define the applicable set of AUSs and whether or not load is incurred when each AUS is assigned to a unit attempt. The latter is achieved through the load incurred indicator.
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type relating to an administrative unit status
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Describes the available teaching calendar types, in combination with load period, load can be incurred
LOAD_INCURRED_IND	VARCHAR2	(1)	Yes	Indicates and specifies if load is incurred when the administrative unit status is assigned to a discontinued student unit attempt in the specified load calendar instance or teaching period combination. Selecting the check box, ticked causes the incurrence of load.
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 ROW_ID
,      MEANING
,      DESCRIPTION
,      UNIT_ATTEMPT_STATUS
,      CLOSED_IND
,      ADMINISTRATIVE_UNIT_STATUS
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      LOAD_INCURRED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_ADM_UT_STT_LD_V;

Dependencies

[top of page]

APPS.IGS_AD_ADM_UT_STT_LD_V references the following:

APPS: IGS_AD_ADM_UNIT_STAT; IGS_AD_ADM_UT_STT_LD; IGS_LOOKUPS_VIEW

APPS.IGS_AD_ADM_UT_STT_LD_V is not referenced by any database object