Delivered Queries
With Global Payroll for India, some predefined queries are delivered to assist you in viewing pertinent data. Use PSQUERY to run these queries. PSQUERY, a part of PeopleTools functionality, enables you to run queries against data in PeopleSoft databases.
The following table lists predefined queries and data results for each:
|
Query |
Data Results |
|---|---|
|
GPIN ESI NOT REGISTERED |
Payees not registered for employee state insurance (ESI). |
|
GPIN LTA MISMATCH |
Leave travel allowance that has been paid but is not identified as reimbursed in the database. |
|
GPIN LTA NOT PAID |
Leave travel allowance claims that have not been paid. |
|
GPIN LTA WAIVE |
Payees who have waived leave travel allowance. |
|
GPIN MDA MISMATCH |
Medical allowance that has been paid but is not identified as reimbursed in the database. |
|
GPIN MDA NOT PAID |
Medical allowance claims that have not been paid. |
|
GPIN MDA WAIVED |
Payees who have waived medical allowance. |
|
GPIN PAYEE REPORT SETUP |
Payee report setup data. |
|
GPIN PF NOT REGISTERED |
Payees who are not registered in provident fund. |
|
GPIN TDS DISABLED |
Payees who are disabled. |
|
GPIN TDS SETUP |
Tax deducted at source setup data. |
|
GPIN TDS SR CITIZEN |
Senior citizen payees. |
|
GIN YE FORM12BA |
Form 12BA perquisites. |
|
GIN YE FORM 3A |
Payees with Form 3A data. |
|
GPIN _ PF_NO_BENEF |
Provident fund enrollees without beneficiaries. |
|
GPIN_ESI_NO_BENEF |
ESI enrollees without beneficiaries. |
See the product documentation for PeopleTools: Query