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: HRI.HRI_MB_UTL_ABSNC_CT

Object Details

Object Name:	HRI_MB_UTL_ABSNC_CT
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_MB_UTL_ABSNC_CT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ABSENCE_SK_FK EFFECTIVE_DATE
HRI_MB_UTL_ABSNC_CT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ABS_PERSON_ID EFFECTIVE_DATE

Columns

Name	Datatype	Length	Mandatory
ABSENCE_SK_FK	NUMBER		Yes
EFFECTIVE_DATE	DATE		Yes
ABS_DRTN_DAYS	NUMBER
ABS_DRTN_HRS	NUMBER
ABS_BLNC_IND	NUMBER
ABS_START_IND	NUMBER
ABS_END_IND	NUMBER
ABS_NTFCTN_DAYS_BLNC	NUMBER
ABS_PERSON_ID	NUMBER	(10)	Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE

Query Text

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


SELECT ABSENCE_SK_FK
,      EFFECTIVE_DATE
,      ABS_DRTN_DAYS
,      ABS_DRTN_HRS
,      ABS_BLNC_IND
,      ABS_START_IND
,      ABS_END_IND
,      ABS_NTFCTN_DAYS_BLNC
,      ABS_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_MB_UTL_ABSNC_CT;

Dependencies

[top of page]

HRI.HRI_MB_UTL_ABSNC_CT does not reference any database object

HRI.HRI_MB_UTL_ABSNC_CT is referenced by following:

APPS: HRI_MB_UTL_ABSNC_CT; HRI_MB_UTL_ABSNC_CT_WHO