COST COLLECTOR HISTORY Table
View exposing historical snapshots of cost collector master data by fiscal period and fiscal year, including organizational rollups, supervisor and contact references, authorization amounts, lifecycle attributes, and status indicators used for time-based reporting and financial auditability.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Name of the designated contact responsible for communications related to the cost collector. |
VARCHAR2 |
120 |
ADDRESSEE_MIT_ID |
MIT institutional identifier of the designated contact for the cost collector. |
VARCHAR2 |
36 |
ADDRESSEE_ROOM |
Office or room location associated with the designated contact. |
VARCHAR2 |
40 |
ADMIN_FLAG |
Administrative indicator used for financial processing or reporting logic. |
VARCHAR2 |
8 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized financial amount associated with the cost collector where applicable. |
NUMBER |
13,2 |
CALC_CODE |
Calculation code used for financial processing logic. |
VARCHAR2 |
4 |
COMPANY_CODE |
Financial company code associated with the cost collector snapshot. |
VARCHAR2 |
16 |
COSTING_SHEET_DESCRIPTION |
Description of the costing sheet procedure. |
VARCHAR2 |
120 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure used for overhead or allocation calculations. |
VARCHAR2 |
24 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the category classification of the cost collector. |
VARCHAR2 |
20 |
COST_COLLECTOR_CATEGORY_DESC |
Description of the cost collector category classification. |
VARCHAR2 |
120 |
COST_COLLECTOR_CONTINUED_FROM |
Identifier of the prior cost collector from which this record was continued. |
VARCHAR2 |
28 |
COST_COLLECTOR_CONTINUED_TO |
Identifier of the subsequent cost collector to which this record was continued. |
VARCHAR2 |
28 |
COST_COLLECTOR_COUNTER |
System-generated counter used for record versioning or internal tracking. |
NUMBER |
1 |
COST_COLLECTOR_CREATE_DATE |
Date the cost collector was created in the source system. |
DATE |
|
COST_COLLECTOR_CREATE_USER_ID |
Identifier of the user who created the cost collector record in the source system. |
VARCHAR2 |
48 |
COST_COLLECTOR_EFFECTIVE_DATE |
Date on which the cost collector became active. |
DATE |
|
COST_COLLECTOR_EXPIRATION_DATE |
Date on which the cost collector became inactive or expired. |
DATE |
|
COST_COLLECTOR_FP_KEY |
Identifier representing the cost collector snapshot for a specific fiscal period. |
VARCHAR2 |
48 |
COST_COLLECTOR_FY_KEY |
Identifier representing the cost collector snapshot aggregated at the fiscal year level. |
VARCHAR2 |
48 |
COST_COLLECTOR_ID |
Business identifier used to reference the cost collector in financial systems. |
VARCHAR2 |
28 |
COST_COLLECTOR_ID_WITH_TYPE |
Cost collector identifier combined with the cost collector type to form a composite identifier. |
VARCHAR2 |
32 |
COST_COLLECTOR_KEY |
Surrogate identifier for the cost collector record. |
VARCHAR2 |
48 |
COST_COLLECTOR_NAME |
Descriptive name of the cost collector. |
VARCHAR2 |
160 |
COST_COLLECTOR_PARENT_ID |
Identifier of the parent cost collector within the cost collector hierarchy. |
VARCHAR2 |
28 |
COST_COLLECTOR_TYPE_CODE |
Code identifying the cost collector type (e.g., cost center, internal order, project). |
VARCHAR2 |
8 |
COST_COLLECTOR_TYPE_DESC |
Description of the cost collector type. |
VARCHAR2 |
80 |
EB_ADJUSTMENT |
Description associated with EB Adjustment Key. |
VARCHAR2 |
120 |
EB_ADJUSTMENT_KEY |
IN SAP keys are used to specify particular EB, F&A, or Allocation rates to be associated with a Cost Collector. When a key is blank, MIT's standard EB or F&A rates apply, and there is no allocation. If the key is filled out, the special rates noted in the key description apply. |
VARCHAR2 |
24 |
FISCAL_PERIOD |
Fiscal period associated with the cost collector snapshot record. |
VARCHAR2 |
24 |
FISCAL_YEAR |
Fiscal year associated with the cost collector snapshot record. |
VARCHAR2 |
16 |
FS_CODE |
Financial statement classification code associated with the cost collector. |
VARCHAR2 |
4 |
FUND_CENTER_ID |
Business identifier of the fund center associated with the cost collector. |
VARCHAR2 |
24 |
FUND_ID |
Business identifier of the fund associated with the cost collector. |
VARCHAR2 |
28 |
FUND_KEY |
Surrogate identifier of the fund associated with the cost collector. |
VARCHAR2 |
44 |
IS_CLOSED_COST_COLLECTOR |
Indicator identifying whether the cost collector was closed at the time of the snapshot. |
VARCHAR2 |
4 |
LAB_ALLOCATION |
Description associated with Lab Allocation Key. |
VARCHAR2 |
120 |
LAB_ALLOCATION_KEY |
Code associated with a Cost Collector which points to an allocation rate which will be applied to this Cost Collector. |
VARCHAR2 |
24 |
MAIL_CODE |
Mail routing code associated with the cost collector. |
VARCHAR2 |
4 |
OH_ADJUSTMENT |
Description associated with OH Adjustment Key. |
VARCHAR2 |
120 |
OH_ADJUSTMENT_KEY |
Code associated with a Cost Collector which points to an overhead rate which will be applied to this Cost Collector. |
VARCHAR2 |
24 |
ON_OFF_CAMPUS_STATUS |
Indicator identifying whether the activity associated with the cost collector is on-campus or off-campus. |
VARCHAR2 |
40 |
ORGANIZATION_ID |
Identifier of the organization responsible for the cost collector. |
VARCHAR2 |
24 |
ORGANIZATION_NAME |
Name of the organization responsible for the cost collector. |
VARCHAR2 |
160 |
OVERRUN_FLAG |
Indicator identifying whether the cost collector was flagged as overrun at the time of the snapshot. |
VARCHAR2 |
4 |
POOL_CODE |
Code identifying the financial pool classification associated with the cost collector. |
VARCHAR2 |
4 |
PROFIT_CENTER_ID |
Business identifier of the profit center associated with the cost collector. |
VARCHAR2 |
28 |
PROFIT_CENTER_KEY |
Surrogate identifier of the profit center associated with the cost collector. |
VARCHAR2 |
44 |
PROFIT_CENTER_NAME |
Name of the profit center associated with the cost collector. |
VARCHAR2 |
160 |
RECORD_TYPE |
Code identifying the type of snapshot record stored in the history table. |
VARCHAR2 |
4 |
SECTION_CODE |
Code identifying the financial section classification associated with the cost collector. |
VARCHAR2 |
12 |
SECTION_NAME |
Description of the financial section classification associated with the cost collector. |
VARCHAR2 |
240 |
SUPERVISOR |
Name of the individual responsible for oversight of the cost collector. |
VARCHAR2 |
120 |
SUPERVISOR_MIT_ID |
MIT institutional identifier of the supervisor associated with the cost collector. |
VARCHAR2 |
36 |
SUPERVISOR_ROOM |
Office or room location associated with the supervisor. |
VARCHAR2 |
40 |
TERM_CODE |
Lifecycle status code associated with the cost collector. |
VARCHAR2 |
4 |
TERM_CODE_DESCRIPTION |
Description of the lifecycle status code associated with the cost collector. |
VARCHAR2 |
160 |
TREASURER_REPORT |
Code indicating treasurer reporting classification for the cost collector. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |