PAY Income Tax Ref No Bulk Upload
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- Income Tax Ref No Bulk Upload
- Short Name
- PYZAITREFU
- DB package
- PY_ZA_ITREF_UPLOAD
Imported from BI Publisher
SQL 20 lines
select pai.action_information3 LINE_NUM, pai.action_information4 CERT_NUM, pai.action_information5 SURNAME, pai.action_information6 FIRST_NAME, pai.action_information7 INITIALS, pai.action_information8 ID_NUM, pai.action_information9 PASSPORT_NUM, pai.action_information10 COUNTRY_OF_ISSUE, pai.action_information11 DOB, pai.action_information12 TAX_REF_NUM, pai.action_information13 EMP_NUM, pai.action_information14 STATUS, pai.action_information15 RESULT, pai.action_information16 ERROR_MSG, pai.action_information17 OLD_TAX_REF_NUM from pay_action_information pai where pai.action_context_type = 'PA' and pai.action_information_category = 'ZA_ITREF_UPLOAD' and pai.action_context_id = &G_PAYROLL_ACTION_ID |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Mode | LOV Oracle | |
| Effective Date | Date | |
| SARS File Name | Char |