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

TABLE: HXT.HXT_TIMECLOCK_ERRORS

Object Details
Object Name: HXT_TIMECLOCK_ERRORS
Object Type: TABLE
Owner: HXT
FND Design Data: TableHXT.HXT_TIMECLOCK_ERRORS
Subobject Name:
Status: VALID


HXT_TIMECLOCK_ERRORS contains error messages displayed during the HXT API upload


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXT_TIMECLOCK_ERRORS_PK NORMAL UNIQUE TablespaceAPPS_TS_NOLOGGING ColumnID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes System generated primary key
OTM_ERROR VARCHAR2 (240) Yes Error code
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
ORA_ERROR VARCHAR2 (512)
Oracle app error number
TIMECARD_SOURCE VARCHAR2 (10)
Original timecard source
APPROVER_NUMBER VARCHAR2 (30)
Foreign key to PERSON_ID
EMPLOYEE_NUMBER VARCHAR2 (30)
Foreign key to PERSON_ID record.
DATE_WORKED VARCHAR2 (30)
Date worked within payroll period
START_TIME DATE

Start Time
END_TIME DATE

End Time
HOURS NUMBER (7)
Number of hours worked or absent
EARNING_POLICY VARCHAR2 (30)
Foreign key to HXT_EARNING_POLICIES record.
HOURS_TYPE VARCHAR2 (30)
Type of Hours
EARN_REASON_CODE VARCHAR2 (30)
Reason Code
PROJECT VARCHAR2 (25)
Project
TASK_NUMBER VARCHAR2 (30)
Task Number
LOCATION_CODE VARCHAR2 (20)
Location Code
HRW_COMMENT VARCHAR2 (255)
Comment
RATE_MULTIPLE NUMBER (15)
Rate Multiple
HOURLY_RATE NUMBER (15)
Hourly Rate
AMOUNT NUMBER (15)
Amount
SEPARATE_CHECK_FLAG VARCHAR2 (30)
Separate Check Indicator
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
CONCAT_COST_SEGMENTS VARCHAR2 (240)
Concatenated Cost Allocation Segments
COST_SEGMENT1 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT2 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT3 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT4 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT5 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT6 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT7 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT8 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT9 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT10 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT11 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT12 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT13 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT14 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT15 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT16 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT17 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT18 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT19 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT20 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT21 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT22 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT23 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT24 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT25 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT26 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT27 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT28 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT29 VARCHAR2 (60)
Cost Allocation Key Flex segment
COST_SEGMENT30 VARCHAR2 (60)
Cost Allocation Key Flex segment
TIME_SUMMARY_ID NUMBER (15)
Foreign key to HXT_SUM_HOURS_WORKED_F record
TIM_SUM_EFF_END_DATE DATE

Foreign key to HXT_SUM_HOURS_WORKED_F Effective End Date
TIM_SUM_EFF_START_DATE DATE

Foreign key to HXT_SUM_HOURS_WORKED_F Effective Start Date
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT ID
,      OTM_ERROR
,      CREATION_DATE
,      CREATED_BY
,      ORA_ERROR
,      TIMECARD_SOURCE
,      APPROVER_NUMBER
,      EMPLOYEE_NUMBER
,      DATE_WORKED
,      START_TIME
,      END_TIME
,      HOURS
,      EARNING_POLICY
,      HOURS_TYPE
,      EARN_REASON_CODE
,      PROJECT
,      TASK_NUMBER
,      LOCATION_CODE
,      HRW_COMMENT
,      RATE_MULTIPLE
,      HOURLY_RATE
,      AMOUNT
,      SEPARATE_CHECK_FLAG
,      BUSINESS_GROUP_ID
,      CONCAT_COST_SEGMENTS
,      COST_SEGMENT1
,      COST_SEGMENT2
,      COST_SEGMENT3
,      COST_SEGMENT4
,      COST_SEGMENT5
,      COST_SEGMENT6
,      COST_SEGMENT7
,      COST_SEGMENT8
,      COST_SEGMENT9
,      COST_SEGMENT10
,      COST_SEGMENT11
,      COST_SEGMENT12
,      COST_SEGMENT13
,      COST_SEGMENT14
,      COST_SEGMENT15
,      COST_SEGMENT16
,      COST_SEGMENT17
,      COST_SEGMENT18
,      COST_SEGMENT19
,      COST_SEGMENT20
,      COST_SEGMENT21
,      COST_SEGMENT22
,      COST_SEGMENT23
,      COST_SEGMENT24
,      COST_SEGMENT25
,      COST_SEGMENT26
,      COST_SEGMENT27
,      COST_SEGMENT28
,      COST_SEGMENT29
,      COST_SEGMENT30
,      TIME_SUMMARY_ID
,      TIM_SUM_EFF_END_DATE
,      TIM_SUM_EFF_START_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HXT.HXT_TIMECLOCK_ERRORS;

Dependencies

[top of page]

HXT.HXT_TIMECLOCK_ERRORS does not reference any database object

HXT.HXT_TIMECLOCK_ERRORS is referenced by following:

SchemaHXT
ViewHXT_TIMECLOCK_ERRORS#