Mars Current Reports Listings
6/6/2007
This document provides a current listing of reports offered through the MARS Management Reporting Database (MRDB) and |
Document Direct. |
Training for accessing these reports using Seagate and Document Direct is available through the Finance Customer |
Resource Center Training Branch @ http://www.state.ky.us/agencies/adm/mars/marstraining.htm. |
To register for training, contact your agency’s Training Team Lead. A list of training leads is provided in the MARS & |
Administrative Services Agency Contacts document posted @ http://www.state.ky.us/agencies/adm/mars/contacts.doc. |
For assistance, contact the Finance Customer Resource Center by e-mail @ Finance.CRCGroup@mail.state.ky.us or phone |
(502-564-9641 or toll-free 877-973-HELP). |
MRDB Seagate Financial Reports |
The following reports are currently available through Seagate Info Desktop as part of the MARS Management Reporting Database |
(MRDB). These reports are accessed through Seagate Info Desktop software. Seagate software must be loaded on the users |
desktop in order to access these reports. Users will view data for those agencies they have access to as defined by the security |
profile established within ADVANTAGE. |
These reports are consistent with the old STARS reports as far as report number, report title and layout. The new |
reports, however, incorporate MARS accounting elements. |
Page 1 of 9
3:30:13AM
6/6/2007
3:30:13AM
Print Time
Data Time
Mars Current Reports Listings
Reports Located on Server/Directory: |
Reports from Cingular System |
0100 CINGULAR PHONE SUMMARY
0110 CINGULAR DETAILED PHONE CALLS
0111 CINGULAR MONTHLY CHARGES
0112 CINGULAR DETAILED LONG DISTANCE
0113 CINGULAR DETAILED ROAMING CALLS
0114 DETAILED CINGULAR PHONE BILL
0115 CINGULAR DETAILED CREDITS
Reports Located on Server/Directory: |
1100 ALLOTMENT FILE LISTING
1101 DAILY ALLOTMENT FILE LISTING STU
1102 ANNUAL ALLOTMENT BALANCE
1120 DAILY APPROPRIATION FILE LISTING
1540 ALLOTMENT DETAIL C1
1
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
1100CP ALLOTMENT FILE LISTING
1102CP ANNUAL ALLOTMENT BALANCE
1540CP ALLOTMENT DETAIL
Reports Located on Server/Directory: |
1110 CASH CONTROL
1550 CASH DETAIL
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
1110CP CASH CONTROL
1550CP CASH DETAIL
Reports Located on Server/Directory: |
1050 REVENUE SUMMARY
1051 REVENUE DETAIL
Reports Located on Server/Directory: |
3190 AGENCY 10099 REPO
3190-P AGENCY 1099 REPORT PREVIEW
3191 STATEWIDE 1099 REPO
MONTHLY ALLOTMENT REPORTS |
Reports Located on Server/Directory: |
Reports that contain the extension _PARM are monthly reports |
2100 MONTHLY ALLOT SUMMARY PARM
P
2260 EXPENDITURE ANALYSIS BY FUND ALLOTMEN
2260 EXPENDITURE ANALYSIS BY FUND ALLOTMENT PARM
2260 EXPENDITURE ANALYSIS BY FUND ALLOTMENT PARM YTD
2262 EXPENDITURE ANALYSIS BY ALLOTMEN
2262 EXPENDITURE ANALYSIS BY ALLOTMENT PARM
P
2262 EXPENDITURE ANALYSIS BY ALLOTMENT PARM YTD
P
2540 MONTHLY ALLOT DETAIL PARM
P
2
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
MONTHLY ALLOTMENT REPORTS |
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
Reports that contain the extension _PARM are monthly reports |
2100CP MONTHLY ALLOTMENT BALANCE PARM
P
2540CP MONTHLY ALLOTMENT DETAIL PARM
Reports Located on Server/Directory: |
Reports that contain the extension _PARM are monthly reports |
2110 MONTHLY CASH SUMMARY PARM
P
2550 MONTHLY CASH DETAIL PARM
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
Reports that contain the extension _PARM are monthly reports |
2110CP MONTHLY CASH BALANCE PARM
P
2550CP MONTHLY CASH DETAIL PARM
P
MONTHLY CHECKWRITER PAYMENT R |
Reports Located on Server/Directory: |
2600 CHECKWRITER PAYMENT CHECK REGISTE
MONTHLY ENCUMBRANCE REPORTS |
Reports Located on Server/Directory: |
2302 OUTSTANDING ENCUMBRANCES
2303 OUTSTANDING PRE ENCUMBRANCES
MONTHLY EXPENDITURE REPORTS |
Reports Located on Server/Directory: |
2210 EXPENDITURE ANALYSIS BY FUND PBU OBJ
2210 MONTHLY EXPD FD PBU OBJ PARM
2210 MONTHLY EXPD FD PBU OBJ PARM YTD
2220 EXPENDITURE ANALYSIS BY AGY PBU OBJ
2220 MONTHLY EXPD AGY PBU OBJ PARM
2220 MONTHLY EXPD AGY PBU OBJ PARM YTD
2230 EXPENDITURE ANALYSIS BY FUND ORG PARM
2230 EXPENDITURE ANALYSIS BY FUND ORG PARM YTD
2230 EXPENDITURE ANALYSIS FUND ORG
2240 EXPENDITURE ANALYSIS BY ORG
2240 EXPENDITURE ANALYSIS BY ORG PARM
P
2240 EXPENDITURE ANALYSIS BY ORG PARM YTD
P
2450-F MONTHLY EXPENDITURE BY FUND REPO
3
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
MONTHLY FIXED ASSETS REPORTS |
Reports Located on Server/Directory: |
5003 FIXED ASSETS BY AGENCY
5004 FIXED ASSETS DETAIL
MONTHLY MANAGEMENT BUDGET RE |
Reports Located on Server/Directory: |
2380 COUNTY FEES BUDGET TO ACTUAL PARM
2440 MONTHLY MANAGEMENT BUDGET ANALYSIS BY AGENCY
2450 MONTHLY BUDGET TO ACTUAL REPO
2450C MONTHLY BUDGET TO ACTUAL BY CLASS REPO
2450P MONTHLY BUDGET TO ACTUAL BY PBU REPO
2450T MONTHLY BUDGET TO ACTUAL BY TYPE REPO
Reports Located on Server/Directory: |
Reports that contain the extension _PARM are monthly reports |
0001 PROCARD MONTHLY SETTLEMENT REPORT PARM
P
0002 PROCARD MONTHLY STATEMENT OF ACCOUNT PARM
P
0003 PROCARD MONTHLY TRANSACTION STATUS PARM
P
Reports Located on Server/Directory: |
Reports that contain the extension _PARM are monthly reports |
2030 MONTHLY PROJECT DETAIL PARM
P
2030 MONTHLY PROJECT DETAIL PARM SW
P
2031 MONTHLY PROJECT ITD PARM
2034 MONTHLY PROJECT FILE LISTING
Reports Located on Server/Directory: |
2038 PROJECT REVENUE EXCEPTION REPO
2050 REVENUE DETAIL PARM
P
2051 REVENUE DETAIL PARM
P
2150 MONTHLY REVENUE SUMMARY BY AGY PARM
2151 MONTHLY REVENUE SUMMARY BY FUND AGY PARM
2152 MONTHLY REVENUE SUMMARY BY FUND AGY PBU PARM
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
2150CP MONTHLY REVENUE SUMMARY BY AGY PARM
2151CP MONTHLY REVENUE SUMMARY BY FUND AGY PARM
2152CP MONTHLY REVENUE SUMMARY BY FUND AGY PBU PARM
4
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
Reports Located on Server/Directory: |
1111 MONTHLY TRAVEL SUMMARY BY CAB/AGENCY
1111 TRAVEL SUMMARY BY CAB/AGENCY 2003
Reports Located on Server/Directory: |
Reports that contain the extension _PARM are monthly reports |
2160 MONTHLY VENDOR REPORT PARM
P
2160 MONTHLY VENDOR REPORT YTD PARM
Reports Located on Server/Directory: |
VW PCARD ACTIVITY LOG
Reports Located on Server/Directory: |
YE indicates that the report IS design TO address year END TRANSACTION data |
2110YE MONTHLY CASH BALANCE YEAREND
2550YE MONTHLY CASH DETAIL YEAREND
Reports Located on Server/Directory: |
Fund 0200 Capital Project Reports ONLY |
YE indicates that the report IS design TO address year END TRANSACTION data |
2110CPYE MONTHLY CASH BALANCE YEAREND
2550CPYE MONTHLY CASH DETAIL PARM
YEARLY MANAGEMENT BUDGET REPOR |
Reports Located on Server/Directory: |
2440 YTD MANAGEMENT BUDGET ANALYSIS BY AGENCY PARM
2453 YTD MANAGEMENT BUDGET ANALYSIS BY PBU PARM
5
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
Reports Located on Server/Directory: |
ADV OPEN CHECK HEADE
CHFS CONTRACT REPORT JOAN
MARS CURRENT SEAGATE REPORTS LISTINGS
MONTHLY EPAY ACH DEPOSI
MONTHLY LINK2GOV DEPOSITS
MONTHLY LINK2GOV INVOICE REOCON
MRDB PD X TABLES USERS
PD CONTRACT USAGE REPORT SUMMARY BY FUNDING
PD PROCARD HOLDERS REPORT V2
PD X INVOICE ENERGY
PERSONNEL MASTER POSTION LISTING
PERSONNEL MASTER POSTION LISTING ARCHIVE
6
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
A number of reports detailing accounting transactions are currently available through Document Direct. Access to certain |
reports may be limited to the specific agency that the data in the report covers. In some instances, agencies may be able to |
view only their agency-specific data within a subsection of a larger, statewide report. If you have questions regarding your |
access to any of the reports in Document Direct, contact your fiscal officer, who will work with your agency’s accountant in |
the Division of Statewide Accounting Services to help you retrieve the report you need. |
Cycle Form Name Report Name |
D FMPA652A OUTSTANDING PAYMENT VOUCHERS |
D FMPCKCSB PAYMENTS SKIPPED DUE TO INSUFFICIENT CASH |
D FMPTCKCB TRAVEL PAYMENTS SKIPPED DUE TO INSUFFICIENT CASH |
D FMPVOFTA VENDOR OFFSET FUNDS TRANSFER REPORT |
D FMPVOFTB VENDOR OFFSET DETAIL INTERCEPT REPORT |
D FMPVOP1B INTERCEPT EXCEPTION REPORT FOR PAYMENTS |
D FMPVOP2B INTERCEPTED EXCEPTION REPORT FOR TRAVEL PAYMENTS |
D FMP655AB SCHEDULED PAYMENT TURNAROUND REPORT (BEFORE) |
D FMP655BB SCHEDULED PAYMENT TURNAROUND REPORT (AFTER) |
D FMP656AB UNSCHEDULED PAYMENT TURNAROUND REPORT (BEFORE) |
D FMP656BB UNSCHEDULED PAYMENT TURNAROUND REPORT (AFTER) |
DOCUMENT LISTING MAINTENANCE REPORTS |
Cycle Form Name Report Name |
M FMPI501A PENDING TRANSACTIONS IN SUSPENSE FILE IN EXCESS OF 30 |
ENCUMBRANCE AND EXPENDITURE REPORTS |
Cycle Form Name Report Name |
D FMPAR11B INVOICE REGISTER AND ERROR REPORT |
D FMPAR13A CUSTOMER STATEMENTS |
D FMPAR13B STATEMENT REGISTER AND ERROR REPORT |
D FMPARWOA SCHEDULED WRITE OFF REPORT |
M FMPA400A DETAIL LISTING OF ENCUMBRANCES VS. EXPENDITURES BY ACCOUNTING DISTRIBUTION |
M FMPA612A STATEMENT OF BUDGET ACTIVITY AND ACCOUNT BALANCES |
D FMPA642A OUTSTANDING PURCHASE ORDERS |
M FMPA706A PLAN VS. ACTUAL SUMMARY BY OBJECT/REPORTING CATEGORY |
M FMPA707A PLAN VS. ACTUAL SUMMARY BY OBJECT/JOB NUMBER |
M FMPA708A AVAILABLE FUNDS SUMMARY BY PROJECT |
M FMP103AA DETAIL LISTING OF OBLIGATION VS. BUDGET AT PBU LEVEL |
M FMP103BA DETAIL LISTING OF OBLIGATION VS. BUDGET AT ALLOTMENT |
M FMP103CA DETAIL LISTING OF OBLIGATION VS. BUDGET AT APPROPRIATION |
M FMP104AA DETAIL LISTING OF OBLIGATIONS VS EXP BUDGET AT PBU (BY ORG) |
M FMP104BA DETAIL LISTING OF OBLIGATIONS VS EXP BUDGET AT AL (BY ORG) |
7
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
M FMP104BA DETAIL LISTING OF OBLIGATIONS VS EXP BUDGET AT AL (BY ORG) |
M FMP104CA DETAIL LISTING OF OBLIGATIONS VS EXP BUDGET AT AP (BY ORG) |
M FMP104DA DETAIL LIST OBLIGATIONS VS EXP BUDGET AT CSH CTRL LEVEL |
Cycle Form Name Report Name |
D FMPFDGNA FIXED ASSET DISPOSITION COMING TO SURPLUS PROPERTY |
D FMPIN40A INVENTORY MANAGEMENT REPORT |
D FMPIN45A INVENTORY AGENCY-ORGANIZATION INV MGMT REPORT (CONSOLIDATED) |
D FMPIN51A INVENTORY CONTROL SUBSYSTEM STOCK MOVEMENT REPORT |
OR FMPIN70A PHYSICAL INVENTORY DISCREPANCY REPORT |
D FMPIN90A INVENTORY AGENCY-ORGANIZATION REPLENISHMENT REVIEW REPORT |
D FMPX002A FIXED ASSET TRANSACTION DETAIL |
PROJECTS AND GRANTS REPORTS |
Cycle Form Name Report Name |
M FMPA711A TRANSACTION DETAIL BY JOB NUMBER |
W FMPFINLA FWHA BILLING DETAIL REPORT |
W FMPFINLB FEDERAL BILLING REPORT (NON-FHWA) |
W FMPFINLC THIRD PARTY BILLING REPORT |
M FMPGF01A PROJECT/GRANT EXPENDITURE SUMMARY REPORT |
OR FMPGF02A PROJECTS/GRANTS TRANSACTION DETAIL ACCOUNTING REPORT |
D FMPG110A PROJECT/GRANT REVENUE DETAIL |
D FMPG111A PROJECT/GRANT EXPENDITURE DETAIL |
M FMPJ001A JOB BILLING REPORT |
D FMPMEMOA REPORT OF DEPLETED FUNDING SOURCES |
D FMPMEMOB REPORT OF FHWA UNBILLED COSTS, PREP |
D FMPMEMOC REPORT OF NON-FHWA UNBILLED COSTS |
D FMPMEMOD FHWA BILLING TURNAROUND REPORT |
D FMPMEMOE REPORT OF SUSPENDED CE COSTS |
D FMPMEMOF FHWA BILLING SUMMARY REPORT |
D FMPMEMOG FEDERAL BILLING REPORT (NON-FHWA) |
D FMPMEMOH THIRD PARTY BILLING REPORT |
D FMPMEMOI FUND TRANSFER REPORT |
D FMPMEMOJ FHWA BILLING DETAIL REPORT |
D FMPMEMOK PROJECT BILLING SETUP ASSURANCE REPORT |
D FMPMEMOL REPORT OF SUSPENSE TRANSFERS BILLING |
OR FMPPBBTA COST ALLOCATION AUTOMATED BUILD REPORT |
D FMPPBDFA POOL/BASE DEFINITION REPORT |
W FMPPBDGA PROJECT BILLING DRAWDOWN GENERATION PROCESS |
W/M FMPPBDGC DRAWDOWN INFORMATION BY SUBRECIPIENT |
W/M FMPPBDGD DRAWDOWN BY PROGRAM BUDGET UNIT |
W FMPPBDQA SUMMARY OF DRAWDOWN GROUP |
W FMPPBRQA DRAWDOWN REDUCTIONS APPLIED |
D FMPP170A PAPR EXCEPTION REPORT FOR OPEN SUBPROJECTS |
W FMPREVWA REPORT OF DEPLETED FUNDING SOURCES |
W FMPREVWB FHWA BILLING TURNAROUND REPORT |
W FMPREVWC REPORT OF SUSPENDED CE COSTS |
W FMPREVWD FHWA BILLING SUMMARY REPORT |
W FMPREVWE FEDERAL BILLING REPORT (NON-FHWA) |
W FMPREVWG FUND TRANSFER REPORT |
8
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |
Mars Current Reports Listings
W FMPREVWG FUND TRANSFER REPORT |
W FMPREVWH FHWA BILLING DETAIL REPORT |
W FMPREVWI PROJECT BILLING SETUP ASSURANCE PROGRAM |
W FMPREVWJ REPORT OF FHWA UNBILLED COSTS, PREP |
W FMPREVWK REPORT OF NON-FHWA UNBILLED COSTS |
W FMPREVWL REPORT OF SUSPENSE TRANSFERS BILLING |
Cycle Form Name Report Name |
D FMPAR38A OPEN RECEIVABLE TABLE - VS - REVENUE LEDGER EXCEPTION REPORT |
M FMPA203A DETAIL LISTING OF REVENUES (VS. BUDGET) |
M FMPA271A REVENUE SOURCE SUMMARY OF REVENUES RECOGNIZED VS. BUDGETS |
OR FMPAR30A REVENUE SOURCE SUMMARY REPORT |
OR FMPAR31A PAST DUE RECEIVABLE DETAIL REPORT |
OR FMPAR32A SUMMARY AGING REPORT BY CUSTOMER |
OR FMPAR34A CUSTOMER CREDIT BALANCE REPORT |
Cycle Form Name Report Name |
M FMPF220A COMBINED STATEMENT OF REV, EXPEND,& CHANGES FB-GEN SPEC CAP |
M FMPF230A COMBINED STATEMENT OF REV, EXPEND,& CHANGES FB-PROP |
1 “D” refers to Daily Reports; “M” refers to Monthly Reports; “W” refers to Weekly Reports; “OR” refers to reports which are |
available On Request”. To request a report, contact your agency’s fiscal officer who will work with his/her designated accountant |
in the Division of Statewide Accounting Services. |
9
“CP” indicates that the report contains 02 fund information for Capital Projects only. |
1 “P” indicates that this is a “PARM” report. Reports that contain the extension _PARM are monthly reports where |
the |
user has the ability to designate parameters for the fiscal month and fiscal year for which the report is to be run . |
2 “CP” indicates that the report contains 02 fund information for Capital Projects only. |
3 “YE” indicates that the report is design to address year end transaction data. |