welcome! to the orientation class for peoplesoft general ledger university of houston system-wide
TRANSCRIPT
![Page 1: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/1.jpg)
WELCOME!
To the Orientation Class for PeopleSoft General Ledger
UNIVERSITY OF HOUSTON
SYSTEM-WIDE
![Page 2: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/2.jpg)
Overview of Elements of the PeopleSoft General Ledger
• TableSet, SetID and TableSet Sharing
• Ledgers
![Page 3: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/3.jpg)
TableSet, SetID and TableSet Sharing
• TableSet refers to the series of tables that control the general ledger.
• SetID is the label that identifies the TableSet used for a Business Unit.
• TableSet Sharing allows multiple Business Units to share a common table, such as Account or Fund.
![Page 4: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/4.jpg)
Ledgers
• Ledgers store the posted net activity for a set of ChartField values by accounting period and fiscal year.
• A ledger is a set of posted balances that represent a set of books for a Business Unit.
• Can store actuals, budgets, statistical or other types of data.
• They are primarily maintained through journal entries.
![Page 5: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/5.jpg)
Ledgers
• The various ledger types include:
– Actuals
– Budget
– Statistical
• Detailed transactions are stored in the actuals ledger.
![Page 6: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/6.jpg)
Chartfield Definition
• PeopleSoft General Ledger uses chartfields to identify journal entries.
• Each chartfield contains information that defines a transaction in terms of responsible party, fund source and function of entity.
![Page 7: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/7.jpg)
PeopleSoft E&G ChartFields
• Business Unit
• Fund Code
• Department
• Program
• Project ID
• Account
• Budget Reference
• Chartfield 1
• Statistics Code
![Page 8: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/8.jpg)
Fund Related Values
• Fund Code
• Grant Related Values– Sponsor Type– Funding Agency– CFDA Code– Sponsor ID
![Page 9: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/9.jpg)
Organizational Related Values• Business Unit
• Department Code
![Page 10: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/10.jpg)
Activity Related Values
• Program Code
• Project ID
![Page 11: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/11.jpg)
Cost Center Definition
• A combination of Chartfields constitutes a cost center. It defines whose money it is, what type of money it is, and what type of activity it is being spent to support.
![Page 12: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/12.jpg)
Cost Center Composition
• A Cost Center will include:– Business Unit– Fund Code– Department– Program– Project ID
![Page 13: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/13.jpg)
Non-Project/GrantCost Center
Example00730-2063-H0066-A0838-NA
where….
00730 = Business Unit
2063 = Fund Code
H0066 = Department
A0838 = Program
NA=Non project/grant
![Page 14: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/14.jpg)
Project/Grant Cost Center
Example00730-1026-H0124-B0001-G000052
where….
00730 = Business Unit
1026 = Fund Code
H0124 = Department
B0001 = Program
G000052 = Project ID
![Page 15: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/15.jpg)
Review of ChartFields
• Business Unit
• Fund Code
• Department
• Program
• Project ID
• Account
• Budget Reference
• Chartfield 1
• Statistics Code
![Page 16: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/16.jpg)
Understanding the Business Unit
• Organizations are divided into entities for operational or reporting purposes.
• PeopleSoft defines these entities as Business Units.
• Each UHS component is defined as a Business Unit.
![Page 17: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/17.jpg)
UHS Business Units
• 00730 - University of Houston
• 00759 - UH Clear Lake
• 00784 - UH Downtown
• 00765 - UH Victoria
• 00783 - UH System Administration
• 00797 - UH System Consolidated
![Page 18: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/18.jpg)
Fund Code
• Each fund is a balanced ledger.
• Funds are coded by source or type of monies they represent.
• A four digit numeric code.
• First digit defines the fund group.
![Page 19: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/19.jpg)
UHS Fund Codes
• 1XXX = State
• 2XXX = Designated
• 3XXX = Auxiliary
• 4XXX = Restricted
• 5XXX = Grants
• 6XXX = Endow. & Loans
• 7XXX = Plant
• 9XXX = Agency
![Page 20: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/20.jpg)
Department Code
• Each UHS department is assigned a unique five digit code.– Leading alpha character for campus.– Four numeric characters assigned sequentially
.
• Hierarchy is assigned through department trees.
![Page 21: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/21.jpg)
UHS Department Codes
• HXXXX = UH departments
• CXXXX = UHCL departments
• DXXXX = UHD departments
• VXXXX = UHV departments
• SXXXX = UHSA departments
![Page 22: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/22.jpg)
Program Code
• Five digits are used to uniquely identify a non-project cost center either within or across departments
• First digit tells the purpose of the program by expenditure function– Expenditure function is related to required
NACUBO reporting
![Page 23: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/23.jpg)
UHS Program Codes
• AXXXX = Instructional programs• BXXXX = Research programs• CXXXX = Public Service• DXXXX = Academic Support• EXXXX = Student Services• FXXXX = Institutional Support• GXXXX = Plant• HXXXX = Scholarship• IXXXX = Auxiliary
![Page 24: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/24.jpg)
Project ID
• Project cost centers use a common Program.
• Uniqueness of Cost Center provided by Project ID.
• Can be used for Grants, Capital and other projects.
• Project ID is a seven digit code.
• First digit defines project group.
![Page 25: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/25.jpg)
UHS Project ID
• GXXXXXX = Grant or sponsored project.
• PXXXXXX = Capital or building project.
• AXXXXXX=Administrative project.
• IXXXXXX=Internal Award project.
![Page 26: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/26.jpg)
Account
• Account describes the nature of the transaction.
• Account uses a five digit numeric code.
• There are five Account types.
• The first digit of the code describes the type of account.
![Page 27: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/27.jpg)
UHS Account Codes
Balance Sheet Items
• 1XXXX = Asset
• 2XXXX = Liability
• 3XXXX = Fund Equity
Income Statement Items
• 4XXXX = Revenue• 5XXXX = Expense
![Page 28: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/28.jpg)
PeopleSoft Journal forNon-Proj/Grant Cost Center
• Identified as:
00730-2063-H0066-A0838-NA-53905
![Page 29: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/29.jpg)
PeopleSoft Journal forProj/Grant Cost Center
• Identified as:
00730-1026-H0124-B0001-G000052-53905
![Page 30: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/30.jpg)
Budget Reference
• Budget Reference is the period of time for which expenditures are planned and authorized.
• UHS has designed six digit Budget Reference coding.– BPXXXX
• UHS Budget Reference is equivalent to the Fiscal Year.
![Page 31: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/31.jpg)
Budgetary Control
Elements that must be part of the Budgetary Control design include:
• Budget Types
• Budget Keys
• Budget Checking
![Page 32: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/32.jpg)
Budget Types
• Revenue (REVEST) Budgets– Represents authorization to generate revenue
• Organization (ORG) Budgets– Expenditure budget for Non-Proj/Grt cost
centers
• Project/Grant (PROJ_GRT) Budgets– Expenditure budget for Proj/Grt cost centers
![Page 33: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/33.jpg)
Budget Keys
Budget Keys• The fields on which budget control will be
decided.• All five chartfields that constitute a cost center are
budget keys.• Budget control occurs at the cost center and
budget pool (i.e. salary & wage, maint. &oper.) level.
![Page 34: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/34.jpg)
Budget Checking
Budgets can be:
• Controlled– Lack of sufficient budget will cause a journal to
fail.
• Tracked– A journal will pass regardless of adequacy of
budget, but will be tracked as an exception.
![Page 35: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/35.jpg)
Chartfield 1
• A new chartfield introduced with the upgrade to PeopleSoft financials version 8.4.
• Designed to help meet departmental reporting/tracking needs.
• Defined and maintained at the department level.
• Chartfield 1 values can be populated on transactions such as journals, POs & Vouchers.
![Page 36: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/36.jpg)
UHS Chartfield 1 Design
• Each department can have up to 260 values for chartfield 1.
• Values are organized in a series of 10 for each letter of the alphabet:– A0 through A9– B0 through B9– C0 through C9
![Page 37: WELCOME! To the Orientation Class for PeopleSoft General Ledger UNIVERSITY OF HOUSTON SYSTEM-WIDE](https://reader036.vdocuments.us/reader036/viewer/2022081504/56649da05503460f94a8af7e/html5/thumbnails/37.jpg)
Statistics Code
• UH System Business Units have defined a Statistics Code for Full Time Equivalent (FTE) employee reporting and tracking purposes.
• A full-time employee is recorded as 1.00, a half-time employee as .50