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_SUBMSN_HEADER

Object Details

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

Holds the information about the Submission headers i.e parameters that need to be applied across all the returns included in the Submission.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_HE_SUBMSN_HEADER_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUBMISSION_NAME
IGS_HE_SUBMSN_HEADER_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SUB_HDR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUB_HDR_ID	NUMBER		Yes	Sequence generated column for uniquely identifying the submission headers
SUBMISSION_NAME	VARCHAR2	(50)	Yes	Contains the Submission Name
DESCRIPTION	VARCHAR2	(200)	Yes	Description of the Submission
ENROLMENT_START_DATE	DATE		Yes	Indicates the start date of the Enrollment period for which this submission is being defined
ENROLMENT_END_DATE	DATE		Yes	Indicates the end date of the Enrollment period for which this submission is being defined
OFFSET_DAYS	NUMBER			Offset Days that need be applied to the filter
APPLY_TO_ATMPT_ST_DT	VARCHAR2	(3)		Indicates whether offset days are to be applied to Program Attempt Start Date
APPLY_TO_INST_ST_DT	VARCHAR2	(3)		Indicate whether offset days are to be applied to Calendar Instance Start Date
COMPLETE_FLAG	VARCHAR2	(3)	Yes	Indicates whether the submission has been completed. A submission is marked as completed if it has been sent and verified by HESA successfully.
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
VALIDATION_COUNTRY	VARCHAR2	(30)		The code that identifies the validation country to be used when running the HESA validation kit

Query Text

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


SELECT SUB_HDR_ID
,      SUBMISSION_NAME
,      DESCRIPTION
,      ENROLMENT_START_DATE
,      ENROLMENT_END_DATE
,      OFFSET_DAYS
,      APPLY_TO_ATMPT_ST_DT
,      APPLY_TO_INST_ST_DT
,      COMPLETE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      VALIDATION_COUNTRY
FROM IGS.IGS_HE_SUBMSN_HEADER;

Dependencies

[top of page]

IGS.IGS_HE_SUBMSN_HEADER does not reference any database object

IGS.IGS_HE_SUBMSN_HEADER is referenced by following:

APPS: IGS_HE_SUBMSN_HEADER