Line Item Details data is split into four tables:
- Base Budget data for the FY being planned
- Trustee Budget data for the FY being planned (populated after the May meetings of the Board of Trustees)
- Current FY Final Budget data
- Current FY Trustee Budget
Line Item Details Extract – New Year Base Budget
Contains line item details base budget data for the FY being planned.
Tablename: LONGVIEW.LID_NEW_BASE_BUDGET
Load schedule: Monday – Friday @ approximately 7:30AM
| Field Listing (name and data type) | Definition |
| EXTRACT_DATE – DATE | Date and Time data was populated to given Extract Table |
| TIME PERIOD – VARCHAR2(500 BYTE) | Indicates whether the data reflects Current Year Final Budget (e.g., FBYR2016), Current Year Trustee Budget (e.g., TBYR2016), New Year Base Budget (e.g., BBYR2017), or New Year Trustee Budget (e.g., TBYR2017). |
| ORGANIZATION – VARCHAR2(500 BYTE) | Org path using codes that indicates place in the lineage of each org, from the parent org code down to the child org code. |
| COLLEGE – VARCHAR2(500 BYTE) | Represents a unique “C” Level Org assigned to units within an institution. Unique to a particular chart to which it belongs. |
| ORG – VARCHAR2(500 BYTE) | Represents a unique “Bottom Org” identifier assigned to units within an institution. Unique to a particular chart to which it belongs. |
| ORGDESCRIPTION – VARCHAR2(500 BYTE) | Name of bottom org |
| ACCOUNT – VARCHAR2(500 BYTE) | The unique number to identify a pool of funds assigned to a specific institution entity for a specific function. |
| ACCOUNTDESC – VARCHAR2(500 BYTE) | The name on the account. |
| OBJECT – VARCHAR2(500 BYTE) | A four-character code to represent all income, expense, asset, liability, and fund balance classifications assigned to transactions & help identify the nature of the transaction. Object codes are defined centrally with broad definitions so that they are available for use by more than one organization. They are specific to a chart and a fiscal year. |
| OBJDESC – VARCHAR2(500 BYTE) | A long descriptive name for the object code that appears on the Accounting Lines tab in financial documents as well as in searches and reports |
| SUBOBJ – VARCHAR2(500 BYTE) | An optional element of the accounting string related to the university object code that allows for finer distinctions within a particular object code for a specific account (for example, income and expense class). |
| SUBOBJDESC – VARCHAR2(500 BYTE) | An optional element of the accounting string related to the university object code that allows for finer distinctions within a particular object code for a specific account (for example, income and expense class). |
| FUNDGRP – VARCHAR2(500 BYTE) | The Fund Group Code. |
| FUNDGRPDESC – VARCHAR2(500 BYTE) | The description of a specific fund group. |
| ENCC – VARCHAR2(500 BYTE) | Code indicating whether the account is related to a Contract or Endowed Unit |
| MAJOR – VARCHAR2(500 BYTE) | Categorization of activities and fund balances that are controlled by various stakeholders including, but not limited to, those controlled by Deans, Departments, Faculty and Students. In addition there is a need to be able to identify what major activities these fund balances are earmarked for. |
| REVEXP – VARCHAR2(500 BYTE) | A unique identifying code that categorizes object codes by Revenue (Income) and Expense (Expense) for reporting. |
| LINE ITEM DETAIL | |
| LINE ITEM AMOUNT $ |