[Home] [Help] [Dependency Information]
Object Name: | PAY_EMP_FED_TAX_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_EMP_FED_TAX_V1 |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ASSIGNMENT_EXTRA_INFO_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | |
WITHHOLDING_ALLOWANCES | NUMBER | |||
ADDITIONAL_WA_AMOUNT | NUMBER | |||
EXCESSIVE_WA_REJECT_DATE | DATE | |||
FILING_STATUS_CODE | VARCHAR2 | (150) | ||
FILING_STATUS | VARCHAR2 | (80) | Yes | |
FIT_ADDITIONAL_TAX | NUMBER | |||
FIT_EXEMPT | VARCHAR2 | (150) | ||
MEDICARE_TAX_EXEMPT | VARCHAR2 | (150) | ||
SS_TAX_EXEMPT | VARCHAR2 | (150) | ||
FUTA_TAX_EXEMPT | VARCHAR2 | (150) | ||
STATUTORY_EMPLOYEE | VARCHAR2 | (150) | ||
CUMULATIVE_TAXATION | VARCHAR2 | (150) | ||
EIC_FILING_STATUS_CODE | VARCHAR2 | (150) | ||
EIC_FILING_STATUS | VARCHAR2 | (80) | Yes | |
W2_FILED_YEAR | VARCHAR2 | (150) | ||
FIT_OVERRIDE_RATE | NUMBER | |||
FIT_OVERRIDE_AMOUNT | NUMBER | |||
RESIDENT_STATE_CODE | VARCHAR2 | (150) | ||
SUPP_TAX_OVERRIDE_RATE | NUMBER | |||
SUI_JURISDICTION_CODE | VARCHAR2 | (150) | ||
SUI_STATE_CODE | VARCHAR2 | (2) | Yes | |
SUI_STATE_NAME | VARCHAR2 | (50) | Yes | |
RESIDENT_LOCALITY | VARCHAR2 | (150) | ||
WORK_LOCALITY | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ASSIGNMENT_EXTRA_INFO_ID
, ASSIGNMENT_ID
, INFORMATION_TYPE
, WITHHOLDING_ALLOWANCES
, ADDITIONAL_WA_AMOUNT
, EXCESSIVE_WA_REJECT_DATE
, FILING_STATUS_CODE
, FILING_STATUS
, FIT_ADDITIONAL_TAX
, FIT_EXEMPT
, MEDICARE_TAX_EXEMPT
, SS_TAX_EXEMPT
, FUTA_TAX_EXEMPT
, STATUTORY_EMPLOYEE
, CUMULATIVE_TAXATION
, EIC_FILING_STATUS_CODE
, EIC_FILING_STATUS
, W2_FILED_YEAR
, FIT_OVERRIDE_RATE
, FIT_OVERRIDE_AMOUNT
, RESIDENT_STATE_CODE
, SUPP_TAX_OVERRIDE_RATE
, SUI_JURISDICTION_CODE
, SUI_STATE_CODE
, SUI_STATE_NAME
, RESIDENT_LOCALITY
, WORK_LOCALITY
FROM APPS.PAY_EMP_FED_TAX_V1;
|
|
|