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_HE_SUB_RTN_QUAL

Object Details

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

Stores the Qualifying Period details for a DLHE Submission Return

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_HE_SUB_RTN_QUAL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_NAME USER_RETURN_SUBCLASS RETURN_NAME QUAL_PERIOD_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SUBMISSION_NAME	VARCHAR2	(50)	Yes	Submission Name
USER_RETURN_SUBCLASS	VARCHAR2	(50)	Yes	User Return Subclass
RETURN_NAME	VARCHAR2	(50)	Yes	Return Name
QUAL_PERIOD_CODE	VARCHAR2	(10)	Yes	Qualifying Period Code
QUAL_PERIOD_DESC	VARCHAR2	(80)	Yes	Qualifying Period Description
QUAL_PERIOD_TYPE	VARCHAR2	(1)	Yes	Indicates the type of Students to be picked up for this Qualifying Period. L (Leaver) , R (Research) , M (Manual)
QUAL_PERIOD_START_DATE	DATE		Yes	Effective Start Date of the Qualifying Period
QUAL_PERIOD_END_DATE	DATE		Yes	Effective End Date of the Qualifying Period
CENSUS_DATE	DATE		Yes	Census Date of the Qualifying Period
SURVEY_START_DATE	DATE		Yes	Survey Start Date of the Qualifying Period
SURVEY_END_DATE	DATE		Yes	Survey End Date of the Qualifying Period
CLOSED_IND	VARCHAR2	(1)	Yes	Indicates if this Qualifying Period is open or closed. Takes values Y or N
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_NAME
,      USER_RETURN_SUBCLASS
,      RETURN_NAME
,      QUAL_PERIOD_CODE
,      QUAL_PERIOD_DESC
,      QUAL_PERIOD_TYPE
,      QUAL_PERIOD_START_DATE
,      QUAL_PERIOD_END_DATE
,      CENSUS_DATE
,      SURVEY_START_DATE
,      SURVEY_END_DATE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_SUB_RTN_QUAL;

Dependencies

[top of page]

IGS.IGS_HE_SUB_RTN_QUAL does not reference any database object

IGS.IGS_HE_SUB_RTN_QUAL is referenced by following:

APPS: IGS_HE_SUB_RTN_QUAL