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_US_CONTRIBUTION_HISTORY#

Source

View Text - Preformatted


select CONTR_HISTORY_ID CONTR_HISTORY_ID, PERSON_ID PERSON_ID, DATE_FROM DATE_FROM, DATE_TO DATE_TO, CONTR_TYPE CONTR_TYPE, TAX_UNIT_ID TAX_UNIT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, AMT_CONTR AMT_CONTR, MAX_CONTR_ALLOWED MAX_CONTR_ALLOWED, INCLUDABLE_COMP INCLUDABLE_COMP, SOURCE_SYSTEM SOURCE_SYSTEM, CONTR_INFORMATION_CATEGORY CONTR_INFORMATION_CATEGORY, CONTR_INFORMATION1 CONTR_INFORMATION1, CONTR_INFORMATION2 CONTR_INFORMATION2, CONTR_INFORMATION3 CONTR_INFORMATION3, CONTR_INFORMATION4 CONTR_INFORMATION4, CONTR_INFORMATION5 CONTR_INFORMATION5, CONTR_INFORMATION6 CONTR_INFORMATION6, CONTR_INFORMATION7 CONTR_INFORMATION7, CONTR_INFORMATION8 CONTR_INFORMATION8, CONTR_INFORMATION9 CONTR_INFORMATION9, CONTR_INFORMATION10 CONTR_INFORMATION10, CONTR_INFORMATION11 CONTR_INFORMATION11, CONTR_INFORMATION12 CONTR_INFORMATION12, CONTR_INFORMATION13 CONTR_INFORMATION13, CONTR_INFORMATION14 CONTR_INFORMATION14, CONTR_INFORMATION15 CONTR_INFORMATION15, CONTR_INFORMATION16 CONTR_INFORMATION16, CONTR_INFORMATION17 CONTR_INFORMATION17, CONTR_INFORMATION18 CONTR_INFORMATION18, CONTR_INFORMATION19 CONTR_INFORMATION19, CONTR_INFORMATION20 CONTR_INFORMATION20, CONTR_INFORMATION21 CONTR_INFORMATION21, CONTR_INFORMATION22 CONTR_INFORMATION22, CONTR_INFORMATION23 CONTR_INFORMATION23, CONTR_INFORMATION24 CONTR_INFORMATION24, CONTR_INFORMATION25 CONTR_INFORMATION25, CONTR_INFORMATION26 CONTR_INFORMATION26, CONTR_INFORMATION27 CONTR_INFORMATION27, CONTR_INFORMATION28 CONTR_INFORMATION28, CONTR_INFORMATION29 CONTR_INFORMATION29, CONTR_INFORMATION30 CONTR_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PAY_US_CONTRIBUTION_HISTORY"

View Text - HTML Formatted

SELECT CONTR_HISTORY_ID CONTR_HISTORY_ID
, PERSON_ID PERSON_ID
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, CONTR_TYPE CONTR_TYPE
, TAX_UNIT_ID TAX_UNIT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, AMT_CONTR AMT_CONTR
, MAX_CONTR_ALLOWED MAX_CONTR_ALLOWED
, INCLUDABLE_COMP INCLUDABLE_COMP
, SOURCE_SYSTEM SOURCE_SYSTEM
, CONTR_INFORMATION_CATEGORY CONTR_INFORMATION_CATEGORY
, CONTR_INFORMATION1 CONTR_INFORMATION1
, CONTR_INFORMATION2 CONTR_INFORMATION2
, CONTR_INFORMATION3 CONTR_INFORMATION3
, CONTR_INFORMATION4 CONTR_INFORMATION4
, CONTR_INFORMATION5 CONTR_INFORMATION5
, CONTR_INFORMATION6 CONTR_INFORMATION6
, CONTR_INFORMATION7 CONTR_INFORMATION7
, CONTR_INFORMATION8 CONTR_INFORMATION8
, CONTR_INFORMATION9 CONTR_INFORMATION9
, CONTR_INFORMATION10 CONTR_INFORMATION10
, CONTR_INFORMATION11 CONTR_INFORMATION11
, CONTR_INFORMATION12 CONTR_INFORMATION12
, CONTR_INFORMATION13 CONTR_INFORMATION13
, CONTR_INFORMATION14 CONTR_INFORMATION14
, CONTR_INFORMATION15 CONTR_INFORMATION15
, CONTR_INFORMATION16 CONTR_INFORMATION16
, CONTR_INFORMATION17 CONTR_INFORMATION17
, CONTR_INFORMATION18 CONTR_INFORMATION18
, CONTR_INFORMATION19 CONTR_INFORMATION19
, CONTR_INFORMATION20 CONTR_INFORMATION20
, CONTR_INFORMATION21 CONTR_INFORMATION21
, CONTR_INFORMATION22 CONTR_INFORMATION22
, CONTR_INFORMATION23 CONTR_INFORMATION23
, CONTR_INFORMATION24 CONTR_INFORMATION24
, CONTR_INFORMATION25 CONTR_INFORMATION25
, CONTR_INFORMATION26 CONTR_INFORMATION26
, CONTR_INFORMATION27 CONTR_INFORMATION27
, CONTR_INFORMATION28 CONTR_INFORMATION28
, CONTR_INFORMATION29 CONTR_INFORMATION29
, CONTR_INFORMATION30 CONTR_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PAY_US_CONTRIBUTION_HISTORY"