VIEW: HXT.HXT_DET_HOURS_WORKED_F_AR#

Source

View Text - Preformatted

select ID ID, PARENT_ID PARENT_ID, LINE_STATUS LINE_STATUS, TIM_ID TIM_ID, DATE_WORKED DATE_WORKED, ASSIGNMENT_ID ASSIGNMENT_ID, HOURS HOURS, TIME_IN TIME_IN, TIME_OUT TIME_OUT, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, FCL_EARN_REASON_CODE FCL_EARN_REASON_CODE, FFV_COST_CENTER_ID FFV_COST_CENTER_ID, FFV_LABOR_ACCOUNT_ID FFV_LABOR_ACCOUNT_ID, TAS_ID TAS_ID, LOCATION_ID LOCATION_ID, SHT_ID SHT_ID, HRW_COMMENT HRW_COMMENT, FFV_RATE_CODE_ID FFV_RATE_CODE_ID, RATE_MULTIPLE RATE_MULTIPLE, HOURLY_RATE HOURLY_RATE, AMOUNT AMOUNT, FCL_TAX_RULE_CODE FCL_TAX_RULE_CODE, SEPARATE_CHECK_FLAG SEPARATE_CHECK_FLAG, SEQNO SEQNO, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACTUAL_TIME_IN ACTUAL_TIME_IN, ACTUAL_TIME_OUT ACTUAL_TIME_OUT, JOB_ID JOB_ID, EARN_POL_ID EARN_POL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PBL_LINE_ID PBL_LINE_ID, RETRO_PBL_LINE_ID RETRO_PBL_LINE_ID, PROJECT_ID PROJECT_ID, PREV_WAGE_CODE PREV_WAGE_CODE, PA_STATUS PA_STATUS, PAY_STATUS PAY_STATUS, RETRO_BATCH_ID RETRO_BATCH_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STATE_NAME STATE_NAME, COUNTY_NAME COUNTY_NAME, CITY_NAME CITY_NAME, ZIP_CODE ZIP_CODE, DATA_SET_ID DATA_SET_ID from "HXT"."HXT_DET_HOURS_WORKED_F_AR"

View Text - HTML Formatted

SELECT ID ID
, PARENT_ID PARENT_ID
, LINE_STATUS LINE_STATUS
, TIM_ID TIM_ID
, DATE_WORKED DATE_WORKED
, ASSIGNMENT_ID ASSIGNMENT_ID
, HOURS HOURS
, TIME_IN TIME_IN
, TIME_OUT TIME_OUT
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, FCL_EARN_REASON_CODE FCL_EARN_REASON_CODE
, FFV_COST_CENTER_ID FFV_COST_CENTER_ID
, FFV_LABOR_ACCOUNT_ID FFV_LABOR_ACCOUNT_ID
, TAS_ID TAS_ID
, LOCATION_ID LOCATION_ID
, SHT_ID SHT_ID
, HRW_COMMENT HRW_COMMENT
, FFV_RATE_CODE_ID FFV_RATE_CODE_ID
, RATE_MULTIPLE RATE_MULTIPLE
, HOURLY_RATE HOURLY_RATE
, AMOUNT AMOUNT
, FCL_TAX_RULE_CODE FCL_TAX_RULE_CODE
, SEPARATE_CHECK_FLAG SEPARATE_CHECK_FLAG
, SEQNO SEQNO
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ACTUAL_TIME_IN ACTUAL_TIME_IN
, ACTUAL_TIME_OUT ACTUAL_TIME_OUT
, JOB_ID JOB_ID
, EARN_POL_ID EARN_POL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PBL_LINE_ID PBL_LINE_ID
, RETRO_PBL_LINE_ID RETRO_PBL_LINE_ID
, PROJECT_ID PROJECT_ID
, PREV_WAGE_CODE PREV_WAGE_CODE
, PA_STATUS PA_STATUS
, PAY_STATUS PAY_STATUS
, RETRO_BATCH_ID RETRO_BATCH_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STATE_NAME STATE_NAME
, COUNTY_NAME COUNTY_NAME
, CITY_NAME CITY_NAME
, ZIP_CODE ZIP_CODE
, DATA_SET_ID DATA_SET_ID
FROM "HXT"."HXT_DET_HOURS_WORKED_F_AR"