MIT IS&T - MIT Data Warehouse

INTERNAL ORDER Table

View exposing internal order master data including identifiers, organizational and profit center rollups, authorization amounts, funding attributes, administrative flags, and supervisor/addressee contact attributes used for project accounting and controlling.

Field Name	Description	Data Type	Length
ADDRESSEE	Name of the addressee associated with the internal order.	VARCHAR2	30
ADDRESSEE_MIT_ID	MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.	VARCHAR2	9
ADDRESSEE_ROOM	Office location of the addressee associated with the internal order.	VARCHAR2	10
ADMIN_FLAG	Administrative flag associated with the internal order.	VARCHAR2	2
ALLOCATION_GROUP	Allocation group associated with the internal order.	VARCHAR2	30
AUTHORIZED_TOTAL_AMOUNT	Authorized total amount associated with the internal order.	NUMBER	13,2
CALC_CODE	Calculation code associated with the internal order.	VARCHAR2	1
COMPANY_CODE	Company code associated with the internal order.	VARCHAR2	4
COSTING_SHEET_DESCRIPTION	Description of the costing sheet procedure.	VARCHAR2	30
COSTING_SHEET_PROCEDURE	Procedure code for the costing sheet associated with the internal order.	VARCHAR2	6
COST_COLLECTOR_CATEGORY_CODE	Code identifying the cost collector category.	VARCHAR2	5
COST_COLLECTOR_CATEGORY_DESC	Description of the cost collector category classification.	VARCHAR2	30
COST_COLLECTOR_CURRENCY	Currency code associated with the internal order.	VARCHAR2	5
COST_COLLECTOR_KEY	Surrogate identifier for the cost collector associated with the internal order.	VARCHAR2	12
COST_SHARE	Indicator identifying whether the internal order is cost shared.	VARCHAR2	1
DCS_PROJECT_TYPE	DCS project type classification associated with the internal order.	VARCHAR2	30
EB_ADJUSTMENT	Employee benefits adjustment designation associated with the internal order.	VARCHAR2	30
EB_ADJUSTMENT_KEY	Identifier for the employee benefits adjustment associated with the internal order.	VARCHAR2	6
EXTERNAL_PROJECT_NUMBER	External project number associated with the internal order.	VARCHAR2	20
FI_CODE	Financial indicator code associated with the internal order.	VARCHAR2	1
FS_CODE	Financial statement classification code associated with the internal order.	VARCHAR2	1
FUNDING_CLASS	Funding class associated with the internal order.	VARCHAR2	3
FUND_CENTER_ID	Identifier for the fund center associated with the internal order.	VARCHAR2	6
FUND_ID	Identifier for the fund associated with the internal order.	VARCHAR2	7
FUND_RESTRICTION_LEVEL	Fund restriction level associated with the internal order.	VARCHAR2	3
FUND_UNDERRECOVERY	Fund underrecovery designation associated with the internal order.	VARCHAR2	30
INTERNAL_ORDER_CONTINUED_FROM	Identifier of the internal order from which this order was continued.	VARCHAR2	7
INTERNAL_ORDER_CONTINUED_TO	Identifier of the internal order to which this order was continued.	VARCHAR2	7
INTERNAL_ORDER_COUNTER	System-generated counter used to track record versions.	NUMBER
INTERNAL_ORDER_EFFECTIVE_DATE	Date the internal order becomes effective.	DATE
INTERNAL_ORDER_EXPIRATION_DATE	Date the internal order expires.	DATE
INTERNAL_ORDER_ID	Business identifier for the internal order defined in the source financial system.	VARCHAR2	7
INTERNAL_ORDER_NAME	Descriptive name of the internal order.	VARCHAR2	50
INTERNAL_ORDER_PARENT_ID	Identifier of the parent internal order when applicable.	VARCHAR2	7
INTERNAL_ORDER_STATUS	Status of the internal order.	VARCHAR2	10
IS_CLOSED_INTERNAL_ORDER	Indicator identifying whether the internal order is closed.	VARCHAR2	1
LAB_ALLOCATION	Lab allocation designation associated with the internal order.	VARCHAR2	30
LAB_ALLOCATION_KEY	Identifier for the lab allocation associated with the internal order.	VARCHAR2	6
MAIL_CODE	Mail code associated with the internal order.	VARCHAR2	1
OH_ADJUSTMENT	Overhead adjustment designation associated with the internal order.	VARCHAR2	30
OH_ADJUSTMENT_KEY	Identifier for the overhead adjustment associated with the internal order.	VARCHAR2	6
ON_OFF_CAMPUS_STATUS	On/off campus designation associated with the internal order.	VARCHAR2	10
ORDER_TYPE	Description of the internal order type classification.	VARCHAR2	40
ORDER_TYPE_CODE	Code identifying the internal order type.	VARCHAR2	4
ORGANIZATION_ID	Identifier for the organization associated with the internal order.	VARCHAR2	6
ORGANIZATION_NAME	Name of the organization associated with the internal order.	VARCHAR2	40
POOL_CODE	Code identifying the pool associated with the internal order.	VARCHAR2	1
POOL_UNIT	Pool unit value associated with the internal order.	NUMBER	10,4
PROFIT_CENTER_ID	Identifier for the profit center associated with the internal order.	VARCHAR2	7
PROFIT_CENTER_KEY	Surrogate identifier for the profit center associated with the internal order.	VARCHAR2	11
PROFIT_CENTER_NAME	Name of the profit center associated with the internal order.	VARCHAR2	40
SECTION_CODE	Code identifying the reporting section associated with the internal order.	VARCHAR2	3
SECTION_NAME	Name of the reporting section associated with the internal order.	VARCHAR2	60
SETTLEMENT_COST_ELEMENT	Cost element used for settlement of the internal order.	VARCHAR2	6
SUB_PLAN	Sub-plan indicator associated with the internal order.	VARCHAR2	1
SUPERVISOR	Name of the supervisor associated with the internal order.	VARCHAR2	30
SUPERVISOR_MIT_ID	MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.	VARCHAR2	9
SUPERVISOR_ROOM	Office location of the supervisor associated with the internal order.	VARCHAR2	10
TERM_CODE	Code identifying the status/term classification associated with the internal order.	VARCHAR2	1
TREASURER_REPORT	Code indicating treasurer reporting classification.	VARCHAR2	3
WAREHOUSE_LOAD_DATE	Date the record was loaded into the data warehouse.	DATE