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_VERIFY_DATA_T

Object Details

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

Temp table to store data during the 'Verify HESA Return' concurrent process

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER			Person ID
COURSE_CD	VARCHAR2	(6)		Course code
CRV_VERSION_NUMBER	NUMBER	(3)		Course version number
CAL_TYPE	VARCHAR2	(10)		Calendar type
LOCATION_CD	VARCHAR2	(10)		Location code
ATTENDANCE_MODE	VARCHAR2	(2)		Attendance mode
ATTENDANCE_TYPE	VARCHAR2	(2)		Attendance type
UNIT_SET_CD	VARCHAR2	(10)		Unit set code
US_VERSION_NUMBER	NUMBER	(3)		Unit set version number
UNIT_CD	VARCHAR2	(10)		Unit Code
U_VERSION_NUMBER	NUMBER	(3)		Unit version number
FIELDS_AFFECTED	VARCHAR2	(30)		Fields affected by the association code
ASSOCIATION_CODE	VARCHAR2	(30)		Association Code
DISPLAY_TITLE	VARCHAR2	(80)		Display Title of Code
OSS_VALUE	VARCHAR2	(80)		Unmapped OSS value
SPA_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA SPA details
QUALAIM_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA SPA Qualaim details
SIN_FLAG	VARCHAR2	(1)		Flag to indicate existence of Student Instance Number
SUSA_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA SUSA details
PROG_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA PROG details
POOUS_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA POOUS Flag
UNIT_FLAG	VARCHAR2	(1)		Flag to indicate existence of HESA Unit details
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	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 PERSON_ID
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_CD
,      U_VERSION_NUMBER
,      FIELDS_AFFECTED
,      ASSOCIATION_CODE
,      DISPLAY_TITLE
,      OSS_VALUE
,      SPA_FLAG
,      QUALAIM_FLAG
,      SIN_FLAG
,      SUSA_FLAG
,      PROG_FLAG
,      POOUS_FLAG
,      UNIT_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_HE_VERIFY_DATA_T;

Dependencies

[top of page]

IGS.IGS_HE_VERIFY_DATA_T does not reference any database object

IGS.IGS_HE_VERIFY_DATA_T is referenced by following:

APPS: IGS_HE_VERIFY_DATA_T