[Home] [Help] [Dependency Information]
Object Name: | PAY_JP_PRE_TAX_OLD# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRE_TAX_ID | NUMBER | (15) | Yes | |
ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ACTION_STATUS | VARCHAR2 | (1) | Yes | |
SALARY_CATEGORY | VARCHAR2 | (30) | ||
TAXABLE_SAL_AMT | NUMBER | (38) | Yes | |
TAXABLE_MAT_AMT | NUMBER | (38) | Yes | |
PREVIOUS_TAXABLE_AMT | NUMBER | (38) | Yes | |
HI_ORGANIZATION_ID | NUMBER | (15) | ||
HI_PREM_EE | NUMBER | (38) | Yes | |
HI_PREM_ER | NUMBER | (38) | Yes | |
WP_ORGANIZATION_ID | NUMBER | (15) | ||
WP_PREM_EE | NUMBER | (38) | Yes | |
WP_PREM_ER | NUMBER | (38) | Yes | |
WPF_ORGANIZATION_ID | NUMBER | (15) | ||
WPF_PREM_EE | NUMBER | (38) | Yes | |
WPF_PREM_ER | NUMBER | (38) | Yes | |
UI_ORGANIZATION_ID | NUMBER | (15) | ||
UI_CATEGORY | VARCHAR2 | (30) | ||
UI_PREM_EE | NUMBER | (38) | Yes | |
UI_SAL_AMT | NUMBER | (38) | Yes | |
WAI_ORGANIZATION_ID | NUMBER | (15) | ||
WAI_CATEGORY | VARCHAR2 | (30) | ||
WAI_SAL_AMT | NUMBER | (38) | Yes | |
ITAX_ORGANIZATION_ID | NUMBER | (15) | ||
ITAX_CATEGORY | VARCHAR2 | (30) | ||
ITAX_YEA_CATEGORY | VARCHAR2 | (30) | ||
ITAX | NUMBER | (38) | Yes | |
ITAX_ADJUSTMENT | NUMBER | (38) | Yes | |
PREVIOUS_ITAX | NUMBER | (38) | Yes | |
LTAX_ORGANIZATION_ID | NUMBER | (15) | ||
LTAX_DISTRICT_CODE | VARCHAR2 | (30) | ||
LTAX_SWOT_NO | VARCHAR2 | (30) | ||
LTAX | NUMBER | (38) | Yes | |
LTAX_LUMPSUM | NUMBER | (38) | Yes | |
SP_LTAX | NUMBER | (38) | Yes | |
SP_LTAX_INCOME | NUMBER | (38) | Yes | |
SP_LTAX_SHI | NUMBER | (38) | Yes | |
SP_LTAX_TO | NUMBER | (38) | Yes | |
CI_PREM_EE | NUMBER | (38) | Yes | |
CI_PREM_ER | NUMBER | (38) | Yes | |
MUTUAL_AID | NUMBER | (38) | Yes | |
DISASTER_TAX_REDUCTION | NUMBER | (38) | Yes | |
SP_LTAX_DISTRICT_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PRE_TAX_ID
, ACTION_ID
, ASSIGNMENT_ACTION_ID
, ACTION_STATUS
, SALARY_CATEGORY
, TAXABLE_SAL_AMT
, TAXABLE_MAT_AMT
, PREVIOUS_TAXABLE_AMT
, HI_ORGANIZATION_ID
, HI_PREM_EE
, HI_PREM_ER
, WP_ORGANIZATION_ID
, WP_PREM_EE
, WP_PREM_ER
, WPF_ORGANIZATION_ID
, WPF_PREM_EE
, WPF_PREM_ER
, UI_ORGANIZATION_ID
, UI_CATEGORY
, UI_PREM_EE
, UI_SAL_AMT
, WAI_ORGANIZATION_ID
, WAI_CATEGORY
, WAI_SAL_AMT
, ITAX_ORGANIZATION_ID
, ITAX_CATEGORY
, ITAX_YEA_CATEGORY
, ITAX
, ITAX_ADJUSTMENT
, PREVIOUS_ITAX
, LTAX_ORGANIZATION_ID
, LTAX_DISTRICT_CODE
, LTAX_SWOT_NO
, LTAX
, LTAX_LUMPSUM
, SP_LTAX
, SP_LTAX_INCOME
, SP_LTAX_SHI
, SP_LTAX_TO
, CI_PREM_EE
, CI_PREM_ER
, MUTUAL_AID
, DISASTER_TAX_REDUCTION
, SP_LTAX_DISTRICT_CODE
FROM HR.PAY_JP_PRE_TAX_OLD#;
|
|
|