Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
310x Filetype XLSX File size 0.05 MB Source: dof.ca.gov
Sheet 1: PeopleSoft to CALSTARS Rpts
| FI$CAL TO CALSTARS REPORTS CROSSWALK (Rev. 2/20/2018) | ||||||||
| Module | Report/Query/Online Inquiry | Report ID | Report/Query Name | Navigation | FI$Cal Report/Query Description and Purpose | Frequency of Use | CALSTARS Report ID | CALSTARS Report Description |
| AM | Report | RPTAM013 | Asset Audit Report | FI$Cal Processes > FI$Cal Report > AM Reports > Asset Audit Report | Displays expenditures related to asset purchases. Use to reconcile capital and non-capital assets. | Monthly/ Annual | H11 | Property Transaction Analysis |
| AM | Report | AMDE1001 | Asset History Sheet by Account | Step 1 Load: Asset Management > Financial Reports > Load Reporting Tables > Asset History Report Tbl Step 2 Run: Asset Management > Financial Reports > Asset Details > History |
Report shows the asset ID, description, In Service date, Useful Life, original cost, additions, retirements, recategorization, accumulated depreciation, net book value. | Monthly/ Annual | ||
| AM | Report | AMDE1002 | Asset History Sheet Summary | Step 1 Load: Asset Management > Financial Reports > Load Reporting Tables > Asset History Report Tbl Step 2 Run: Asset Management > Financial Reports > Asset Details > History |
Report shows Asset ID, Description, In Service Date, Depreciation Method, Useful Life, Cost, Additions, Retirements, Depreciation and Accumulated Depreciation. | Monthly/ Annual | ||
| AM | Report | AMDP2100 | Net Book Value Detail Report | Asset Management > Financial Reports > Cost and Depreciation > Asset Net Book Value | Shows asset ID, cost balance, current depreciation, YTD/LTD depreciation, and net book value. | Monthly/ Annual | ||
| AM | Report | AMDP2000 | Depreciation Activity Detail | Step 1 Load: Asset Management > Financial Reports > Loading Reporting Tables > Depr Reporting Table Step 2 Run: Asset Management > Financial Reports > Cost and Depreciation > Depreciation Activity |
Sorts cost activity by ChartField. Shows beginning/prior/ending depreciation. | Monthly/ Annual | ||
| AM | Query | ZZ | ZZ_AM_ACCT_ENTRIES_NOT_SENT_TO | Reporting Tools > Query > Query Viewer | Displays all AM accounting entries that have not been journal-generated. AM entries are sent to GL the next day after asset depreciation is completed. | Monthly/ Annual | ||
| AP | Report | RPTAP003 | BOE Use Tax Report | FI$Cal Processes > FI$Cal Report > AP Reports > BOE Sales Use Tax Report | Tracks information pertaining to Use Tax that needs to be paid to the BOE for goods that are purchased from a retailer who is not engaged in business in California and who is not registered to collect the California Use Tax. | Monthly/ Annual | ||
| AP | Report | RPTAP020 | Reportable Payments | FI$Cal Processes > FI$Cal Report > AP Reports > Reportable Payments | Lists suppliers that will be included on the Form 1099 reported to the IRS and FTB at the end of each tax year. | Monthly/ Annual | P01 | Year-To_Date Reportable Payment Report |
| AP | Report | RPTAP019 | Unreimbursed ORF Payments | Accounts Payable > Reports > Prepayments > Unreimbursed ORF Payments | Unreimbursed payments for ORF travel advances. | Monthly | D02 | Aged Revolving Fund Advances |
| AP | Report | APSX8001 | Voucher Activity | Accounts Payable > Reports > Vouchers > Voucher Activity | Used as a month end tool to see what vouchers were created and the gross amount of payments. Can be run by date range, and chartfield values. | Monthly | ||
| AP | Query | DFQ | DFQ_AP_01_EXP_ACCRUAL | Reporting Tools > Query > Query Viewer | Displays AP expenditure accrual information as per the original query with the following modifications: - Does not display Vouchers that have cleared - Displays the appropriate Due To Account instead of the generic '50' account - The Fund, ENY, Program, and Ref fields are now optional |
Monthly | ||
| AP | Query | DFQ | DFQ_AP_02_VOUCHERS_LISTING | Reporting Tools > Query > Query Viewer | Used to obtain a list of AP Vouchers with payment information. | Daily | ||
| AP | Query | DFQ | DFQ_AP_03_FEDERAL_ACTIVITY | Reporting Tools > Query > Query Viewer | Used to obtain a list of AP Vouchers for federal draw using the Scheduled Date. | Daily | ||
| AP | Query | DFQ | DFQ_AP_04_SUPPLIER_SEARCH | Reporting Tools > Query > Query Viewer | Used to obtain a list of Suppliers with address information. | Daily | x | |
| AP | Query | ZZ | ZZ_AP_ACCT_ENTRIES_NOTSENTTOGL | Reporting Tools > Query > Query Viewer | Displays all AP accounting entries that have not been journal-generated. Vouchers are required to journal-generate to the GL and post before the amount can be reported on ledger based reports. | Daily/ Monthly | ||
| AP | Query | ZZ | ZZ_AP_ACCT_ENTRIES_SENT_TO_GL | Reporting Tools > Query > Query Viewer | Displays AP accounting entries that have been journal-generated. Identifies the voucher and the associated journal. | Daily/ Monthly | ||
| AP | Query | ZZ | ZZ_AP_ORF_RECON | Reporting Tools > Query > Query Viewer | Displays the details of journal(s) that is/are included in replenishment claims. | Monthly | ||
| AP | Query | ZZ | ZZ_AP_VCHR_DELETED | Reporting Tools > Query > Query Viewer | Lists all deleted vouchers. | Daily | ||
| AP | Query | ZZ | ZZ_ENCUMBRANCE_STATUS_AP | Reporting Tools > Query > Query Viewer | Report displays PO number, PO date, accounting date, original encumbrance amount, remaining encumbrance balance and charftields. | Monthly | D12, D16 | List of Document File records |
| AP | Query | ZZ | ZZ_EXP_AP_ACCRUAL | Reporting Tools > Query > Query Viewer | Displays AP expenditure accruals that have been distributed to the general ledger. | Monthly | ||
| AP | Query | ZZ | ZZ_OUTSTANDING_VOUCHER | Reporting Tools > Query > Query Viewer | Identifies outstanding vouchers. | Daily | ||
| AP | Query | ZZ | ZZ_PAYMENT_STATUS | Reporting Tools > Query > Query Viewer | Cross references the reference number (agency check number) to voucher ID. | Daily | ||
| AP | Query | ZZ | ZZ_VCHR_STATUS | Reporting Tools > Query > Query Viewer | Displays the status of vouchers. | Daily | ||
| AP, AR, GL | Query | ZZ | ZZ_MEC_OUTSTANDING_TRXNS | Reporting Tools > Query > Query Viewer | Consolidates various ZZ_Outstanding queries from AP, AR, and GL Modules to assist in correcting outstanding transactions. | Daily/ Monthly | ||
| AP, AR, LD, PC, BI, AM, GL | Query | ZZ | ZZ_MEC_ENTRIES_NOT_SENT_TO_GL | Reporting Tools > Query > Query Viewer | Consolidates various ZZ_Entries_NotSentTo_GL queries from AP, AR, LD, PC, BI, AM, and GL Modules to verify sub-system transactions. | Daily/ Monthly | ||
| AR | Query | ZZ | ZZ_SUPPORT_DOC_BILL | Reporting Tools > Query > Query Viewer | Displays the voucher number and details of an Accounts Receivable item. | Daily | ||
| AR | Query | ZZ | ZZ_BILL_STATUS | Reporting Tools > Query > Query Viewer | Shows the status of ungenerated invoices. | Daily | ||
| AR | Query | ZZ | ZZ_REV_ACCRUAL | Reporting Tools > Query > Query Viewer | Lists revenue accruals. | Daily/ Monthly | ||
| AR | Query | ZZ | ZZ_REV_BAL_AGENCY | Reporting Tools > Query > Query Viewer | Lists revenue balance per agency. | Daily/ Monthly | ||
| AR | Report | AR30006 | Accounts Receivable Aging by ChartField Report | Accounts Receivable > Receivable Analysis > Aging > Aging by Chartfield Rpt | Displays all open receivable transactions by chartfield. | Monthly | D03 | Accounts Receivable Aging |
| AR | Report | RPTAR018 | Accounts Receivable Aging Report | Accounts Receivable > Receivable Analysis > Aging > Aging Detail by Unit Rpt (select CSV format) |
Provides information to help monitor Accounts Receivable. | Monthly | D03 | Accounts Receivable Aging |
| AR | Report | AR30003 | Aging Detail by Business Unit | Accounts Receivable > Receivable Analysis > Aging > Aging Detail by Unit Rpt | Provides information to help monitor and verify the outstanding ARs by Business Unit. | Monthly | D16 | Document Report for SCO Reconciliation |
| AR | Report | RPTAR007 | Cash Receipts Report | FI$Cal Processes > FI$Cal Report > AR Reports > Cash Receipts Report | Displays receipt transactions, including all deposit, payment, and chartfield data. Receipts do not need to be posted to appear on the report. | Daily/ Monthly | H06 | Cash Receipts and Disbursements Register |
| AR | Report | RPTAR025 | Customer Account History Report | FI$Cal Processes > FI$Cal Report > AR Reports > Customer Account History Rpt | Displays customer item balances and any adjustments applied to the item. | Daily/ Monthly | ||
| AR | Query | DFQ | DFQ_AR_01_PENDING_ITEM_BY_DTL | Reporting Tools > Query > Query Viewer | Used to obtain AR pending item transactions by detail. AR Processor or Approver can review the AR pending item transactions by distribution lines. Query data has Group Unit, Group ID, Accounting Date, Posting Status, Customer ID, Name, Item ID, Amount and Distribution lines. | Daily | ||
| AR | Query | DFQ | DFQ_AR_02_ABATEMENT_ACCRUAL | Reporting Tools > Query > Query Viewer | Displays AR items and Abatements accrual information as per the original query with the following modifications: - Displays all AR accounts including AR-Other and Deferred Receivables - Update Prompts display |
Monthly | ||
| AR | Query | DFQ | DFQ_AR_03_AP_AR_ACCRUAL | Reporting Tools > Query > Query Viewer | Combines AR abatement and AP expenditure Accrual query into one query. Displays all AR and AP expenditure Accrual. - Update Prompts display |
Monthly | ||
| AR | Query | DFQ | DFQ_AR_04_ITEMS_VALIDATION | Reporting Tools > Query > Query Viewer | Lists AR item transactions. | Monthly | ||
| AR | Query | DFQ | DFQ_AR_05_CUSTOMERS | Reporting Tools > Query > Query Viewer | Lists AR Customers. | Monthly | ||
| AR | Query | DFQ | DFQ_AR_06_AGING_REPORT | Reporting Tools > Query > Query Viewer | Provides an AR aging report that displays starting balance, payments, ending balance, aging category, and customer conversations related to the AR item. | Daily/ Monthly | x | |
| AR | Query | ZZ | ZZ_AR_Accrual | Reporting Tools > Query > Query Viewer | Lists AR and Revenue journal accruals. | Daily/ Monthly | ||
| AR | Query | ZZ | ZZ_AR_PAYMENT_POSTED | Reporting Tools > Query > Query Viewer | Displays all payments posted to billing invoices or AR items, including the nominal accounts used for remitting. | Daily | ||
| AR | Query | ZZ | ZZ_ARItem_Entries_NotSentTo_GL | Reporting Tools > Query > Query Viewer | Displays all AR Item accounting entries that have not been journal-generated. | Daily/ Monthly | Q35 | Program Expenditures and Reimbursements |
| AR | Query | ZZ | ZZ_ARItem_Entries_SentTo_GL | Reporting Tools > Query > Query Viewer | Provides information on the agency's budget and related expenditures and reimbursements. | Daily/ Monthly | Q35 | Program Expenditures and Reimbursements |
| AR | Query | ZZ | ZZ_ARMisc_Entries_NotSentTo_GL | Reporting Tools > Query > Query Viewer | Displays receipt accounting entries that have not been journal-generated. | Daily/ Monthly | ||
| AR | Query | ZZ | ZZ_Cash_Receipts_Report | Reporting Tools > Query > Query Viewer | Displays deposit, payment, and chartfield data for receipt transactions. | Monthly | ||
| AR | Query | ZZ | ZZ_DEPOSIT_LOG | Reporting Tools > Query > Query Viewer | Shows deposit information/details and notes. | Monthly | ||
| AR | Query | ZZ | ZZ_Outstanding_Deposit | Reporting Tools > Query > Query Viewer | Used to review and correct outstanding transactions before month-end close. | Monthly | ||
| AR | Query | ZZ | ZZ_Outstanding_Items | Reporting Tools > Query > Query Viewer | Displays AR items that were entered but not successfully posted to GL. | Monthly | ||
| AR | Query | ZZ | ZZ_REIMB_ ACCRUAL | Reporting Tools > Query > Query Viewer | Lists reimbursement accruals. | Daily/ Monthly | ||
| AR | Online Inquiry | Inquiry | Accounts Receivable Item Details | Accounts Receivable > Customer Accounts > Item Info > View/Update Item Details | Displays the details of AR items to validate balances that are due. | Daily/ Monthly | ||
| AR | Online Inquiry | Online Inquiry | Miscellaneous Receipts | Accounts Receivable > Payments > Direct Journal Payments > Modify Accounting Entries | Displays Journal ID numbers and chartfield entries for miscellaneous receipts. | Daily/ Monthly | ||
| CM | Report | RPTCM007 | Bank Statement Register | FI$Cal Processes > FI$Cal Report > CM Reports > Bank Statement Register | Lists transactions on the bank account statement for date range specified. | Monthly | ||
| CM | Report | RPTCM088 | CTS Account Reconciliation Report | FI$Cal Processes > FI$Cal Report > CM Reports > CTS Account Reconciliation | Cross references CPP journal ID to AP journal ID to voucher ID to Payment Reference (agency check number) for AP transactions. Cross references CRD journal ID to AR journal ID to Deposit ID for AR transactions | Monthly | ||
| CM | Query | DFQ | DFQ_CM_01_CCP_CRD_PYMT_XREF | Reporting Tools > Query > Query Viewer | Used for CTS bank reconciliation. Query cross references the Voucher Number, Journal ID, Payment Reference, and Deposit ID. BU and Accounting Date (To/From) are required fields and wildcard (%) is not permitted. Accounting period is optional. All other fields are required and wildcard (%) is permitted. | Monthly | ||
| CM | Online Inquiry | Online Inquiry | Review Customer Item Payment | Cash Management > Treasury Account > Cash Accounting > Review Customer Item Payment | Displays customer item payments, which reflect payment-related money movements. | Daily/ Monthly | ||
| CM | Query | ZZ | ZZ_CM_ENTRIES_NOTSENTTO_GL | Reporting Tools > Query > Query Viewer | Displays all Cash Management entries that have not been journal-generated. | Monthly | ||
| GL | Query | ZZ | ZZ_SUBSYS_JRNL_NOT_POSTED | Reporting Tools > Query > Query Viewer | Displays journals that have not been posted in the GL by journal ID, journal date, and business unit. Status fields and ChartFields are included in this query. | Daily/ Monthly | ||
| GL | Report | RPTGL113 | Analysis of Change in Fund Balance | FI$Cal Processes > FI$Cal Report > GL Reports > Analysis of Change in Fund Bal | Also known as the Statement of Operations, lists the beginning fund balance, additions (e.g., revenues), less deductions (e.g., expenditures), and the ending fund balance. | Annual | G04 | Analysis of Change in Fund Balance |
| GL | Query | DFQ | DFQ_GL_01_JOURNAL_DETAIL | Reporting Tools > Query > Query Viewer | Used to obtain GL journal (detail transactions) at a point of time for research purposes. The GL Processor or GL Approver can view all transactions that are sent to the GL including both system and non-system generated transactions. | Daily | ||
| GL | Report | RPTGL115 | Due To/ Due From Other Funds/Appropriations Supplemental Form | FI$Cal Processes > FI$Cal Report > GL Reports > Due To/From Supplemental Rpt. | Provides the Fund and Organization information involved in all Due To/ Due From transactions. Note: the original form will be included with the financial reports to SCO. | Annual | ||
| GL | Report | RPTGL072 | Federal Project Report (YE Report 13) | FI$Cal Processes > FI$Cal Report > GL Reports > Federal Project Report | Provides the department's expenditures and encumbrances for each federal award by (CFDA) number for federal funds. | Monthly/ Annual | ||
| GL | Report | RPTGL067 | Final Budget Report (YE Report 6) | FI$Cal Processes > FI$Cal Report > GL Reports > Final Budget Report | Provides a summary status of appropriations, which includes expenditures, encumbrances and balances for each appropriation. Follow steps in Job Aid FI$Cal.235 to generate report. | Monthly/ Annual | B06 | Final Budget Report |
| GL | Report | FIN2001 | Journal Entry Detail Report | General Ledger > General Reports > Journal Entry Detail | Shows journal entry detail information by BU, journal ID, date, description, ledger group, source, reversal, foreign currency, rate type, effective date, and effective rate. | Daily | ||
| GL | Report | GLS7002 | Ledger Activity | General Ledger > General Reports > Ledger Activity | Lists the detailed journal line activity that is posted against the ledger for the accounting periods that are specified. Also lists the beginning and ending ledger balances by chartfield combination and account. | Daily/ Monthly | HG1 | General Ledger Analysis |
| GL | Report | GLS3000 | Open Item Listing Report | General Ledger > Open Items > Open Item Listing Report | Lists open items for specified accounts, including a description of the accounts, the Open Item key field, and a detailed listing of the journal lines that have an open status up to the as of date. | Daily/ Monthly | ||
| GL | Report | RPTGL104 | Plan of Financial Adjustment (PFA) Report | FI$Cal Processes > FI$Cal Reports > GL Reports > Plan for Financial Adjustment | Used to make adjustments between funding sources for services rendered, supplies used or a proper proportion of other expenses. | Monthly | Q22 | Summarizes the results of the CALSTAS Cost Allocation process by appropriations and program. |
| GL | Report | RPTGL076 | Statement of Capital Asset Group of Accounts (YE Report 19) | FI$Cal Processes > FI$Cal Report > GL Reports > Statement of Capital Assets | Provides the capital assets of a department. It summarizes the information contained in Statement of Changes in Capital Asset Group of Accounts (YE Report 18). Follow steps in Job Aid FI$Cal.230 to generate report. | Monthly/ Annual | ||
| GL | Report | RPTGL075 | Statement of Changes in Capital Asset Group of Accounts (YE Report 18) | FI$Cal Processes > FI$Cal Report > GL Reports > Changes in Capital Asset | Provides information regarding the acquisition and dispositions of capital assets acquired by Governmental Funds during the fiscal year. Follow steps in Job Aid FI$Cal.231 to generate report. | Monthly/ Annual | G05 | Statement of Changes in Capital Assets |
| GL | Report | RPTGL077 | Statement of Financial Condition (YE Report 20) | Reporting Tools > PS/nVision > Define Report Request | Discloses the balances of the assets, liabilities, and fund equity as of June 30. This report is required when departments account for any one of the following: 1. A non-governmental cost fund in its entirety (non-shared fund) 2. An accounts within a non-governmental cost fund, such as accounts in the Federal Trust Fund and the Special Deposit Fund. Follow steps in Job Aid FI$Cal.232 to generate report. | Annual | ||
| GL | Report | RPTGL065, RPTGL155 | Statement of Revenue (YE Report 4) | FI$Cal Processes > FI$Cal Report > GL Reports > Final Statement of Revenue | Displays the total current year revenue and used to reconcile with the SCO's records. Follow the steps in Job Aid FI$Cal.233 to generate report. | Monthly/ Annual | ||
| GL | Report | RPTGL114 | Subsidiaries on File (YE Report 8) | FI$Cal Processes > FI$Cal Report > GL Reports > Subsidiaries on File | Provides the required subsidiary numbers for GL accounts that require subsidiary information. Follow steps in Job Aid FI$Cal.256 to generate report. | Annual | G02 | Subsidiaries on File |
| GL | Query | ZZ | ZZ_Ledger_Detail | Reporting Tools > Query > Query Viewer | Displays the details of accounting entries. | Daily | ||
| GL | Query | ZZ | ZZ_PFA_TRANSACTIONS | Reporting Tools > Query > Query Viewer | Detailed level of PFA transations by appropriation. Used to verify PFA transactions to make sure transactions within the Program and Fund and ENY net to zero. | Monthly | Q22 | Summarizes the results of the CALSTAS Cost Allocation process by appropriations and program. |
| GL | Report | RPTGL148 | Budget to Actual Report | FI$Cal Processes > FI$Cal Report > GL Reports > Budget to Actuals Report | Provides detail by account for each expenditure incurred summarized in chartfield combinations. | Monthly | ||
| GL, AP, AR | Report | RPTGL061, ZGL061 | Trial Balance | FI$Cal Processes > FI$Cal Report > GL Reports > Trial Balance Reports | Used to reconcile GL account balances by displaying the beginning and ending ledger balances by account number and description. | Monthly | G01 | Trial Balance of General Ledger Accounts |
| GL, AP, AR | Report | ZGL111 | Trial Balance Report By Period | FI$Cal Processes > FI$Cal Report > GL Reports > Trial Balance Report by Period | Used to ensure the sum of all debit and credit colums from each ledger Account are equal at the BU and Fund level. This supports preparing financial statements and locating errors that may have been made in the recording or posting processes. | Monthly | G01 | Trial Balance of General Ledger Accounts |
| GL, AP, AR | Report | GLS7012 | Trial Balance Report - Delivered | General Ledger > General Reports > Trial Balance | Used to reconcile GL account balances by displaying the ending ledger balances for a specified year and period by chartfield combinations. | Monthly | G01 | Trial Balance of General Ledger Accounts |
| GL, AP, AR | Report | RPTGL069 | Post-Closing Trial Balance (YE Report 8) | FI$Cal Processes > FI$Cal Report > GL Reports > Post Closing Trial Balance | Lists the net balance of all Revenue/Expense Accounts in the Fund Equity resulted from the year end close process. Follow steps in Job Aid FI$Cal.229 to generate report. | Annual | G02 | Post-Closing Trial Balance |
| GL, AP, AR | Report | RPTGL068 | Pre-Closing Trial Balance (YE Report 7) | FI$Cal Processes > FI$Cal Report > GL Reports > Pre-Closing Trial Balance | Lists the general ledger account balances for nominal and real accounts, including accruals and adjustments before nominal accounts have been closed. Follow steps in Job Aid FI$Cal.228 to generate report. | Annual | G02 | Pre-Closing Trial Balances |
| GM | FFR | Federal Financial Report (FFR) | Grants > Interactive Reports > Federal Financial Report | Displays departments grant amounts and state share, cash disbursements, cash receipts, cash on hand, and total federal expenditures. | Monthly/ Annual | |||
| GM | Report | RPTGM002 | Detail of Project Revenues and Expenditures | FI$Cal Processes > FI$Cal Report > GM Reports > Summary of Proj Revenue & Exp | Displays the Project Revenues and Expenditure by BU. Based on the Project and Activity the Customer is undertaking, the report will display the details of Revenues, Expenditures, Budgets, and Commitments. | Monthly | ||
| GM | Report | RPTGM002 | Summary of Project Revenues and Expenditures | FI$Cal Processes > FI$Cal Report > GM Reports > Summary of Proj Revenue & Exp | Displays the Project Revenues and Expenditure by BU. Based on the Project and Activity the Customer is undertaking, the report will display the summary of Revenues, Expenditures, Budgets, and Commitments. | Monthly | ||
| KK | Report | RPTGL051 | Program Disbursement Activity Report (PDA Report) | FI$Cal Processes > FI$Cal Report > GL Reports > Program Disbursement Activity | Displays the expenditures, encumbrances, and budget amounts for all chartfield combinations, separated by account. The PDA report data can be downloaded using Monarch to show data at various levels. Data can be filtered and sorted using excel. | Monthly | Q10, Q12, Q14, Q16, Q35 | Expenditures by Program, Organization and Object |
| KK | Report | ZGL013 | Agency Reconciliation Report | FI$Cal Processes > FI$Cal Report > GL Reports > Agency Reconciliation Report | Used to reconcile expenditures, revenue, and reimbursement balances between departments and the SCO. | Monthly | DB1, DB2 | SCO Reconciliation Report |
| KK | Online Inquiry | Online Inquiry | Budget Overview Inquiry | Commitment Control > Review Budget Activities > Budget Overview | Used to verify appropriation balances and reconcile with SCO. | Daily | HB4, H02, Q24, Q25 | Include appropriation and receipt transactions used to reconcile with SCO. |
| KK | Report | GLS8020 | Budget Status Report | Commitment Control > Budget Reports > Budget Status | Displays all Commitment Control ledger amounts (budgeted, pre-encumbrance, encumbrance, expenditure, reimbursements) and the available balance for the budgets selected. | Daily | ||
| KK | Report | GLS8005 | Budget Transaction Detail Account | Commitment Control > Budget Reports > Budget Transaction Detail | Shows transaction level detail information by chartfield values. | Daily | ||
| KK | Query | DFQ | DFQ_ALO_01_KK_ACTIVITY | Reporting Tools > Query > Query Viewer | Used to: 1) validate initial allocation configurations, 2) determine whether allocation steps ran as expected, and 3) filter data to see portions of each step. This query shows the entries created in the ByPass Ledgers (ALLC_ENC/ALLC_EXP) during the MEC Allocations process. | Monthly | ||
| KK | Query | DFQ | DFQ_KK_01_ACTIVITYLOG_SUP_PROJ | Reporting Tools > Query > Query Viewer | KK ActivityLog w/ Suppl & Proj Displays KK Activity as per original query with the following modifications: - Additional fields added, including Supplier Name & ID, Project ID, Activity ID, & others - Ledger Group & ENY fields made optional - Symbol * added for required fields - Prompt table added for Ledger Group field |
Monthly | ||
| KK | Query | DFQ | DFQ_KK_02_BUDGET_JRNL_LINES | Reporting Tools > Query > Query Viewer | Used to extract budget journal lines for selected ledger. (The query provides easier to navigate data than reviewing each of the budget journals online). | Daily | ||
| KK | Query | DFQ | DFQ_KK_03_CHARTFIELD_SUMMARY | Reporting Tools > Query > Query Viewer | Used to extract summary level expenditures/encumbrances/etc by chartfield combination. | Daily | ||
| KK | Query | DFQ | DFQ_KK_04_CHARTFIELD_DETAIL | Reporting Tools > Query > Query Viewer | Used to extract more detailed summary level expenditures/encumbrances/etc by chartfields and account. | Daily | ||
| KK, LD | Query | ZZ | ZZ_BUDGET_ERR_ONLY | Reporting Tools > Query > Query Viewer | Lists accounting entries that encountered errors during Budget Checking. These entries are not posted to KK and as such, must be researched and corrective action taken prior to runnin the LD process again. | Daily | ||
| LD | Query | DFQ | DFQ_LD_01_CLO_SUMMARY | Reporting Tools > Query > Query Viewer | Used for LD reconciliation. The line items in the query are compared with the SCO's Monthly Agency Reconciliation report. | Monthly | ||
| LD | Query | DFQ | DFQ_LD_02_CLO_EMP_SUMMARY | Reporting Tools > Query > Query Viewer | Used for LD reconciliation. The line items in the query are compared with the SCO's Monthly Agency Reconciliation report. The query includes employee details (listed by payroll clearance number) to research discrepancies to the employee level. | Monthly | ||
| LD | Query | DFQ | DFQ_LD_03_ACCT_ENTRIES | Reporting Tools > Query > Query Viewer | Used to view all LD detail line items as they are to be posted according to their employee activity sheets, employee default options, or employee group options. The query will include the distribution status indicating if the line item has been posted or if there are any errors that need to be addressed before completion. | Monthly | ||
| LD | Query | Query | LD_ACCT_ENTRIES_NOT_SENT_TO_GL | Reporting Tools > Query > Query Viewer | Displays all Labor Distribution entries that have not been journal-generated. Entries are required to journal-generate to the GL before the amount can be reported on ledger based reports. | Monthly | L02 | Labor Distribution |
| LD | Query | ZZ | ZZ_CHARTFLD_ERR | Reporting Tools > Query > Query Viewer | Provides listing of all accounting entries that failed Combination Edits and identifies the related error(s). | Monthly | ||
| LD | Query | ZZ | ZZ_DEPT_EMP_POS_RPT | Reporting Tools > Query > Query Viewer | Displays Employee ID numbers that are used for Salary Advances. | Monthly | ||
| LD | Query | ZZ | ZZ_LD_ACCT_ENTRIES | Reporting Tools > Query > Query Viewer | Provides accounting entries created by LD and identifies the employee and position number associated with each entry. | Monthly | L02 | Labor Distribution |
| LD | Query | ZZ | ZZ_LD_PAYROLL_BENEFITS | Reporting Tools > Query > Query Viewer | Lists Payroll Benefits, with the benefit amount and other information in the payroll record from SCO, for a specific BU, FY, and Accounting Period. | Monthly | ||
| LD | Query | ZZ | ZZ_LD_PAYROLL_HEADERS | Reporting Tools > Query > Query Viewer | Lists Payroll Headers, with gross amount and other information in the payroll record from SCO (excluding State share of benefit amounts), for a specific BU, FY, and Accounting Period. | Monthly | ||
| LD | Query | ZZ | ZZ_LD_UNDIST_PAYROLL | Reporting Tools > Query > Query Viewer | Provides payroll records, for the fiscal year and accounting period, which have not been distributed by labor distribution. | Monthly | ||
| LD | Query | ZZ | ZZ_PAYROLL_ERR | Reporting Tools > Query > Query Viewer | Displays labor related errors for payroll issues (e.g. missing employees, units, etc.) after LD run. | Monthly | ||
| LD | Query | ZZ | ZZ_EMP_DEFAULTS | Reporting Tools > Query > Query Viewer | Lists Employee Default records. | Daily/ Monthly | ||
| LD | Report | RPTGL117 | Labor Details by Empoyee | FI$Cal Processes > FI$Cal Report > LD Reports > Labor Details by Employee | Lists labor distribution expenditures for the period. | Monthly | ||
| LD | Query | ZZ | ZZ_EMP_GROUP_LIST | Reporting Tools > Query > Query Viewer | Lists all Employee Group Default recrods that have Defaults configured specifically to them. | Monthly | ||
| LD | Query | ZZ | ZZ_EMP_OPT_LIST | Reporting Tools > Query > Query Viewer | Lists all Employee Options records for Employee IDs which have been configured specifically to the BU. | Monthly | ||
| LD | Query | ZZ | ZZ_LD_EMPS_WITH_PRU_DEFAULTS | Reporting Tools > Query > Query Viewer | Lists all Employee ID records for the requested. This is only for the Employee IDs which have been configured specifically to the BU, Payroll Agency Code, and Reporting Unit. | Monthly | ||
| PC | Report | RPTPC036 | Project Financial Report | FI$Cal Processes > FI$Cal Report > PC Reports > Project Financial Report | Provides a summary of Project expenditures, revenues, and statistics (units). | Monthly/ Annual | F01 | Project Financial Report |
| PC | Query | ZZ | ZZ_PC_ACCT_ENTRIES_NOT_SENT_TO | Reporting Tools > Query > Query Viewer | Displays PC accounting entries not sent to GL. | Daily/ Monthly | ||
| PC | Query | ZZ | ZZ_PROJECT_TRANSACTIONS | Reporting Tools > Query > Query Viewer | Provides detailed data of project related transactions. | Daily/ Monthly | ||
| PO | Report | RPTPO189 | Encumbrance Status by PO Report | FI$Cal Processes > FI$Cal Report > PO Reports > Encumbrance Status by PO | Used to identify the Encumbered amount, Expensed amount, and Remaining Encumbrance amount by total for each PO. | Daily | ||
| PO | Query | DFQ | DFQ_PO_01_ENC_STATUS_BY_PO | Reporting Tools > Query > Query Viewer | Used to reconcile Encumbrances. Lists the Encumbered amount, Expensed amount, and Remaining Encumbrance amount by sub-total for each PO. Use query data to reconcile PO balances to source documents. The Accounting From Date defaults to ’01-01-1901’ and the Accounting To date defaults to the current date. All other fields are optional. | Daily/ Monthly | ||
| PO | Query | DFQ | DFQ_PO_02_ACTIVITY_ACCTG_ENTRY | Reporting Tools > Query > Query Viewer | Used to obtain backup supporting information (PO accounting entries and GL encumbrance transactions) at a point of time for Report 6 – Final Budget Report at the organization (BU) level. | Monthly/ Annual | ||
| PO | Query | DFQ | DFQ_PO_03_ENCUMBRANCE_ACCRUAL | Reporting Tools > Query > Query Viewer | Used to obtain PO encumbrance balance by Fiscal Year and Period for month-end reconciliation. | Annual | ||
| PO | Query | DFQ | DFQ_PO_04_VALIDATION | Reporting Tools > Query > Query Viewer | Used to obtain a list of POs for validation. | Daily | ||
| System | Query | DFQ | DFQ_SYS_01_USER_ROLE_LOOKUP | Reporting Tools > Query > Query Viewer | Used to display roles assigned to UserIDs using an individual's Name (First and Last) as the search criteria. Names must be entered as listed in the Description field. The Lookup feature allows users to search for names by UserID or partial Description. | Daily | ||
no reviews yet
Please Login to review.
