Labor Cost Distribution by X1C2SF7

VIEWS: 5 PAGES: 18

									Labor Cost Distribution

       April 11 & 12 2006
        FOA Conference
Account Code Lookup
Account Code Lookup
Set Up – Account Code Build
The PS delivered process to populate the
  Account Code Table creates one value at a
  time.
The values are just randomly generated
  numbers with no visual meaning.
Set Up – Account Code Build
The CSU Account Code Build process creates chartfield
  combinations for use in HR accounting transactions.
The run control for the custom process references:
  The individual HR chartfield tables that are
  populated with data provided by the Finance
  database
 The DEPTID value from the HR Department table

 The Labor Expense Accounts from the CSU Labor

  Expense Accounts table
Set Up – Account Code Build
Some ‘pre work’ needs to be done before this process
  can be used:

   Update chartfield tables from the Finance database.
   Establish DEPTID values in the HR database.
   Populate the CSU HR Labor Expense Accounts table
    (PS_CSU_GEN_ACCTS).
Set Up – Account Code Build
CSU HR Labor Expense Accounts table

   This table is used to identify the subset of the GL
    Accounts (a table populated via Integration Broker
    from the Finance application) to be used for payroll
    expenditures.
   The user must identify in this table the Activity type
    (earnings, tax, or deduction) for each labor expense
    account, to be used during the Distribution Process
Set Up – Account Code Build
CSU HR Labor Expense Accounts table
Home > Compensate Employees > Administer GL
  Interface > Setup > CSU HR Labor Expense Accounts
Set Up – Account Code Build
   Identify an effective date and SetID for the data
    being entered into the Account Code Table.
   Select at least a Fund and DeptID – this is the
    Account Code ‘core’ upon which the data in the CSU
    Labor Expense Accounts table will be exploded.
   The core combination of chartfields will be inserted
    into the Account Code Table, with the addition of
    each of the GL Accounts from the CSU Labor Expense
    Accounts table.
Set Up – Account Code Build

   ACCOUNT CODE BUILD




                        ACCOUNT CODE TABLE
Set Up – Account Code Build
Home > Compensate Employees > Administer GL
  Interface > Process > CSU HR Account Code Build




                                     OUTER SCROLL




                                     INNER SCROLL
Set Up – Account Code Build

                                            OUTER SCROLL

   SetID
   Effective Date
   DeptID (lookup filtered by SetID)
   Fund (lookup filtered by SetID and effective date)
   Dept/Fund Value - 19 character free-form field - user can create
    ‘smart values’.
        The build process will truncate each of the 6 digit GL Account
         values from the CSU Labor Expense Account table onto the end of
         the core value identified in this field.
        Be sure to use ‘-’ between chartfields
Set Up – Account Code Build

                            OUTER SCROLL


      EXAMPLE
      Account Code Values
      LCD001-GF-601100
      LCD001-GF-601200
      LCD001-GF-601300
      LCD001-GF-603100
      LCD001-GF-603200
      Etc…
    Set Up – Account Code Build


                                                 INNER SCROLL

   Acct Code Descr - 20 character free-form field - user can create ‘smart
    descriptions’. Must be completed even if no Class/Prog/Proj.
       The build process will truncate each of the 10 digit GL Account
        descrs from the CSU Labor Expense Account table onto the front of
        the core description identified in this field.
   Class/Prog/Proj (Optional) - 14 character free-form field used to
    establish additional ‘smart value’ for the Combo Code.
        The build process will truncate the value entered in this field to the end of
         the smart value created in the outer scroll area of the run control. The
         total length of the combo code value, including the outer scroll
         portion + the 6 digit GL Account + the inner scroll portion, is 25
         characters.
    Set Up – Account Code Build


                                          INNER SCROLL

   Class Field, optional field
   Project/Grant Field, optional field
   Program Field, optional field

   Additional inner scrolls can be added to the same Dept/Fund
    ‘core’ using different combinations of Class/Program/Project
    chartfields.
Set Up – Account Code Build

                    INNER SCROLL
Set Up – Account Code Build
Set Up – Account Code Build

                         INNER SCROLL
                              #1




                         INNER SCROLL
                              #2

								
To top