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

TABLE: HXC.HXC_ABSENCE_TYPE_ELEMENTS_TEMP

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


HXC_ABSENCE_TYPE_ELEMENTS_TEMP is mainly used for rendering "Configure Absence Types" Self Service Page, for configuring Alternate Names for Absence Type Elements


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ABSENCE_ATTENDANCE_TYPE_ID NUMBER (15)
Holds the Absence Attendance Type Id, which the corresponding element is associated with.
ABSENCE_ATTENDANCE_TYPE_NAME VARCHAR2 (30)
Holds the Absence Attendance Name attached to the corresponding Element
ELEMENT_TYPE_ID NUMBER (15)
Holds the Element Type Id.
ELEMENT_NAME VARCHAR2 (80)
Holds the Element Name.
UOM VARCHAR2 (15)
Unit of Measure of the time entered against the Element
ALIAS_VALUE_NAME VARCHAR2 (400)
Holds the Alternate Name Alias used for this element in OTL
ABSENCE_CATEGORY VARCHAR2 (30)
Holds the Absence Category of the Absence Attendance Type associated with the Element
ABSENCE_CATEGORY_MEANING VARCHAR2 (80)
Holds the meaning of the Absence Category associated
Query Text

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


SELECT ABSENCE_ATTENDANCE_TYPE_ID
,      ABSENCE_ATTENDANCE_TYPE_NAME
,      ELEMENT_TYPE_ID
,      ELEMENT_NAME
,      UOM
,      ALIAS_VALUE_NAME
,      ABSENCE_CATEGORY
,      ABSENCE_CATEGORY_MEANING
FROM HXC.HXC_ABSENCE_TYPE_ELEMENTS_TEMP;

Dependencies

[top of page]

HXC.HXC_ABSENCE_TYPE_ELEMENTS_TEMP does not reference any database object

HXC.HXC_ABSENCE_TYPE_ELEMENTS_TEMP is referenced by following:

SchemaHXC
ViewHXC_ABSENCE_TYPE_ELEMENTS_TEM#