Filetype Excel XLSX | Posted on 09 Aug 2022 | 4 years ago
Authentication
digital resources
381x Filetype XLSX File size 0.03 MB Source: oklahoma.gov
PeopleSoft Financials Toolkit
MODULE QUERY DESCRIPTION LONG DESCRIPTION TYPE QUERY NAME PROMPTS NAVIGATION
REPORT NAME
Accounts Payable
Voucher
Vouchers in Budget Error status (by BU) Displays vouchers by Business Unit in Error Crystal OCP_0224_AP From BU, To BU Accounts Payable > Reports > Vouchers > Budget Checking Error
status after the budget checking process has
completed.
Fiscal YTD AP Transactions by Business Unit This query is for agencies that daily download Query OCP_ALLTRANS_AP From BU, To BU, Reporting Tools > Query > Query Viewer
data to their own financial software. It will From Accounting
download all AP transactions for the selected Date, To
time period. Accounting Date
Professional Services Report (by BU) Displays all vouchers by Business Unit for the Crystal OCP_AP0067_PROF_SERVICES Beg BU, End BU, Accounts Payable > Reports > Vouchers > Professional Services
515xx (professional services) object codes. Beg Acct Date,
There are sub-totals by account, fund and End Acct Date
agency, as well as a grand total.
Expenditures sorted by AFP number (by BU) Provides a list of expenditures by Business Unit Crystal OCP_AP0074 Beg BU, End BU, Accounts Payable > Reports > Vouchers > Fiscal AFP Expn By Agy - AFP
sorted by AFP number. Beg Acct Date,
End Acct Date
Total for all A/P transactions for a given period. Contains totals by account, fund, agency, and Crystal OCP_AP0116 Beg BU, End BU, Accounts Payable > Reports > Vouchers > Successful Vouchers
transaction code, as well as a Grand Total for all Beginning
A/P transactions for a given period. Processing Date,
Ending
Processing Date
Deleted vouchers that are not budget checked Displays all deleted vouchers that have not been Query OCP_AP0117_DEL_VCHRS_NOT_BCM BU Reporting Tools > Query > Query Viewer
budget checked so the funds can be returned to
their respective budgets.
PO Invoice Exception Report Displays vouchers that were created after the Crystal OCP_AP0231_PO_INV_EXCEP_RPT Voucher Date Accounts Payable > Reports > Vouchers > Monitor PO/Invoice Dates
related purchase order.
Voucher Batch Slip Prints a batch slip that will be submitted along Crystal OCP_AP0245 BU, Pay Group Accounts Payable > Reports > Vouchers > Voucher Batch Slip
with their vouchers to OSF for processing. Code
Page 1 of 5 Issue Date: 11/27/2006
Revised Date:
PeopleSoft Financials Toolkit
MODULE QUERY DESCRIPTION LONG DESCRIPTION TYPE QUERY NAME PROMPTS NAVIGATION
REPORT NAME
Purchase Card Voucher Build process On a monthly basis, an employee from each BU Crystal OCP_AP0302 None Accounts Payable > Batch Processes > Vouchers > Batch Voucher Request
will access the Pathway web site and download
the current month's charges. The file will be
loaded into PeopleSoft. The People soft Voucher
Build process will then be used to extract the
data from the staging tables and create vouchers.
After the vouchers are created they will be
handled in the same manner as vouchers
entered online (i.e. budget checked, matched and
paid).
Six-digit Expenditure Report (by BU) Displays data based on the Journal Date. The Crystal OCP_AP0312_VCHR_REG_X_UNIT Beginning BU, Accounts Payable > Reports > Vouchers > 6 Digit Exp Detl by Jrnl Date
journal date is found in the VCHR_ACCTG_LINE Ending BU,
table and is created when the voucher Beginning
information is processed by the journal Journal Date,
generation process. Agencies need to be able to Ending Journal
reconcile this report with the Six Digit Object of Date
Expenditure report (OCP_0060_GL), the Six Digit
Expenditure by Fund report (OCP_0062_GL) and
the Summary of Receipts and Disbursements
report (OCP_0059_GL).
Vouchers not paid detail Displays Business Unit, Voucher, Accounting Query OCP_VCHR_DETAIL_NOT_PAID BU and Reporting Tools > Query > Query Viewer
Date, Match Status, Payment and vendor Accounting Date
information for vouchers not paid. less than the
date entered.
Vouchers not budget checked Displays Business Unit, voucher, accounting date Query OCP_VCHRS_NOT_BCM Accounting date Reporting Tools > Query > Query Viewer
and budget checking status for vouchers that are less than date
not template, reversals or deleted. entered.
Vouchers not budget checked and associated Displays Business Unit, voucher, accounting Query OCP_VCHRS_NOT_BCM_PO Accounting date Reporting Tools > Query > Query Viewer
Purchase order date, Purchase order number and its budget less than date
checking status for vouchers that are not entered.
template, reversals or deleted.
Daily Warrant Count & Amount Displays payment information, count, and dollar Query OCP_WARRANT_DAILY_SUMMARY Accounting date Reporting Tools > Query > Query Viewer
sum of the payments not including $0 payments. from and to
Voucher assigned to EDT claim Displays Business Unit, voucher, vendor, vendor Query OCP_EDT_VOUCHER_ID BU and Reporting Tools > Query > Query Viewer
name, amount , and claim number. description (claim
number)
Page 2 of 5 Issue Date: 11/27/2006
Revised Date:
PeopleSoft Financials Toolkit
MODULE QUERY DESCRIPTION LONG DESCRIPTION TYPE QUERY NAME PROMPTS NAVIGATION
REPORT NAME
Payment
Authority Order payments by FEI/SSN (by BU) Displays payments by Business Unit by FEI/SSN Crystal OCP_AP0073 From BU, To BU, Accounts Payable > Reports > Vendor > Fiscal AFP Expenditure By Payee
made to authority orders. From Date,
Through Date
Payment History By Payment Report Displays Agencies total warrants issued and all Crystal OCP_AP0119 From Date, Accounts Payable > Reports > Payments > Misc Warrants
their alternate claim warrants issued by warrant Through Date ,
type. It also allows them to see totals of EFT Begin Agency,
warrants. End Agency
15B or non-15B warrants issued with totals by Provides agencies with either non-15B or 15B Crystal OCP_AP0135 Run Date Accounts Payable > Reports > Payments > 15B Warrant Issue Notice
type of warrant warrants issued and displays totals of ASA
warrants, duplicate warrants, 7xx warrants, and
total warrants.
Miscellaneous Warrant Cancellation Report Extract warrants from the payment_tbl Crystal OCP_AP0136_WRRNT_CNCL_MISC Begin BU, End Accounts Payable > Reports > Payments > Warrant Cancellation Register
(miscellaneous) and the mdc_payment_tbl BU, Begin
(payroll) where the payment status = “S” Cancel Date, End
(stopped) and the cancel date is between the Cancel Date
entered beginning and end dates. The payment
method of ‘WIR’ will designate a direct deposit.
Statewide Cost Allocation Warrants Calculates the number of warrants generated Crystal OCP_AP0179_STATEWIDE_CST_ALLOC Beginning Date, Accounts Payable > Reports > Payments > Statewide Cost Alloc Warrants
each year by agency. Warrants are divided into Ending Date
four groups: Interagency, Miscellaneous, ASA
(7xx Fund), Payroll, and Payroll (EFT). The
program reads the agency database and creates
a table containing agency number and agency
name. As the warrant records are read, the
warrant counts are added to the appropriate
agency totals and grand totals. As the totals are
written to the report, the program calculates the
percentage of the agency’s warrant total to the
grand total of warrants issued. A single line is
printed for each agency. There are grand totals
by warrant type at the end of the report.
36 month Stat Cancel Report Displays payroll warrants that have stat cancelled Crystal OCP_AP0309_36_MTH_STAT_CANCEL From BU, To BU, Accounts Payable > Reports > Payments > Payroll 36 Month Stat Cancel
that are eligible to be re-issued Through Date
Warrants with their payment inquiry information. Displays a detailed picture of the status and Query OCP_AP0336_BU_WARRANT_INQ Business Unit Reporting Tools > Query > Query Viewer
completed processes of the selected warrant. and Warrant
Number
Page 3 of 5 Issue Date: 11/27/2006
Revised Date:
PeopleSoft Financials Toolkit
MODULE QUERY DESCRIPTION LONG DESCRIPTION TYPE QUERY NAME PROMPTS NAVIGATION
REPORT NAME
Deleted vouchers Displays vouchers that have been deleted by Query VOUCHERS_DELETED Business Unit Reporting Tools > Query > Query Viewer
Business Unit.
Payments Posted by Business Unit Displays Business Unit, Voucher, Payment Query OCP_PYMTS_POSTED_BY_BU Business Unit Reporting Tools > Query > Query Viewer
Count, Bank Code, Bank Acct Key, and Payment
Id Ref for posted payments.
Identifies voucher that has had an ADJ voucher Display vouchers that have had an ADJ voucher Query VOUCHER_ADJ_VOUCHERS_CREATED Business Unit Reporting Tools > Query > Query Viewer
made. made. and Related
Voucher #
General Ledger
Ledger
6 Digit Expenditure by Fund Displays all Expenditures including summarized Crystal OCP_GL0062 BU, Accting Accounts Payable > Reports > Vouchers
payroll by chartfield value. Period, Fiscal Yr
Journal
Deposit Report Displays all Deposits, Transfers, and Corrections Crystal OCP_0058_GL BU and Journal General Ledger > General Reports
by Class and Account. Includes Journal date and Date
ID.
JE's by Agency and Fund Displays On Line Journal Entries for a BU. Crystal OCP_GL0065_JE_BY_AGENCY_FUND Posted Date and General Ledger > General Reports
(These are typically manual JEs ) BU
Payroll Funding non-PS payroll Displays non-PeopleSoft payroll funding Query OCP_PAYROLL_FUND_TRANSFER BU from and to Reporting Tools > Query > Query Viewer
information by chartfield. and Journal Date
from and to.
Payroll Funding PS payroll Displays payroll funding information by chartfield. Query OCP_PAYROLL_FUND_TRANSFER_PS BU from and to Reporting Tools > Query > Query Viewer
and Journal Date
from and to.
Deposit Report Displays Deposits, Transfers, and Corrections Query OCP_AGY_DEP_TO_00000_BY_OST BU and Journal Reporting Tools > Query > Query Viewer
entered by OST made to BU 00000, by Affiliated Date
BU.
Agency Deposits to 00000 Displays Deposits, Transfers, and Corrections Query OCP_AGY_DEP_TO_00000 Depositing BU Reporting Tools > Query > Query Viewer
made to BU 00000 and Journal Date
Jrnl Date and Posted Date Displays the Post Status of selected Journals Query OCP_JRNL_DATE_POSTED_DATE BU and Journal Reporting Tools > Query > Query Viewer
Date
Budget
Lapsed Funds - Appropriated Displays Appropriated Funds that are about to Crystal OCP_GL0114_LAPSED_FUNDS BU General Ledger > General Reports
Lapse in the next 60 days
Lapsed Funds - Continuing Funds Displays Continuing Funds that are about to Crystal OCP_GL0068_LAPSED_FUNDS BU General Ledger > General Reports
Lapse in the next 60 days
Page 4 of 5 Issue Date: 11/27/2006
Revised Date:
no reviews yet
Please Login to review.
