Budget Tree Information
Review of BCM_FUND_SRC Tree
The BCM_FUND_SRC tree and related values should be reviewed as indicated below.
1. Run the 0BD019C query and sort by LEVEL, then CHILD.
2. Review the BD_DETAIL and BD_ORG level values. All BD_DETAIL level values must have parent values that roll up to the values indicated below. All BD_ORG level values must have parent values as indicated below.
Fund Source Values - 1st Two Digits | Valid Parent Values |
---|---|
01 |
ST2, SMF2, LOTT2, BSIT2, KRSR2, CMO2, or NHPF2 |
02 |
STPY2, MFPY2, LTPY2, TBPY2, BSPY2, or GEPY2 |
03 |
TOB2 |
04 |
NOT GEF2, WTHD, REV, or any value listed above |
05 |
GEF2 |
06 (except 06999) |
OTH2 |
07 |
REV |
08 – 09 |
generally OTH2 |
10 – 39 |
generally FED2 |
40 – 99 |
generally OTH2 |
Note: Fund sources beginning with “02” were used prior to FY 2009 for Indirect Funding. Indirect Funding is no longer a valid source of funds, and any related fund sources should have an inactive status. All “02” fund sources in use should relate to prior year State funds. If a new BCM_FUND_SRC tree is being requested, the old Indirect Funding fund sources should not be included on the new tree.
3. Review the FS_TYPE level values. Valid values and appropriate parent values are listed in the table below.
Descriptions |
FS Type Values |
Valid Parent Values |
State Funds | ||
State General Funds | ST2 | ST1 |
State Motor Fuel Funds | SMF2 | SMF1 |
Lottery Proceeds | LOTT2 | LOTT1 |
Tobacco Settlement Funds | TOB2 | TOB1 |
Brain & Spinal Injury Trust Fund | BSIT2 | BSIT1 |
Governor’s Emergency Fund | GEF2 | GEF1 |
K – 12 RSR | KRSR2 | KRSR1 |
Care Management Organization Fees | CMO2 | CMO1 |
Nursing Home Provider Fees | NHPF2 | NHPF1 |
Hospital Provider Fee | HPP2 | HPP1 |
Prior Year State Funds | ||
State General Funds | STPY2 | STPY1 |
State Motor Fuel Funds | MFPY2 | MFPY1 |
Lottery Proceeds | LTPY2 | LTPY1 |
Tobacco Settlement Funds | TBPY2 | TBPY1 |
Brain & Spinal Injury Trust Fund | BSPY2 | BSPY1 |
Governor’s Emergency Fund | GEPY2 | GEPY1 |
Federal Funds | ||
Federal Funds – non-specific | FED2 | FED1 |
CCDF Mandatory & Matching Funds | CCDF | |
Child Care and Development Block Grant | CCDBG | |
Community Mental Health Svcs Block Grnt | CMHSB | |
Community Services Block Grant | CSBG | |
Foster Care Title IV-E | FCIVE | |
Fed Hwy Admin – Highway Plan & Constr | FHAHP | |
Fed Transit Admin – Cap Invest Grant | FTACI | |
Low-Income Home Energy Assist | LIHEA | |
Medical Assistance Program | MAP | |
Maternal & Child Health Svcs Block Grant | MCHSB | |
Preventative Health & Health Svcs Block Gr | PHHSB | |
Prev & Treat of Subs Abuse Block Grant | PTSAB | |
State Children’s Health Insurance Program | SCIP | |
Social Services Block Grant | SSBG | |
Temporary Assistance for Needy Families | TANF | |
TANF - Unobligated Balance | TANFU | |
TANF – Transfer to CCDF | TANFX | |
TANF – Transfer to SSBG | TANFZ | |
Temp Fed – used to align ARRA w/ Approp | FTEMP | |
Federal Stimulus Funds (ARRA) | ||
Federal Funds – non-specific | ZFED2 | STIM1 |
CCDF Mandatory & Matching Funds | ZCCDF | |
Child Care and Development Block Grant | ZCCBG | |
Community Mental Health Svcs Block Grnt | ZCMHS | |
Community Services Block Grant | ZCSBG | |
Foster Care Title IV-E | ZFCIV | |
Fed Hwy Admin – Highway Plan & Constr | ZFHWP | |
Fed Transit Admin – Cap Invest Grant | ZFTAC | |
Low-Income Home Energy Assist | ZLIHE | |
Medical Assistance Program | ZMAP | |
Maternal & Child Health Svcs Block Grant | ZMCHS | |
Preventative Health & Health Svcs Block Gr | ZPHHS | |
Prev & Treat of Subs Abuse Block Grant | ZPTSA | |
State Children’s Health Insurance Program | ZSCIP | |
Social Services Block Grant | ZSSBG | |
Temporary Assistance for Needy Families | ZTANF | |
TANF - Unobligated Balance | ZTANU | |
TANF – Transfer to CCDF | ZTANX | |
TANF – Transfer to SSBG | ZTANZ | |
Other Funds | ||
Other | OTH2 | OTH1 |
Health Ins Payments | HIP | |
Indigent Care Trust Fund | ICTF | |
Medicaid Services Pay’ts - Other Agencies | MSPOA | |
Other Intra-State Government Payments | OISGP | |
Record Center Storage Fee | RCSF | |
Research Funds | RESRC | |
Revenue Collections | REV | |
Retirement Payments | RP | |
Self Insurance Trust Fund Payments | SITFP | |
Payroll Withholdings | WTHD |
4. Review the FS_CAT level values. Valid values are those listed as “Valid Parent Values” in the table above. The parent value for all FS_CAT values should be “ALL.”
5. Run the 0GL027 query and sort by STATUS, then FUND SRC.
6. For all active (Status “A”) fund sources, review the “CFDA Nbr” column. Only fund sources beginning with 10 – 39 and 1X – 3X (ARRA funds) should have CFDA numbers other than 0.000; all fund sources beginning with 10 – 39 and 1X – 3X (ARRA funds) should have valid CFDA numbers.
a. If fund sources other than those noted above have a CFDA number other than 0.000, either a funding type of “Federal” was incorrectly chosen in the initial setup of such fund source (Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Define Values > Chartfield Values > Funding Source), or the fund source is incorrectly numbered. Make appropriate corrections in TeamWorks.
b. If fund sources in the ranges noted above do not have valid fund source numbers (that is, such fund sources have a CFDA number of 0.000, or the fund source number is not listed in the Catalog of Federal Domestic Assistance (retired) – see sam.gov), make sure that a funding type of “Federal” is selected in the fund source set-up screen and enter the appropriate CFDA number. If such a fund source does not belong in the “Federal” category, create a new fund source using the appropriate numbering scheme. If a valid CFDA number cannot be found for a particular Federal grant, enter the two-digit code for the Federal agency awarding the grant, followed by “.999” (e.g., for Department of Health and Human Services, enter 93.999). Every effort should be made to obtain accurate CFDA numbers.
7. When all CFDA numbers have been validated, sort the 0GL027 query (if changes were made, run the query again) by CFDA NBR, then FUND SRC. Fund sources with specific CFDA numbers may have parent values (or may have parent values that roll up to values) other than FED2 (or ZFED2 for ARRA grants), as indicated in the table below. Agencies should review the appropriations acts for federal funds specifically identified..
CFDA Number | FS TYPE Value |
---|---|
20.205 |
FHAHP or ZFHWP (ARRA) |
20.500 |
(1) |
93.558 |
TANF (2) (see 93.714 & 93.716 for ARRA) |
93.568 |
LIHEA (3) |
93.569 |
CSBG (see 93.710 for ARRA) |
93.575 |
CCDBG (see 93.713 for ARRA) |
93.596 |
CCDF (3) |
93.658 |
FCIVE or ZFCIV (ARRA) |
93.667 |
SSBG (3) |
93.710 |
ZCCBG (ARRA) |
93.713 |
ZCCBG (ARRA) |
93.714 |
ZTANF (ARRA) |
93.716 |
ZTANF (ARRA) |
93.767 |
SCIP (3) |
93.778 |
MAP or ZMAP (ARRA) |
93.958 |
CMHSB (3) |
93.959 |
PTSAB (3) |
93.991 |
PHHSB (3) |
93.994 |
MCHSB (3) |
(1) The Federal Transit Administration Capital Investment Grant was previously specifically identified in the Appropriation Act. Older grants may still carry the FS_TYPE identifier of FTACI; however, for FY 2010 reporting purposes, fund sources with this CFDA number should be identified as FED2.
(2) CFDA 93.558 may also be used for FS_TYPEs TANFU, TANFX, and TANFZ.
(3) No ARRA funding currently awarded for this grant.