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]

VIEW: APPS.PAY_US_TERRITORY_W2_V

Object Details

Object Name:	PAY_US_TERRITORY_W2_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_US_TERRITORY_W2_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is used to fetch the values for PuertoRico Employee W-2

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
YEAR	NUMBER			YEAR
EFFECTIVE_DATE	DATE		Yes	EFFECTIVE_DATE
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	PAYROLL_ACTION_ID
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes	ASSIGNMENT_ACTION_ID
ASSIGNMENT_ID	NUMBER	(10)		ASSIGNMENT_ID
TAX_UNIT_ID	NUMBER	(15)		TAX_UNIT_ID
ACTION_STATUS	VARCHAR2	(1)	Yes	ACTION_STATUS
PERSON_ID	VARCHAR2	(30)		PERSON_ID
TERRITORY_ABBREV	VARCHAR2	(240)		TERRITORY_ABBREV
JURISDICTION_CODE	VARCHAR2	(30)	Yes	JURISDICTION_CODE
LAST_NAME	VARCHAR2	(4000)		LAST_NAME
FIRST_NAME	VARCHAR2	(4000)		FIRST_NAME
MIDDLE_NAME	VARCHAR2	(1)		MIDDLE_NAME
SSN	VARCHAR2	(4000)		SSN
MARITAL_STATUS	VARCHAR2	(4000)		MARITAL_STATUS
SPOUSE_SSN	VARCHAR2	(4000)		SPOUSE_SSN
TERRITORY_WAGES	NUMBER			TERRITORY_WAGES
TERRITORY_TAX_WH	NUMBER			TERRITORY_TAX_WH
COMMISSIONS	NUMBER			COMMISSIONS
REIMBURSED_EXPENSES	NUMBER			REIMBURSED_EXPENSES
RETIREMENT_CONTRIBUTION	NUMBER			RETIREMENT_CONTRIBUTION
ALLOWANCES	NUMBER			ALLOWANCES
TIPS	NUMBER			TIPS
COST_OF_PENSION	NUMBER			COST_OF_PENSION
CODA_PLAN	NUMBER			CODA_PLAN
W2_SOCIAL_SECURITY_WAGES	NUMBER			W2_SOCIAL_SECURITY_WAGES
W2_SST_WITHHELD	NUMBER			W2_SST_WITHHELD
W2_MED_WAGES_TIPS	NUMBER			W2_MED_WAGES_TIPS
W2_MED_TAX_WITHHELD	NUMBER			W2_MED_TAX_WITHHELD
W2_SOCIAL_SECURITY_TIPS	NUMBER			W2_SOCIAL_SECURITY_TIPS
UNCOLL_SS_TAX_ON_TIPS	NUMBER			UNCOLL_SS_TAX_ON_TIPS
UNCOLL_MED_TAX_ON_TIPS	NUMBER			UNCOLL_MED_TAX_ON_TIPS
HIRE_ACT_WAGES	NUMBER			HIRE_ACT_WAGES
PR_CHARITABLE_CONTRIBUTIONS	NUMBER			PR_CHARITABLE_CONTRIBUTIONS
PR_DOUBLE_MONEY	NUMBER			PR_DOUBLE_MONEY
W2_HEALTH_COVERAGE	NUMBER			W2_HEALTH_COVERAGE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT YEAR
,      EFFECTIVE_DATE
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      TAX_UNIT_ID
,      ACTION_STATUS
,      PERSON_ID
,      TERRITORY_ABBREV
,      JURISDICTION_CODE
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      SSN
,      MARITAL_STATUS
,      SPOUSE_SSN
,      TERRITORY_WAGES
,      TERRITORY_TAX_WH
,      COMMISSIONS
,      REIMBURSED_EXPENSES
,      RETIREMENT_CONTRIBUTION
,      ALLOWANCES
,      TIPS
,      COST_OF_PENSION
,      CODA_PLAN
,      W2_SOCIAL_SECURITY_WAGES
,      W2_SST_WITHHELD
,      W2_MED_WAGES_TIPS
,      W2_MED_TAX_WITHHELD
,      W2_SOCIAL_SECURITY_TIPS
,      UNCOLL_SS_TAX_ON_TIPS
,      UNCOLL_MED_TAX_ON_TIPS
,      HIRE_ACT_WAGES
,      PR_CHARITABLE_CONTRIBUTIONS
,      PR_DOUBLE_MONEY
,      W2_HEALTH_COVERAGE
FROM APPS.PAY_US_TERRITORY_W2_V;

Dependencies

[top of page]

APPS.PAY_US_TERRITORY_W2_V references the following:

APPS: FF_ARCHIVE_ITEMS; FF_ARCHIVE_ITEM_CONTEXTS; FF_DATABASE_ITEMS; HR_US_W2_REP - show dependent code; PAY_ASSIGNMENT_ACTIONS; PAY_PAYROLL_ACTIONS

APPS.PAY_US_TERRITORY_W2_V is not referenced by any database object