Financial Data Elements

Data Element Name:

Account

Long Name:

Account Number

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

The number assigned by the campus for the purpose of identifying a specific balance sheet, revenue or expenditure account

Code Interpretation:

Refer to Accounting Manual Section A-115-2

Comments:

Revision Date:

5/1/98

Data Element Name:

Account_Group_Code

Long Name:

ACCOUNT GROUP CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code indicating the category to which an account belongs in the University's accounting structure.

Code Interpretation:

See Financial Statement Mapping for Account Group Codes.

Comments:

Revision Date:

Data Element Name:

Account_Group1

Long Name:

ACCOUNT GROUP 1 CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

A hierarchical subdivision of Account Group Code. At each successive level, accounts are grouped into more and more specific categories. By specifying an account group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX
'4' - 9999XX
'5' - 99999X

Comments:

Revision Date:

Data Element Name:

Account_Group1_Title

Long Name:

ACCOUNT GROUP 1 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Account Group level 1.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Group2

Long Name:

ACCOUNT GROUP 2 CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

A hierarchical subdivision of Account Group Code. At each successive level, accounts are grouped into more and more specific categories. By specifying an account group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX
'4' - 9999XX
'5' - 99999X

Comments:

Revision Date:

Data Element Name:

Account_Group2_Title

Long Name:

ACCOUNT GROUP 2 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Account Group level 2.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Group3

Long Name:

ACCOUNT GROUP 3 CODE

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

A hierarchical subdivision of Account Group Code. At each successive level, accounts are grouped into more and more specific categories. By specifying an account group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX
'4' - 9999XX
'5' - 99999X

Comments:

Revision Date:

Data Element Name:

Account_Group3_Title

Long Name:

ACCOUNT GROUP 3 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Account Group level 3.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Group4

Long Name:

ACCOUNT GROUP 4 CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

A hierarchical subdivision of Account Group Code. At each successive level, accounts are grouped into more and more specific categories. By specifying an account group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX
'4' - 9999XX
'5' - 99999X

Comments:

Revision Date:

Data Element Name:

Account_Group4_Title

Long Name:

ACCOUNT GROUP 4 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Account Group level 4.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Group5

Long Name:

ACCOUNT GROUP 5 CODE

Type:

ALPHANUMERIC

Length:

5

Format:

N/A

General Description:

A hierarchical subdivision of Account Group Code. At each successive level, accounts are grouped into more and more specific categories. By specifying an account group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX
'4' - 9999XX
'5' - 99999X

Comments:

Revision Date:

Data Element Name:

Account_Group5_Title

Long Name:

ACCOUNT GROUP 5 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Account Group level 5.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Group6_Title

Long Name:

ACCOUNT GROUP 6 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with the Account Group Code.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Title

Long Name:

ACCOUNT TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with an account number.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Account_Type_Code

Long Name:

ACCOUNT TYPE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the financial category to which an account belongs.

Code Interpretation:

'1'         Balance Sheet

'2'         Revenue

'3'         Expenditure

Comments:

Derived from the first character of Record Type for CFSBAL file submission records. Record types '10' and '11' will be Account Type Code '1'. Record type '20' will be '2'. Record Types '30' and '31' will be Account Type Code '3'.

Derived from Account Group Code for FJE journal transactions. FJE journal transaction data with Account Group Codes starting with '1','4','5','6', '7' and '8' will be Account Type Code '1', FJE data for Account Group Codes starting with '2' will be Account Type Code '2', and FJE data for Account Group Codes starting with '3' will be Account Type Code '3'.             

Revision Date:

December 18, 2013

Data Element Name:

Account_Type_Title

Long Name:

ACCOUNT TYPE CODE

Type:

ALPHANUMERIC

Length:

13

Format:

N/A

General Description:

Name describing the type of account based on the Account Type Code.

Code Interpretation:

'1'         Balance Sheet

'2'         Revenue

'3'         Expenditure

Comments:

Revision Date:

Data Element Name:

Agency_Code

Long Name:

AGENCY CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the federal or state major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Agency_Short_Title

Long Name:

AGENCY SHORT TITLE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

The abbreviated name of the federal or state major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Agency_Title

Long Name:

AGENCY TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name of the federal or state major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Alpha_Location

Long Name:

ALPHA LOCATION CODE 

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Redefinition of UC Location Code 1 and UC Location Code 2.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

ARC_Code

Long Name:

ANNUAL REPORT CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code used to group certain accounts by function or administrative unit for reporting at the close of fiscal year. In some cases ARC will be identical to account number. Applies to current expenditure accounts only.

Code Interpretation:

(Codes are assigned by the campuses.)

Comments:

Department of Agriculture and Natural Resources (DANR) Flag value is derived from specific ARC Codes by location. See Campus Account Fund (CAF) ARC_Code comments for the specific ARC Code to DANR Flag value translations.

Revision Date:

Data Element Name:

ARC_College

Long Name:

ANNUAL REPORT CODE COLLEGE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

The third and fourth digits of ARC_Code which identify the college if ARC Function is '40' or '43' or '44' or '62'..

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

ARC_Department

Long Name:

ANNUAL REPORT CODE DEPARTMENT

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

The fifth and sixth digits of ARC_Code which identify the department.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

ARC_Function

Long Name:

ANNUAL REPORT CODE FUNCTION

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

The first and second digits of ARC_Code which identify the function.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Asset_Amount

Name:

AMOUNT-FINANCIAL CURRENT BALANCE (ASSET)

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The current balance amount of an account for all transactions with a specific asset number.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Asset_Number

Long Name:

PLANT ASSET NUMBER

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Unique number assigned to a University-owned or acquired building or plant asset at the time the expenditure for that asset are capitalized on the University's financial records.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Asset_Title

Long Name:

PLANT ASSET TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name of the University-owned or acquired building or other plant asset associated with a plant asset number.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Award_Type

Long Name:

AWARD TYPE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating the type of award made to the University.

Code Interpretation:

'1'         Cooperative Agreement

'2'         Contract

'3'         Grant, including State Interagency Agreements and Memoranda of Understanding

'4'         Gift

See Guidelines for Determining Type of Award.

Comments:

Revision Date:

Data Element Name:

Budget_Adj_Amount

Long Name:

AMOUNT-ADJUSTED BUDGET

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Amount equal to Budget_Initial_Amount + Budget_ADTD_Amount. 

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_ADTD_Amount

Long Name:

AMOUNT-ADJUSTMENTS TO DATE

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Sum of all transaction adjustment amounts since the beginning of the fiscal year. 

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Adj_Fte

Long Name:

FTE-ADJUSTED BUDGET788

Type:

NUMERIC

Length:

9

Format:

Zone S9(4)v99

General Description:

Full time equivalent amount equal to Budget_Initial_FTE + Budget_ADTD_Fte. 

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_ADTD_Fte

Long Name:

FTE-ADJUSTMENTS TO DATE

Type:

NUMERIC

Length:

9

Format:

Zone S9(4)v99

General Description:

Sum of all transaction adjustment full time equivalents since the beginning of the fiscal year.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Doc_Number

Long Name:

BUDGET DOCUMENT REFERENCE NUMBER

Type:

ALPHANUMERIC

Length:

5

Format:

General Description:

Number identifying a transaction from the Corporate Budget System as to its source. 

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_Doc_Suffix

Long Name:

BUDGET DOCUMENT REFERENCE NUMBER

Type:

ALPHANUMERIC

Length:

2

Format:

General Description:

Suffix which identifies a transaction as a modification to an existing transaction from the Corporate Budget System with the same Document Number. 

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_Increment_Amount

Long Name:

AMOUNT-INCREMENTS TO DATE

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Sum of all budget transaction increment amounts since the start of the fiscal year.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Initial_Amount

Long Name:

AMOUNT-INITIAL BUDGET

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Budget appropriation or income amount as of the beginning of the fiscal year, July 1.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Initial_Fte

Long Name:

FTE-INITIAL BUDGET

Type:

NUMERIC

Length:

9

Format:

Zone S9(4)v99

General Description:

Budget appropriation full time equivalents as of the beginning of the fiscal year, July 1.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Location3_Code

Long Name:

SUB CAMPUS ID CODE - BUDGET LOCATION 3 CODE

Type:

ALPHANUMERIC

Length:

1

Format:

General Description:

Identifies a University organizational category. Source is the Corporate Budget System.  

Code Interpretation:

'1' - General Campus
'2' - Health Science
'3' - Marine Science 

Comments:

Revision Date:

Data Element Name:

Budget_NYR_Amount

Long Name:

AMOUNT-NEW YEAR BUDGET

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Amount equal to Budget_Initial _Amount+Budget_ADTD_Amount+Budget_Increment_Amount 

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_NYR_Fte

Long Name:

FTE-NEW YEAR BUDGET

Type:

NUMERIC

Length:

9

Format:

Zone S9(7)v99

General Description:

Amount equal to Budget_Initial _Fte+Budget_ADTD_Fte+Budget_Increment_Fte 

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Post_Date

Long Name:

BUDGET TRANSACTION POSTING DATE

Type:

ALPHANUMERIC

Length:

6

Format:

YYMMDD

General Description:

Date that a transaction was added. 

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_RAFG_Code

Long Name:

Budget Revenue/Account Fund Group Code

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code used to group income amounts based on a combination of revenue account number and fund number.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_RAFG_Code

Long Name:

Budget Revenue/Account Fund Group Code Description

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

Code used to group income amounts based on a combination of revenue account number and fund number.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Amount

Name:

AMOUNT-TRANSACTION BUDGET

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The amount of an appropriation, income, or delete transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Class

Long Name:

BUDGET TRANSACTION CLASS

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating a budget transaction as either an adjustment, increment, or file maintenance delete. 

Code Interpretation:

'A' - Adjustment
'I' - Increment
'D' - Adjustment Delete
'E' - Increment Delete

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Descr

Long Name:

BUDGET TRANSACTION DESCRIPTION

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

Description entered with a budget transaction. 

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Fte

Name:

FTE-TRANSACTION BUDGET

Type:

NUMERIC

Length:

4

Format:

Zone S9(2)v99

General Description:

The amount of an appropriation full time equivalents transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Fte (9 character)

Name:

FTE-TRANSACTION BUDGET

Type:

NUMERIC

Length:

9

Format:

S9(4).99

General Description:

The amount of an appropriation full time equivalents transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Budget_Trans_Type

Long Name:

BUDGET TRANSACTION TYPE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type and source of a budget transaction.

Code Interpretation:

A - Salary reconciliation
B - Other
1 - Detail budget worksheets
2 - Interlocation transfers
3 - Regents'/President's action
4 - Merit (Academic)
5 - Merit (Staff)
6 - Range (Academic)
7 - Range (Staff)
8 - Reclassification
9 - Six month/trainee increases

Comments:

Revision Date:

Data Element Name:

Budgeted_Fund_Code

Long Name:

Budgeted Fund Code

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether a fund is budgeted (i.e., incorporated into the annual budget, including State of California support, non-resident tuition fees, registration fees, endowments, and miscellaneous other funds) or non-budgeted (including Regents' Opportunity Funds and other discretionary funds, or funds provided for a limited time period and specific purpose, such as federal contracts and grants, private gifts and grants, special agreements with state and local agencies, and other special income).

Code Interpretation:

'B' - Budgeted
'N' - Non-budgeted

Comments:

Revision Date:

Data Element Name:

CFDA_Code

Long Name:

CATALOG OF FEDERAL DOMESTIC ASSISTANCE NUMBER (CFDA)

Type:

ALPHANUMERIC

Length:

5

Format:

N/A

General Description:

Code indicating the program of federal assistance assigned by the Federal agencies. This code is required on new federal funds for Appropriations, Grants, Cooperative Agreements, and Contracts beginning July 1, 1995.

Code Interpretation:

Refer to Catalog of Federal Domestic Assistance in the Contracts and Grants Manual, Section 2-F03.

Comments:

Revision Date:

Data Element Name:

Cycle_Ending

Long Name:

CYCLE ENDING DATE

Type:

DATE

Length:

10

Format:

e.g. 2/29/2008, 6/30/2008

General Description:

Month, day and year of the reporting period to which the data applies, i.e., the "as of" date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

DANR_Flag

Long Name:

DIVISION OF AGRICULTURE & NATURAL RESOURCES FLAG

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating how an account should be grouped in reports for DANR.

Code Interpretation:

'A' - UW Programs
'B' - Local Campus AES
'C' - Local Campus College

Comments:

See Campus Account Fund (CAF) ARC_Code comments for the specific ARC Code to DANR Flag value translations.

Revision Date:

Data Element Name:

Dept_Report_Code

Long Name:

DEPARTMENT REPORT CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code used to group DANR accounts by administrative unit for reporting purposes.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Dept_Report_Title

Long Name:

DEPARTMENT REPORT CODE TITLE

Type:

ALPHANUMERIC

Length:

29

Format:

N/A

General Description:

Name associated with Dept_Report_Code used to group DANR accounts by administrative unit for reporting purposes.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Eff_Date

Long Name:

EFFECTIVE DATE

Type:

ALPHANUMERIC

Length:

7

Format:

e.g. SEP1999, FNL1999

General Description:

Month and year of the reporting period to which the data applies, i.e., the "as of" date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Eff_FY

Long Name:

EFFECTIVE FISCAL YEAR

Type:

ALPHANUMERIC

Length:

7

Format:

e.g. 2007-08, 2008-09

General Description:

Fiscal year to which the data applies, i.e., the "as of" date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Eff_Qtr

Long Name:

EFFECTIVE QUARTER

Type:

NUMERIC

Length:

1

Format:

e.g. SEP = '1', DEC = '2', MAR = '3', FNL = '4'

General Description:

Value is only populated for SEP, DEC, MAR, FNL Effective Date records. Fiscal quarter to which the data applies, i.e., the "as of" date. JUL, AUG, OCT, NOV, JAN, FEB, APR, MAY and PRE Effective Date records will contain a blank value.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Encumbrance_Amount

Long Name:

AMOUNT-ENCUMBRANCE-CURRENT BALANCE

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The total amount of dollars committed for future payment within an expenditure account.

Code Interpretation:

N/A

Comments:

Revision Date:

Name:

Endowment_Restriction

Long Name:

ENDOWMENT RESTRICTION CODE

Type:

ALPHANUMERIC

Length:

5

Format:

N/A

General Description:

Code indicating the type of restriction placed on the use of income earned by an endowment or similar type fund. The first two digits indicate the specific restriction placed on the fund. The second two digits specify the purpose of the fund. The last digit identifies the campus or location to which earnings of the fund are to be distributed.

Code Interpretation:

Refer to Accounting Manual Chapter E-525, Endowment and Similar Funds

Comments:

Revision Date:

Data Element Name:

FCP_Location_3_Code

Long Name:

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating a broad University organizational category.

Code Interpretation:

'1'         General campus

'2'         Health sciences

'3'         not used

'4','5',..,'9','0'    See SAU_Code

Comments:

Revision Date:

February 20, 2009

Data Element Name:

Finance_Amount

Name:

AMOUNT-FINANCIAL-CURRENT BALANCE

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The current balance amount of an account. For balance sheet accounts, this is the financial balance as of the effective date; for revenue accounts, the actual income balance as of the year to date; for expenditure accounts, the balance of all transactions against the account as of the year to date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Finance_Amount_Mo

Long Name:

AMOUNT-FINANCIAL-CURRENT MONTH ACTIVITY

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The net amount of total activity against an account for the current month.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Full_Accounting_Unit

Long Name:

FULL ACCOUNTING UNIT

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The concatenation of Location_1, Loaction_2, Account, Fund, Sub_Account

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Function

Long Name:

FUNCTIONAL CLASSIFICATION CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type of University activity, e.g., instruction, research, or public service, associated with an expenditure account number. 

Code Interpretation:

Code   Title

'40'       Instruction

'41'       Summer Session

'42'       Teaching Hospital

'43'       Academic support

'44'       Research

'60'       Academic support: Libraries

'61'       Instruction: University Extension

'62'       Public Service

'64'       Maintenance & Operation of Physical Plant

'68'       Student services

'72'       Institutional support

'76'       Auxiliary enterprises

'78'       Student financial aid

'80'       Provisions for allocations

Comments:

Derived 1:1 from Account Group Code - Table 9 in CFSTABS

• 30001 40 INSTRUCTION
• 30002 41 SUMMER SESSION
• 30003 42 TEACHING HOSPITALS
• 30004 43 ACADEMIC SUPPORT
• 30005 44 RESEARCH
• 30006 60 LIBRARIES
• 30007 61 UNIVERSITY EXTENSION
• 30008 62 PUBLIC SERVICE
• 30009 64 MAINT/OPR OF PHYS. PLANT
• 30011 68 STUDENT SERVICES
• 30012 72 INSTITUTIONAL SUPPORT
• 30013 76 AUXILIARY ENTERPRISES
• 30014 78 STUDENT FINANCIAL AID
• 300159 80 PROVISIONS FOR ALLOCATION

Revision Date:

September 25, 2012

Data Element Name:

Fund

Long Name:

FUND NUMBER

Type:

ALPHANUMERIC

Length:

5

Format:

N/A

General Description:

Number identifying a specific source of funding.

Code Interpretation:

Refer to Accounting Manual section A-115-2.

Comments:

Revision Date:

5/21/98

Name:

Fund_Balance_Ind

Long Name:

FUND BALANCES ACCOUNT CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating  the category of fund balances accounts or current funds accounts with which an account number is associated.

Code Interpretation:

Code   Account Group Range            Category

'1'         109100-109500           Unexpended Plant Funds

'1'         310000            Plant Funds

'2'         119100            Retirement of Indebtedness

'3'         149100            Loan funds

'4'         159100-159300           Endowment & similar funds

'4'         18481  Endowment & similar funds

'5'         169100-169600           Current funds

'5'         200100-208220           Current funds - revenue

'5'         300010-300159           Current funds - expenditures

'5'         320000            Current funds - encumbrance control

'6'         519000            UCRS - fund balances

'6'         529000            UCRS - fund balances

'6'         539000            UCRS - fund balances

'6'         549000            UCRS - fund balances

'6'         559000            UCRS - fund balances

'6'         569000            UCRS - fund balances

'6'         579000            UCRS - fund balances

'6'         589000            UCRS - fund balances

'6'         599000            UCRS - fund balances

'6'         609000            UCRS - fund balances

'7'         139100            Renewal & Replacement

'8'         129000            Investment in Plant

Comments:

Revision Date:

6/28/02

Data Element Name:

Fund_Group_Budget

Long Name:

FUND GROUP BUDGET

Type:

ALPHANUMERIC

Length:

25

Format:

N/A

General Description:

An alternative coding structure for Fund Group Code which is used by the Budget Office for its reports.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Fund_Group_Code

Long Name:

FUND GROUP CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code indicating the category to which a fund belongs in the University's accounting structure.

Code Interpretation:

See Appendix E: Fund Group Codes.

Comments:

Revision Date:

Data Element Name:

Fund_Group1

Long Name:

FUND GROUP 1 CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

A hierarchical subdivision of Fund Group Code. At each successive level, funds are grouped into more and more specific categories. By specifying an fund group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 99XXXX
'3' - 999XXX

Comments:

Revision Date:

Data Element Name:

Fund_Group1_Title

Long Name:

FUND GROUP 1 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Fund Group level 1

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Fund_Group2

Long Name:

FUND GROUP 2 CODE

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

A hierarchical subdivision of Fund Group Code. At each successive level, funds are grouped into more and more specific categories. By specifying an fund group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 999XXX
'3' - 9999XX

Comments:

Revision Date:

Data Element Name:

Fund_Group2_Title

Long Name:

FUND GROUP 2 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Fund Group level 2

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Fund_Group3

Long Name:

FUND GROUP 3 CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

A hierarchical subdivision of Fund Group Code. At each successive level, funds are grouped into more and more specific categories. By specifying an fund group level, the level of detail in a report can be controlled.

Code Interpretation:

Level:

'1' - 9XXXXX
'2' - 999XXX
'3' - 9999XX

Comments:

Revision Date:

Data Element Name:

Fund_Group3_Title

Long Name:

FUND GROUP 3 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Fund Group level 3

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Fund_Group4_Title

Long Name:

FUND GROUP 4 TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with Fund Group Code.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Fund_Restriction_Code

Long Name:

FUND RESTRICTION CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether a fund can be used for any operating purpose or is subject to special restrictions established by external agencies or The Regents.

Code Interpretation:

'U'        Unrestricted -- Nonstate funds with no restrictions placed on usage by an external agency.

'R'        Restricted -- Fund is restricted in its use.

'G'        General -- General State support funds and funds from certain student fees and miscellaneous sources. used to finance instruction and operating costs.

Comments:

Revision Date:

Data Element Name:

FUND NAME

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name associated with a fund number.

Code Interpretation:

Refer to Accounting Manual section A-115-2.

Comments:

Revision Date:

Data Element Name:

IDC_Base

Long Name:

INDIRECT COST BASE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Indentifies the direct cost base on which the applicable indirect cost rate will be applied. This code applies to Contracts and Grants from Federal, State, Local, and Private Sponsors.

Code Interpretation:

A         Total direct costs

B         Modified total direct costs

C         Salaries and wages only

D         Salaries, wages and benefits

E          Total direct costs, excluding tuition and fees

F          Total direct costs, excluding equipment, tuition and fees

G         No indirect costs applied (all excluded)

H         Supplies and expenses only

O         Other

Comments:

Revision Date:

Data Element Name:

IDC_Rate

Long Name:

INDIRECT COST RATE

Type:

ALPHANUMERIC

Length:

4

Format:

General Description:

Percentage of indirect costs to be applied to the direct cost base by the University for the given fund. Where multiple rates exist per fund, the rate is to be reported on a preponderance basis.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Location_1

Long Name:

UC LOCATION CODE 1-MAJOR LOCATION

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating a campus, major affiliated institution, or U.S. government-owned/ contractor-operated laboratory of the University.

Code Interpretation:

'01'       - Berkeley

'02'       - San Francisco

'03'       - Davis

'04'       - Los Angeles

'05'       - Riverside

'06'       - San Diego

'07'       - Santa Cruz

'08'       - Santa Barbara

'09'       - Irvine

'10'       - Merced

'20'       - Office of the President

'21'       - Lawrence Berkeley Laboratory

'22'       - Lawrence Livermore National Laboratory

'23'       - Los Alamos National Laboratory

'24'       - Hastings College of Law

'25'       - ASUCLA

'40'       - Endowments

'41'       - UC Retirement System (UCRS)

'42'       - Other Post-Employement Benefits (OPEB) Trust

Comments:

Revision Date:

Data Element Name:

Location_1_Title

Long Name:

UC LOCATION CODE 1 TITLE

Type:

ALPHANUMERIC

Length:

13

Format:

N/A

General Description:

Name associated with a campus, major affiliated institution, or U.S. government-owned/ contractor-operated laboratory of the University.

Code Interpretation:

'01'       - Berkeley

'02'       - San Francisco

'03'       - Davis

'04'       - Los Angeles

'05'       - Riverside

'06'       - San Diego

'07'       - Santa Cruz

'08'       - Santa Barbara

'09'       - Irvine

'10'       - Merced

'20'       - Office of the President

'21'       - Lawrence Berkeley Laboratory

'22'       - Lawrence Livermore National Laboratory

'23'       - Los Alamos National Laboratory

'24'       - Hastings College of Law

'25'       - ASUCLA

'40'       - Endowments

'41'       - UC Retirement System (UCRS)

'42'       - Other Post-Employement Benefits (OPEB) Trust

Comments:

Revision Date:

Data Element Name:

Location_2

Long Name:

UC LOCATION CODE 2-UNIVERSITYWIDE INDICATOR

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether administrative responsibility is local or Universitywide.

Code Interpretation:

'1'         Local (Campus, affiliated institution, US government owned/ contractor-operated laboratory)

'2'         Universitywide

Comments:

Revision Date:

Data Element Name:

Location_2_Title

Long Name:

UC LOCATION CODE 2 TITLE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Name associated with UC Location Code 2 which indicates whether administrative responsibility is local or Universitywide.

Code Interpretation:

'1'         Local (Campus, affiliated institution, US government owned/ contractor-operated laboratory)

'2'         Universitywide (UW)

Comments:

Revision Date:

Data Element Name:

Location_3_Code

Long Name:

UC LOCATION CODE 3 - ORGANIZATIONAL CATEGORY

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating a broad University organizational category.

Code Interpretation:

'1'         General campus

'2'         Health sciences

Comments:

Revision Date:

Data Element Name:

Location_3_Title

Long Name:

UC LOCATION  3 TITLE - ORGANIZATIONAL CATEGORY

Type:

ALPHANUMERIC

Length:

22

Format:

N/A

General Description:

Code indicating a broad University organizational category.

Code Interpretation:

'1'         General campus

'2'         Health sciences

Comments:

Revision Date:

Data Element Name:

Account

Long Name:

METHOD OF PAYMENT CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the manner in which Federal Contract and Grant Funds are paid to the University.

Code Interpretation:

'10'       Reimbursement, billable monthly

'20'       Reimbursement, billable quarterly

'50'       Reimbursement, with billing frequency limited to completion of specific tasks

'60'       Advance payment by treasury check according to a predetermined automatic payment schedule (schedule of the amount to be paid on each date is listed in the contract or grant)

'80'       Advance payment by treasury check based upon periodic invoices submitted by campuses (i.e., USN and USAF advance payment pools)

'90'       Payment by Letter of Credit (i.e., DOE, DHHS, and NSF Letters of Credit)

'95'       Intercampus advances or cost reimbursements on subcontracts or subgrants

'99'       Offset funds for cost of education and institutional allowances

Comments:

Revision Date:

Data Element Name:

Monthly_Max_Rate

Long Name:

Monthly Maximum Rate

Type:

NUMERIC

Length:

15

Format:

2 decimal places

General Description:

Highest monthly amount for a Title Code as defined in the Corporate Title Code System (TCS)

Code Interpretation:

Comments:

Revision Date:

10/07/2009

Data Element Name:

Monthly_Min_Rate

Long Name:

Monthly Minimum Rate

Type:

NUMERIC

Length:

15

Format:

2 decimal places

General Description:

Lowest monthly amount for a Title Code as defined in the Corporate Title Code System (TCS)

Code Interpretation:

Comments:

Revision Date:

10/07/2009

Data Element Name:

MTDC

Long Name:

MODIFIED TOTAL DIRECT COSTS

Type:

ALPHANUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

A distribution base that consists of all salaries and wages, fringe benefits, materials and supplies, services, travel and subgrants and subcontractors (up to the first $25K of each subgrant or subcontract). Specific object codes for equipment, capital expenditures, charges for patient care, rental costs and the portion in excess of $25 are excluded. Other items may be excluded when the relevant federal agency determines that an exclusion is necesssary to avoid a serious inequity in the distribution of indirect costs.

Code Interpretation:

Comments:

Revision Date:

March 05, 2010

Data Element Name:

NSF_Code

Long Name:

NATIONAL SCIENCE FOUNDATION DISCIPLINE CODE

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the academic discipline as defined by the National Science Foundation (NSF) associated with a research expenditure account.

Code Interpretation:

See attached code table.

Comments:

Revision Date:

January 30, 2009

Data Element Name:

NSF_Title

Long Name:

NATIONAL SCIENCE FOUNDATION DISCIPLINE TITLE

Type:

ALPHANUMERIC

Length:

19

Format:

N/A

General Description:

The name of the academic discipline as defined by the National Science Foundation (NSF) associated with a research expenditure account.

Code Interpretation:

See attached code table.

Comments:

Revision Date:

November 18, 2009

Data Element Name:

Object_Amount

Name:

AMOUNT-FINANCIAL CURRENT BALANCE (OBJECT)

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The current balance amount of an account for all transactions with a specific object code.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Object_Amount_Month

Name:

AMOUNT-FINANCIAL CURRENT BALANCE (OBJECT)

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

Net amount of total activity against an account for the current month for all transactions with a specific object code.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Object_Code

Long Name:

OBJECT CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Purpose, type of goods, or service for which an expenditure was incurred.

Code Interpretation:

Refer to the Accounting Manual A-115-2 Accounting Codes: General Ledger, Object Codes, Exhibit F..

Comments:

Corporate Systems CFSTABS Table 207 edits object codes for valid ranges

Revision Date:

03/05/2010

Data Element Name:

Object_Title

Long Name:

OBJECT TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

Descriptive name of the purpose, type of goods, or service for which an expenditure was incurred.

Code Interpretation:

Refer to the following list of Object Codes and the Accounting Manual A-115-2 Accounting Codes: General Ledger, Object Codes..

Comments:

Revision Date:

11/18/2009

Data Element Name:

On_Off_Campus

Long Name:

ON/OFF CAMPUS CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether a project is considered on or off campus. As a general rule, a project is considered off campus if it pays its own rent. This code is required for Gifts, Contracts, and Grants provided by Private sources and by Federal, State, Local, and other governments.

Code Interpretation:

'1'         On campus

'2'         Off campus

'  '         On campus (default)

Comments:

Those projects which cannot be identified as either on or off campus will default to "on campus".

Projects which are conducted partly on and partly off campus will be coded according to preponderance of activity.

Projects whose activities are equally divided are to be coded as "on campus".

Gifts whose on/off status cannot be determined should be coded as "on campus".

Revision Date:

Data Element Name:

Org_1_Code

Long Name:

ORGANIZATIONAL UNIT CODE - LEVEL 1

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code indicating the higher level administrative entity to which an account belongs. This is normally a high level organization responsible for multiple schools, colleges, or divisions (headed by a Vice Chancellor or Provost).

Code Interpretation:

(Codes are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Org_1_Title

Long Name:

ORGANIZATIONAL UNIT TITLE - LEVEL 1

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of the higher level administrative entity to which an account belongs.

Code Interpretation:

(Names are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Org_2_Code

Long Name:

ORGANIZATIONAL UNIT CODE - LEVEL 2

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code indicating an administrative entity above the department or unit to which an account belongs. For academic departments, this should be the school, college, or division.

Code Interpretation:

(Codes are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Org_2_Title

Long Name:

ORGANIZATIONAL UNIT TITLE - LEVEL 2

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of the administrative entity above the department or unit to which an account belongs.

Code Interpretation:

(Names are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Org_3_Code

Long Name:

ORGANIZATIONAL UNIT CODE - LEVEL 3

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code indicating the academic department or administrative unit to which an account belongs.

Code Interpretation:

(Codes are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Org_3_Title

Long Name:

ORGANIZATIONAL UNIT NAME TITLE- LEVEL 3

Type:

ALPHANUMERIC

Length:

30

Format:

N/A

General Description:

The name of the academic department or administrative unit to which an account belongs.

Code Interpretation:

(Names are assigned by the campuses.)

Comments:

Revision Date:

Data Element Name:

Recharge_Expend_Amount

Name:

AMOUNT-RECHARGE EXPENDITURES

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The total amount of recharge expenditures (object code 3900-3999) for an account/fund combination as of the year to date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Salary_Expend_Amount

Name:

AMOUNT-RECHARGE EXPENDITURES

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The total amount of salary expenditures (object code 1000-1999) for an account/fund combination as of the year to date.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

SAU_Code

Long Name:

SYSTEMWIDE ADMINISTRATIVE UNIT (SAU)

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

code indicating the particular systemwide unit responsible for administering a systemwide account.

Code Interpretation:

'4'         Division of Agricultural & Natural Resources

'5'         Universitywide Academic Program

'6'         Office of the President

'7'         Regents Officers

'8'         University Programs

'9'         University Provisions

'0'         Other Programs

Comments:

Revision Date:

Data Element Name:

SAU_Title

Long Name:

SYSTEMWIDE ADMINISTRATIVE UNIT TITLE(SAU)

Type:

ALPHANUMERIC

Length:

22

Format:

N/A

General Description:

The name of he particular systemwide unit responsible for administering a systemwide account.

Code Interpretation:

'4'         Division of Agricultural & Natural Resources

'5'         Universitywide Academic Program

'6'         Office of the President

'7'         Regents Officers

'8'         University Programs

'9'         University Provisions

'0'         Other Programs

Comments:

Revision Date:

Data Element Name:

Special_Fund_Code

Long Name:

SPECIAL FUND CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating whether a fund is designated as a DANR special fund.

Code Interpretation:

'Y - Special
'N' - Not special

Comments:

Revision Date:

Data Element Name:

Sponsor_Category_Code

Long Name:

SPONSOR CATEGORY CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the type of organization sponsoring an extramurally-funded project.

Code Interpretation:

'01'       Federal Government

'02'       State Government

'03'       Other Government Agency

'04'       Business/Profit Entity

'05'       Non-Profit, Business-Related

'06'       Foundation/Charitable Trust

'07'       Other Charitable Organization

'08'       Higher Education Institution/Association

'09'       Campus-Related Organization

'10'       Individual

'11'       UC Foundation

'12'       Marketing orders

'13'       Major UC DOE laboratories (LBL, LLNL, LANL)

'   '        Unknown/to be assigned

Comments:

Revision Date:

Data Element Name:

Sponsor_Code

Long Name:

SPONSOR CODE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code identifying the federal, state, or private contracting or granting agency, i.e., the agency which is the source of funds.

Code Interpretation:

See Sponsor Code Table in Appendix B and Guidelines for Sponsor Code.

Comments:

Revision Date:

Data Element Name:

Sponsor_Country

Long Name:

FOREIGN SPONSOR COUNTRY

Type:

ALPHANUMERIC

Length:

19

Format:

N/A

General Description:

The name of the country of a foreign sponsor.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Sponsor_Foreign

Long Name:

FOREIGN SPONSOR FLAG

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

General Description:

Code indicating that an award is sponsored by a foreign sponsor.

Code Interpretation:

'Y' - Foreign
'  '  - Not Foreign

Comments:

Revision Date:

Data Element Name:

Sponsor_Title

Long Name:

SPONSOR TITLE

Type:

ALPHANUMERIC

Length:

70

Format:

N/A

General Description:

The name of the federal, state, or private contracting or granting agency, i.e., the agency which is the source of funds.

Code Interpretation:

See Sponsor Code Table and Guidelines for Sponsor Code.

Comments:

Revision Date:

Data Element Name:

Sub_Account

Long Name:

SUBACCOUNT CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating a specific category of expenditures.

Code Interpretation:

Refer to Accounting Manual section a-115-2 for further clarification.

Current Funds

'0'            - Salaries--Academic

'1'            - Salaries--Staff

'2'            - General Assistance

'3'            - Supplies & Expense

'4'            - Equipment & Facilities

'5'            - Code available for special items

'6'            - Employee benefits

'7'            - Code available for special items

'8'            - Code available for unallocated funds and special items

'9'            - Recharges to other departments

Plant Funds

'0'            - Site clearance and preparations

'1'            - Construction

'2'            - External Utilities

'3'            - Groups 2 and 3 equipment

'4'            - Landscaping

'5'            - Architects & Engineers Services-External

'6'            - Architects & Engineers Services-Internal

'7'            - Surveys, tests, plans, specifications, etc.

'8'            - Special items

'9'            - Unallocated and contingency funds

Comments:

Revision Date:

Data Element Name:

Sub_Account_Description

Long Name:

SUBACCOUNT CODE Description

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

Code indicating a specific category of expenditures.

Code Interpretation:

Refer to Accounting Manual section a-115-2 for further clarification.

Current Funds

'0'            - Salaries--Academic

'1'            - Salaries--Staff

'2'            - General Assistance

'3'            - Supplies & Expense

'4'            - Equipment & Facilities

'5'            - Code available for special items

'6'            - Employee benefits

'7'            - Code available for special items

'8'            - Code available for unallocated funds and special items

'9'            - Recharges to other departments

Plant Funds

'0'            - Site clearance and preparations

'1'            - Construction

'2'            - External Utilities

'3'            - Groups 2 and 3 equipment

'4'            - Landscaping

'5'            - Architects & Engineers Services-External

'6'            - Architects & Engineers Services-Internal

'7'            - Surveys, tests, plans, specifications, etc.

'8'            - Special items

'9'            - Unallocated and contingency funds

Comments:

Revision Date:

Data Element Name:

Subagency_Code

Long Name:

SUB AGENCY CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating the federal or state department within a major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Subagency_Short_Title

Long Name:

SUB AGENCY SHORT TITLE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

The abbreviated name of the federal or state department within a major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Subagency_Title

Long Name:

SUB AGENCY TITLE

Type:

ALPHANUMERIC

Length:

35

Format:

N/A

General Description:

The name of the federal or state department within a major administrative department with which a contract or grant sponsoring agency is affiliated.

Code Interpretation:

Comments:

Revision Date:

Data Element Name:

Trans_Amount

Name:

AMOUNT FINANCIAL TRANSACTION

Type:

NUMERIC

Length:

15

Format:

Zone S9(13)v99

General Description:

The balance forward amount or the amount of transaction activity.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Trans_Audit_ID

Long Name:

TRANSACTION AUDIT ID

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

The number of the source document (voucher or financial journal number) which identifies a transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Trans_Code

Long Name:

TRANSACTION CODE-FUND BALANCES

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

Code indicating a financial addition to, deduction from, or transfer between fund balance accounts and expended balance accounts.

Code Interpretation:

Refer to Accounting Manual Section A-115-3.

Comments:

Revision Date:

Data Element Name:

Trans_Date

Long Name:

TRANSACTION DATE

Type:

ALPHANUMERIC

Length:

6

Format:

'YYMMDD' where 'YY' - year, 'MM' - Month, 'DD' - Day

General Description:

Date of source document (input form) for a financial or budget transaction. Transaction date may also be machine-generated.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Trans_Date (10 character)

Long Name:

TRANSACTION DATE

Type:

ALPHANUMERIC

Length:

10

Format:

'YYYY-MM-DD' where 'YY' - year, 'MM' - Month, 'DD' - Day

General Description:

Date of source document (input form) for a financial or budget transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Trans_Descr

Long Name:

TRANSACTION DESCRIPTION

Type:

ALPHANUMERIC

Length:

18

Format:

N/A

General Description:

Narrative information about the nature or source of a transaction.

Code Interpretation:

N/A

Comments:

Revision Date:

Data Element Name:

Trans_Type_Entry

Long Name:

TRANSACTION TYPE ENTRY CODE

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

Code indicating how a transaction is recorded in the General Ledger.

Code Interpretation:

Refer to Accounting Manual Section A-115-6.

'00'       - Balance forward

'11', '12', '13'    - Budget entries

'14', '15'           - Transfer of funds

'30' through '59'           - Financial transactions

'60'       - Lien cancellation

'61' through '69'           - Lien entry or cancellation

Comments:

Revision Date:

Data Element Name:

UAS_Code

Long Name:

UNIFORM ACCOUNTING STRUCTURE CODE

Type:

ALPHANUMERIC

Length:

6

Format:

N/A

General Description:

Code used to classify academic and administrative activities according to a hierarchical structure of programs and subprograms, without regard to the administrative structure at the location. The first two digits identify the primary program. The second two digits identify subcategories within each program. The last two digits identify sub-subcategories (specific activities) within each program.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Discipline

Long Name:

UNIFORM ACCOUNTING STRUCTURE - ACADEMIC DISCIPLINE CODE

Type:

ALPHANUMERIC

Length:

3

Format:

N/A

General Description:

Code indicating the academic discipline or activity associated with a specific category of current fund expenditure accounts.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Program_Code

Long Name:

UNIFORM ACCOUNTING STRUCTURE PROGRAM

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

The first two characters of UAS Code which identify the program.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Program_Title

Long Name:

UNIFORM ACCOUNTING STRUCTURE PROGRAM TITLE

Type:

ALPHANUMERIC

Length:

20

Format:

N/A

General Description:

The name associated UAS Program.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Structure

Long Name:

UNIFORM ACCOUNTING STRUCTURE CODE

Type:

ALPHANUMERIC

Length:

10

Format:

N/A

General Description:

The concatenation of UAS Code and UAS Discipline, separated by a blank. For example, '440100 240'.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Structure_Title

Long Name:

UNIFORM ACCOUNTING STRUCTURE TITLE

Type:

ALPHANUMERIC

Length:

20

Format:

N/A

General Description:

The name associated with UAS Structure.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date:

Data Element Name:

UAS_Subprogram

Long Name:

UNIFORM ACCOUNTING SUBPROGRAM TITLE

Type:

ALPHANUMERIC

Length:

4

Format:

N/A

General Description:

The first four characters of UAS Code which identify the subprogram.

Code Interpretation:

Refer to Accounting Manual Chapter U-751-17.

Comments:

Revision Date: