VIEW: HR.PAY_JP_PRE_TAX_OLD#

Source

View Text - Preformatted

select PRE_TAX_ID PRE_TAX_ID, ACTION_ID ACTION_ID, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID, ACTION_STATUS ACTION_STATUS, SALARY_CATEGORY SALARY_CATEGORY, TAXABLE_SAL_AMT TAXABLE_SAL_AMT, TAXABLE_MAT_AMT TAXABLE_MAT_AMT, PREVIOUS_TAXABLE_AMT PREVIOUS_TAXABLE_AMT, HI_ORGANIZATION_ID HI_ORGANIZATION_ID, HI_PREM_EE HI_PREM_EE, HI_PREM_ER HI_PREM_ER, WP_ORGANIZATION_ID WP_ORGANIZATION_ID, WP_PREM_EE WP_PREM_EE, WP_PREM_ER WP_PREM_ER, WPF_ORGANIZATION_ID WPF_ORGANIZATION_ID, WPF_PREM_EE WPF_PREM_EE, WPF_PREM_ER WPF_PREM_ER, UI_ORGANIZATION_ID UI_ORGANIZATION_ID, UI_CATEGORY UI_CATEGORY, UI_PREM_EE UI_PREM_EE, UI_SAL_AMT UI_SAL_AMT, WAI_ORGANIZATION_ID WAI_ORGANIZATION_ID, WAI_CATEGORY WAI_CATEGORY, WAI_SAL_AMT WAI_SAL_AMT, ITAX_ORGANIZATION_ID ITAX_ORGANIZATION_ID, ITAX_CATEGORY ITAX_CATEGORY, ITAX_YEA_CATEGORY ITAX_YEA_CATEGORY, ITAX ITAX, ITAX_ADJUSTMENT ITAX_ADJUSTMENT, PREVIOUS_ITAX PREVIOUS_ITAX, LTAX_ORGANIZATION_ID LTAX_ORGANIZATION_ID, LTAX_DISTRICT_CODE LTAX_DISTRICT_CODE, LTAX_SWOT_NO LTAX_SWOT_NO, LTAX LTAX, LTAX_LUMPSUM LTAX_LUMPSUM, SP_LTAX SP_LTAX, SP_LTAX_INCOME SP_LTAX_INCOME, SP_LTAX_SHI SP_LTAX_SHI, SP_LTAX_TO SP_LTAX_TO, CI_PREM_EE CI_PREM_EE, CI_PREM_ER CI_PREM_ER, MUTUAL_AID MUTUAL_AID, DISASTER_TAX_REDUCTION DISASTER_TAX_REDUCTION, SP_LTAX_DISTRICT_CODE SP_LTAX_DISTRICT_CODE from "HR"."PAY_JP_PRE_TAX_OLD"

View Text - HTML Formatted

SELECT PRE_TAX_ID PRE_TAX_ID
, ACTION_ID ACTION_ID
, ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, ACTION_STATUS ACTION_STATUS
, SALARY_CATEGORY SALARY_CATEGORY
, TAXABLE_SAL_AMT TAXABLE_SAL_AMT
, TAXABLE_MAT_AMT TAXABLE_MAT_AMT
, PREVIOUS_TAXABLE_AMT PREVIOUS_TAXABLE_AMT
, HI_ORGANIZATION_ID HI_ORGANIZATION_ID
, HI_PREM_EE HI_PREM_EE
, HI_PREM_ER HI_PREM_ER
, WP_ORGANIZATION_ID WP_ORGANIZATION_ID
, WP_PREM_EE WP_PREM_EE
, WP_PREM_ER WP_PREM_ER
, WPF_ORGANIZATION_ID WPF_ORGANIZATION_ID
, WPF_PREM_EE WPF_PREM_EE
, WPF_PREM_ER WPF_PREM_ER
, UI_ORGANIZATION_ID UI_ORGANIZATION_ID
, UI_CATEGORY UI_CATEGORY
, UI_PREM_EE UI_PREM_EE
, UI_SAL_AMT UI_SAL_AMT
, WAI_ORGANIZATION_ID WAI_ORGANIZATION_ID
, WAI_CATEGORY WAI_CATEGORY
, WAI_SAL_AMT WAI_SAL_AMT
, ITAX_ORGANIZATION_ID ITAX_ORGANIZATION_ID
, ITAX_CATEGORY ITAX_CATEGORY
, ITAX_YEA_CATEGORY ITAX_YEA_CATEGORY
, ITAX ITAX
, ITAX_ADJUSTMENT ITAX_ADJUSTMENT
, PREVIOUS_ITAX PREVIOUS_ITAX
, LTAX_ORGANIZATION_ID LTAX_ORGANIZATION_ID
, LTAX_DISTRICT_CODE LTAX_DISTRICT_CODE
, LTAX_SWOT_NO LTAX_SWOT_NO
, LTAX LTAX
, LTAX_LUMPSUM LTAX_LUMPSUM
, SP_LTAX SP_LTAX
, SP_LTAX_INCOME SP_LTAX_INCOME
, SP_LTAX_SHI SP_LTAX_SHI
, SP_LTAX_TO SP_LTAX_TO
, CI_PREM_EE CI_PREM_EE
, CI_PREM_ER CI_PREM_ER
, MUTUAL_AID MUTUAL_AID
, DISASTER_TAX_REDUCTION DISASTER_TAX_REDUCTION
, SP_LTAX_DISTRICT_CODE SP_LTAX_DISTRICT_CODE
FROM "HR"."PAY_JP_PRE_TAX_OLD"