Data Warehouse

COMPANY_CODE

Shows to which "company" in SAP a cost collector is attached. MIT uses separate "companies" in SAP to differentiate financial transactions for different legal entities with differing business rules or reporting requirements. There are currently three company codes, "CUR" for main campus, "TECR" for MIT's alumni magazine, Technology Review, and "LCP1" for Lincoln Laboratory.

VARCHAR2

4

COST_ELEMENT_CATEGORY

Text categorizing the Cost Element (Example: Assessment Cost Element, External Settlement, Overhead Rates, Primary Cost Element, Revenue Element).

VARCHAR2

50

COST_ELEMENT_EFFECTIVE_DATE

Date the Cost Element is available for use.

DATE

8

COST_ELEMENT_EXPIRATION_DATE

The date the Cost Element expires (is no longer in use.)

DATE

8

FINANCIAL_STATEMENT_GROUP

XXX

VARCHAR2

40

FINANCIAL_STATEMENT_GROUP_CODE

XXX

VARCHAR2

4

GL_ACCOUNT_COUNTER

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

NUMBER

1

GL_ACCOUNT_ID

Identifies the GL Account.

VARCHAR2

6

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

GL_ACCOUNT_NAME

The text name associated with the GL_ACCOUNT_ID. For example: Telephone-Data Facilities, Materials and Services, and outside purchases.

VARCHAR2

20

GL_ACCOUNT_TYPE_CODE

Identifies the type of GL Account (Example: ND, LIAB, REVN, STL).

VARCHAR2

4

GL_ACCOUNT_TYPE_DESCRIPTION

Text describing the account type. For example: Asset accounts-Fixed, Asset account-Liquid, Expenses-Primary Cost Element, Fund Accounts, Liabilities, Revenue Accounts, Settlement Accounts.

VARCHAR2

30

IS_BALANCE_SHEET_ACCOUNT

Y= this is a balance sheet account. N= this is not a balance sheet account.

VARCHAR2

1

IS_BLOCKED_FOR_POSTING

Y= this GL Account is blocked and cannot be posted to. N= this GL Account is not blocked and can be posted to.

VARCHAR2

1

IS_BLOCKED_FOR_POSTING_TECR

XXX

VARCHAR2

1

IS_CLOSED_COST_ELEMENT

Y= this cost element has been closed.

VARCHAR2

1

IS_EXPENSE_ACCOUNT

Y= this is an expense account. N= this is not an expense account.

VARCHAR2

1

IS_FIXED_ASSET_ACCOUNT

Y= this is a fixed asset account. N=this is not a fixed asset account.

VARCHAR2

1

IS_FUND_ACCOUNT

Y= this is a fund account. N= this is not a fund account.

VARCHAR2

1

IS_IN_MTDC_BASE

XXX

VARCHAR2

1

IS_LIABILITY_ACCOUNT

Y= this is a liability account. N= this is not a liability account.

VARCHAR2

1

IS_LIQUID_ASSET_ACCOUNT

Y= this is a liquid asset account. N= this is not a liquid asset account.

VARCHAR2

1

IS_MARKED_FOR_DELETION

Y= this account is marked for deletion. N= this account is not marked for deletion.

VARCHAR2

1

IS_PRINCIPAL_ACCOUNT

Y= this is a principle account. N= this is not a principle account.

VARCHAR2

1

IS_PROFIT_AND_LOSS_ACCOUNT

Y= this is a profit and loss account. N= this is not a profit and loss account.

VARCHAR2

1

IS_REVENUE_ACCOUNT

Y=this is a revenue account. N=this is not a revenue account.

VARCHAR2

1

IS_SETTLEMENT_ACCOUNT

Y=this is a settlement account. N=this is not a settlement account.

VARCHAR2

1

PROFIT_CENTER

XXX

VARCHAR2

7

SECTION_CODE

A code which classifies cost collectors into sections for financial statement reporting purposes

VARCHAR2

3

SECTION_NAME

Description associated with the Section Code.

VARCHAR2

60

SUPERVISOR

The name of the person responsible for this project, cost center, internal order, or cost center.

VARCHAR2

30

SURCHARGE_BASE_PATTERN_KEY

Key used to join the GL_ACCOUNT table with SURCHARGE_PERCENTAGES and SURCHARGE_POSTINGS tables.

NUMBER

22

WAREHOUSE_LOAD_DATE

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

DATE

8