GL99006 CFS90 DS GeneralLedgerDrillDown 20100315

Document Sample
GL99006 CFS90 DS GeneralLedgerDrillDown 20100315 Powered By Docstoc
					                                                          CFS Modification Approval and Design Request
                                                                                             California State University
                                                                                                          CMS Baseline

 General Information
Item                                           Enter Information Requested
Service Request Number                         Click here to enter service request number.
Modification Number                            GL99006
Modification Name                              General Ledger Drilldown
Modification Request Status                    Approved
Request Initiated By (campus, team, or CMS )   Design Team
Primary Contact (name)                         Design Team
Primary Contact (email)                        cfsdesignteam@calstate.edu
Filename                                       GL99006_CFS90-DS_GeneralLedgerDrillDown_20100315.docx



 Modification Request Applies To: (Check all that apply)

       Finance 9.0                                        Common Financial System 9.0

       Human Resources 8.9                                Human Resources 9.0

       Student Administration 8.9                         Student Administration 9.0



          Important
 Modifications must accommodate multiple campus Business Units, SetIDs and Ledgers. The prompt tables used
 in run control pages and setup tables must use the PeopleSoft delivered row-level application security views. The
 use of temp tables must support multiple occurrences of the same report/process, so that one campus’ process
 will not adversely affect another. Hard coding will be allowed when necessary to help establish common business
 practices.

 About this Document
 The Modification Approval and Design Request document is a point-in-time document that provides the approval
 history, business requirements, design solution, and object list for modifications made to the CMS Baseline
 product.

 Once the modification is released and posted to the CMS website, this document becomes a historical record of
 the modification as initially released. Minor updates (i.e. editing errors or minor corrections) are updated and
 republished in this document, but all functional or object changes are documented and posted as Modification
 Update Requests.

 Section One: Revision History provides a table listing all Modification Update Requests associated with this
 document (if applicable), as well as a second table listing all minor document edits. Modification Update
 Requests will be posted with the original modification on the CMS website. Please refer to the documentation
 web page for each application.

 Related Documents
 The documents listed below are supporting materials such as test plans, test scripts, business process guides,
 etc. associated with this modification. Depending on the complexity of the modification, support materials will

 Last Revised: 03/15/10                                                                                        Page 1 of 12
General Ledger Drilldown                                             CFS Modification Approval and Design Request
GL99006-CFS90                                                                                      General Ledger



vary. Support materials are also posted on the CMS website, on the documentation web page for each
application.

   N/A




Last Revised: 03/15/10                                                                               Page 2 of 12
General Ledger Drilldown                                                                                      CFS Modification Approval and Design Request
GL99006-CFS90                                                                                                                               General Ledger




Table of Contents

Section One: Revision History ................................................................................................................................... 4

Section Two: CMS Central Modification Governance Review [CMS Use Only] ..................................................... 4

Section Three: Business Justification for Modification Request ............................................................................... 5

1.0     Overview ........................................................................................................................................................... 6

2.0     Department/Process Impact ............................................................................................................................. 6

3.0     Cross Product Analysis ..................................................................................................................................... 6

4.0     Alternatives and Recommendation ................................................................................................................... 6

Section Four: Design Specification ............................................................................................................................ 7

1.0     Conceptual Model (Process Flow) .................................................................................................................... 7

2.0     Requirements and Design Details .................................................................................................................... 7
        2.1      Regulatory Requirements/Business Rules ............................................................................................. 7
        2.2      Security Requirements ............................................................................................................................ 8
        2.3      Process Frequency ................................................................................................................................. 8
        2.4      Inputs/Outputs ......................................................................................................................................... 8

Section Five: Business Test Conditions .................................................................................................................... 9

Section Six: Object Changes ................................................................................................................................... 10




Last Revised: 03/15/10                                                                                                                                       Page 3 of 12
 General Ledger Drilldown                                                     CFS Modification Approval and Design Request
 GL99006-CFS90                                                                                              General Ledger




 Section One: Revision History

 Modification Update Requests

 Please list Service Request Number (SR#), Date, and Filename of any Update Requests associated with this
 modification.
SR#           Date          Filename of Update Request
Click here    Click here    Click here to enter Filename of Update Request.
to enter      to enter
SR#           Date.
Click here    Click here    Click here to enter Filename of Update Request.
to enter      to enter
SR#           Date.



 Document Edits

 Please provide a high-level description of edits made to this document to alert users to changes made since its
 initial release. Please note: Minor updates (i.e., editing errors or minor corrections) are updated and republished
 in this document, but all functional or object changes are documented and posted as Modification Update
 Requests.
  Date         By             Description of Document Edits                                            Section Edited
  03/15/10     CFS Team       Release of new document                                                  All




 Last Revised: 03/15/10                                                                                       Page 4 of 12
 General Ledger Drilldown                                                      CFS Modification Approval and Design Request
 GL99006-CFS90                                                                                               General Ledger




 Section Two: CMS Central Modification Governance Review [CMS Use Only]
 CMS Analyst / Author:               CFS Design Team
 Oracle Analysis:                    N/A - CSU Requirement

Category of Analysis                                     Estimates/ Impacts
Preliminary Time Estimate for Original Modification      1 hour
Final Time for Original Modification                     1 hour
Estimated Maintenance Over 5 Years                       1 hour
Impact on Upgrades                                       Minimal
Impact on Data Warehouse                                 Minimal

 Review and Approval
  Area / Title              Name              Date         Action             Comments
  User Group                CFS Design Team   08/31/09     Reviewed           Recommended for Application Team review
  CMS Application           E Kist            03/04/10     Reviewed           Recommended for CMS Senior Director
  Team                                                                        review and approval
  Senior Director,          J Lum             03/11/10     Approved           For posting to CMS website
  CMS




 Last Revised: 03/15/10                                                                                        Page 5 of 12
General Ledger Drilldown                                                      CFS Modification Approval and Design Request
GL99006-CFS90                                                                                               General Ledger




Section Three: Business Justification for Modification Request

Please select the appropriate categories to indicate the business justification for this modification request.

Modification Governance Category: Select One – State/Legal, CSU Business Requirement, Productivity Enhancement, or
Software Improvement

Modification Decision Criteria (Select ALL that apply)

   Impacts the ability to go live or is a result of collective bargaining, Trustee requirements, Executive direction, or
   State / Federal regulations
   Modification would result in a significant reduction in manual effort

   Modification would maintain a significant service level or add significant improvement in administrative
   productivity and / or service

   Without the modification, additional staff would be necessary to perform the business process



1.0      Overview
The PeopleSoft application enables cross module drill down capability from the general ledger module back into
the other modules such as Accounts Payable to retrieve source data such as voucher detail. However, since the
CSU has created a customized accounting line table CSU_ACCTG_LN that is used to generate journals into the
general ledger, functionality to the drill down back to this table for data validation purposes is required. This
modification will create this drill down functionality.



2.0      Department/Process Impact
Provides the campus financial users an efficient means to use on line functionality to retrieve source data from a
customized table.



3.0      Cross Product Analysis
No impact on cross products.



4.0      Alternatives and Recommendation
1. Alternative One: Not Applicable.
2. Recommendation: Develop a customized drill down page to allow the users to retrieve source data.




Last Revised: 03/15/10                                                                                         Page 6 of 12
General Ledger Drilldown                                                    CFS Modification Approval and Design Request
GL99006-CFS90                                                                                             General Ledger




Section Four: Design Specification


1.0        Conceptual Model (Process Flow)
A high level flow chart of the General Ledger Drill Down process is presented below.

General Ledger Drilldown Process

Flow Chart


        1                      2              3                 4                 5
     Select a            Click on the   Click on the        View data          Validate
    Journal ID           GL Journal        Line #           on all tabs         Data
                          hyperlink      hyperlink




Steps
1. Select a Journal ID at the CSU Acctg Line Drill Page.
      -    Navigation: CSU Administer Integration > CSU Manage Interfaces > CSU Accounting Line Drill
      -    Enter a Journal ID and click on Search
      OR
      -    Click on Search and Select a Journal ID.
2. At the CSU Acctg Line Drill Tab Page for the Journal ID selected, click on the GL Journal hyperlink under the
   Journal ID Section.
3. At the Journal Lines tab page, click on the Line # hyperlink.
4. Click on the Business Unit tab, CSU Information and Chartfields tabs to see the detail in the
   CSU_ACCTG_LN Interface table.
5. Validate data using queries or other reports.


2.0        Requirements and Design Details
The drilldown to the CSU_ACCTG_LN Interface table will require:

     A new page to drill down to the interface transactions in CSU_ACCTG_LINE
     A new component CSU_ACCTG_LN_DRILL
     Add the new component to the menu CSU_MANAGE_INTERFACES
     On the run control page for the report, create a checkbox to allow the user to select print “Exceptions only” or
      a “Complete” report.
     The CSU to Campus Data Validation Report (CSUFS165) will generate one page for each ledger that has a
      variance.


2.1        Regulatory Requirements/Business Rules
None.



Last Revised: 03/15/10                                                                                      Page 7 of 12
General Ledger Drilldown                                                 CFS Modification Approval and Design Request
GL99006-CFS90                                                                                          General Ledger



2.2       Security Requirements
Standard PeopleSoft operator/class security will control access to panels, processes, etc.


2.3       Process Frequency
Ad Hoc.


2.4       Inputs/Outputs
Interfaces will populate the CSU_ACCTG_LN table. The drilldown will provide access to the interface
transactions.




Last Revised: 03/15/10                                                                                   Page 8 of 12
 General Ledger Drilldown                                                   CFS Modification Approval and Design Request
 GL99006-CFS90                                                                                            General Ledger




 Section Five: Business Test Conditions
Business Process             Sequence   Scenario Description                    Intent
Drill down from Journal to   1          Navigation: CSU Manage Integration >    Navigate to Run Control page
CSU_ACCTG_LN table                      Manage Interfaces > CSU Accounting
                                        Line Drill
                             2          Select Journal ID
                             3          Click on the GL Journal hyperlink       Drill to CSU_ACCTG_LN table
                             4          Click on journal line # hyperlink       Drill to CSU_ACCTG_LN table
                             5          Review journal line data                Validate data using queries or other
                                                                                reports




 Last Revised: 03/15/10                                                                                      Page 9 of 12
    General Ledger Drilldown                                                        CFS Modification Approval and Design Request
    GL99006-CFS90                                                                                                 General Ledger




    Section Six: Object Changes
    Objects listed in this section reflect the point-in-time when the modification is first released. New projects and
    objects will be listed on their respective Modification Update Request forms. Please see Section One: Revision
    History for a full list of associated update requests.

    Important Note:
    This section lists objects delivered with a project, but does not provide all details for each object. For complete
    specifications on the PeopleSoft objects listed in this section, please use Application Designer to open and view
    the project/object details.

    Key: When completing the Action column, actions are
           New
           Altered
           Dropped
            N/A


Project Name                                Description                                                             Action
BSL_FS_GL_GL99006                           CSU GL Drilldown Enhancement                                            New
BSL_FS_GL_GL99006_20100325                  MP2 PCF Project to enforce Business Unit Security                       New

    Fields
#      Field Name              Long Name                     Short Name     Description         Type     Length       Action
1.

    Records and Views
Record / View Name                                           Type                                Add to Data Warehouse?
CSU_ACCTG_LINE                                               Table

Parent Record                      Query Sec Record          Set Control Field                SQL View



Record / View Name                                           Type                                Add to Data Warehouse?
CSU_ACCTG_LN_VW                                              View

Parent Record                      Query Sec Record          Set Control Field                SQL View
                                                                                              CSU_ACCTG_LN_VW

Record / View Name                                           Type                                Add to Data Warehouse?
CSU_JRNL_LN_CSU                                              View

Parent Record                      Query Sec Record          Set Control Field                SQL View
                                                                                              CSU_JRNL_LN_CSU
                                                          Use View                                       Edit View
#      Field                                                         List                                             Prmpt
                                   Key     Order #    Search                Audit   Default     Req’d    Tbl Edit
                                                                     Box                                               Tbl
1.




    Last Revised: 03/15/10                                                                                           Page 10 of 12
 General Ledger Drilldown                                                    CFS Modification Approval and Design Request
 GL99006-CFS90                                                                                             General Ledger



 Application Engine Programs
App Engine Program Name                 Description                                                     Action



 Application Engine Sections
App Engine Section Name                 Description                                                     Action



 Components
Component Name                          Description                                                     Action
CSU_ACCTG_LN_DRILL                      CSU Drill Down                                                  N

 Menus
Menu Name                     Bar Name         Item Name                  Description                   Action
CSU_MANAGE_INTERFACES         Inquire          CSU_ACCTG_LN_DRILL         CSU – Drill Down              N


 Pages
Page Name                               Description                                                     Action
CSU_ACCTG_LN_DRILL                      CSU - GL Xdrill                                                 N

 Process Definitions
Process Definition Name                 Description                                                     Action



 SQL
SQL Name                                Description                                                     Action
CSU_ACCTG_LN_VW                         CSU Accounting Lines Drill View                                 N
CSU_JRNL_LN_CSU                         Search Record View                                              N


 Translate Values
Field               Value   EFFDT          Status A/I     Long Name              Short Name             Action



 PeopleCode Tables
 Please note: There are multiple types of PeopleCode. Tables are provided for the most common types - if other
 types are delivered, please insert a new table and title it with the type of PeopleCode delivered. Enter N/A if no
 PeopleCode is included in the tables listed below.

 Record PeopleCode
Record PeopleCode Name                                  Description                                     Action
CSU_JRNL_LN_CSU.BUSINESS_UNIT.SearchInit                                                                New




 Last Revised: 03/15/10                                                                                       Page 11 of 12
 General Ledger Drilldown                                                 CFS Modification Approval and Design Request
 GL99006-CFS90                                                                                          General Ledger



 Application Engine PeopleCode
App Engine PeopleCode Name             Description                                                   Action



 Component PeopleCode
Component PeopleCode Name              Description                                                   Action



 Component Record PeopleCode
Component Record PeopleCode Name       Description                                                   Action



 Component Record Field PeopleCode
Component Record Field PeopleCode      Description                                                   Action



 Page PeopleCode
Name                                 Description                                                     Action



 Batch Module
Object Type     Name                          Description                                            Action



 Other
Object Type                 Name                            Description                               Action
Portal Registry Structure   CSU_ADMINISTER_INTEGRATION      Main Folder for CSU Integration           N
                                                            Components
Portal Registry Structure   CSU_MANAGE_INTERFACES           Main Folder for CSU Interfaces            N
Portal Registry Structure   CSU_ACCTG_LN_DRILL              Drill Down Component to view CSU          N
                                                            Accounting Lines




 Last Revised: 03/15/10                                                                                   Page 12 of 12

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:9/16/2012
language:Latin
pages:12