FND Design Data [Home] [Help]

View: PAYBV_US_FEDERAL_TAX_INFO_F_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAYBV_US_FEDERAL_TAX_INFO_F_V
View Text

SELECT PUFTI.EFFECTIVE_START_DATE
, PUFTI.EFFECTIVE_END_DATE
, PUFTI.FUTA_WAGE_LIMIT
, PUFTI.FUTA_RATE
, PUFTI.SS_EE_WAGE_LIMIT
, PUFTI.SS_EE_RATE
, PUFTI.SS_ER_WAGE_LIMIT
, PUFTI.SS_ER_RATE
, PUFTI.MEDI_EE_RATE
, PUFTI.MEDI_ER_RATE
, PUFTI.PROGRAM_UPDATE_DATE /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:FEDERAL TAX RATE INFO DF:PUFTI' /* ID COLUMNS */
, FEDERAL_TAX_INFO_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID /* WHO COLUMNS */
, PUFTI.LAST_UPDATE_DATE
, PUFTI.LAST_UPDATED_BY
, PUFTI.CREATED_BY
, PUFTI.CREATION_DATE
FROM PAY_US_FEDERAL_TAX_INFO_F PUFTI WITH READ ONLY

Columns

Name
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
FUTA_WAGE_LIMIT
FUTA_RATE
SS_EE_WAGE_LIMIT
SS_EE_RATE
SS_ER_WAGE_LIMIT
SS_ER_RATE
MEDI_EE_RATE
MEDI_ER_RATE
PROGRAM_UPDATE_DATE
"_DF:PUFTI"
FEDERAL_TAX_INFO_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE