Information Release 2013_12_SPDTYPINFO_VW / Retrieval Name: Information Release 2013_1
Issue Date: December 10, 2013
Revision Date:
Originator: PeopleSoft Functional Support Team

New Table Available for Query: ZZSPDTYPINFO_VW

Scope:This PeopleSoft Financials Information Release applies to Enterprise Financial Business Units that utilize Speedtype and Project Information. Business and Department Managers will be able to select the new table to query speedtype associated high-level information from one source.

Purpose: This information release serves as notification of the new table and provides a detailed listing of the fields contained within the table.

Modules: This release applies to PeopleSoft Financials 9.1, PRD and RPT databases, and may be utilized by Project Grants, Contracts, and General Ledger teams as well as department and business managers responsible for documenting project related information.

Table Name: ZZSPDTYPINFO_VW

Fields Contained in the table:

Key / Field / Field Description / Information
Y / SETID / SetID / Setid is the control setting that refers to one or more business units under which the data is shared
Y / SPEEDTYPE_KEY / SpeedType code / The code used to identify a combination of chartfields
ZZSPEEDTYP_DESCR / Speedtype Description / Description of the speedtype
ACCOUNT / Account / The revenue or expense account number used in the speedtype
ZZACCOUNT_DESCR / Account Description / The description of the account number used in the speedtype
DEPTID / Department / The department code used in the speedtype
ZZDEPT_DESCR / Dept. Description / The description of the department used in the speedtype
FUND_CODE / Fund Code / The fund code used in the speedtype to segregate data by type of accounting rules
ZZFUND_DESCR / Fund Description / The description of the fund code used in the speedtype
PROGRAM_CODE / Program Code / The program code used in the speedtype to classify how funds are used
ZZPROGRAM_DESCR / Program Description / The description of the program code used in the speedtype
CLASS_FLD / Class Field / The class code used in the speedtype to identify the source of the funds
ZZCLASS_DESCR / Class Field Description / The description of the class code used in the speedtype
Key / Field / Field Description
PROJECT_ID / Project / The project code used in the speedtype used to group revenues and expenses for a related project, grant, or contract
ZZPROJ_DESCR / Project Description / The description of the project code
FA_RATE_TYPE / Facilities Admin Rate / The F&A Percentage Rate for the speedtype
CUST_NAME / Sponsor / The Sponsor’s name
NAME / Award PI / The Award’s Principal Investigator’s name
START_DT / Start Date / The Start Date of the Award, Grant, Contract
END_DT / End Date / The End Date of the Award, Grant, Contract
PURPOSE / Purpose / The purpose of the Award such as Clinical Trial or Research
AWARD_STATUS / Award Status / The current status of the Award
CFDA / CFDA / CFDA number if the Grant is a federal one
REF_AWD_NUMBER / Reference Award Number / The Reference Award Number of the Grant that is provided by the granting agency
ZZPROJ_DESCR254 / Project Description254 / The longest description of the project that includes the title, reference award number, grant award number and CFDA number
ZZPROJ_DESCR_LONG / Project Description Long / Title of the Grant is populated in this field
ZZGL_HRACCT_CD / HR Account Code / The HR General Ledger Account Code for the speedtype

This new table may be used to pull additional information into existing queries and reports.

The Public Query called ZZGLDTL_WITH_SPEEDTYPEis available for your use. It joins the ZZGL_TRANS_DTL and the ZZSPEEDTYPINFO_VW tables to retrieve all fields in the Trans Detail table and any additional information that is contained in the Speedtype Info table that coincides with the original table data. The query prompts for the GL Business Unit, the department, and fiscal year. If additional criteria are desired, you may save the query as a private one and apply additional criteria to the tables.

As an analysis tool, a sample pivot table file has been created for general use with the new public query. Save the file to a network drive and it may be used to assist in monthly data reconciliation. The file may be downloaded from the PeopleSoft Support web page: Template ZZGLTRANSDTL.xlsx