[Home] [Help] [Dependency Information]
Object Name: | HXT_PREV_WAGE_BASE |
---|---|
Object Type: | TABLE |
Owner: | HXT |
FND Design Data: | HXT.HXT_PREV_WAGE_BASE |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HXT_PREV_WAGE_BASE_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
PREV_WAGE_CODE
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREV_WAGE_CODE | VARCHAR2 | (10) | Yes | |
EFFECTIVE_START_DATE | DATE | Yes | ||
EFFECTIVE_END_DATE | DATE | Yes | ||
CONTRACT_NUMBER | VARCHAR2 | (30) | ||
REG_AMT | NUMBER | (15) | ||
OVT_15_AMT | NUMBER | (15) | ||
OVT_20_AMT | NUMBER | (15) | ||
FBE_AMT | NUMBER | (15) | ||
PRINT_FLAG | VARCHAR2 | (1) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
BUILDING_NUMBER | VARCHAR2 | (20) | ||
BUILDING_NAME | VARCHAR2 | (30) | ||
PREV_WAGE_DESC | VARCHAR2 | (40) |
Cut, paste (and edit) the following text to query this object:
SELECT PREV_WAGE_CODE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, CONTRACT_NUMBER
, REG_AMT
, OVT_15_AMT
, OVT_20_AMT
, FBE_AMT
, PRINT_FLAG
, PROJECT_NUMBER
, BUILDING_NUMBER
, BUILDING_NAME
, PREV_WAGE_DESC
FROM HXT.HXT_PREV_WAGE_BASE;
HXT.HXT_PREV_WAGE_BASE does not reference any database object
HXT.HXT_PREV_WAGE_BASE is referenced by following:
|
|
|