[Home] [Help] [Dependency Information]
Object Name: | PAY_US_WAGES_1099R_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_WAGES_1099R_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 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) | GRE ID | |
ACTION_STATUS | VARCHAR2 | (1) | Yes | assignment action status |
PERSON_ID | NUMBER | (10) | Yes | Person ID |
LAST_NAME | VARCHAR2 | (4000) | Last Name | |
FIRST_NAME | VARCHAR2 | (4000) | First Name | |
MIDDLE_NAME | VARCHAR2 | (1) | Middle Name | |
PRE_NAME_ADJUNT | VARCHAR2 | (4000) | Pre Fix | |
SSN | VARCHAR2 | (4000) | Social Security Number | |
TERMINATION_REASON | VARCHAR2 | (30) | reason of termination | |
SORT_LOCATION_ID | NUMBER | (15) | Location used in Sorting | |
SORT_ORGANIZATION_ID | NUMBER | (15) | Yes | Organization used in sorting |
FEDERAL_EIN | VARCHAR2 | (4000) | Federal E | |
TAX_UNIT_NAME | VARCHAR2 | (4000) | GRE Name | |
TAXABLE_AMOUNT_UNKNOWN | VARCHAR2 | (4000) | Taxable Amount not Known | |
TOTAL_DISTRIBUTIONS | VARCHAR2 | (4000) | Total Distributions | |
EMPLOYEE_DISTRIBUTION_PERCENT | VARCHAR2 | (4000) | Employee Distribution Percentage | |
TOTAL_DISTRIBUTION_PERCENT | VARCHAR2 | (4000) | Total Distribution Percentage | |
WAGES_TIPS_COMPENSATION | NUMBER | Wages Tips and Compensation | ||
TAXABLE_AMT_1099R | NUMBER | Taxable Amount for 1099r | ||
FED_IT_WITHHELD | NUMBER | FIT | ||
GROSS_1099R | NUMBER | Gross | ||
CAPITAL_GAIN | NUMBER | Capital Gain | ||
EE_CONTRIBUTIONS_OR_PREMIUMS | NUMBER | Employee Contributiobns or insurance premimus | ||
UNREALIZED_NET_ER_SECURITY | NUMBER | Net unrealized appreciation in employer securities | ||
OTHER_EE_ANNUITY_CONTRACT_AMT | NUMBER | Other Employee Annuity Contract Amount | ||
TOTAL_EE_CONTRIBUTIONS | NUMBER | Total Employee Contributions | ||
IRR_AMOUNT | NUMBER | IRR Amount | ||
DISTRIBUTION_CODE | VARCHAR2 | (4000) | Distribution Code | |
DEFFERAL_YEAR | VARCHAR2 | (4000) |
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
, FEDERAL_EIN
, TAX_UNIT_NAME
, TAXABLE_AMOUNT_UNKNOWN
, TOTAL_DISTRIBUTIONS
, EMPLOYEE_DISTRIBUTION_PERCENT
, TOTAL_DISTRIBUTION_PERCENT
, WAGES_TIPS_COMPENSATION
, TAXABLE_AMT_1099R
, FED_IT_WITHHELD
, GROSS_1099R
, CAPITAL_GAIN
, EE_CONTRIBUTIONS_OR_PREMIUMS
, UNREALIZED_NET_ER_SECURITY
, OTHER_EE_ANNUITY_CONTRACT_AMT
, TOTAL_EE_CONTRIBUTIONS
, IRR_AMOUNT
, DISTRIBUTION_CODE
, DEFFERAL_YEAR
FROM APPS.PAY_US_WAGES_1099R_V;
|
|
|