Income Statement Dashboard - DOC by qki16857

VIEWS: 33 PAGES: 43

More Info
									         LSU
Health Care Services
      Division



          Report Index




    Updated October 2008
LSUHSC HCSD Reports Index
October 2008




                                INTRODUCTION


This document presents a summary of the reports that are a vailable on the
nVision Dashboard of the PeopleSoft Database and through Crystal Reports.
For instructions on how to get to the nVision screen, go to:
http://www.lsuhsc.edu/hcsd/finance/PSTraining.htm

For each report, the following information is presented:

         Title:          Title of the button row and button name
         Screen Shot:    Screen shot of the first page of the report
         Description:    Brief description of the report
         Layout:         Name of the layout for the report
         Report Request: Title of the report request that is tied to the dashboard
         Queries:        The list of queries that are used in the report if any
         Prompts:        The number of prompts required by the report

This document uses one business unit’s screen as its example. All other HCSD
business unit screens have the same reports with the exception of the HCSD
screen. The HCSD screen includes additional reports that report on all business
units. The reports include all fund codes unless otherwise specified.

The Table of Contents link to the report descriptions contained in this document if
the document is opened in Microsoft Word.

TERMS USED:

nVision – Report writing software used with the PeopleSoft Database that is used
in HCSD to process financial and human relations information

nPlode - Refers to the process of expanding (imploding) a set of data within
prescribed limits

.xnv – The file extension used for nVision report layouts

Layout – The template or base for a report that identifies the data to be captured,
the placement of the data on the report and the formatting of the report

Report Request – A template for defining parameters of report production




                                    Page 2 of 43
LSUHSC HCSD Reports Index
October 2008


                                                Table of Contents
OPENING SCREE NS .............................................................................................................5
  nVision User Welcome Screen ............................................................................................5
  Business Unit Menu Screen ................................................................................................5
  PeopleSoft Utilities Screen ..................................................................................................6
  All Departments ..................................................................................................................6
  Projects by BU....................................................................................................................7
  All Programs.......................................................................................................................7
  Balance Sheet Accounts .....................................................................................................8
  Revenue Accounts..............................................................................................................8
  Expense Accounts ..............................................................................................................9
  Single Journal Information ...................................................................................................9
  nVision Report Requests...................................................................................................10
ACCRUA L REPORTS SCREEN ............................................................................................10
  Income Statement – All Depts 111/ 811...............................................................................11
  Income Statement – Fund 111/ 811 ....................................................................................11
  Income Statement – Fund 113/ 813 ....................................................................................12
  Income Statement – Fund 115/ 815 ....................................................................................12
  Trial Balance – All Funds ..................................................................................................13
  Trial Balance – Fund 111/811 ............................................................................................13
  Trial Balance – Fund 113/813 ............................................................................................14
  Trial Balance – Fund 115/815 ............................................................................................14
  Rev (Charges) by Payor ....................................................................................................15
  ER Rev (Charges) by Payor ..............................................................................................15
  Dept List 111/811 .............................................................................................................16
ACTUA LS REPORTS SCREEN ............................................................................................17
  Income Statement – Dept with Prompt ...............................................................................17
  Income Statement – Project Funds 113/115 .......................................................................18
  Income Statement – All Depts Fund 111 ............................................................................18
  Trial Balance – Y TD All Funds ...........................................................................................19
  Trial Balance – Cur All Funds ............................................................................................19
  Trial Balance – By Period ..................................................................................................20
  Trial Balance – Detail ........................................................................................................20
  Trial Balance – By Fund ....................................................................................................21
  Cash Receipts & Exp – All Funds.......................................................................................21
  Cash Receipts & Exp – Fund 111 ......................................................................................22
  Cash Receipts & Exp – Fund 113 ......................................................................................22
  Cash Receipts & Exp – Fund 115 ......................................................................................23
  Rev & Exp Analysis – Analysis All......................................................................................23
  Rev & Exp Analysis – Analysis HC.....................................................................................24
  Rev & Exp Analysis – Analysis Delta..................................................................................24
  Professional Services Detail ..............................................................................................25
  Other/ IA T Charges Detail ..................................................................................................25
  Inventory – Valuation ........................................................................................................26
  Dept Comparison..............................................................................................................26
Additional HCSDA Reports ....................................................................................................27
  Income Statement – Restricted Funds Trans Dtl .................................................................28
  Trial Balance – All BU’s Fund 111 ......................................................................................28
  Trial Balance – All BU’s All Funds ......................................................................................29
  Cash Rec & Exp – All BU’s & Funds ..................................................................................29
  Cash Rec & Exp – All BU’s Fund 111 .................................................................................30
  Fund 116 Project Analysis .................................................................................................30
HCS D ANNUA L FINANCIAL REP ORTS ................................................................................31
CRYS TA L REPORTS ...........................................................................................................32
  Cleanup PO MGT .............................................................................................................33

                                                         Page 3 of 43
LSUHSC HCSD Reports Index
October 2008


 HCS D MGT INV JOURNAL INFO ......................................................................................34
 HCS D MGT JOURNAL SYS INFO ACCRU ........................................................................34
 HCS D MGT JOURNAL SYS INFO APCLS .........................................................................35
 HCS D MGT JOURNAL SYS INFO APCNX ........................................................................36
 HCS D MGT JOURNAL SYS INFO .....................................................................................36
 HCS D MGT SUMMARY – Count of PO’s by Group –BU .....................................................37
 HCS D MGT SUMMARY – Count of PO’s by Group .............................................................37
 HCS D Summary Drilldown – Date Range ..........................................................................38
 HCS D Trans Detail – With ROA .........................................................................................39
 HCS D Trans Detail – Without ROA ....................................................................................39
 INV _JRN_DTL..................................................................................................................40
 Inventory Open PO REPORT ............................................................................................40
 Inventory Orders not Received ..........................................................................................41
 Inventory Receipts Outstanding by Item-Short ....................................................................41
 Inventory Receipts Outstanding by Item .............................................................................42
 Receipts Outstanding 3-Way Match ...................................................................................42
 Standing Orders by Vendor and Dept .................................................................................43




                                                      Page 4 of 43
LSUHSC HCSD Reports Index
October 2008


OPENING SCREENS
nVision User Welcome Screen




Business Unit Menu Screen
This screen appears when you click on any of the Business Units. From this screen you pick
either the Actuals or the Accruals Screens.




                                        Page 5 of 43
LSUHSC HCSD Reports Index
October 2008


PeopleSoft Utilities Screen
On the bottom of the main menu is the button to the Utilities screen.




All Departments                             All Departments




Description               List of all PeopleSoft departments
Layout Name               Departments Tabular.xnv
Report Request            DP TALL
Query                     DEPARTME NT_LIS T
Table(s)                  DEPARTME NT_TB L
Prompts                   0


                                           Page 6 of 43
LSUHSC HCSD Reports Index
October 2008




Projects by BU




Description        List of all projects in PeopleSoft for a specific business unit
Layout Name        Project List.xnv
Report Request     PROJ_LS T
Query              PROJECT_BY_BU
Table(s)           PROJECT_HEA DER
Prompts            1 (Business Unit )



All Programs




Description        List of all programs in PeopleSoft
Layout Name        Program Codes.xnv
Report Request     PROGRAM
Query              PROGRAMS
Table(s)           PROGRAM_TB L
Prompts            0

(HCSD Business Units only use Program #95001)




                                   Page 7 of 43
LSUHSC HCSD Reports Index
October 2008




Balance Sheet Accounts




Description      List of all Balance Sheet Accounts in PeopleSoft
Layout Name      Accounts Balance Sheet.xnv
Report Request   ACCT_BAL
Query            ACCTS _BAL
Table(s)         GL_A CCOUNT_TBL
Prompts          0




Revenue Accounts




Description      List of all Revenue Accounts in PeopleSoft
Layout Name      Accounts Revenue.xnv
Report Request   ACCT_REV
Query            ACCTS _REV
Table(s)         GL_A CCOUNT_TBL
Prompts          0




                               Page 8 of 43
LSUHSC HCSD Reports Index
October 2008




Expense Accounts




Description      List of all Expenditure Accounts in PeopleSoft
Layout Name      Accounts Revenue.xnv
Report Request   ACCT_E XP
Query            ACCTS _E XP
Table(s)         GL_A CCOUNT_TBL
Prompts          0




Single Journal Information




Description      Provides specific detail, such as Operator ID, for a specific
                 journal based on the Journal ID, Journal Date and Business Unit
Layout Name      Single Journal Tabular .xnv
Report Request   SNG_JRNL
Query            HCS D_S INGLE _JRNL_INFO_QUERY
Table(s)         JRNL_HEA DER
Prompts          3 (Business Unit, Journal ID, Journal Date)




                                 Page 9 of 43
LSUHSC HCSD Reports Index
October 2008




nVision Report Requests




Description      List of all PeopleSoft Reports by Report Request for a specific
                 Business Unit
Layout Name      Report Requests Tabular.xnv
Report Request   REP T_REQ
Query            REPORT_REQUESTS
Table(s)         NVS_REP ORT
Prompts          1 (Business Unit )

ACCRUAL REPORTS SCREEN




                               Page 10 of 43
LSUHSC HCSD Reports Index
October 2008




Income Statement – All Depts 111/811




Description        Executive level report of accrued and actual revenues and
                   expenditures in all departments within a Business Unit; nplodes
                   on revenues and expenditures
Layout Name        Dept Exp by BU by Dept 111a.xnv
Report Request     DEP T111A
Query              HCS D_A CTUALS_A CCRUALS
Table(s)           LEDGE R
Prompts            0


Income Statement – Fund 111/811




Description        Report of Actuals and Accruals for a single Department in Operating
                   Funds
Layout Name:       Dept Actuals & Accruals - By Dept - Fund 111.xnv
Report Request :   DP TAA111
Queries            HCS D_DEP T_B UDGE T_P ROMP T_111
                   HCS D_DEP T_P ROMP T_111
                   HCS D_DEP T_P ROMP T_811
Table(s)           LEDGE R_KK
                   LEDGE R
Prompts            3 (Department)

                                  Page 11 of 43
LSUHSC HCSD Reports Index
October 2008



Income Statement – Fund 113/813




Description        Report of Actuals and Accruals for a single Department in Restricted
                   Funds
Layout Name:       Dept Actuals & Accruals - By Dept - Fund 113.xnv
Report Request :   DP TAA113
Queries            HCS D_DEP T_B UDGE T_P ROMP T_113
                   HCS D_DEP T_P ROMP T_113
                   HCS D_DEP T_P ROMP T_813
Table(s)           LEDGE R_KK
                   LEDGE R
Prompt             3 (Department)


Income Statement – Fund 115/815




Description        Report of Actuals and Accruals for a single Department in Budgeted
                   Restricted Funds
Layout Name        Dept Actuals & Accruals - By Dept - Fund 115.xnv
Report Request     DP TAA115
Queries            HCS D_DEP T_B UDGE T_P ROMP T_115
                   HCS D_DEP T_P ROMP T_115
                   HCS D_DEP T_P ROMP T_815
Table(s)           LEDGE R_KK
                   LEDGE R
Prompt             3 (Department)




                                  Page 12 of 43
LSUHSC HCSD Reports Index
October 2008



Trial Balance – All Funds




Description      Trial balance report that nplodes accounts for all funds,
                 separated by actuals and accruals
Layout Name      Trial Balance Actuals & Accruals-All Funds.xnv
Report Request   TBAAALL
Query            NA
Table(s)         Ledger
Prompts          0


Trial Balance – Fund 111/811




Description      Trial balance report that nplodes accounts for Fund 111,
                 separated by actuals and accruals
Layout Name      Trial Balance Actuals & Accruals-Fund 111.xnv
Report Request   TBAA111
Query            NA
Table(s)         Actuals Ledger
Prompts          0




                                  Page 13 of 43
LSUHSC HCSD Reports Index
October 2008



Trial Balance – Fund 113/813




Description      Trial balance report that nplodes accounts for Fund 113,
                 separated by actuals and accruals
Layout Name      Trial Balance Actuals & Accruals-Fund 113.xnv
Report Request   TBAA113
Query            NA
Table(s)         Actuals Ledger
Prompts          0


Trial Balance – Fund 115/815




Description      Trial balance report that nplodes accounts for Fund 115,
                 separated by actuals and accruals
Layout Name      Trial Balance Actuals & Accruals-Fund 115.xnv
Report Request   TBAA115
Query            NA
Table(s)         Actuals Ledger
Prompts          0



                                  Page 14 of 43
LSUHSC HCSD Reports Index
October 2008




Rev (Charges) by Payor




Description      Patient Revenue by Payor in aggregate and divided by inpatient
                 & outpatient; presented by month. Data and charts are provided
Layout Name      HCSD Patient Revenue by Payor.xnv
Report Request   PTREV
Query            NA
Table(s)         HCS D_Accruals Ledger



ER Rev (Charges) by Payor




Description      Emergency Room (Dept2047100) Patient Revenue by Payor in
                 aggregate and divided by inpatient and outpatient; presented by
                 month. Data and charts are provided
Layout Name      HCSD Patient Revenue by Payor.xnv
Report Request   PTREV_ER
Query            NA
Table(s)         HCS D_Accruals Ledger



                               Page 15 of 43
LSUHSC HCSD Reports Index
October 2008




Dept List 111/811




Description      List of total actual and accrual expenditures by department
                 that nplodes on all departments used by the business unit
                 within the fiscal year
Layout Name      DeptList by BU 111.xnv
Report Request   DPTLSTUT
Query            HCS D_A CTUALS_A CCRUALS
Table(s)         LEDGE R
Prompts          0




                              Page 16 of 43
LSUHSC HCSD Reports Index
October 2008


ACTUALS REPORTS SCREEN




Income Statement – Dept with Prompt




Description      Layout for hospitals that nplodes to all hospital income and gives
                 expenditure details with columns for fiscal year budget, fiscal year
                 actual and open commitments. When the report runs, a column for
                 each period that has elapsed will nplode/populate in a column
                 before the fiscal year actual column. This layout includes a prompt
                 so the end-user can request report by fund & department.
Layout Name      Sch of Rev and Expense with Prompt.xnv
Report Request   RVEXDEPT
Queries          HCSD_DEPT_BUDGET_PROMPT
                 HCSD_DEPT_PROMPT
Table(s)         BUD_JRNL_LN
                 LEDGE R
Prompts          3 sets of 2 (Fund and Department)




                                 Page 17 of 43
LSUHSC HCSD Reports Index
October 2008




Income Statement – Project Funds 113/115




Description      Layout that gives Restricted Fund expenditure details for a
                 specific project number. The report includes transactions in
                 Funds 113 and 115. The end-user is prompted for the project
                 number. Once the report runs, the user can type the project
                 number into the space allowed in the in the heading.
Layout Name      Project Year to Date by Month.xnv
Report Request   113PRMPT
Query            HCSD_PROJECT_YEAR_TO_DATE
Table(s)         LEDGER
# of Prompts     2



Income Statement – All Depts Fund 111




Description      Executive level report of actual revenues and expenditures in all
                 departments within a Business Unit in Fund 111; nplodes on
                 revenues and expenditures
Layout Name      Dept Exp by BU by Dept 111.xnv
Report Request   DEP T111
Query            NA
Table(s)         Ledger
Prompts          0


                               Page 18 of 43
LSUHSC HCSD Reports Index
October 2008



Trial Balance – YTD All Funds




Description      Trial Balance that nplodes to the expenditure accounts with
                 columns for each fund used in the year
Layout Name      Trial Balance Act by Fund FYTD.xnv
Report Request   TBACTYTD
Query            NA
Table(s)         Ledger
Prompts          0



Trial Balance – Cur All Funds




Description      Trial Balance that nplodes to all accounts used in the current
                 period with a column for each fund used in the current period
Layout Name      Trial Balance Actuals by Fund.xnv
Report Request   TBACTPER
Query            NA
Table(s)         Ledger
Prompts          0

                               Page 19 of 43
LSUHSC HCSD Reports Index
October 2008



Trial Balance – By Period




Description      Trial Balance that nplodes with one column of information for
                 each period of the fiscal year that has elapsed
Layout Name      Trial Balance-Net Activity by Month.xnv
Report Request   TBPERIOD
Query            NA
Table(s)         Ledger
Prompts          0


Trial Balance – Detail




Description      Trial Balance that nplodes to all detail with the YTD totals
Layout Name      Trial Balance - Actuals Ledger.xnv
Report Request   TBDETAIL
Query            NA
Table(s)         Ledger
Prompts          0


                                Page 20 of 43
LSUHSC HCSD Reports Index
October 2008



Trial Balance – By Fund




Description      Trial Balance that nplodes to the accounts with one column of
                 information for the current period and one for the year to date
                 total. The end user is prompted for the fund code.
Layout Name      Trial Balance - Single Fund.xnv
Report Request   TBSIGFND
Query            HCSD_FUND_PROMPT
Table(s)         Ledger
# of Prompts     2


Cash Receipts & Exp – All Funds




Description      Report of Cash Receipts and Expenditures for all funds with
                 current period activity and total year-to-date activity for entire
                 Business Unit
Layout Name      Cash Receipts & Expend-All Funds.xnv
Report Request   CREXALL
Query            NA
Table(s)         Ledger
Prompts          0

                                Page 21 of 43
LSUHSC HCSD Reports Index
October 2008



Cash Receipts & Exp – Fund 111




Description      Report of Unrestricted (Fund 111) Cash Receipts and
                 Expenditures with the budget amounts, current and YTD
                 collections and a comparison to budget
Layout Name      Cash Receipts & Expend-Fund 111.xnv
Report Request   CREX111
Query            NA
Prompts          0


Cash Receipts & Exp – Fund 113




Description      Report of Restricted (Fund 113) Cash Receipts and Expenditures
                 giving the current period activity and total year-to-date activity
Layout Name      Cash Receipts & Exp-Fund 113.xnv
Report Request   CREX113
Query            NA
Table(s)         Ledger
Prompts          0

                               Page 22 of 43
LSUHSC HCSD Reports Index
October 2008



Cash Receipts & Exp – Fund 115




Description           Report of Restricted Budgeted (Fund 115) Cash Receipts and
                      Expenditures giving the current period activity and total year-to-
                      date activity
Layout Name           Cash Receipts & Expend-Fund 115.xnv
Report Request        CREX115
Query                 NA
Table(s)              Ledger
Prompts               0


Rev & Exp Analysis – Analysis All




Description      This report layout is run by the Business Units when beginning the
                 monthly revenue and expenditure analysis and projection process.
                 The layout populates with 6 columns of data: Budgets, PY Actuals
                 Totals, PY Actuals to Date, Current Month Collections or
                 Expenditures, Year-to-Date Collections or Expenditures and
                 Encumbrances. The report nplodes to all accounts and the totals
                 should be verified with the totals on the hard-coded report generated
                 from the button named “Analysis-HC” which calls the report request
                 named “ANAL_HC”.
Layout Name      Rev & Exp Analysis & Projections.xnv
Report Request   ANALPROJ
Query            HCSD_DEPT
Table(s)         LEDGER
Prompts          0

                                     Page 23 of 43
LSUHSC HCSD Reports Index
October 2008



Rev & Exp Analysis – Analysis HC




Description      The report layout is for the hospital business units to use in
                 submitting their monthly revenue and expenditure projections. The
                 report is hard-coded, that is the accounts are forced to roll-up into
                 various high-level categories. The grand total should verify to the
                 nploded report generated from the button named “Analysis-All” which
                 calls the report request named “ANALPROJ”. The report layout then
                 has additional columns of information that must be calculated or filled
                 in after further work is performed. The final report is then saved to
                 the V drive and a memo is sent to the Budget Office noting that the
                 report is ready for review.
Layout Name      Rev & Exp Anal & Proj Detail HC.xnv
Report Request   ANAL_HC
Queries          HCSD_DEPT
Table(s)         LEDGER
Prompts          0
Rev & Exp Analysis – Analysis Delta




Description
Layout Name      DepList by BU 111 Comparison HCSD.xnv
Report request   ANALDLTA
Query            NA
Table(s)         Ledger
Prompts          0


                                   Page 24 of 43
LSUHSC HCSD Reports Index
October 2008




Professional Services Detail




Description      Report of expenditures within the “Professional Services” account
                 category for a Business Unit for the fiscal year. Prompts for BU,
                 Journal Beginning & Ending Dates and Fund. The report can be
                 run in the Reporting database only. (Tabular Layout)
Layout Name      BU Transaction DTL ProfSrvs.xnv
Report Request   BUTRANSP
Query            BU_TRANS_DTL_PROF_SRVS
Table(s)         ZZGL_TRANS_DTL
Prompts          4


Other/IAT Charges Detail




Description      Report of all expenditures within the “IAT – Other” account
                 category for a Business Unit for the fiscal year. Prompts for
                 Business Unit, Journal Beginning & Ending Dates and Fund. The
                 report can be run in the Reporting database only. (Tabular
                 Layout)
Layout Name      BU Transaction DTL Other.xnv
Report Request   BUTRANSO
Query            BU_TRANS_DTL_OTHER
Table(s)         ZZGL_TRANS_DTL
Prompts          4




                               Page 25 of 43
LSUHSC HCSD Reports Index
October 2008



Inventory – Valuation




Description       Listing of inventory items with the on hand quantities and values
                  sorted by value in descending order.
Layout Name       INV Value.xnv
Report Request    INVVALUE
Query             INV_VALUE_RPT
Table(s)          PHYSICAL_INV, CM_PRODCOST, MASTER_ITEM_TBL,
                  CM_PRODCOST, INV_ITEMS, INV_ITEM_UOM3
Prompts           3




Dept Comparison




 Description      Lists expenditures by departments in use as
                  compared to the departments included on the
                  HCSD Department Tree of the Business Unit.
 Layout Name      DeptList by BU 111 Comparison.xnv
 Report Request   DEPTCOMP
 Query            NA
 Table(s)         LEDGER
 Prompts          0




                                Page 26 of 43
LSUHSC HCSD Reports Index
October 2008



Additional HCSDA Reports
     Reports that include data on all HCSD Business Units




                               Page 27 of 43
LSUHSC HCSD Reports Index
October 2008




Income Statement – Restricted Funds Trans Dtl




Description      Detailed Transactions of select restricted funds by project
Layout Name      TransDtl.xnv
Report Request   TRANS_DT
Query            HCSD_TRANS_DTL
Table(s)         Ledger
Prompts          5




Trial Balance – All BU’s Fund 111




Description      Trial Balance that nplodes with one column of information for each
                 BU; Fund 111 only
Layout Name      Trial Bal Actuals Ledger - ALL HCSD BU'sFund111.xnv
Report Request   TB111AL
Query            NA
Table(s)         Ledger
Prompts          0




                                   Page 28 of 43
LSUHSC HCSD Reports Index
October 2008




Trial Balance – All BU’s All Funds




Description      Trial Balance that nplodes with one column of information for each
                 BU; includes all funds
Layout Name      Trial Balance Actuals Ledger - ALL HCSD BU's.xnv
Report Request   TBALL
Query            NA
Table(s)         Ledger
Prompts          0




Cash Rec & Exp – All BU’s & Funds




Description         Cash receipts and expenditures in all funds. The report nplodes
                    in each revenue and expenditure category and presents one
                    column for each business unit.
Layout Name         Cast Receipts & Exp-All Funds-All BU.xnv
Report Request      CRALLYTD
Query               None
Table(s)            Ledger
Prompts             0




                                  Page 29 of 43
LSUHSC HCSD Reports Index
October 2008



Cash Rec & Exp – All BU’s Fund 111




Description      Operating funds cash receipts and expenditures that nplodes in
                 each revenue and expenditure category. The report presents
                 one column for each business unit.
Layout Name      Cast Receipts & Exp-Fund111-All BU.xnv
Report Request   CR111ALL
Query            None
Table(s)         Ledger
Prompts          0

Fund 116 Project Analysis




Description      Restricted fund report of expenditures, encumbrances and pre-
                 encumbrances for Fund 116 projects associated with Hurricanes
                 Katrina and Rita.
Layout Name      HCSD – Disaster Recover Costs.xnv
Report Request   CR116ALL
Query            HCSD_PROJ_GRT_BUDGET
                 HCSD_FUND_116_PE
                 HCSD_FUND_116_E
                 HCSD_FUND_116
Table(s)         Ledger
Prompts          0




                               Page 30 of 43
LSUHSC HCSD Reports Index
October 2008



HCSD ANNUAL FINANCIAL REPORTS




Description   The Reports in this section are used to compile the Consolidated Annual
              Financial Report for LSU HCSD. These reports differ from all previously
              presented reports in that they include beginning balances and audit
              adjustments from the Actuals and Accrucals ledger. All HCSD funds are
              included. Samples of each of these reports are available on the HCSD
              Finance website at http://www.lsuhospitals.org/finance/fin.htm with the
              exception of TB-ALL. TB-All is a Trial Balance report of all hospitals, all
              funds, beginning balances and audit adjustments that is used in to check
              transactions for accuracy prior to generation of the final AFR. Most of
              these reports include hidden columns that can be unhidden to see detailed
              breakdowns of the data.




                                     Page 31 of 43
LSUHSC HCSD Reports Index
October 2008



CRYSTAL REPORTS

Crystal Reports are accessed from the PeopleSoft Launcher as illustrated below:




                                 Page 32 of 43
LSUHSC HCSD Reports Index
October 2008



The full list of Crystal Reports that are available for HCSD is:




Cleanup PO MGT




Description      Purchasing transactions summary by department
Prompts          4: BU, Dept, Date Begin, Date End
Query            CLEANUP_PO_MGT
Table(s)         PO_HDR, PO_LINE_DISTRIB, OPEN_ENC, VENDOR,
                 PO_LINE_SHIP, DEPARTMENT_TBL




                                    Page 33 of 43
LSUHSC HCSD Reports Index
October 2008



HCSD MGT INV JOURNAL INFO




Description    This report presents the detail journal lines for all Inventory
               Subsystem Journals and General Ledger Inventory correcting
               Journals for a Time period (Usually a month) The report is
               presented in Journal ID Order by Journal Line Number.
Prompts        3: BU. Begin Date, End Date
Query          JOURNAL_SYS_INFO_INV
Table(s)       JRNL_HEADER, JRNL_LN



HCSD MGT JOURNAL SYS INFO ACCRU




Description   This Report presents the detailed journal lines for all journals Posted to
              the HCSD_ACCRU Ledger for the Business Unit for a Time period
              (Usually a month). The report is presented in Journal ID Order by
              Journal Line Number.
Prompts       3: BU, Date Begin, Date End
Query         JOURNAL_SYS_INFO_ACRUALS
Table(s)      JRNL_HEADER, JOURNAL, LN




                                  Page 34 of 43
LSUHSC HCSD Reports Index
October 2008


HCSD MGT JOURNAL SYS INFO APCLS




Description   This Report presents the detailed journal lines for all Accounts Payable
              Voucher Close journals, generated by the Accounts Payable subsystem
              and posted to the Actuals Ledger for the Business Unit for a Time period
              (Usually a month). The report is presented in Journal ID Order by Journal
              Line Number. This report was designed to be used for reviewing APCLS
              journals to insure the correct Budget Period is used upon closing a
              Voucher. If other than the current Budget_Period appears on a journal
              line, manual corrections to the general ledger may be required.
Prompts       3: BU, Date Begin, Date End
Query         JOURNAL_SYS_INFO_APCLS
Table(s)      JRNL_HEADER, JOURNAL, LN




                                     Page 35 of 43
LSUHSC HCSD Reports Index
October 2008



HCSD MGT JOURNAL SYS INFO APCNX




Description   This Report presents the detailed journal lines for all Accounts Payable
              Voucher Cancellation journals, generated by the Accounts Payable
              subsystem and posted to the Actuals Ledger for the Business Unit for a
              Time period (Usually a month). The report is presented in Journal ID
              Order by Journal Line Number. This report was designed to be used for
              reviewing APCNX journals to insure the correct Budget Period is used
              upon closing a Voucher. If other than the current Budget_Period appears
              on a journal line, manual corrections to the general ledger may be
              required.
Prompts       3: BU, Date Begin, Date End
Query         JOURNAL_SYS_INFO_APCNX
Table(s)      JRNL_HEADER, JOURNAL, LN


HCSD MGT JOURNAL SYS INFO




Description      This Report presents the detailed journal lines for all manual general
                 ledger journals. These journals are not generated by the any
                 subsystem and posted to the Actuals Ledger or HCSD_ACCRU
                 Ledger for the Business Unit for a Time period (Usually a month). The
                 report is presented in Journal ID Order by Journal Line Number. This
                 report was designed to be used for reviewing all manual journals
                 during a period.
Prompts          3: BU, Date Begin, Date End
Query            JOURNAL_SYS_INFO
Table(s)         JRNL_HEADER, JOURNAL, LN




                                     Page 36 of 43
LSUHSC HCSD Reports Index
October 2008




HCSD MGT SUMMARY – Count of PO’s by Group –BU




Description   This report shows the number of purchase orders issued by the specified
              business unit broken down by total PO amounts during the specified
              period.
Prompts       3: BU, Date Begin, Date End
Query         LSUHCSD_PO_BY_DATE_RANGE_BU
Table(s)      PO_LINE_DISTRIB, PO_HDR




HCSD MGT SUMMARY – Count of PO’s by Group




Description        This report shows the number of purchase orders issued by all
                   HCSD business units broken down by total PO amounts during the
                   specified period.
Prompts            2: Date Begin, Date End
Query              LSUHCSD_PO_BY_DATE_RANGE
Table(s)           PO_LINE_DISTRIB, PO_HDR




                                    Page 37 of 43
LSUHSC HCSD Reports Index
October 2008



HCSD Summary Drilldown – Date Range
                              (Summary Page)




                                (Det ail Page)




Description   Summary of revenues and expenditures per project for a specific
              date range. ROA transactions are not included. The report allows
              drilldown on Actuals column.
Prompts       5; BU, Fund, Project ID, Begin Date, End Date
Query         HCSD_TRANS_DTL
Table(s)      ZZGL_TRANS_DTL, GL_ACCOUNT_TBL




                               Page 38 of 43
LSUHSC HCSD Reports Index
October 2008




HCSD Trans Detail – With ROA




Description   Summary of revenues and expenditures per project for a specific
              date range. ROA transactions are included. The report allows
              drilldown on Actuals column. This report should be used to
              determine what amounts are yet to be reimbursed by LSUHSC.
Prompts       5; BU, Fund, Project ID, Begin Date, End Date
Query         HCSD_TRANS_DTL_ROA
Table(s)      ZZGL_TRANS_DTL, GL_ACCOUNT_TBL




HCSD Trans Detail – Without ROA




Description   Summary of revenues and expenditures per project for a specific
              date range. ROA transactions are not included. The report allows
              drilldown on Actuals column. This report should be used to
              determine actual expenditures for a project.
Prompts       5; BU, Fund, Project ID, Begin Date, End Date
Query         HCSD_TRANS_DTL
Table(s)      ZZGL_TRANS_DTL, GL_ACCOUNT_TBL




                               Page 39 of 43
LSUHSC HCSD Reports Index
October 2008




INV_JRN_DTL




Description   The report presents the detail transactions that make up a specific
              journal line on a specific Inventory subsystem generated journal.
              This report will not provide any additional detail for Inventory
              Correcting Journals (INVC) journals since INVC journals are manual
              Journals directly to the General Ledger.
Prompts       3; BU, Begin Date, End Date
Query         INV_JRN_DTL
Table(s)      CM_ACCT_Post_Ln Table




Inventory Open PO REPORT




Description   This report lists pertinent information on inventory purchase order
              lines that have not been fully paid in PeopleSoft.
Prompts       4: BU, INV BU, Begin Date, End Date
Query         INVENTORY_REPORT
Table(s)      Vendor, PO_HDR, PO_LINE, PO_LINE_ACCTG,
              PO_LINE_DISTRIB, BUS_UNIT_TBL_IN, DEPARTMENT_TBL




                                Page 40 of 43
LSUHSC HCSD Reports Index
October 2008




Inventory Orders not Received




Descriptio    This report lists pertinent information on inventory purchase order lines that
n             have not been fully received in PeopleSoft.
Prompts       5: BU, INV BU, Begin Date, End Date, Vendor ID
Query         INVENTORY_RECEIPTS
Table(s)      Vendor, PO_HDR, PO_LINE, PO_LINE_DISTRIB, RECV_LN_DISTRIB,
              PO_LINE_SHIP, BUS_UNIT_TBL, RECV_LN_SHIP



Inventory Receipts Outstanding by Item-Short




Description      Inventory orders not received by item number
Prompts          5: BU, INV BU, Date Begin, Date End, Vendor ID
Query            INVENTORY_RECEIPTS
Table(s)         Vendor, PO_HDR, PO_LINE, PO_LINE_DISTRIB, RECV_LN_DISTRIB,
                 PO_LINE_SHIP, BUS_UNIT_TBL_IN, RECV_LN_SHIP




                                        Page 41 of 43
LSUHSC HCSD Reports Index
October 2008


Inventory Receipts Outstanding by Item




Description       Inventory orders not received by PO number
Prompts           5: BU, INV BU, Date Begin, Date End, Vendor ID
Query             INVENTORY_RECEIPTS
Table(s)          Vendor, PO_HDR, PO_LINE, PO_LINE_DISTRIB,
                  RECV_LN_DISTRIB,
                  PO_LINE_SHIP, BUS_UNIT_TBL_IN, RECV_LN_SHIP



Receipts Outstanding 3-Way Match




Description   Non-inventory orders not received by PO number
Prompts       5: BU; Dept, Begin Date, End Date, Vendor ID
Query         RECEIPTS_NON_INVENTORY
Table(s)      Vendor, PO_HDR, PO_LINE, PO_LINE_DISTRIB, RECV_LN_DISTRIB,
              PO_LINE_SHIP, BUS_UNIT_TBL_IN, RECV_LN_SHIP




                                Page 42 of 43
LSUHSC HCSD Reports Index
October 2008



Standing Orders by Vendor and Dept




Description   This report lists PO’s for a prompted budget period and presents the
              original quantity ordered as compared to the actual quantity received and
              invoiced. This report should be used when new PO’s are created for the
              next fiscal year to avoid over-encumbering.
Prompts       4 prompts: BU, Budget Period, Vendor ID, Dept ID
Query         STA NDING_P O_BY_V NDR_N_DEP T(
Table(s)      Vendor, PO_HDR, PO_LINE, PO_LINE_DISTRIB, DISTRIB_LINE,
              VOUCHER




                                     Page 43 of 43

								
To top