[Home] [Help] [Dependency Information]
Object Name: | HXT_PREV_WAGE_BASE# |
---|---|
Object Type: | VIEW |
Owner: | HXT |
Subobject Name: | |
Status: | VALID |
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#;
|
|
|