eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PAY_JP_PRE_TAX_OLD

Object Details

Object Name:	PAY_JP_PRE_TAX_OLD
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_JP_PRE_TAX_OLD
Subobject Name:
Status:	VALID

PAY_JP_PRE_TAX_OLD holds Japanese tax amount and information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_JP_PRE_TAX_PK

PRE_TAX_ID

Unique Key: PAY_JP_PRE_TAX_U1

ASSIGNMENT_ACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_JP_PRE_TAX_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRE_TAX_ID
PAY_JP_PRE_TAX_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ACTION_ID
PAY_JP_PRE_TAX_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PRE_TAX_ID	NUMBER	(15)	Yes	System-generated primary key column.
ACTION_ID	NUMBER	(9)	Yes	System-generated non-unique column. Used for which row should be processed by PAY_JP_PRE_TAX_PKG.
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	Foreign key to PAY_ASSIGNMENT_ACTIONS.
ACTION_STATUS	VARCHAR2	(1)	Yes	Valid status for the assignment_action_id of PAY_JP_PRE_TAX_PKG process.
SALARY_CATEGORY	VARCHAR2	(30)		Salary category.
TAXABLE_SAL_AMT	NUMBER	(38)	Yes	Taxable salary amount (including salary for non-resident and terminator).
TAXABLE_MAT_AMT	NUMBER	(38)	Yes	Taxable material salary amount (including salary for non-resident and terminator).
PREVIOUS_TAXABLE_AMT	NUMBER	(38)	Yes	Taxable amount from previous career.
HI_ORGANIZATION_ID	NUMBER	(15)		HI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
HI_PREM_EE	NUMBER	(38)	Yes	Employee's premium for HI.
HI_PREM_ER	NUMBER	(38)	Yes	Employer's premium for HI.
WP_ORGANIZATION_ID	NUMBER	(15)		WP organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WP_PREM_EE	NUMBER	(38)	Yes	Employee's premium for WP.
WP_PREM_ER	NUMBER	(38)	Yes	Employer's premium for WP.
WPF_ORGANIZATION_ID	NUMBER	(15)		WPF organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WPF_PREM_EE	NUMBER	(38)	Yes	Employee's premium for WPF.
WPF_PREM_ER	NUMBER	(38)	Yes	Employee's premium for WPF.
UI_ORGANIZATION_ID	NUMBER	(15)		UI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
UI_CATEGORY	VARCHAR2	(30)		Employee's caterogy on UI.
UI_PREM_EE	NUMBER	(38)	Yes	Employee's premium for UI.
UI_SAL_AMT	NUMBER	(38)	Yes	Salary amount for UI.
WAI_ORGANIZATION_ID	NUMBER	(15)		WAI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WAI_CATEGORY	VARCHAR2	(30)		Employee's category on UI.
WAI_SAL_AMT	NUMBER	(38)	Yes	Salary amount for WAI.
ITAX_ORGANIZATION_ID	NUMBER	(15)		ITAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
ITAX_CATEGORY	VARCHAR2	(30)		Employee's category on ITAX calc.
ITAX_YEA_CATEGORY	VARCHAR2	(30)		Employee's processing category for (Re-)Year-End-Adjustment(YEA).
ITAX	NUMBER	(38)	Yes	ITAX Amount (Excluding ITAX Adjustment amount for YEA).
ITAX_ADJUSTMENT	NUMBER	(38)	Yes	ITAX Adjustment amount for YEA.
PREVIOUS_ITAX	NUMBER	(38)	Yes	ITAX from previous career.
LTAX_ORGANIZATION_ID	NUMBER	(15)		LTAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
LTAX_DISTRICT_CODE	VARCHAR2	(30)		LTAX DISTRICT Code.
LTAX_SWOT_NO	VARCHAR2	(30)		LTAX SWOT Number.
LTAX	NUMBER	(38)	Yes	LTAX amount (excluding lumpsum LTax).
LTAX_LUMPSUM	NUMBER	(38)	Yes	LTAX Amount for lumpsum.
SP_LTAX	NUMBER	(38)	Yes	Special LTAX Amount.
SP_LTAX_INCOME	NUMBER	(38)	Yes	Taxable amount for special LTAX.
SP_LTAX_SHI	NUMBER	(38)	Yes	Special LTAX amount for DISTRICT.
SP_LTAX_TO	NUMBER	(38)	Yes	Special LTAX amount for prefecture.
CI_PREM_EE	NUMBER	(38)	Yes	Employee's premium for CI.
CI_PREM_ER	NUMBER	(38)	Yes	Employer's premium for CI.
MUTUAL_AID	NUMBER	(38)	Yes	Premium for Mutual Aid.
DISASTER_TAX_REDUCTION	NUMBER	(38)	Yes	Disaster Tax Reduction
SP_LTAX_DISTRICT_CODE	VARCHAR2	(30)		Special LTAX DISTRICT Code.

Query Text

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;

Dependencies

[top of page]

HR.PAY_JP_PRE_TAX_OLD does not reference any database object

HR.PAY_JP_PRE_TAX_OLD is referenced by following:

HR: PAY_JP_PRE_TAX_OLD#