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: HXC.HXC_ABS_CO_DETAILS

Object Details

Object Name:	HXC_ABS_CO_DETAILS
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_ABS_CO_DETAILS
Subobject Name:
Status:	VALID

HXC_ABS_CO_DETAILS Table holds the information for the PrePopulated entries on a Timecard.
It mainly identifies which time_building_blocks in timecard plsql tables are PrePopulated Absence Entries.
The p_blocks plsql table which is generated while creating a timecard holds all the time entered in the timecard. The time building block ids which are prepopulated absence entries are entered into hxc_abs_co_details. The tbb ids are usually negative in nature, and the set of tbb ids for each timecard are identified by "START_TIME","STOP_TME","SESSIONID","LOCK_ROW_ID", which could identify a timecard opened in a particular session.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_ABS_CO_DETAILS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID
HXC_ABS_CO_DETAILS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCK_ROWID
HXC_ABS_CO_DETAILS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STOP_TIME START_TIME RESOURCE_ID
HXC_ABS_CO_DETAILS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ABSENCE_ATTENDANCE_ID

Columns

Name	Datatype	Length	Comments
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Denotes the Time Building Id in the p_blocks plsql table. This column mainly holds the tbb ids of the prepopulated entries in the timecard.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Time Building Block OVN of the Time Building Block Id
ABSENCE_TYPE_ID	NUMBER	(15)	Absence Attendance Type ID of the Prepopulated Entry
ABSENCE_ATTENDANCE_ID	NUMBER	(15)	Absence Attendance Type Id of the PrePopulated entry
ELEMENT_TYPE_ID	NUMBER	(15)	Element Type Id of Absence Element against which the time is PrePopulated in OTL Timecards.
UOM	VARCHAR2	(50)	Unit of Measure of the PrePopulated Entry
MEASURE	NUMBER	(15)	Measure
START_DATE	DATE		Absence Start Date
END_DATE	DATE		Absence End Date
STAGE	VARCHAR2	(50)	Stage of the PrePopulated entry. PREP depicts 'PrePopulated'; DEP depicts "Deposited" onto Timestore. RET depicts "Online Retrieved onto HR Absences"
SESSIONID	NUMBER	(15)	Holds the session id of the session during which the timecard is PrePopulated.
CO_DATE	DATE		Carryover date: Holds the session date on which Time entry is prepopulated.
LOCK_ROWID	VARCHAR2	(50)	Holds the Lock Row id of the timecard in which the absence entry is prepopulated.
RESOURCE_ID	NUMBER	(15)	Person id against whom the time is prepopulated
START_TIME	DATE		Timecard Start Time
STOP_TIME	DATE		Timecard Stop Time
TRANSACTION_ID	NUMBER	(22)	Records Transaction
ACTION	VARCHAR2	(240)	Records Action
CONFIRMED_FLAG	VARCHAR2	(10)	Records whether confirmed or not

Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      ABSENCE_TYPE_ID
,      ABSENCE_ATTENDANCE_ID
,      ELEMENT_TYPE_ID
,      UOM
,      MEASURE
,      START_DATE
,      END_DATE
,      STAGE
,      SESSIONID
,      CO_DATE
,      LOCK_ROWID
,      RESOURCE_ID
,      START_TIME
,      STOP_TIME
,      TRANSACTION_ID
,      ACTION
,      CONFIRMED_FLAG
FROM HXC.HXC_ABS_CO_DETAILS;

Dependencies

[top of page]

HXC.HXC_ABS_CO_DETAILS does not reference any database object

HXC.HXC_ABS_CO_DETAILS is referenced by following:

HXC: HXC_ABS_CO_DETAILS#