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_RE_CDT_ATT_HIST_ALL

Object Details

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

IGS_RE_CDT_ATT_HIST_ALL describes the history of the attendance of a research student for the duration of their candidature. It stores details of both attendance type and attendance percentage details in a consolidated view. Note, these histories are only stored from date to date, not considering time components. If two changes are made on the same day then the latest change replaces any earlier histories.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_RE_CDT_ATT_HIST_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID CA_SEQUENCE_NUMBER SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Describes the person identifier number for whom the history is entered
CA_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes the candidature sequence number
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Describes an unique identifier for the candidature attendance history
HIST_START_DT	DATE		Yes	Describes the start date and time of the attendance history.
HIST_END_DT	DATE		Yes	Describes the end date and time of the attendance history
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	Describes the attendance type represented in the history
ATTENDANCE_PERCENTAGE	NUMBER	(5)	Yes	Describes the attendance percentage represented in the history.
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
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT PERSON_ID
,      CA_SEQUENCE_NUMBER
,      SEQUENCE_NUMBER
,      HIST_START_DT
,      HIST_END_DT
,      ATTENDANCE_TYPE
,      ATTENDANCE_PERCENTAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGS.IGS_RE_CDT_ATT_HIST_ALL;

Dependencies

[top of page]

IGS.IGS_RE_CDT_ATT_HIST_ALL does not reference any database object

IGS.IGS_RE_CDT_ATT_HIST_ALL is referenced by following:

APPS: IGS_RE_CDT_ATT_HIST_ALL