[Home] [Help] [Dependency Information]
Object Name: | PAY_US_FEDERAL_ACTION_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_US_FEDERAL_ACTION_INFO_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 |
---|---|---|---|---|
ACTION_NUMBER | NUMBER | (15) | Yes | |
EFFECTIVE_DATE | DATE | |||
ASSIGNMENT_ID | NUMBER | (10) | ||
FIT_GROSS | NUMBER | |||
FIT_WITHHELD | NUMBER | |||
REGULAR_EARNINGS | NUMBER | |||
SUPPLEMENTAL_EARNINGS_FOR_FIT | NUMBER | |||
SUPP_EARNINGS_FOR_NWFIT | NUMBER | |||
PRE_TAX_DEDUCTIONS | NUMBER | |||
PRE_TAX_DEDUCTIONS_FOR_FIT | NUMBER | |||
FIT_SUBJECT_WHABLE | NUMBER | |||
FIT_REDUCED_SUBJECT | NUMBER | |||
SS_EE_TAXABLE | NUMBER | |||
SS_EE_WITHHELD | NUMBER | |||
SS_ER_LIABILITY | NUMBER | |||
SS_ER_TAXABLE | NUMBER | |||
SUPPLEMENTAL_EARNINGS_FOR_SS | NUMBER | |||
PRE_TAX_DEDUCTIONS_FOR_SS | NUMBER | |||
SS_SUBJECT | NUMBER | |||
SS_REDUCED_SUBJECT | NUMBER | |||
MEDICARE_EE_TAXABLE | NUMBER | |||
MEDICARE_EE_WITHHELD | NUMBER | |||
MEDICARE_ER_LIABILITY | NUMBER | |||
MEDICARE_ER_TAXABLE | NUMBER | |||
SUPP_EARNINGS_FOR_MEDICARE | NUMBER | |||
PRE_TAX_DEDUCT_FOR_MEDICARE | NUMBER | |||
MEDICARE_SUBJECT | NUMBER | |||
MEDICARE_REDUCED_SUBJECT | NUMBER | |||
SUPP_EARNINGS_FOR_FUTA | NUMBER | |||
PRE_TAX_DEDUCT_FOR_FUTA | NUMBER | |||
FUTA_TAXABLE | NUMBER | |||
FUTA_LIABILITY | NUMBER | |||
FUTA_SUBJECT | NUMBER | |||
FUTA_REDUCED_SUBJECT | NUMBER | |||
EIC_ADVANCE | NUMBER | |||
MEDICARE_EE_TAXABLE_OVER_LIMIT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_NUMBER
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, FIT_GROSS
, FIT_WITHHELD
, REGULAR_EARNINGS
, SUPPLEMENTAL_EARNINGS_FOR_FIT
, SUPP_EARNINGS_FOR_NWFIT
, PRE_TAX_DEDUCTIONS
, PRE_TAX_DEDUCTIONS_FOR_FIT
, FIT_SUBJECT_WHABLE
, FIT_REDUCED_SUBJECT
, SS_EE_TAXABLE
, SS_EE_WITHHELD
, SS_ER_LIABILITY
, SS_ER_TAXABLE
, SUPPLEMENTAL_EARNINGS_FOR_SS
, PRE_TAX_DEDUCTIONS_FOR_SS
, SS_SUBJECT
, SS_REDUCED_SUBJECT
, MEDICARE_EE_TAXABLE
, MEDICARE_EE_WITHHELD
, MEDICARE_ER_LIABILITY
, MEDICARE_ER_TAXABLE
, SUPP_EARNINGS_FOR_MEDICARE
, PRE_TAX_DEDUCT_FOR_MEDICARE
, MEDICARE_SUBJECT
, MEDICARE_REDUCED_SUBJECT
, SUPP_EARNINGS_FOR_FUTA
, PRE_TAX_DEDUCT_FOR_FUTA
, FUTA_TAXABLE
, FUTA_LIABILITY
, FUTA_SUBJECT
, FUTA_REDUCED_SUBJECT
, EIC_ADVANCE
, MEDICARE_EE_TAXABLE_OVER_LIMIT
FROM APPS.PAY_US_FEDERAL_ACTION_INFO_V;
|
|
|