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

TABLE: HXT.HXT_SUM_HOURS_WORKED_F

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


Describes a summary of the number of hours, rate and type of
premium associated with each hour worked in a payroll period..


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXT_SUM_HOURS_WORKED_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
HXT_SUM_HOURS_WORKED_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
HXT_SUM_HOURS_WORKED_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_TYPE_ID
HXT_SUM_HOURS_WORKED_F_TBB_FK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_BUILDING_BLOCK_ID
HXT_SUM_HOURS_WORKED_F_TIM_FK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIM_ID
ColumnDATE_WORKED
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes System generated primary key
LINE_STATUS VARCHAR2 (1)
Line status
TIM_ID NUMBER (15) Yes Foreign key to HXT_TIMECARDS record.
DATE_WORKED DATE
Yes The date the hours were worked or absence was taken
ASSIGNMENT_ID NUMBER (10) Yes Assignment worked
HOURS NUMBER (7) Yes Number of hours worked or absent
TIME_IN DATE

Time in
TIME_OUT DATE

Time out
ELEMENT_TYPE_ID NUMBER (9)
Earning Code
FCL_EARN_REASON_CODE VARCHAR2 (30)
Earning Reason lookup
FFV_COST_CENTER_ID NUMBER (15)
Cost Center identifier
FFV_LABOR_ACCOUNT_ID NUMBER (15)
Labour Account identifier
TAS_ID NUMBER (15)
System generated task primary key
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS record,
SHT_ID NUMBER (15)
System generated shift primary key
HRW_COMMENT VARCHAR2 (255)
Comment
FFV_RATE_CODE_ID NUMBER (15)
Rate Code identifier
RATE_MULTIPLE NUMBER (15)
Rate Multiple factor
HOURLY_RATE NUMBER (15)
Hourly Rate
AMOUNT NUMBER (15)
Amount factor
FCL_TAX_RULE_CODE VARCHAR2 (30)
Tax Rule lookups from Fnd_Common_Lookups
SEPARATE_CHECK_FLAG VARCHAR2 (30)
Separate check
SEQNO NUMBER (5) Yes Sequence Number
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
ACTUAL_TIME_IN DATE

Actual time in
ACTUAL_TIME_OUT DATE

Actual time out
EFFECTIVE_START_DATE DATE
Yes Effective start date
EFFECTIVE_END_DATE DATE
Yes Effective end date.
PROJECT_ID NUMBER (15)
Foreign key to HXT_PROJECTS (PA_PROJECTS if Project accounting is installed) records.
PREV_WAGE_CODE VARCHAR2 (10)
Prevailing wage code
JOB_ID NUMBER (15)
Foreign key to per_jobs record.
EARN_POL_ID NUMBER (15)
Foreign key to HXT_EARNING_POLICIES record.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
TIME_BUILDING_BLOCK_ID NUMBER (15)
Foreign key to HXC_TIME_BUILDING_BLOCKS
TIME_BUILDING_BLOCK_OVN NUMBER (9)
Time Building Block Object Version Number
STATE_NAME VARCHAR2 (25)
US State Name
COUNTY_NAME VARCHAR2 (30)
Country Name
CITY_NAME VARCHAR2 (30)
US City Name
ZIP_CODE VARCHAR2 (10)
US Zip Code
Query Text

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


SELECT ID
,      LINE_STATUS
,      TIM_ID
,      DATE_WORKED
,      ASSIGNMENT_ID
,      HOURS
,      TIME_IN
,      TIME_OUT
,      ELEMENT_TYPE_ID
,      FCL_EARN_REASON_CODE
,      FFV_COST_CENTER_ID
,      FFV_LABOR_ACCOUNT_ID
,      TAS_ID
,      LOCATION_ID
,      SHT_ID
,      HRW_COMMENT
,      FFV_RATE_CODE_ID
,      RATE_MULTIPLE
,      HOURLY_RATE
,      AMOUNT
,      FCL_TAX_RULE_CODE
,      SEPARATE_CHECK_FLAG
,      SEQNO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACTUAL_TIME_IN
,      ACTUAL_TIME_OUT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PROJECT_ID
,      PREV_WAGE_CODE
,      JOB_ID
,      EARN_POL_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      OBJECT_VERSION_NUMBER
,      TIME_BUILDING_BLOCK_ID
,      TIME_BUILDING_BLOCK_OVN
,      STATE_NAME
,      COUNTY_NAME
,      CITY_NAME
,      ZIP_CODE
FROM HXT.HXT_SUM_HOURS_WORKED_F;

Dependencies

[top of page]

HXT.HXT_SUM_HOURS_WORKED_F does not reference any database object

HXT.HXT_SUM_HOURS_WORKED_F is referenced by following:

SchemaHXT
ViewHXT_SUM_HOURS_WORKED_F#