Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP INVESTIGATOR DETAIL Table


XXX


Field Name

Description

Data Type

Length

DOCUMENT_TYPE_ID

2 characters which are used to identify the type of document (Example: A1 - Alumni Credit Memo, AA - Asset Posting, DA - Customer Document, AB - Accounting Document, etc.?)

VARCHAR2

3

FULL_NAME

The full name of the person.

VARCHAR2

90

NON_MIT_ORG_NAME

XXX

VARCHAR2

50

NON_MIT_TITLE

XXX

VARCHAR2

30

OSP_INVESTIGATOR_KEY

XXX

VARCHAR2

12

OSP_PROPOSAL_KEY

XXX

VARCHAR2

8

OSP_UNIT_KEY

XXX

VARCHAR2

8

PROFIT_CENTER_KEY

Key used to join the Profit Center 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

11