Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse BALANCES Table


Contains financial information, balance & budget data by cost collector ID as of yesterday. Use this table to view a current balance, or to compare several past fiscal years in total. Normally the limit selected for this table is by Fiscal Year. (Taken from SAP tables COSP & COSS.)


Field Name

Description

Data Type

Length

ANNUAL_FORECAST_BUDGET

XXX

NUMBER

22

APRIL_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

APRIL_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

APRIL_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

AUGUST_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

AUGUST_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

AUGUST_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

CLOSING_PERIOD_13_AMOUNT

Additional closing period where adjustments are made after June 30th.

NUMBER

13.2

CLOSING_PERIOD_14_AMOUNT

Additional closing period where adjustments are made after June 30th.

NUMBER

13.2

CLOSING_PERIOD_15_AMOUNT

Additional closing period where adjustments are made after June 30th.

NUMBER

13.2

CLOSING_PERIOD_16_AMOUNT

Additional closing period where adjustments are made after June 30th.

NUMBER

13.2

COST_COLLECTOR_FY_KEY

Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in.

VARCHAR2

12

COST_COLLECTOR_ID_WITH_TYPE

Contains the first digit of the Cost Collector Type Code and the seven digit Cost Collector ID.

VARCHAR2

8

COST_COLLECTOR_KEY

Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

12

CUMULATIVE_AMOUNT

The total actual dollar amount charged since the inception of the cost collector, G/L account or Profit Center.

NUMBER

13.2

DECEMBER_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

DECEMBER_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

DECEMBER_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

FEBRUARY_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

FEBRUARY_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

FEBRUARY_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

FISCAL_YEAR

The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998)

VARCHAR2

4

FISCAL_YEAR_BUDGET

The Institute budget for a particular fiscal year (July 1 through June 30).

NUMBER

22

FISCAL_YEAR_DEPT_BUDGET

The department-specified budget for the fiscal period to date.

NUMBER

22

FYTD_AMOUNT

The total dollar amount charged for the fiscal year to date.

NUMBER

13.2

FY_COMMITMENT_AMOUNT

The total of open commitments with Expected Debit Date falling in the given Fiscal Year.

NUMBER

13

GL_ACCOUNT_KEY

Key used to join the GL_ACCOUNT to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting.

VARCHAR2

10

JANUARY_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

JANUARY_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

JANUARY_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

JULY_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

JULY_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

JULY_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

JUNE_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

JUNE_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

JUNE_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

MARCH_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

MARCH_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

MARCH_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

MAY_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

MAY_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

MAY_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

NOVEMBER_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

NOVEMBER_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

NOVEMBER_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

OCTOBER_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

OCTOBER_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

OCTOBER_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

PREV_YEAR_CUM_AMOUNT

The total actual dollar amount charged since the inception of the cost collector, G/L account or Profit Center for the previous fiscal year.

NUMBER

13.2

RECORD_COUNTER

Used to count records within a group on a report. Always contains a value of 1.

NUMBER

1

SEPTEMBER_AMOUNT

The actual dollar amount charged in this calendar month or fiscal period for the fiscal year(s) selected.

NUMBER

13.2

SEPTEMBER_BUDGET

The Institute budget amount recorded in this calendar month for the fiscal year(s) selected. The Institue budget is currently spread evenly across period 1 through 12 of each fiscal year.

NUMBER

13.2

SEPTEMBER_DEPT_BUDGET

The Department budget amount recorded in this calendar month for the fiscal year(s) selected.

NUMBER

13.2

TOTAL_COMMITMENT_AMOUNT

The total commitment (encumbered) amount.. This amount only exists in Current Fiscal Year and includes ALL open commitments regardless of Expected Debit Date

NUMBER

13

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8