[Home] [Help] [Dependency Information]
Object Name: | PAY_US_W2_WAGES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_W2_WAGES_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 | |||
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_BOX1 | NUMBER | |||
W2_BOX2 | NUMBER | |||
W2_BOX3 | NUMBER | |||
W2_BOX4 | NUMBER | |||
W2_BOX5 | NUMBER | |||
W2_BOX6 | NUMBER | |||
W2_BOX7 | NUMBER | |||
W2_BOX8 | NUMBER | |||
W2_BOX9 | NUMBER | |||
W2_BOX10 | NUMBER | |||
W2_BOX11 | NUMBER | |||
W2_BOX12 | NUMBER | |||
W2_BOX15A | VARCHAR2 | (4000) | ||
W2_BOX15B | VARCHAR2 | (4000) | ||
W2_BOX15C | VARCHAR2 | (4000) | ||
W2_BOX15D | VARCHAR2 | (4000) | ||
W2_BOX15F | VARCHAR2 | (4000) | ||
GROSS_1099R | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT YEAR
, 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_BOX1
, W2_BOX2
, W2_BOX3
, W2_BOX4
, W2_BOX5
, W2_BOX6
, W2_BOX7
, W2_BOX8
, W2_BOX9
, W2_BOX10
, W2_BOX11
, W2_BOX12
, W2_BOX15A
, W2_BOX15B
, W2_BOX15C
, W2_BOX15D
, W2_BOX15F
, GROSS_1099R
FROM APPS.PAY_US_W2_WAGES_V;
APPS.PAY_US_W2_WAGES_V is not referenced by any database object
|
|
|