DBA Data[Home] [Help] [Dependency Information]

TABLE: HXC.HXC_ABSENCE_TYPE_ELEMENTS

Object Details
Object Name: HXC_ABSENCE_TYPE_ELEMENTS
Object Type: TABLE
Owner: HXC
FND Design Data: TableHXC.HXC_ABSENCE_TYPE_ELEMENTS
Subobject Name:
Status: VALID


HXC_ABSENCE_TYPE_ELEMENTS table holds the information regarding Elements having an Absence Attendance Type attached to it, which are imported inot Oracle Time and Labor using the Generate Flexfield and Mapping Process. HXC_ABSENCE_TYPE_ELEMENTS hold the information for the "Configure Absences" Screen introduced for entering Alternate Name Definitions for Absence Elements imported via the Generate Flexfield and Mapping Process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXC_ABSENCE_TYPE_ELEMENTS_FK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_TYPE_ID
ColumnABSENCE_ATTENDANCE_TYPE_ID
HXC_ABSENCE_TYPE_ELEMENTS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnABSENCE_ATTENDANCE_TYPE_ID
ColumnELEMENT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
ABSENCE_ATTENDANCE_TYPE_ID NUMBER (15)
Stores the Absence Attendance type id of the Element imported to OTL
ELEMENT_TYPE_ID NUMBER (15)
Element Type Id of the Absence Element
EDIT_FLAG VARCHAR2 (1)
Holds the Flag which determines whether PrePopulated entries against the Absence Element could be edited or not in OTL.
UOM VARCHAR2 (10)
Unit of Measure
ABSENCE_CATEGORY VARCHAR2 (30)
Absence Category of the Absence Type attached to the element
Query Text

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


SELECT ABSENCE_ATTENDANCE_TYPE_ID
,      ELEMENT_TYPE_ID
,      EDIT_FLAG
,      UOM
,      ABSENCE_CATEGORY
FROM HXC.HXC_ABSENCE_TYPE_ELEMENTS;

Dependencies

[top of page]

HXC.HXC_ABSENCE_TYPE_ELEMENTS does not reference any database object

HXC.HXC_ABSENCE_TYPE_ELEMENTS is referenced by following:

SchemaHXC
ViewHXC_ABSENCE_TYPE_ELEMENTS#