CT_CORE_JRNL_SRC_SEFA_SUBRECIP

Purpose of Query

55050 Sub-recipient Journal Detail - Query developed to assist agencies in monitoring and identifying those expenditures as journal entries, coded as pass through funds to sub-recipients GL account 55050 for Federal Grant reporting. Each agency is responsible in the correct reporting of expenditures coded as sub awards.

The State as a pass-through entity is required to identify in the State's SEFA the total amount provided to sub-recipients (external entities) for each Federal program, including separate identification of ARRA funds.

Folder

GL

Tables

A.CTW_JRNL_TRN - Journal Transaction Rpt

Join B.CTW_CF_ATRB_TBL - CFs & Attribute Values

Join C.CTW_CF_ATRB_VAL - Valid CF Attribute Values

Prompts

FISCAL_YEAR - Fiscal Year= - (Equal To)

JOURNAL_DATE - Journal Date From / JOURNAL_DATE - Journal Date To (Between criteria)

DEPTID - DeptID Like (%) – (Wildcard enabled)

Sample Results

Please note, due to page size limitations, sample results may be incomplete.

Criteria

B.CHARTFIELD_VALUE - ChartField Value= A.CT_SID – SID

B.FIELDNAME - Field Name= CLASS_FLD

B.CT_CF_ATTRIBUTE - Chartfield Attrib= CFDA_NUMBER

A..ACCOUNT - Account =55050

A.ACCOUNTING_PERIOD - Accounting Period not equal to 999

A.LEDGER_GROUP - Ledger Group equal to MOD_ACCRL – (Modified Accrual ledger)

A.JRNL_HDR_STATUS - Journal Header Status in list (‘P’,’U’)

Note: Runtime prompts are included as criteria.

Fields

Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text
1 / SUBSTR(A.DEPTID,1,3) / Char3 / Agency
2 / A.FUND_CODE - Fund Code / Char5 / Fund
3 / A.CT_SID - SID / Char5 / SID
4 / B.CT_CF_ATTRIB_VALUE - Chartfiled Attribute Value / Char20 / CFDA Nbr
5 / C.DESCR60 - Description / Char60 / CFDA Description
6 / A.MONETARY_AMOUNT - Monetary Amount / SNm25.3 / Sum / Sum Amount
7 / A.JOURNAL_ID - Journal ID / Char10 / Journal ID
8 / A.JOURNAL_LINE - GL Journal Line Number / Num9.0 / Journal Line
9 / A.JOURNAL_DATE - Journal Date / Date / Journal Date
10 / A.ACCOUNT - Account / Char10 / Acct
11 / A.SOURCE - Source / Char3 / Source
12 / A.FISCAL_YEAR - Fiscal Year / Num4.0 / Fiscal Year