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

TABLE: HXT.HXT_SUM_HOURS_WORKED_F_AR

Object Details
Object Name: HXT_SUM_HOURS_WORKED_F_AR
Object Type: TABLE
Owner: HXT
Subobject Name:
Status: VALID


Archive Tables for OTLR records


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXT_SUM_HOURS_WORKED_AR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
HXT_SUM_HOURS_WORKED_AR_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIM_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ID
LINE_STATUS VARCHAR2 (1)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.LINE_STATUS
TIM_ID NUMBER (15) Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TIM_ID
DATE_WORKED DATE
Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.DATE_WORKED
ASSIGNMENT_ID NUMBER (10) Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ASSIGNMENT_ID
HOURS NUMBER (7) Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.HOURS
TIME_IN DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TIME_IN
TIME_OUT DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TIME_OUT
ELEMENT_TYPE_ID NUMBER (9)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ELEMENT_TYPE_ID
FCL_EARN_REASON_CODE VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.FCL_EARN_REASON_CODE
FFV_COST_CENTER_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.FFV_COST_CENTER_ID
FFV_LABOR_ACCOUNT_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.FFV_LABOR_ACCOUNT_ID
TAS_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TAS_ID
LOCATION_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.LOCATION_ID
SHT_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.SHT_ID
HRW_COMMENT VARCHAR2 (255)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.HRW_COMMENT
FFV_RATE_CODE_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.FFV_RATE_CODE_ID
RATE_MULTIPLE NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.RATE_MULTIPLE
HOURLY_RATE NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.HOURLY_RATE
AMOUNT NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.AMOUNT
FCL_TAX_RULE_CODE VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.FCL_TAX_RULE_CODE
SEPARATE_CHECK_FLAG VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.SEPARATE_CHECK_FLAG
SEQNO NUMBER (5) Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.SEQNO
CREATED_BY NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.CREATED_BY
CREATION_DATE DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.CREATION_DATE
LAST_UPDATED_BY NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.LAST_UPDATED_BY
LAST_UPDATE_DATE DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.LAST_UPDATE_DATE
LAST_UPDATE_LOGIN NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.LAST_UPDATE_LOGIN
ACTUAL_TIME_IN DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ACTUAL_TIME_IN
ACTUAL_TIME_OUT DATE

The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ACTUAL_TIME_OUT
JOB_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.JOB_ID
EARN_POL_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.EARN_POL_ID
PROJECT_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.PROJECT_ID
PREV_WAGE_CODE VARCHAR2 (10)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.PREV_WAGE_CODE
EFFECTIVE_START_DATE DATE
Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.EFFECTIVE_START_DATE
EFFECTIVE_END_DATE DATE
Yes The field stores information about HXT_SUM_HOURS_WORKED_F_AR.EFFECTIVE_END_DATE
ATTRIBUTE_CATEGORY VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE_CATEGORY
ATTRIBUTE1 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE1
ATTRIBUTE2 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE2
ATTRIBUTE3 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE3
ATTRIBUTE4 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE4
ATTRIBUTE5 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE5
ATTRIBUTE6 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE6
ATTRIBUTE7 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE7
ATTRIBUTE8 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE8
ATTRIBUTE9 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE9
ATTRIBUTE10 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE10
ATTRIBUTE11 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE11
ATTRIBUTE12 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE12
ATTRIBUTE13 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE13
ATTRIBUTE14 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE14
ATTRIBUTE15 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE15
ATTRIBUTE16 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE16
ATTRIBUTE17 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE17
ATTRIBUTE18 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE18
ATTRIBUTE19 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE19
ATTRIBUTE20 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE20
ATTRIBUTE21 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE21
ATTRIBUTE22 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE22
ATTRIBUTE23 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE23
ATTRIBUTE24 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE24
ATTRIBUTE25 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE25
ATTRIBUTE26 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE26
ATTRIBUTE27 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE27
ATTRIBUTE28 VARCHAR2 (240)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE28
ATTRIBUTE29 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE29
ATTRIBUTE30 VARCHAR2 (150)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ATTRIBUTE30
OBJECT_VERSION_NUMBER NUMBER (9)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.OBJECT_VERSION_NUMBER
TIME_BUILDING_BLOCK_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN NUMBER (9)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.TIME_BUILDING_BLOCK_OVN
STATE_NAME VARCHAR2 (25)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.STATE_NAME
COUNTY_NAME VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.COUNTY_NAME
CITY_NAME VARCHAR2 (30)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.CITY_NAME
ZIP_CODE VARCHAR2 (10)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.ZIP_CODE
DATA_SET_ID NUMBER (15)
The field stores information about HXT_SUM_HOURS_WORKED_F_AR.DATA_SET_ID
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
,      JOB_ID
,      EARN_POL_ID
,      PROJECT_ID
,      PREV_WAGE_CODE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      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
,      DATA_SET_ID
FROM HXT.HXT_SUM_HOURS_WORKED_F_AR;

Dependencies

[top of page]

HXT.HXT_SUM_HOURS_WORKED_F_AR does not reference any database object

HXT.HXT_SUM_HOURS_WORKED_F_AR is referenced by following:

SchemaHXT
ViewHXT_SUM_HOURS_WORKED_F_AR#