PROJECT Table
View exposing project (WBS) master data and related sponsor and billing attributes, including organizational rollups, authorization amounts, planning and billing indicators, and supervisor/addressee contact attributes used for project accounting and reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESSEE |
Name of the addressee associated with the project. |
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 project. |
VARCHAR2 |
10 |
ADMIN_FLAG |
Administrative flag associated with the project. |
VARCHAR2 |
2 |
AGREEMENT_TYPE |
Code identifying the agreement type. |
VARCHAR2 |
2 |
AGREEMENT_TYPE_DESCRIPTION |
Description of the agreement type code. |
VARCHAR2 |
40 |
AUTHORIZED_TOTAL_AMOUNT |
Authorized total amount associated with the project. |
NUMBER |
13,2 |
BILLING_FORM |
Description of the billing form. |
VARCHAR2 |
100 |
BILLING_FORM_CODE |
Code identifying the billing form. |
VARCHAR2 |
2 |
BILLING_TYPE |
Billing type associated with the project. |
VARCHAR2 |
30 |
CALC_CODE |
Calculation code associated with the project. |
VARCHAR2 |
1 |
CFDANO |
CFDA number associated with the project. |
VARCHAR2 |
7 |
COMPANY_CODE |
Company code associated with the project. |
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 project. |
VARCHAR2 |
6 |
COST_COLLECTOR_CATEGORY_CODE |
Code identifying the cost collector category. |
VARCHAR2 |
5 |
COST_COLLECTOR_CATEGORY_DESC |
Description of the cost collector category code. |
VARCHAR2 |
30 |
COST_COLLECTOR_CURRENCY |
Currency code associated with the project. |
VARCHAR2 |
5 |
COST_COLLECTOR_KEY |
Surrogate identifier for the cost collector associated with the project. |
VARCHAR2 |
12 |
COST_SHARE |
Indicator identifying whether the project is cost shared. |
VARCHAR2 |
1 |
CUSTOMER_KEY |
Identifier for the customer associated with project billing. |
VARCHAR2 |
11 |
DFAFS |
DFAFS designation associated with the project. |
VARCHAR2 |
20 |
EB_ADJUSTMENT |
Employee benefits adjustment designation associated with the project. |
VARCHAR2 |
30 |
EB_ADJUSTMENT_KEY |
Identifier for the employee benefits adjustment associated with the project. |
VARCHAR2 |
6 |
FI_CODE |
Financial indicator code associated with the project. |
VARCHAR2 |
1 |
FS_CODE |
Financial statement code associated with the project. |
VARCHAR2 |
1 |
FUNDING_CLASS |
Funding class associated with the project. |
VARCHAR2 |
3 |
FUND_CENTER_ID |
Identifier for the fund center associated with the project. |
VARCHAR2 |
6 |
FUND_CENTER_KEY |
Surrogate identifier for the fund center associated with the project. |
VARCHAR2 |
6 |
FUND_ID |
Identifier for the fund associated with the project. |
VARCHAR2 |
7 |
GOVERNMENT_CONTRACT_NUMBER |
Government contract number associated with the project. |
VARCHAR2 |
70 |
IS_ACCOUNT_ASSIGNMENT_ELEMENT |
Indicator identifying whether the WBS element is an account assignment element. |
VARCHAR2 |
1 |
IS_BILLING_ELEMENT |
Indicator identifying whether the WBS element is a billing element. |
VARCHAR2 |
1 |
IS_CLOSED_PROJECT_WBS |
Indicator identifying whether the project WBS element is closed. |
VARCHAR2 |
1 |
IS_PLANNING_ELEMENT |
Indicator identifying whether the WBS element is a planning element. |
VARCHAR2 |
1 |
LAB_ALLOCATION |
Lab allocation designation associated with the project. |
VARCHAR2 |
30 |
LAB_ALLOCATION_KEY |
Identifier for the lab allocation associated with the project. |
VARCHAR2 |
6 |
MAIL_CODE |
Mail code associated with the project. |
VARCHAR2 |
1 |
MASTER_PROJECT_EXPIRATION_DATE |
Expiration date of the master project. |
DATE |
|
MASTER_PROJECT_FINAL_EXP_DATE |
Final expiration date of the master project. |
DATE |
|
MASTER_PROJECT_NAME |
Descriptive name of the master project. |
VARCHAR2 |
40 |
MASTER_PROJECT_NUMBER |
Business identifier for the master project. |
VARCHAR2 |
7 |
OH_ADJUSTMENT |
Overhead adjustment designation associated with the project. |
VARCHAR2 |
30 |
OH_ADJUSTMENT_KEY |
Identifier for the overhead adjustment associated with the project. |
VARCHAR2 |
6 |
ON_OFF_CAMPUS_STATUS |
On/off campus status associated with the project. |
VARCHAR2 |
10 |
ORGANIZATION_ID |
Identifier for the organization associated with the project. |
VARCHAR2 |
6 |
ORGANIZATION_NAME |
Name of the organization associated with the project. |
VARCHAR2 |
40 |
OVERRUN_FLAG |
Indicator identifying whether the project is flagged as overrun. |
VARCHAR2 |
1 |
PENDING_CODE |
Pending code associated with the project. |
VARCHAR2 |
1 |
PLANNING |
Planning designation associated with the project. |
VARCHAR2 |
30 |
PLANNING_KEY |
Identifier for the planning designation associated with the project. |
VARCHAR2 |
6 |
POOL_CODE |
Code identifying the pool associated with the project. |
VARCHAR2 |
1 |
POOL_UNIT |
Pool unit value associated with the project. |
NUMBER |
10,4 |
PRIME_SPONSOR_ADMIN_ACTIVITY |
Prime sponsor administrative activity classification. |
VARCHAR2 |
30 |
PRIME_SPONSOR_CODE |
Business code identifying the prime sponsor. |
VARCHAR2 |
6 |
PRIME_SPONSOR_COUNTRY |
Prime sponsor country. |
VARCHAR2 |
40 |
PRIME_SPONSOR_KEY |
Identifier for the prime sponsor associated with the project. |
VARCHAR2 |
10 |
PRIME_SPONSOR_NAME |
Name of the prime sponsor associated with the project. |
VARCHAR2 |
200 |
PRIME_SPONSOR_STATE |
Prime sponsor state or province. |
VARCHAR2 |
30 |
PRIME_SPONSOR_TYPE |
Prime sponsor type classification. |
VARCHAR2 |
40 |
PROFIT_CENTER_ID |
Identifier for the profit center associated with the project. |
VARCHAR2 |
7 |
PROFIT_CENTER_KEY |
Surrogate identifier for the profit center associated with the project. |
VARCHAR2 |
11 |
PROFIT_CENTER_NAME |
Name of the profit center associated with the project. |
VARCHAR2 |
40 |
PROJECT_PROFILE_CODE |
Code identifying the project profile. |
VARCHAR2 |
7 |
PROJECT_PROFILE_DESC |
Description of the project profile code. |
VARCHAR2 |
40 |
PROJECT_WBS_COUNTER |
System-generated counter used to track record versions. |
NUMBER |
|
PROJECT_WBS_CREATE_DATE |
Date the project WBS element was created in the source system. |
DATE |
|
PROJECT_WBS_CREATE_USER_ID |
User identifier indicating who created the project WBS element record in the source system. |
VARCHAR2 |
12 |
PROJECT_WBS_EFFECTIVE_DATE |
Date the project WBS element becomes effective. |
DATE |
|
PROJECT_WBS_EXPIRATION_DATE |
Date the project WBS element expires. |
DATE |
|
PROJECT_WBS_FINAL_EXP_DATE |
Final expiration date of the project WBS element. |
DATE |
|
PROJECT_WBS_ID |
Business identifier for the project WBS element. |
VARCHAR2 |
7 |
PROJECT_WBS_NAME |
Descriptive name of the project WBS element. |
VARCHAR2 |
40 |
SECTION_CODE |
Code identifying the section associated with the project. |
VARCHAR2 |
3 |
SECTION_NAME |
Name of the section associated with the project. |
VARCHAR2 |
60 |
SOURCE_OF_FUNDING_KEY |
Identifier for the source of funding associated with the project. |
VARCHAR2 |
10 |
SPONSOR_ADMIN_ACTIVITY |
Sponsor administrative activity classification. |
VARCHAR2 |
30 |
SPONSOR_CODE |
Business code identifying the sponsor. |
VARCHAR2 |
6 |
SPONSOR_COUNTRY |
Sponsor country. |
VARCHAR2 |
40 |
SPONSOR_KEY |
Identifier for the sponsor associated with the project. |
VARCHAR2 |
10 |
SPONSOR_NAME |
Name of the sponsor associated with the project. |
VARCHAR2 |
200 |
SPONSOR_STATE |
Sponsor state or province. |
VARCHAR2 |
30 |
SPONSOR_TYPE |
Sponsor type classification. |
VARCHAR2 |
40 |
SUB_PLAN |
Sub-plan indicator associated with the project. |
VARCHAR2 |
1 |
SUPERVISOR |
Name of the supervisor associated with the project. |
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 project. |
VARCHAR2 |
10 |
TERM_CODE |
Code identifying the term/status associated with the project. |
VARCHAR2 |
1 |
TREASURER_REPORT |
Code indicating treasurer report grouping or handling for the project. |
VARCHAR2 |
3 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WBS_ELEMENT_CONTINUED_FROM |
Identifier of the WBS element from which this element was continued. |
VARCHAR2 |
7 |
WBS_ELEMENT_CONTINUED_TO |
Identifier of the WBS element to which this element was continued. |
VARCHAR2 |
7 |
WBS_ELEMENT_PARENT_ID |
Identifier of the parent WBS element when applicable. |
VARCHAR2 |
7 |
WBS_TYPE |
WBS type indicator. |
VARCHAR2 |
1 |