11/18/02

Conventions for Conversion of UD Account Code to PeopleSoft Chartfields

Current UD Account Code

1 - 1 - 74 - 4710 - 00 - 410

A - B-C-D-E -F

A.Fund

B.Type

C.Source of Revenue or Function of Expense

D.Budget Unit

E.Project Number

F.Object

New PeopleSoft Chartfieldsapproximately equal toCurrent UD Codes

Mandatory

PURPOSE (10 or less alphanumeric characters)=UD 11-digit account code or

UD 14-digit asset/liability account

PSACCT (6 alphanumeric characters) UD 3-digit object code

Mandatory With Salary Line Item Positions

CLASS(3 alpha or numeric characters)=UD 3-digit salary line number

Prefilled By Speed Type or Optional

PSFUND(5 alpha characters)=UD Fund / Fundtype

PSPROGRAM(5 alphanumeric characters)=UD Expense Function

PSPROJECT(15 alphanumeric characters)=New to define contract and grant accounts

and facilities projects—for use in the Projects

Module, as well as GL

SOURCE(8 numeric characters)=New to define revenue source where appropriate,

especially for contract & grant agency,

state appropriations and capital projects sources.

DEPTID(5 numeric characters)=Field to be used to identify administrative unit for each PURPOSE code

CHARTFIELD 3(10 numeric characters)=Field to be designated as a “User” Field.

PURPOSE(10 or less alphanumeric characters)

Roughly equivalent to current UD 11-digit code or Assets & Liabilities 14-digit code

Non Asset/Liability Purpose codes:

·1st 4 characters will identify major unit (mirror Registrar's acronyms at time of setup)

·Next 2 characters will generally be equivalent to UD Fund Type (e.g. UD 031 = 31) - helps

with visual cues.

·Final 4 characters will be randomly sequentially assigned with some variations

randomly sequentially assigned numbers for allocated funds will start with a 5

randomly sequentially assigned numbers for other funds using such, will start with a 2

(exceptions will be explained in the following detail)

Specifics and examples:

Basic Revenue:old 1-0-89-7201-03 will be replaced with PBRL112125

Basic Expense main dept:1-1-01-2170-00 will be replaced with PLSC11 (6 characters only)

Basic Expense not main dept:1-1-01-2170-02 will be replaced with PLSC112111

Basic 1-3 Exp will match 1-1:1-3-01-2170-02 will be replaced with PLSC112111

Allocated supplemental funds (S will be used in the 7th position):

Main supplemental fund 1-7-09-2522-50 will be replaced with CHEM17S (7 characters only)

SF sub-accounts 1-7-09-2522-51 will be replaced with CHEM17S511

Other Allocated 1-5,1-6,1-7,2-6,2-7 examples

(17 will be used in 5th & 6th positions and 5 will be used in 7th position):

1-5-29-2547-90will be replaced with HIST175113

1-7-09-2522-52(non SF) will be replaced with CHEM175137

2-7-95-5660-04 will be replaced with BOOK175111

Self-supporting revenue (2-0) and expense (2-1) will become one Purpose code:

2-0-89-2180-01 and 2-1-41-2180-01 will be replaced by AGCM212112

AG 3-0 Federal Appropriations 3-0-41-2210-05 will be replaced by AGEX3A2115

(3A will be used in 5th & 6th positions for all old 3-0 accounts)

Other Federal 3-1,3-2,3-3,3-4,3-5,3-6,3-7 examples:

3-1-21-2553-71 will be replaced with MATH312122

3-5-42-2101-15 will be replaced with AGRI352115

3-6-01-3140-99 will be replaced with MEEG362111

State Appropriations 4-0-01-2553-02 will be replaced by MATH222111

(22 will be used in the 5th & 6th positions for all 4-0 accounts)

Other Restricted funds 4-1,4-2,4-3,4-5,4-6,4-7 will carry old fundtype in positions 5 & 6 of new Purpose code:

4-2-42-7385-01 will be replaced with CHEP422194

4-6-01-2720-01 will be replaced with ECON462111

Old 5-book Loan accounts will carry dept acronym of “LOAN” followed by old fundtype

5-1-74-4740-97 will be replaced with LOAN512153

5-7-74-4740-05 will be replaced with LOAN572115

Old 6-book Endowment accounts will have a Purpose code starting with “XM” followed by 8 additional letters representative of the Purpose Description:

6-4-74-4801-06 will be replaced with XMCRESTLEA

Old Endowment funds 7-0 thru 7-3 will have a Purpose code starting with “XS” followed by 8 additional letters representative of the Purpose Description (similar to prior example).

Old Endowment funds 7-4 thru 7-6 will have a Purpose code starting with “Y” followed by 8 additional letters representative of the Purpose Description (similar to example for 6-book above).

Old Endowment funds 7-7 will have a Purpose code starting with “Z” followed by 8 additional letters representative of the Purpose Description (similar to example for 6-book above).

Old 8-3 funds will be coded as DEBT832###.

Old 8-4 funds will be coded as UNIV842###.

Old 8-5 funds will be coded as RNOV852### with old codes for same project merged into one new Purpose code.

Old 8-6 funds will be coded as BLDG followed by 6 additional letters representative of the Purpose Description; old codes for the same project will be merged into one new Purpose code.

Agency student groups old 9-1,9-2,9-3, will be coded as STGP2###

Agency financial aid old 9-5 will be coded as EXFA2####

Other Agency old 9-4,9-6,9-7 will be coded as AGCY2####

Most Academic departments will have a basic budget PS-Purpose code for instruction, departmental research and matching.A sample of the instruction format is:CHEM11.Departmental Research will have a "DRES" added as follows: CHEM11DRES.Match will have an "MTCH" added as follows:CHEM11MTCH.

Asset/Liability Purpose codes(6 alphanumeric characters)

PeopleSoft PURPOSE value will be same as PSACCT

Assets will always start with “A”; Liabilities will always start with “L”

The second digit will identify the Major Asset/Liability Heading and the third digit will

Identify Sub-Headings, as per following example:

Old 1-8-32-0000-00-104 will be replaced with A21MOB

Where “A” = Asset, “2” = Receivables, with a “1” = Student Accounts

Standard asset/liability contained in each fund group will have identical values with 6thdigit representing the old fund group (e.g. A1CWT1, A1CWT2, A1CWT3, etc.)

PSACCT(6 alphanumeric characters)

Roughly equivalent to current UD 3-digit object code or Assets & Liabilities 14-digit code

(note: Assets & Liabilities will use the same value for both PSACCT and PURPOSE;

see PURPOSE section above for Asset & Liability description).

NOTE:some old object codes will be combined into one new PSACCT; also, some new PSACCTs will be added.

Revenue items (old object 000 – 189) will start with an R (e.g. Gifts old object 081 will be R08100).

Transfers and allocations (old 191-198 and 991-999) will be replaced with 9TRS00.

Expense objects 200 – 950 will start with the number 1 as per following examples:

Old 211 Faculty Full-Time will be replaced with 1FF000

Old 410 Office Supplies will be replaced with 141000

CLASS(3 alpha or numeric characters)

Full-time Faculty CLASS value will be alpha;all others will be numeric to mimic our

previous UD 3-digit salary line number.

PSFUND(5 alpha characters)

Roughly equivalent to current UD fund / fundtype.

·OPBAS- Current UD 010, 012, 011 and 013

·OPSS - Current UD 020 and 021

·OPBAL - Current UD Allocated and Restricted

(015,016,017,018,019,026,027,028,029,03x and 04x)

·NOEND - Current UD 06x and 07s

·NOLOA - Current UD 05x

·NOPLT - Current UD 08x

·AGNCY - Current UD 09x

PSPROGRAM(5 alphanumeric characters)

·Roughly equates to UD Expense Function

·No Revenue source - will be identified by PSACCT (old object code)

Selected examples (not complete list) of new PSPROGRAM with old UD expense function:

·INST1 - Instruction (UD 01)

·INST2 - Departmental Research (UD 09)

·RSCH1 - Federal Research (UD 21)

·RSCH2 - State Research (UD 22 & 27)

·PUBSV - Public Service (UD 42)

·ACDLB - Library (UD 51)

·OPMNT - Operations & Maint of Plant (UD 71)

·ADALL - Administrative allowable in Indirect Cost Calc (UD 74)

·ADNON - Administrative NOT allowable in Indirect Cost calc (UD 76)

·AUXIL - Auxiliary Enterprises (UD 90,91,92,93,94,95)

PSPROJECT(15 alphanumeric characters)

Field to define contract and grant accounts and facilities projects.

For contract and grant accounts, value will be same as PURPOSE plus next two digits equivalent to fiscal year of start date with last three digits filled with zeros.

e.g. old 3-7-06-2515-02 will convert to ARTC37211199000

For facilities projects, will be used as follows:

Old 1-6 and 8-5 codes will be 10000 plus PURPOSE

e.g. 8-5-22-5008-84will be 10000RNOV852166

Old 8-6 codes will be20000 plus PURPOSE

e.g. 8-6-70-7000-97will be20000BLDGDUPONT

This field may be used for additional purposes not yet defined.

SOURCE(8 numeric characters)

Field will be used for contracts and grants agency information.The logic is based on previously used logic in the current Grants Management System.

(e.g. 33041101 OFFICE OF EDUCATION; 89801052 HYDROQUAL,INC.)

Field will be used to tag and track State Appropriation for Operations, State Special Lines and Capital State items.Will also be used to track source of funds backing expenditures for capital projects, including State and all other sources.

(SEE APPENDIX A AT END OF DOCUMENT FOR COMPLETE LIST)

DEPTID(5 numeric characters)

Field to be used to identify administrative unit for each PURPOSE code.

(e.g.#####CNTR DISABILITY STUDIES (CDS)

A#####STUDENT ACTIVITIES)

CHARTFIELD 3(10 numeric characters)

Field to be designated as a “User” Field.

APPENDIX A:


 
SOURCE
SOURCE DESCRIPTION
10000000
STATE APPROPRIATION FOR OPERATIONS
11000000
DINING RESERVE FOR CAPITAL NEEDS
12000000
HOUSING RESERVE FOR CAPITAL NEEDS
15000000
BOOKSTORE RESERVE FOR CAPITAL NEEDS
16000000
ATHLETIC RESERVE FOR CAPITAL NEEDS
17000000
CONFERENCES LOAN FROM HOUSING
20000000
STATE CAPITAL APPROP FOR YEAR 20X0
21000000
STATE CAPITAL APPROP FOR YEAR 20X1
22000000
STATE CAPITAL APPROP FOR YEAR 20X2
23000000
STATE CAPITAL APPROP FOR YEAR 20X3
24000000
STATE CAPITAL APPROP FOR YEAR 20X4
25000000
STATE CAPITAL APPROP FOR YEAR 20X5
26000000
STATE CAPITAL APPROP FOR YEAR 20X6
27000000
STATE CAPITAL APPROP FOR YEAR 20X7
28000000
STATE CAPITAL APPROP FOR YEAR 20X8
29000000
STATE CAPITAL APPROP FOR YEAR 20X9
33000000
FEDERAL FUNDS
40000000
STATE SPECIAL LINE
52000000
STATE FUNDS
54000000
LOCAL FUNDS
61000000
UNIDEL FOUNDATION
62000000
LONGWOOD FOUNDATION
63000000
OTHER FOUNDATIONS
64000000
RESTRICTED GIFTS
65000000
RESTRICTED GIFT
70000000
UNIVERSITY FUNDING
74000000
00 BOND FUNDING
75000000
01 BOND FUNDING
81000000
ENDOWMENT
82000000
PURCHASE OF REAL ESTATE
85000000
UNIV RESERVE
89000000
OTHER