PTAEO Strings in OGA www.dartmouth.edu/~osp What is PTAEO? A unique chart string that is used to: Record sponsored-project financial transactions Specify details about transactions Report on transactions Allocate and.
Download ReportTranscript PTAEO Strings in OGA www.dartmouth.edu/~osp What is PTAEO? A unique chart string that is used to: Record sponsored-project financial transactions Specify details about transactions Report on transactions Allocate and.
PTAEO Strings in OGA www.dartmouth.edu/~osp What is PTAEO? A unique chart string that is used to: Record sponsored-project financial transactions Specify details about transactions Report on transactions Allocate and track sponsored-project budgets www.dartmouth.edu/~osp Why not just use the GL? Budgeting, transacting, and reporting require a different accounting approach for grants. Accounting Oracle Application Type of String Non-Grant General Ledger (GL) Grant Grants PTAEO Accounting (OGA) www.dartmouth.edu/~osp GL Chart String Impact and Usage of PTAEO Used by: Impacts: Purchase Requisitions P-Card Transactions Journal Entries Reporting Payroll Authorizations All financial systems OSP Project personnel Procurement Grant Managers Service & Recharge centers Fiscal offices www.dartmouth.edu/~osp PTAEO Strings P T A E O Project Task Award Expenditure Type Org XXXXXX ● XXXX ● XXXXXX ● XXXXX ● XXX 5 segments separated by periods make a PTAEO string Each segment represents a different piece of information Total of 24 characters in a PTAEO string Every transaction must have a complete PTAEO string One PTAEO string represents all of the information about a particular transaction No hierarchies or range values with PTAEO www.dartmouth.edu/~osp What does a PTAEO String tell us? P T A E O Project Task Award Expenditure Type Org Indicates the work being done Provides a mechanism for organizing expenditures within a project Describes how the work is being paid and how we are being reimbursed Is equivalent to Natural Class “expense” values Denotes the same value as “Org” in GL chart string OGA Feeds Data to GL www.dartmouth.edu/~osp Segment Values: Project P Project XXXXXX 6 characters All projects fall within 500000-589999 range Examples: Indicates the work being done Insulin Regulation Bioinformatics Mascoma Clinic www.dartmouth.edu/~osp Segment Values: Task T Task XXXX Provides a mechanism for organizing expenditures within a project 4 characters Organizes expenses within a project Each project must have at least one task Current task ranges: 5000-5999—funded by an external sponsor 6000-6999—funded by internal cost share www.dartmouth.edu/~osp Segment Values: Award A Award XXXXXX Describes the money paying for the work being done 6 characters Initial alpha character identifies billing mechanism to allow efficient processing of sponsor invoices L - Letter of credit B - Billed monthly and quarterly P - Payment/Installment Schedule C - Cost Share www.dartmouth.edu/~osp Segment Values: Expenditure Type E Expenditure type XXXXX Is equivalent to Natural Class “expense” values 5 characters Is a subset of the GL Expense Natural Class An Alpha character at end of the four digits provides flexibility when greater detail is needed in OGA, for example, subcontractor payments Examples: 7471A SUPPL LAB Chemical Gases 8111A TRAVEL FOREIGN Air www.dartmouth.edu/~osp Segment Values: Org O Org XXX Is equivalent to G/L Org 3 characters Values identical to the Org values in GL Some Oracle modules, such as Accounts Payable, Labor Distribution, Procurement, accept name in place of Org value www.dartmouth.edu/~osp PTAEO Relationships PTAEO allows several types of relationships among Projects, Tasks, and Awards. Single Project, Single Award Project 500001 Task 5000 Award L12345 Single Project, Multiple Awards Project 500001 www.dartmouth.edu/~osp Task 5000 Award L78221 Externally funded Task 6000 Award C26116 Internally funded Another PTAEO Relationship Multiple Projects, Single Award PI Robinson Project 500001 Task 5000 PI Radley Project 500002 Task 5000 PI Finch Project 500003 Task 5000 www.dartmouth.edu/~osp Award L12345 Another PTAEO Relationship Multiple Projects with Cost Sharing, Single Award PI Robinson Project 500001 Task 5000 PI Radley Project 500002 Task 5000 internally funded PI Finch Project 500003 Task 6000 Award C48001 Task 5000 www.dartmouth.edu/~osp Award L12345 Sample PTAEO String 500322 ● ● 5000 P00290 Project Task Award Smooth muscle cells External funding Smooth muscle cells ● 7471A ● Expenditure Type SUPPL LAB Chemical gases 500322.5000.P00290.7471A.169 Sample Project in Dartmouth Medical School www.dartmouth.edu/~osp 169 Org Surgery Sample PTAEO String 501381 ● 5000 ● L00475 Project Task Award Smart Laser Beams External Funding Smart Laser Beams ● 7571A ● Expenditure Type CAP EQUIP Scientific 501381.5000.L00475.7571A.842 Sample Project in Thayer www.dartmouth.edu/~osp 842 Org Mechanical Thayer Sample PTAEO String 500681 ● 5000 ● B00051 Project Task Award From Cells to Solids External Funding From Cells to Solids ● 6012A ● Expenditure Type FAC REG Tenure 500681.5000.B00051.6012A.472 Sample Project in Arts & Sciences www.dartmouth.edu/~osp 472 Org Physics & Astronomy Attention Grant Managers! Project dates set up within OGA will enforce existing policies of spending within project start and end dates by blocking expenditures with an expenditure item date that does not fall between the start and end dates. www.dartmouth.edu/~osp Attention Grant Managers! Submit project documents (cost transfers, budget templates, attribute changes, SPUD, journals) to OSP via a new allinclusive e-mail account: [email protected] www.dartmouth.edu/~osp What OGA is Checking For Mandate valid PTAEO string combinations Transaction date that falls between the start and end dates of the Project, Task, or Award Project status that allows transactions Award status that allows transactions www.dartmouth.edu/~osp