eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PAY_CA_EMP_FED_TAX_INFO_F#

Source

View Text - Preformatted


select EMP_FED_TAX_INF_ID EMP_FED_TAX_INF_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, LEGISLATION_CODE LEGISLATION_CODE, ASSIGNMENT_ID ASSIGNMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EMPLOYMENT_PROVINCE EMPLOYMENT_PROVINCE, TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT, CLAIM_CODE CLAIM_CODE, BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG, ADDITIONAL_TAX ADDITIONAL_TAX, ANNUAL_DEDN ANNUAL_DEDN, TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION, TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION, PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT, OTHER_FEDTAX_CREDITS OTHER_FEDTAX_CREDITS, CPP_QPP_EXEMPT_FLAG CPP_QPP_EXEMPT_FLAG, FED_EXEMPT_FLAG FED_EXEMPT_FLAG, EI_EXEMPT_FLAG EI_EXEMPT_FLAG, TAX_CALC_METHOD TAX_CALC_METHOD, FED_OVERRIDE_AMOUNT FED_OVERRIDE_AMOUNT, FED_OVERRIDE_RATE FED_OVERRIDE_RATE, CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY, CA_TAX_INFORMATION1 CA_TAX_INFORMATION1, CA_TAX_INFORMATION2 CA_TAX_INFORMATION2, CA_TAX_INFORMATION3 CA_TAX_INFORMATION3, CA_TAX_INFORMATION4 CA_TAX_INFORMATION4, CA_TAX_INFORMATION5 CA_TAX_INFORMATION5, CA_TAX_INFORMATION6 CA_TAX_INFORMATION6, CA_TAX_INFORMATION7 CA_TAX_INFORMATION7, CA_TAX_INFORMATION8 CA_TAX_INFORMATION8, CA_TAX_INFORMATION9 CA_TAX_INFORMATION9, CA_TAX_INFORMATION10 CA_TAX_INFORMATION10, CA_TAX_INFORMATION11 CA_TAX_INFORMATION11, CA_TAX_INFORMATION12 CA_TAX_INFORMATION12, CA_TAX_INFORMATION13 CA_TAX_INFORMATION13, CA_TAX_INFORMATION14 CA_TAX_INFORMATION14, CA_TAX_INFORMATION15 CA_TAX_INFORMATION15, CA_TAX_INFORMATION16 CA_TAX_INFORMATION16, CA_TAX_INFORMATION17 CA_TAX_INFORMATION17, CA_TAX_INFORMATION18 CA_TAX_INFORMATION18, CA_TAX_INFORMATION19 CA_TAX_INFORMATION19, CA_TAX_INFORMATION20 CA_TAX_INFORMATION20, CA_TAX_INFORMATION21 CA_TAX_INFORMATION21, CA_TAX_INFORMATION22 CA_TAX_INFORMATION22, CA_TAX_INFORMATION23 CA_TAX_INFORMATION23, CA_TAX_INFORMATION24 CA_TAX_INFORMATION24, CA_TAX_INFORMATION25 CA_TAX_INFORMATION25, CA_TAX_INFORMATION26 CA_TAX_INFORMATION26, CA_TAX_INFORMATION27 CA_TAX_INFORMATION27, CA_TAX_INFORMATION28 CA_TAX_INFORMATION28, CA_TAX_INFORMATION29 CA_TAX_INFORMATION29, CA_TAX_INFORMATION30 CA_TAX_INFORMATION30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, FED_LSF_AMOUNT FED_LSF_AMOUNT, CPP_ELECTION_DATE CPP_ELECTION_DATE, CPP_REVOCATION_DATE CPP_REVOCATION_DATE from "HR"."PAY_CA_EMP_FED_TAX_INFO_F"

View Text - HTML Formatted

SELECT EMP_FED_TAX_INF_ID EMP_FED_TAX_INF_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, LEGISLATION_CODE LEGISLATION_CODE
, ASSIGNMENT_ID ASSIGNMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EMPLOYMENT_PROVINCE EMPLOYMENT_PROVINCE
, TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT
, CLAIM_CODE CLAIM_CODE
, BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG
, ADDITIONAL_TAX ADDITIONAL_TAX
, ANNUAL_DEDN ANNUAL_DEDN
, TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION
, TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION
, PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT
, OTHER_FEDTAX_CREDITS OTHER_FEDTAX_CREDITS
, CPP_QPP_EXEMPT_FLAG CPP_QPP_EXEMPT_FLAG
, FED_EXEMPT_FLAG FED_EXEMPT_FLAG
, EI_EXEMPT_FLAG EI_EXEMPT_FLAG
, TAX_CALC_METHOD TAX_CALC_METHOD
, FED_OVERRIDE_AMOUNT FED_OVERRIDE_AMOUNT
, FED_OVERRIDE_RATE FED_OVERRIDE_RATE
, CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY
, CA_TAX_INFORMATION1 CA_TAX_INFORMATION1
, CA_TAX_INFORMATION2 CA_TAX_INFORMATION2
, CA_TAX_INFORMATION3 CA_TAX_INFORMATION3
, CA_TAX_INFORMATION4 CA_TAX_INFORMATION4
, CA_TAX_INFORMATION5 CA_TAX_INFORMATION5
, CA_TAX_INFORMATION6 CA_TAX_INFORMATION6
, CA_TAX_INFORMATION7 CA_TAX_INFORMATION7
, CA_TAX_INFORMATION8 CA_TAX_INFORMATION8
, CA_TAX_INFORMATION9 CA_TAX_INFORMATION9
, CA_TAX_INFORMATION10 CA_TAX_INFORMATION10
, CA_TAX_INFORMATION11 CA_TAX_INFORMATION11
, CA_TAX_INFORMATION12 CA_TAX_INFORMATION12
, CA_TAX_INFORMATION13 CA_TAX_INFORMATION13
, CA_TAX_INFORMATION14 CA_TAX_INFORMATION14
, CA_TAX_INFORMATION15 CA_TAX_INFORMATION15
, CA_TAX_INFORMATION16 CA_TAX_INFORMATION16
, CA_TAX_INFORMATION17 CA_TAX_INFORMATION17
, CA_TAX_INFORMATION18 CA_TAX_INFORMATION18
, CA_TAX_INFORMATION19 CA_TAX_INFORMATION19
, CA_TAX_INFORMATION20 CA_TAX_INFORMATION20
, CA_TAX_INFORMATION21 CA_TAX_INFORMATION21
, CA_TAX_INFORMATION22 CA_TAX_INFORMATION22
, CA_TAX_INFORMATION23 CA_TAX_INFORMATION23
, CA_TAX_INFORMATION24 CA_TAX_INFORMATION24
, CA_TAX_INFORMATION25 CA_TAX_INFORMATION25
, CA_TAX_INFORMATION26 CA_TAX_INFORMATION26
, CA_TAX_INFORMATION27 CA_TAX_INFORMATION27
, CA_TAX_INFORMATION28 CA_TAX_INFORMATION28
, CA_TAX_INFORMATION29 CA_TAX_INFORMATION29
, CA_TAX_INFORMATION30 CA_TAX_INFORMATION30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, FED_LSF_AMOUNT FED_LSF_AMOUNT
, CPP_ELECTION_DATE CPP_ELECTION_DATE
, CPP_REVOCATION_DATE CPP_REVOCATION_DATE
FROM "HR"."PAY_CA_EMP_FED_TAX_INFO_F"