PROJECT HISTORY Table
View exposing project history records including project identifiers, status attributes, and historical project accounting details used for reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Addressee associated with the record. |
VARCHAR2 |
30 |
ADDRESSEE_ROOM |
Addressee room associated with the record. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Indicator identifying whether admin (Y/N). |
VARCHAR2 |
2 |
AGREEMENT_TYPE |
Agreement type associated with the record. |
VARCHAR2 |
2 |
AGREEMENT_TYPE_DESCRIPTION |
Description of agreement type. |
VARCHAR2 |
40 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the record. |
NUMBER |
13,2 |
BILLING_TYPE |
Billing type associated with the record. |
VARCHAR2 |
30 |
CALC_CODE |
Code identifying calc. |
VARCHAR2 |
1 |
CFDANO |
Cfdano associated with the record. |
VARCHAR2 |
7 |
COMPANY_CODE |
Code identifying company. |
VARCHAR2 |
4 |
COSTING_SHEET_DESCRIPTION |
Description of costing sheet. |
VARCHAR2 |
30 |
COSTING_SHEET_PROCEDURE |
Costing sheet procedure associated with the record. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of cost collector category. |
VARCHAR2 |
30 |
COST_COLLECTOR_FP_KEY |
Surrogate key identifying the cost collector fp. |
VARCHAR2 |
12 |
COST_COLLECTOR_FY_KEY |
Surrogate key identifying the cost collector fy. |
VARCHAR2 |
12 |
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
COST_SHARE |
Cost share associated with the record. |
VARCHAR2 |
1 |
CUSTOMER_KEY |
Surrogate key identifying the customer. |
VARCHAR2 |
11 |
DFAFS |
Dfafs associated with the record. |
VARCHAR2 |
20 |
EB_ADJUSTMENT |
Eb adjustment associated with the record. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Surrogate key identifying the eb adjustment. |
VARCHAR2 |
6 |
FISCAL_PERIOD |
Fiscal period associated with the record. |
VARCHAR2 |
6 |
FISCAL_YEAR |
Fiscal year associated with the record. |
VARCHAR2 |
4 |
FI_CODE |
Code identifying fi. |
VARCHAR2 |
1 |
FS_CODE |
Code identifying fs. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Funding class associated with the record. |
VARCHAR2 |
3 |
FUND_CENTER_ID |
Business identifier for the fund center. |
VARCHAR2 |
6 |
FUND_ID |
Business identifier for the fund. |
VARCHAR2 |
7 |
GOVERNMENT_CONTRACT_NUMBER |
Government contract number associated with the record. |
VARCHAR2 |
70 |
IS_ACCOUNT_ASSIGNMENT_ELEMENT |
Indicator identifying whether account assignment element (Y/N). |
VARCHAR2 |
1 |
IS_BILLING_ELEMENT |
Indicator identifying whether billing element (Y/N). |
VARCHAR2 |
1 |
IS_CLOSED_PROJECT_WBS |
Indicator identifying whether closed project wbs (Y/N). |
VARCHAR2 |
1 |
IS_PLANNING_ELEMENT |
Indicator identifying whether planning element (Y/N). |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Lab allocation associated with the record. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Surrogate key identifying the lab allocation. |
VARCHAR2 |
6 |
MAIL_CODE |
Code identifying mail. |
VARCHAR2 |
1 |
MASTER_PROJECT_NAME |
Master project name associated with the record. |
VARCHAR2 |
160 |
MASTER_PROJECT_NUMBER |
Master project number associated with the record. |
VARCHAR2 |
7 |
OH_ADJUSTMENT |
Oh adjustment associated with the record. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Surrogate key identifying the oh adjustment. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
On off campus status associated with the record. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
40 |
OVERRUN_FLAG |
Indicator identifying whether overrun (Y/N). |
VARCHAR2 |
1 |
PENDING_CODE |
Code identifying pending. |
VARCHAR2 |
1 |
PLANNING |
Planning associated with the record. |
VARCHAR2 |
30 |
PLANNING_KEY |
Surrogate key identifying the planning. |
VARCHAR2 |
6 |
POOL_CODE |
Code identifying pool. |
VARCHAR2 |
1 |
POOL_UNIT |
Pool unit associated with the record. |
NUMBER |
10,4 |
PRIME_SPONSOR_ADMIN_ACTIVITY |
Prime sponsor admin activity associated with the record. |
VARCHAR2 |
30 |
PRIME_SPONSOR_CODE |
Code identifying prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_COUNTRY |
Prime sponsor country associated with the record. |
VARCHAR2 |
40 |
PRIME_SPONSOR_KEY |
Surrogate key identifying the prime sponsor. |
VARCHAR2 |
10 |
PRIME_SPONSOR_NAME |
Prime sponsor name associated with the record. |
VARCHAR2 |
200 |
PRIME_SPONSOR_STATE |
Prime sponsor state associated with the record. |
VARCHAR2 |
30 |
PRIME_SPONSOR_TYPE |
Prime sponsor type associated with the record. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Business identifier for the profit center. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Profit center name associated with the record. |
VARCHAR2 |
40 |
PROJECT_WBS_COUNTER |
Project wbs counter associated with the record. |
NUMBER |
|
PROJECT_WBS_CREATE_DATE |
Date associated with project wbs create. |
DATE |
|
PROJECT_WBS_CREATE_USER_ID |
Business identifier for the project wbs create user. |
VARCHAR2 |
12 |
PROJECT_WBS_EFFECTIVE_DATE |
Date associated with project wbs effective. |
DATE |
|
PROJECT_WBS_EXPIRATION_DATE |
Date associated with project wbs expiration. |
DATE |
|
PROJECT_WBS_ID |
Business identifier for the project wbs. |
VARCHAR2 |
7 |
PROJECT_WBS_NAME |
Project wbs name associated with the record. |
VARCHAR2 |
160 |
RECORD_TYPE |
Record type associated with the record. |
VARCHAR2 |
1 |
SECTION_CODE |
Code identifying section. |
VARCHAR2 |
3 |
SECTION_NAME |
Section name associated with the record. |
VARCHAR2 |
60 |
SOURCE_OF_FUNDING_FY_KEY |
Surrogate key identifying the source of funding fy. |
VARCHAR2 |
14 |
SOURCE_OF_FUNDING_KEY |
Surrogate key identifying the source of funding. |
VARCHAR2 |
10 |
SPONSOR_ADMIN_ACTIVITY |
Sponsor admin activity associated with the record. |
VARCHAR2 |
30 |
SPONSOR_CODE |
Code identifying sponsor. |
VARCHAR2 |
6 |
SPONSOR_COUNTRY |
Sponsor country associated with the record. |
VARCHAR2 |
40 |
SPONSOR_FY_KEY |
Surrogate key identifying the sponsor fy. |
VARCHAR2 |
14 |
SPONSOR_KEY |
Surrogate key identifying the sponsor. |
VARCHAR2 |
10 |
SPONSOR_NAME |
Sponsor name associated with the record. |
VARCHAR2 |
200 |
SPONSOR_STATE |
Sponsor state associated with the record. |
VARCHAR2 |
30 |
SPONSOR_TYPE |
Sponsor type associated with the record. |
VARCHAR2 |
40 |
SUB_PLAN |
Sub plan associated with the record. |
VARCHAR2 |
1 |
SUPERVISOR |
Supervisor associated with the record. |
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 |
Supervisor room associated with the record. |
VARCHAR2 |
10 |
TERM_CODE |
Term code associated with the record. |
VARCHAR2 |
1 |
TERM_CODE_DESCRIPTION |
Term code description associated with the record. |
VARCHAR2 |
40 |
TREASURER_REPORT |
Treasurer report associated with the record. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WBS_ELEMENT_CONTINUED_FROM |
Wbs element continued from associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_CONTINUED_TO |
Wbs element continued to associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_PARENT_ID |
Business identifier for the wbs element parent. |
VARCHAR2 |
7 |
WBS_TYPE |
Wbs type associated with the record. |
VARCHAR2 |
1 |