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: HXT.HXT_DET_HOURS_WORKED_F

Object Details

Object Name:	HXT_DET_HOURS_WORKED_F
Object Type:	TABLE
Owner:	HXT
FND Design Data:	HXT.HXT_DET_HOURS_WORKED_F
Subobject Name:
Status:	VALID

A location for describing a specific block of time worked for a
specific date.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXT_DET_HOURS_WORKED_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
HXT_DET_HOURS_WORKED_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID
HXT_DET_HOURS_WORKED_F_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_TYPE_ID
HXT_DET_HOURS_WORKED_F_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RETRO_BATCH_ID
HXT_DET_HOURS_WORKED_F_SUM_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ID
HXT_DET_HOURS_WORKED_F_TIM_FK	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIM_ID DATE_WORKED

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER	(15)	Yes	System generated primary key
PARENT_ID	NUMBER	(15)	Yes	Foreign key to HXT_SUM_HOURS_WORKED
LINE_STATUS	VARCHAR2	(1)		Line status (I) = Null, (E) = Error, (C) = Changed, (W) = Warning
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)		Foreign key to PAY_ELEMENT_TYPES_F record.
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)		HR_LOCATIONS foreign key
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 Rules lookup
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_END_DATE	DATE		Yes	Effective start date
EFFECTIVE_START_DATE	DATE		Yes	Effective end date
JOB_ID	NUMBER	(15)		Foreign key to PER_JOBS record.
EARN_POL_ID	NUMBER	(15)		Foreign Key to HXT_EARNING_POLICIES record.
PREV_WAGE_CODE	VARCHAR2	(10)		Prevailing wage code.
PROJECT_ID	NUMBER	(15)		Foreign key to HXT_PROJECTS (PA_PROJECTS if Project Accounting is installed) record.
RETRO_PBL_LINE_ID	NUMBER	(15)		Retro batch Line id
PBL_LINE_ID	NUMBER	(15)		Batch line id
RETRO_BATCH_ID	NUMBER	(15)		Retro Batch id
PAY_STATUS	VARCHAR2	(1)		Pay Status. States the transfer to BEE status.
PA_STATUS	VARCHAR2	(1)		Transfer to Projects Status
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
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
,      PARENT_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_END_DATE
,      EFFECTIVE_START_DATE
,      JOB_ID
,      EARN_POL_ID
,      PREV_WAGE_CODE
,      PROJECT_ID
,      RETRO_PBL_LINE_ID
,      PBL_LINE_ID
,      RETRO_BATCH_ID
,      PAY_STATUS
,      PA_STATUS
,      OBJECT_VERSION_NUMBER
,      STATE_NAME
,      COUNTY_NAME
,      CITY_NAME
,      ZIP_CODE
FROM HXT.HXT_DET_HOURS_WORKED_F;

Dependencies

[top of page]

HXT.HXT_DET_HOURS_WORKED_F does not reference any database object

HXT.HXT_DET_HOURS_WORKED_F is referenced by following:

APPS: HXT_DET_HOURS_WORKED_F; HXT_DET_HOURS_WORKED_F_WHO