Expenditures by SID/CFDA Number .us



CT_CORE_FIN_FED_GRANT_EXP

Purpose of Query

Expenditures by SID/CFDA Number - The purpose of this query is to monitor Federal grant expenditures. Please note that if an attribute (CFDA) number is not associated in CORE-CT with a particular SID the expenditures are excluded in the results.

Folder

AR

Tables

A CTW_LED_BAL - Ledger Balances Rpt

Join B CTW_CF_ATRB_TBL - CFs & Attribute Values

Join C CTW_CF_ATRB_VAL - Valid CF Attribute Values

Note: A JOIN is an SQL command that is used to relate two or more data tables (Records in PeopleSoft) based on the use of related (key) fields from one table to the next. Once joined, data can be retrieved without repeating all of the data in every table.

Prompts

ACCOUNTING_PERIOD - Accounting Period From / ACCOUNTING_PERIOD - Accounting Period To – (Between condition)

FISCAL_YEAR - Fiscal Year – (Equal To)

ACCOUNT - Acct like % - (Wildcard enabled)

CT_SID - SID like % - (Wildcard enabled)

DEPTID - DeptID (%) - (Wildcard enabled)

[pic]

Criteria

C.CT_CF_ATTRIBUTE - Chartfield Attrib equal to CFDA_NUMBER

A.ACCOUNT - Account like 5% - (All expenditures)

SUBSTR(A.DEPTID,1,3) between AAA AND ZZZ – (All Department IDs)

A.ACCOUNT - Account not between 56180 AND 56200 – (Excluded expenditure accounts)

A.LEDGER - Ledger in list ('MOD_ACCRL','MOD_CASH')

B.EFFDT - Effective Date Eff Date ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download