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: HXC.HXC_PAY_PA_LINK_ALL

Object Details

Object Name:	HXC_PAY_PA_LINK_ALL
Object Type:	TABLE
Owner:	HXC
Subobject Name:
Status:	VALID

Used for Enhanced Projects and payroll integration

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_PAY_PA_LINK_ALL_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_BUILDING_BLOCK_ID OBJECT_VERSION_NUMBER
HXC_PAY_PA_LINK_ALL_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMECARD_ID
HXC_PAY_PA_LINK_ALL_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_LINE_ID
HXC_PAY_PA_LINK_ALL_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Length	Comments
TIME_BUILDING_BLOCK_ID	NUMBER	(15)	Time building block id
OBJECT_VERSION_NUMBER	NUMBER	(15)	System generated version of row.
PROJECT_ID	NUMBER	(15)	Project_id of a Project
TASK_ID	NUMBER	(15)	Task_id of a project's Task.
EXP_TYPE	VARCHAR2	(50)	Expenditure type for a project
BILLABLE_FLAG	VARCHAR2	(5)	Billable Flag
SYSTEM_LINKAGE_FUNCTION	VARCHAR2	(50)	System Linkage Function for a project
JOB_ID	NUMBER	(15)	Indicates the Job ID attached to the building block.
WORK_TYPE_ID	NUMBER	(15)	Indicates the Work Type ID attached to the building block.
LOCATION_ID	NUMBER	(15)	Indicates the Location ID attached to the building block.
ELEMENT_TYPE_ID	NUMBER	(15)	Implicit Foreign Key based on Element Type.
BATCH_LINE_ID	NUMBER	(15)	Indicates the Batch Line id attached to the building block.
BATCH_ID	NUMBER	(15)	Timecard is processed in batch with this batch_id
XFERRED_TO_PA_FLAG	VARCHAR2	(5)	Building block is Tranferred to PA or not
DATE_WORKED	DATE		Date Worked
TIMECARD_ID	NUMBER	(15)	Timecard id

Query Text

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


SELECT TIME_BUILDING_BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      PROJECT_ID
,      TASK_ID
,      EXP_TYPE
,      BILLABLE_FLAG
,      SYSTEM_LINKAGE_FUNCTION
,      JOB_ID
,      WORK_TYPE_ID
,      LOCATION_ID
,      ELEMENT_TYPE_ID
,      BATCH_LINE_ID
,      BATCH_ID
,      XFERRED_TO_PA_FLAG
,      DATE_WORKED
,      TIMECARD_ID
FROM HXC.HXC_PAY_PA_LINK_ALL;

Dependencies

[top of page]

HXC.HXC_PAY_PA_LINK_ALL does not reference any database object

HXC.HXC_PAY_PA_LINK_ALL is referenced by following:

HXC: HXC_PAY_PA_LINK_ALL#