SQL to Extract Tax Withholding Calculation card Details
Summary:
SQL to Extract Tax Withholding Calculation card Details
Content (required):
If there is a requirement to pull the Tax Calculation Card Details on BIP Report, the below SQL will help you achieve that.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
PAPF.PERSON_NUMBER
,(
Select
HL1.MEANING
From
HR_LOOKUPS HL1
Where
HL1.LOOKUP_CODE = X.XVALUE
And HL1.LOOKUP_TYPE = 'HRX_US_FEDERAL_FILING_STATUS'
) FILING_STATUS
, Y.YVALUE MEDICARE_EXEMPT
, Z.ZVALUE SOCIAL_SECURITY_EXEMPT
, X.EFFECTIVE_START_DATE START_DATE
, X.EFFECTIVE_END_DATE END_DATE
Tagged:
2