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

VIEW: APPS.PAYBV_JP_PRE_TAX_V

Object Details
Object Name: PAYBV_JP_PRE_TAX_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view is used for Japanese localization only.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PRE_TAX_ID NUMBER (15) Yes System-generated primary key column.
ACTION_ID NUMBER

System-generated non-unique column. Used for which row should be processed by PAY_JP_PRE_TAX_PKG.
ASSIGNMENT_ACTION_ID NUMBER

Foreign key to PAY_ASSIGNMENT_ACTIONS.
ACTION_STATUS CHAR (1)
Valid status for the assignment_action_id of PAY_JP_PRE_TAX_PKG process.
SALARY_CATEGORY VARCHAR2 (240)
Salary category.
TAXABLE_SAL_AMT NUMBER

Taxable salary amount (including salary for non-resident and terminator).
TAXABLE_MAT_AMT NUMBER

Taxable material salary amount (including salary for non-resident and terminator).
PREVIOUS_TAXABLE_AMT NUMBER

Taxable amount from previous career.
HI_ORGANIZATION_ID NUMBER

HI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
HI_PREM_EE NUMBER

Employee's premium for HI.
HI_PREM_ER NUMBER

Employer's premium for HI.
WP_ORGANIZATION_ID NUMBER

WP organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WP_PREM_EE NUMBER

Employee's premium for WP.
WP_PREM_ER NUMBER

Employer's premium for WP.
WPF_ORGANIZATION_ID NUMBER

WPF organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WPF_PREM_EE NUMBER

Employee's premium for WPF.
WPF_PREM_ER NUMBER

Employer's premium for WPF.
UI_ORGANIZATION_ID NUMBER

UI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
UI_CATEGORY VARCHAR2 (240)
Employee's caterogy on UI.
UI_PREM_EE NUMBER

Employee's premium for UI.
UI_SAL_AMT NUMBER

Salary amount for UI.
WAI_ORGANIZATION_ID NUMBER

WAI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WAI_CATEGORY VARCHAR2 (240)
Employee's category on WAI.
WAI_SAL_AMT NUMBER

Salary amount for WAI.
ITAX_ORGANIZATION_ID NUMBER

ITAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
ITAX_CATEGORY VARCHAR2 (240)
Employee's category on ITAX calc.
ITAX_YEA_CATEGORY VARCHAR2 (240)
Employee's processing category for (Re-)Year-End-Adjustment(YEA).
ITAX NUMBER

ITAX Amount (Excluding ITAX Adjustment amount for YEA).
ITAX_ADJUSTMENT NUMBER

ITAX Adjustment amount for YEA.
PREVIOUS_ITAX NUMBER

ITAX from previous career.
LTAX_ORGANIZATION_ID NUMBER

LTAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
LTAX_DISTRICT_CODE VARCHAR2 (240)
LTAX DISTRICT Code.
LTAX_SWOT_NO VARCHAR2 (240)
LTAX SWOT Number.
LTAX NUMBER

LTAX amount (excluding lumpsum LTax).
LTAX_LUMPSUM NUMBER

LTAX Amount for lumpsum.
SP_LTAX NUMBER

Special LTAX Amount.
SP_LTAX_INCOME NUMBER

Taxable amount for special LTAX.
SP_LTAX_SHI NUMBER

Special LTAX amount for DISTRICT.
SP_LTAX_TO NUMBER

Special LTAX amount for prefecture.
CI_PREM_EE NUMBER

Employee's premium for CI.
CI_PREM_ER NUMBER

Employer's premium for CI.
MUTUAL_AID NUMBER

Premium for Mutual Aid.
DISASTER_TAX_REDUCTION NUMBER

Disaster Tax Reduction
SP_LTAX_DISTRICT_CODE VARCHAR2 (240)
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 APPS.PAYBV_JP_PRE_TAX_V;

Dependencies

[top of page]

APPS.PAYBV_JP_PRE_TAX_V references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
ViewPAY_JP_PRE_TAX

APPS.PAYBV_JP_PRE_TAX_V is not referenced by any database object