Labor Cost Distribution

1
Labor Cost Distribution

• April 11 12 2006
• FOA Conference

2
Account Code Lookup
3
Account Code Lookup
4
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.

5
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

6
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).

7
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

8
Set Up Account Code Build

• CSU HR Labor Expense Accounts table
• Home gt Compensate Employees gt Administer GL
  Interface gt Setup gt CSU HR Labor Expense Accounts

9
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.
•  

10
Set Up Account Code Build

•  

ACCOUNT CODE BUILD
ACCOUNT CODE TABLE
11
Set Up Account Code Build

• Home gt Compensate Employees gt Administer GL
  Interface gt Process gt CSU HR Account Code Build 

OUTER SCROLL
INNER SCROLL
12
Set Up Account Code Build

• 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

OUTER SCROLL
13
Set Up Account Code Build

• EXAMPLE
• Account Code Values
• LCD001-GF-601100
• LCD001-GF-601200
• LCD001-GF-601300
• LCD001-GF-603100
• LCD001-GF-603200
• Etc

OUTER SCROLL
14
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.  

15
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.

16
Set Up Account Code Build
INNER SCROLL
17
Set Up Account Code Build
18
Set Up Account Code Build
INNER SCROLL 1
INNER SCROLL 2