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: PAY_KR_YER_PREV_ER_V

Product:	PAY - Payroll
Description:	This view returns previous employer information from assignment EIT.YEA process does not output previous employer information as database item.Therefore, the system have to get these data from assignment EIT based on assignment_id and termi
Implementation/DBA Data:	APPS.PAY_KR_YER_PREV_ER_V

View Text

SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID
, AEI.INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION1) TERMINATION_DATE
, AEI.AEI_INFORMATION2 BP_NAME
, AEI.AEI_INFORMATION3 BP_NUMBER
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION4) TAXABLE_EARNINGS_MTH
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION5) TAXABLE_EARNINGS_BON
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION6) SP_IRREG_BONUS
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION4)+FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION5)+FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION6) TAXABLE_TOTAL
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_PREV_ER_INFO'

Columns

Name
ASSIGNMENT_EXTRA_INFO_ID
ASSIGNMENT_ID
INFORMATION_TYPE
AEI_INFORMATION_CATEGORY
OBJECT_VERSION_NUMBER
TERMINATION_DATE
BP_NAME
BP_NUMBER
TAXABLE_EARNINGS_MTH
TAXABLE_EARNINGS_BON
SP_IRREG_BONUS
TAXABLE_TOTAL