VIEW: HR.PQP_PENSION_TYPES_F#

Source

View Text - Preformatted

select PENSION_TYPE_ID PENSION_TYPE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PENSION_TYPE_NAME PENSION_TYPE_NAME, PENSION_CATEGORY PENSION_CATEGORY, PENSION_PROVIDER_TYPE PENSION_PROVIDER_TYPE, SALARY_CALCULATION_METHOD SALARY_CALCULATION_METHOD, THRESHOLD_CONVERSION_RULE THRESHOLD_CONVERSION_RULE, CONTRIBUTION_CONVERSION_RULE CONTRIBUTION_CONVERSION_RULE, ER_ANNUAL_LIMIT ER_ANNUAL_LIMIT, EE_ANNUAL_LIMIT EE_ANNUAL_LIMIT, EE_ANNUAL_SALARY_THRESHOLD EE_ANNUAL_SALARY_THRESHOLD, ER_ANNUAL_SALARY_THRESHOLD ER_ANNUAL_SALARY_THRESHOLD, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, DESCRIPTION DESCRIPTION, MINIMUM_AGE MINIMUM_AGE, EE_CONTRIBUTION_PERCENT EE_CONTRIBUTION_PERCENT, MAXIMUM_AGE MAXIMUM_AGE, ER_CONTRIBUTION_PERCENT ER_CONTRIBUTION_PERCENT, EE_ANNUAL_CONTRIBUTION EE_ANNUAL_CONTRIBUTION, ER_ANNUAL_CONTRIBUTION ER_ANNUAL_CONTRIBUTION, ANNUAL_PREMIUM_AMOUNT ANNUAL_PREMIUM_AMOUNT, EE_CONTRIBUTION_BAL_TYPE_ID EE_CONTRIBUTION_BAL_TYPE_ID, ER_CONTRIBUTION_BAL_TYPE_ID ER_CONTRIBUTION_BAL_TYPE_ID, BALANCE_INIT_ELEMENT_TYPE_ID BALANCE_INIT_ELEMENT_TYPE_ID, PTY_ATTRIBUTE_CATEGORY PTY_ATTRIBUTE_CATEGORY, PTY_ATTRIBUTE1 PTY_ATTRIBUTE1, PTY_ATTRIBUTE2 PTY_ATTRIBUTE2, PTY_ATTRIBUTE3 PTY_ATTRIBUTE3, PTY_ATTRIBUTE4 PTY_ATTRIBUTE4, PTY_ATTRIBUTE5 PTY_ATTRIBUTE5, PTY_ATTRIBUTE6 PTY_ATTRIBUTE6, PTY_ATTRIBUTE7 PTY_ATTRIBUTE7, PTY_ATTRIBUTE8 PTY_ATTRIBUTE8, PTY_ATTRIBUTE9 PTY_ATTRIBUTE9, PTY_ATTRIBUTE10 PTY_ATTRIBUTE10, PTY_ATTRIBUTE11 PTY_ATTRIBUTE11, PTY_ATTRIBUTE12 PTY_ATTRIBUTE12, PTY_ATTRIBUTE13 PTY_ATTRIBUTE13, PTY_ATTRIBUTE14 PTY_ATTRIBUTE14, PTY_ATTRIBUTE15 PTY_ATTRIBUTE15, PTY_ATTRIBUTE16 PTY_ATTRIBUTE16, PTY_ATTRIBUTE17 PTY_ATTRIBUTE17, PTY_ATTRIBUTE18 PTY_ATTRIBUTE18, PTY_ATTRIBUTE19 PTY_ATTRIBUTE19, PTY_ATTRIBUTE20 PTY_ATTRIBUTE20, PTY_INFORMATION_CATEGORY PTY_INFORMATION_CATEGORY, PTY_INFORMATION1 PTY_INFORMATION1, PTY_INFORMATION2 PTY_INFORMATION2, PTY_INFORMATION3 PTY_INFORMATION3, PTY_INFORMATION4 PTY_INFORMATION4, PTY_INFORMATION5 PTY_INFORMATION5, PTY_INFORMATION6 PTY_INFORMATION6, PTY_INFORMATION7 PTY_INFORMATION7, PTY_INFORMATION8 PTY_INFORMATION8, PTY_INFORMATION9 PTY_INFORMATION9, PTY_INFORMATION10 PTY_INFORMATION10, PTY_INFORMATION11 PTY_INFORMATION11, PTY_INFORMATION12 PTY_INFORMATION12, PTY_INFORMATION13 PTY_INFORMATION13, PTY_INFORMATION14 PTY_INFORMATION14, PTY_INFORMATION15 PTY_INFORMATION15, PTY_INFORMATION16 PTY_INFORMATION16, PTY_INFORMATION17 PTY_INFORMATION17, PTY_INFORMATION18 PTY_INFORMATION18, PTY_INFORMATION19 PTY_INFORMATION19, PTY_INFORMATION20 PTY_INFORMATION20, EE_CONTRIBUTION_FIXED_RATE EE_CONTRIBUTION_FIXED_RATE, ER_CONTRIBUTION_FIXED_RATE ER_CONTRIBUTION_FIXED_RATE, SPECIAL_PENSION_TYPE_CODE SPECIAL_PENSION_TYPE_CODE, PENSION_SUB_CATEGORY PENSION_SUB_CATEGORY, PENSION_BASIS_CALC_METHOD PENSION_BASIS_CALC_METHOD, PENSION_SALARY_BALANCE PENSION_SALARY_BALANCE, RECURRING_BONUS_PERCENT RECURRING_BONUS_PERCENT, NON_RECURRING_BONUS_PERCENT NON_RECURRING_BONUS_PERCENT, RECURRING_BONUS_BALANCE RECURRING_BONUS_BALANCE, NON_RECURRING_BONUS_BALANCE NON_RECURRING_BONUS_BALANCE, STD_TAX_REDUCTION STD_TAX_REDUCTION, SPL_TAX_REDUCTION SPL_TAX_REDUCTION, SIG_SAL_SPL_TAX_REDUCTION SIG_SAL_SPL_TAX_REDUCTION, SIG_SAL_NON_TAX_REDUCTION SIG_SAL_NON_TAX_REDUCTION, SIG_SAL_STD_TAX_REDUCTION SIG_SAL_STD_TAX_REDUCTION, SII_STD_TAX_REDUCTION SII_STD_TAX_REDUCTION, SII_SPL_TAX_REDUCTION SII_SPL_TAX_REDUCTION, SII_NON_TAX_REDUCTION SII_NON_TAX_REDUCTION, PREVIOUS_YEAR_BONUS_INCLUDED PREVIOUS_YEAR_BONUS_INCLUDED, RECURRING_BONUS_PERIOD RECURRING_BONUS_PERIOD, NON_RECURRING_BONUS_PERIOD NON_RECURRING_BONUS_PERIOD, EE_AGE_THRESHOLD EE_AGE_THRESHOLD, ER_AGE_THRESHOLD ER_AGE_THRESHOLD, EE_AGE_CONTRIBUTION EE_AGE_CONTRIBUTION, ER_AGE_CONTRIBUTION ER_AGE_CONTRIBUTION from "HR"."PQP_PENSION_TYPES_F"

View Text - HTML Formatted

SELECT PENSION_TYPE_ID PENSION_TYPE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PENSION_TYPE_NAME PENSION_TYPE_NAME
, PENSION_CATEGORY PENSION_CATEGORY
, PENSION_PROVIDER_TYPE PENSION_PROVIDER_TYPE
, SALARY_CALCULATION_METHOD SALARY_CALCULATION_METHOD
, THRESHOLD_CONVERSION_RULE THRESHOLD_CONVERSION_RULE
, CONTRIBUTION_CONVERSION_RULE CONTRIBUTION_CONVERSION_RULE
, ER_ANNUAL_LIMIT ER_ANNUAL_LIMIT
, EE_ANNUAL_LIMIT EE_ANNUAL_LIMIT
, EE_ANNUAL_SALARY_THRESHOLD EE_ANNUAL_SALARY_THRESHOLD
, ER_ANNUAL_SALARY_THRESHOLD ER_ANNUAL_SALARY_THRESHOLD
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, DESCRIPTION DESCRIPTION
, MINIMUM_AGE MINIMUM_AGE
, EE_CONTRIBUTION_PERCENT EE_CONTRIBUTION_PERCENT
, MAXIMUM_AGE MAXIMUM_AGE
, ER_CONTRIBUTION_PERCENT ER_CONTRIBUTION_PERCENT
, EE_ANNUAL_CONTRIBUTION EE_ANNUAL_CONTRIBUTION
, ER_ANNUAL_CONTRIBUTION ER_ANNUAL_CONTRIBUTION
, ANNUAL_PREMIUM_AMOUNT ANNUAL_PREMIUM_AMOUNT
, EE_CONTRIBUTION_BAL_TYPE_ID EE_CONTRIBUTION_BAL_TYPE_ID
, ER_CONTRIBUTION_BAL_TYPE_ID ER_CONTRIBUTION_BAL_TYPE_ID
, BALANCE_INIT_ELEMENT_TYPE_ID BALANCE_INIT_ELEMENT_TYPE_ID
, PTY_ATTRIBUTE_CATEGORY PTY_ATTRIBUTE_CATEGORY
, PTY_ATTRIBUTE1 PTY_ATTRIBUTE1
, PTY_ATTRIBUTE2 PTY_ATTRIBUTE2
, PTY_ATTRIBUTE3 PTY_ATTRIBUTE3
, PTY_ATTRIBUTE4 PTY_ATTRIBUTE4
, PTY_ATTRIBUTE5 PTY_ATTRIBUTE5
, PTY_ATTRIBUTE6 PTY_ATTRIBUTE6
, PTY_ATTRIBUTE7 PTY_ATTRIBUTE7
, PTY_ATTRIBUTE8 PTY_ATTRIBUTE8
, PTY_ATTRIBUTE9 PTY_ATTRIBUTE9
, PTY_ATTRIBUTE10 PTY_ATTRIBUTE10
, PTY_ATTRIBUTE11 PTY_ATTRIBUTE11
, PTY_ATTRIBUTE12 PTY_ATTRIBUTE12
, PTY_ATTRIBUTE13 PTY_ATTRIBUTE13
, PTY_ATTRIBUTE14 PTY_ATTRIBUTE14
, PTY_ATTRIBUTE15 PTY_ATTRIBUTE15
, PTY_ATTRIBUTE16 PTY_ATTRIBUTE16
, PTY_ATTRIBUTE17 PTY_ATTRIBUTE17
, PTY_ATTRIBUTE18 PTY_ATTRIBUTE18
, PTY_ATTRIBUTE19 PTY_ATTRIBUTE19
, PTY_ATTRIBUTE20 PTY_ATTRIBUTE20
, PTY_INFORMATION_CATEGORY PTY_INFORMATION_CATEGORY
, PTY_INFORMATION1 PTY_INFORMATION1
, PTY_INFORMATION2 PTY_INFORMATION2
, PTY_INFORMATION3 PTY_INFORMATION3
, PTY_INFORMATION4 PTY_INFORMATION4
, PTY_INFORMATION5 PTY_INFORMATION5
, PTY_INFORMATION6 PTY_INFORMATION6
, PTY_INFORMATION7 PTY_INFORMATION7
, PTY_INFORMATION8 PTY_INFORMATION8
, PTY_INFORMATION9 PTY_INFORMATION9
, PTY_INFORMATION10 PTY_INFORMATION10
, PTY_INFORMATION11 PTY_INFORMATION11
, PTY_INFORMATION12 PTY_INFORMATION12
, PTY_INFORMATION13 PTY_INFORMATION13
, PTY_INFORMATION14 PTY_INFORMATION14
, PTY_INFORMATION15 PTY_INFORMATION15
, PTY_INFORMATION16 PTY_INFORMATION16
, PTY_INFORMATION17 PTY_INFORMATION17
, PTY_INFORMATION18 PTY_INFORMATION18
, PTY_INFORMATION19 PTY_INFORMATION19
, PTY_INFORMATION20 PTY_INFORMATION20
, EE_CONTRIBUTION_FIXED_RATE EE_CONTRIBUTION_FIXED_RATE
, ER_CONTRIBUTION_FIXED_RATE ER_CONTRIBUTION_FIXED_RATE
, SPECIAL_PENSION_TYPE_CODE SPECIAL_PENSION_TYPE_CODE
, PENSION_SUB_CATEGORY PENSION_SUB_CATEGORY
, PENSION_BASIS_CALC_METHOD PENSION_BASIS_CALC_METHOD
, PENSION_SALARY_BALANCE PENSION_SALARY_BALANCE
, RECURRING_BONUS_PERCENT RECURRING_BONUS_PERCENT
, NON_RECURRING_BONUS_PERCENT NON_RECURRING_BONUS_PERCENT
, RECURRING_BONUS_BALANCE RECURRING_BONUS_BALANCE
, NON_RECURRING_BONUS_BALANCE NON_RECURRING_BONUS_BALANCE
, STD_TAX_REDUCTION STD_TAX_REDUCTION
, SPL_TAX_REDUCTION SPL_TAX_REDUCTION
, SIG_SAL_SPL_TAX_REDUCTION SIG_SAL_SPL_TAX_REDUCTION
, SIG_SAL_NON_TAX_REDUCTION SIG_SAL_NON_TAX_REDUCTION
, SIG_SAL_STD_TAX_REDUCTION SIG_SAL_STD_TAX_REDUCTION
, SII_STD_TAX_REDUCTION SII_STD_TAX_REDUCTION
, SII_SPL_TAX_REDUCTION SII_SPL_TAX_REDUCTION
, SII_NON_TAX_REDUCTION SII_NON_TAX_REDUCTION
, PREVIOUS_YEAR_BONUS_INCLUDED PREVIOUS_YEAR_BONUS_INCLUDED
, RECURRING_BONUS_PERIOD RECURRING_BONUS_PERIOD
, NON_RECURRING_BONUS_PERIOD NON_RECURRING_BONUS_PERIOD
, EE_AGE_THRESHOLD EE_AGE_THRESHOLD
, ER_AGE_THRESHOLD ER_AGE_THRESHOLD
, EE_AGE_CONTRIBUTION EE_AGE_CONTRIBUTION
, ER_AGE_CONTRIBUTION ER_AGE_CONTRIBUTION
FROM "HR"."PQP_PENSION_TYPES_F"