[Home] [Help] [Dependency Information]
Object Name: | PAY_US_WAGES_W2C_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_WAGES_W2C_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
YEAR | NUMBER | |||
EFFECTIVE_DATE | DATE | Yes | ||
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | ||
TAX_UNIT_ID | NUMBER | (15) | ||
ACTION_STATUS | VARCHAR2 | (1) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
LAST_NAME | VARCHAR2 | (4000) | ||
FIRST_NAME | VARCHAR2 | (4000) | ||
MIDDLE_NAME | VARCHAR2 | (1) | ||
PRE_NAME_ADJUNT | VARCHAR2 | (4000) | ||
SSN | VARCHAR2 | (4000) | ||
TERMINATION_REASON | VARCHAR2 | (30) | ||
SORT_LOCATION_ID | NUMBER | (15) | ||
SORT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
W2_WAGES_TIPS_COMPENSATION | NUMBER | |||
W2_FED_IT_WITHHELD | NUMBER | |||
W2_SOCIAL_SECURITY_WAGES | NUMBER | |||
W2_SST_WITHHELD | NUMBER | |||
W2_MED_WAGES_TIPS | NUMBER | |||
W2_MED_TAX_WITHHELD | NUMBER | |||
W2_SOCIAL_SECURITY_TIPS | NUMBER | |||
W2_ALLOCATED_TIPS | NUMBER | |||
W2_ADV_EIC_PAYMENT | NUMBER | |||
W2_DEPENDENT_CARE_BEN | NUMBER | |||
W2_NONQUAL_PLANS | NUMBER | |||
W2_STATUTORY_EMPLOYEE | VARCHAR2 | (4000) | ||
W2_RETIREMENT_PLAN | VARCHAR2 | (4000) | ||
W2_THIRD_PARTY_SICK_PAY | VARCHAR2 | (4000) | ||
GROSS_1099R | NUMBER | |||
REPORT_TYPE | VARCHAR2 | (30) |
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
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAME
, PRE_NAME_ADJUNT
, SSN
, TERMINATION_REASON
, SORT_LOCATION_ID
, SORT_ORGANIZATION_ID
, W2_WAGES_TIPS_COMPENSATION
, W2_FED_IT_WITHHELD
, W2_SOCIAL_SECURITY_WAGES
, W2_SST_WITHHELD
, W2_MED_WAGES_TIPS
, W2_MED_TAX_WITHHELD
, W2_SOCIAL_SECURITY_TIPS
, W2_ALLOCATED_TIPS
, W2_ADV_EIC_PAYMENT
, W2_DEPENDENT_CARE_BEN
, W2_NONQUAL_PLANS
, W2_STATUTORY_EMPLOYEE
, W2_RETIREMENT_PLAN
, W2_THIRD_PARTY_SICK_PAY
, GROSS_1099R
, REPORT_TYPE
FROM APPS.PAY_US_WAGES_W2C_V;
|
|
|