BU-BALANCE

DWH Archive Name: B__BU_BALANCE

Contains balance information for a fiscal year, company (fund and location), budgetary unit, class, and institutional category. This data is used in preparation & establishment of the University budget. Some data is directly manipulated during the budget process while other data is summarized from supporting systems on a periodic basis.

Data Element Definitions for BU-BALANCE (U-90)

Type & Level		Field Name & Attributes	Format & Length		Comp Opt	Index	Field Definition
	1	BUDGET-FY DB=AB CS=GL	N	4.0	N		The UAF fiscal year in which an associated budget entry is effective. The fiscal year ends on June 30, therefore fiscal year 1993 begins on July 1, 1992 and goes through June 30, 1993.
	1	COMPANY-NO DB=AC CS=GL	N	4.0	N		Numeric identifier for a fund group (first 2 digits), fund within a group (3rd digit), and location (4th digit). Used to segregate financial records at a high level.
	1	BUDGETARY-UNIT-NO DB=AD CS=UA	N	4.0	N		Unique numeric identifier for a UAF budgetary unit. A budgetary unit is an organizational entity that either receives a budget or has staff. It exists between the company-cost center and the department levels. All cost centers are associated with a budgetary unit, all budgetary units are associated with a department.
	1	DEPT-ACCT-CATEGORY-CLASS DB=A1 CS=GL	A	1.0	F		The classification of a departmental accounting category as: 1 = Asset 2 = Liability 3 = Fund Balance 4 = Revenue/Estimated Revenue/ 5 = Budget/Expense/ Encumbrance/Commitment Planned Expenditure/ Fund Transfer
	1	INSTITUTIONAL-CATEGORY DB=AE CS=UA	A	1.0	F		A predefined code used to identify the highest level of categorization of budget. This is the level at which the institution budgets. For example, 'Maint' is the institutional category for maintenance.
PE	1	BU-BUDGET-SOURCE-GROUP DB=AF CS=* Max Occ=3 HD=__BU_BUDGET_SRC_GRP					DWH Archive Name: B__BU_BALANCE__BU_BUDGET_SRC_GRP Periodic repeating group used to maintain segregated budget data (by occurrence) for the following funding types: 1 - Hard funded 2 - Soft funded 3 - Departmental revenue
	2	BU-BUDGET-AMT DB=AG CS=GL PE=BU-BUDGET-SOURCE-GROUP	P	9.0	N		The amount of budget posted during the budget cycle to a Company/BU for a funding type during the budget cycle. This amount is available for allocation to other BUs and distribution to Cost Centers. It is reduced when allocated to other BUs, but not when distributed to cost centers.
	2	ANTICIPATED-BU-BUDGET-AMT DB=AH CS=* PE=BU-BUDGET-SOURCE-GROUP	P	9.0	N		The budget expected to be available to the Co/BU by funding type for the next budget cycle. Immediately following the budget cycle, this amount in the next fiscal year is set equal to the BU Budget just established. This anticipated amount in the future budget year is updated throughout the year as the result of sanctioned activity such as merit increases. It is used as the base for determining the budget during that future budget cycle.
	2	SUM-POSITION-BUDGET-AMT DB=AI CS=* PE=BU-BUDGET-SOURCE-GROUP	P	9.0	N		The sum of Position-Budget-Amt for the defined Funding-Type and associated Budget-FY, Company-No, Budgetary-Unit-NO, and Institutional-Category from the Position-Budget. This value is updated as the position budget records are maintained. Position-Budget updates cannot be performed if they would result in the corresponding Sum-Position-Budget exceeding the BU-Budget. Similarly, BU-Budget allocations may also be prevented.
	1	SUM-CCC-DIST-BUDGET-AMT DB=AN CS=*	P	9.0	N		Sum of the BU-Budget distributed to Cost Centers from this Company/BU. This value is updated as these distributions are performed. Distributions cannot be effected if they would result in this amount exceeding the total BU-Budget (aggregate accross funding types). Similarly, BU-Budget allocations may also be blocked.
	1	BU-ESTIMATED-REVENUE-AMT DB=AO CS=GL	P	9.0	N		The amount of estimated revenue posted to a Company/BU during the budget cycle. This amount is available for allocation to other BUs or for distribution to Cost Centers. It is reduced by the amount allocated to other BUs.
	1	SUM-CCC-DIST-EST-REVENUE-AMT DB=AP CS=*	P	9.0	N		Sum of the BU Estimated Revenue distributed to Cost Centers from this Company/BU. This value is updated as these distributions are performed. Distributions cannot be effected if they would result in this amount exceeding the BU-Estimated- Revenue-Amt. Similarly, allocations to other BUs may also be blocked.
	1	BU-ENCUMBRANCE-AMT DB=AQ CS=GL	P	9.2	N		An amount representing an obligation to the University, typically because of an open Purchase Order. Anticipated salary expenditures are also treated as an encumbrance (these are automatically liquidated [set to zero] when the salary expense for a period is recorded). Aggregated periodically from the Dynamic-Balance file.
	1	BU-REVENUE-AMT DB=AR CS=GL	P	9.2	N		A summary of University revenues (income) that have been recorded within GL. Aggregated periodically from the Dynamic-Balance file.
	1	BU-TRANSFER-AMT DB=AS CS=GL	P	9.2	N		Funds that are moved between Departmental Centers during the operating year. Positive values have a positive impact on available funds while negative values reduce available funds. Aggregated periodically from the Dynamic-Balance file.
	1	BU-EXPENDITURE-AMT DB=AT CS=GL	P	9.2	N		A summary of University expenditures that have been recorded within GL. Aggregated periodically from the Dynamic-Balance file.
	1	BU-COMMITMENT-AMT DB=AU CS=GL	P	9.2	N		The Commitment-Amt aggregated from the Dynamic-Balance file to the BU-Balance file. This amount represents current, open commitments -- approved requisitions whose lines have not yet been pulled into an open PO line.
	1	BU-PENDING-APPROVAL-AMT DB=AV CS=GL	P	9.2	N		The Pending-Approval-Amt from the Dynamic-Balance file aggregated to the BU-Balance file. This amount represents TARGET transactions that are pending approval.
	1	BU-PLANNED-AMT DB=AW CS=GL	P	9.2	N		The Planned-Amt aggregated from the Dynamic-Balance file to the BU-Balance file. This amount represents unreconciled planned financial transactions.
	1	TARGET-TXN-PENDING-CD DB=AX CS=*	A	1.0	N		A code identifying when certain TARGET transactions are pending for a record. This code is used to ensure that multiple TARGET transactions are not pending for the same BU-Balance record. Possible values are: A = AUBB B = BUBA C = CUB = Nothing pending
PE	1	AUDIT-LOG-GROUP DB=BA CS=* Max Occ=9 HD=__AUDIT_LOG_GROUP					DWH Archive Name: B__BU_BALANCE__AUDIT_LOG_GROUP The periodic repeating group used to record audit information related to updates to a BU-Balance entry. Occurrences within this group correspond with the following updates: 1 - BUCM 2 - SETB,SETE 3 - AUBB,AUER 4 - PBMC,PBM 5 - CUBC,CUB 6 - BUBA 7 - DUBC,DUER 8 - SALI,APBU,CTRA 9 - Batch Update
	2	TIME-OF-UPDATE DB=BB CS=UA PE=AUDIT-LOG-GROUP	T		N		Date and time that a record or associated item was last updated on the data base.
	2	UPDATED-BY-USER DB=BC CS=UA PE=AUDIT-LOG-GROUP	A	8.0	N		The Natural user ID (USER-ID) of the last user to update a record or associated item.
	1	TIME-STAMP DB=AA CS=UA	B	8.0	F		This field is used to uniquely identify each update to a record. Each time a record is updated, this field should be assigned the value of the Natural function *TIMESTMP. Programs should check to see if this field has changed from the time they first read a record until the time they read the record with hold. This will determine if someone else has altered the record.
SP	1	FY-CO-BU-CLASS-I-CAT-KEY DB=S1 CS=*	A	14.0	N	U	The super-descriptor composed of Budget-FY, Company-NO, Budgetary-Unit-NO, Dept-Acct-Category-Class, and Institutional-Category. This index is used to uniquely identify, retrieve, and list BU-Balance entries.