Master Project
Field Name |
Caption |
Mask |
Description |
Field Type |
MP_AC_ID |
Eden Acct Rec # |
nnnnnnnn |
Long Integer |
|
MP_ACCOUNT |
Account # |
45x |
Account # |
Text |
MP_ACTCOST |
Actual Cost To Date |
nnnnnnnn.nn |
Actual Cost To Date |
Double |
MP_AWARD |
Awarded |
-nnnnnnnnn.nn |
Amount Awarded to Contractors |
Double |
MP_BCE |
BCE Comment |
254x |
BCE Comment |
Text |
MP_BCE_CD |
BCE |
5x |
BCE |
Text |
MP_BCE_DT |
BCE Completion Date |
mm/dd/yyyy |
BCE Completion Date |
Date/Time |
MP_BCE_TY |
BCE Text |
40x |
BCE Text |
Text |
MP_BTNUM |
Transfer Budget From |
20x |
Master Project where budget is requested to be transfered from |
Text |
MP_CAT_CD |
Category |
10x |
Category |
String |
MP_CAT_TY |
Category Text |
50x |
Category Text |
String |
MP_CCMP_DT |
Contr Completion |
mm/dd/yyyy |
Contract Completion Date |
Date/Time |
MP_CEXP_DT |
Contr Expires |
mm/dd/yyyy |
Contract Expiration Date |
Date/Time |
MP_CIP2005 |
CIP 2005 |
|
CIP 2005 |
Boolean |
MP_CIP2006 |
CIP 2006 |
|
CIP 2006 |
Boolean |
MP_CIP2007 |
CIP 2007 |
|
CIP 2007 |
Boolean |
MP_CIP2008 |
CIP 2008 |
|
CIP 2008 |
Boolean |
MP_CIP2009 |
CIP 2009 |
|
CIP 2009 |
Boolean |
MP_CIP2010 |
CIP 2010 |
|
CIP 2010 |
Boolean |
MP_CIP2011 |
CIP 2011 |
|
CIP 2011 |
Boolean |
MP_CIP2012 |
CIP 2012 |
|
CIP 2012 |
Boolean |
MP_CIP2013 |
CIP 2013 |
|
CIP 2013 |
Boolean |
MP_CIP2014 |
CIP 2014 |
|
CIP 2014 |
Boolean |
MP_CIP2015 |
CIP 2015 |
|
CIP 2015 |
Boolean |
MP_CIP2016 |
CIP 2016 |
|
CIP 2016 |
Boolean |
MP_CIP2017 |
CIP 2017 |
|
CIP 2017 |
Boolean |
MP_CIP2018 |
CIP 2018 |
|
CIP 2018 |
Boolean |
MP_CIP2019 |
CIP 2019 |
|
CIP 2019 |
Boolean |
MP_CIP2020 |
CIP 2020 |
|
CIP 2020 |
Boolean |
MP_CIP2021 |
CIP 2021 |
|
CIP 2021 |
Boolean |
MP_CIP2022 |
CIP 2022 |
|
CIP 2022 |
Boolean |
MP_CIP2023 |
CIP 2023 |
|
CIP 2023 |
Boolean |
MP_CIP2024 |
CIP 2024 |
|
CIP 2024 |
Boolean |
MP_CIP2025 |
CIP 2025 |
|
CIP 2025 |
Boolean |
MP_CIP2026 |
CIP 2026 |
|
CIP 2026 |
Boolean |
MP_CIP2027 |
CIP 2027 |
|
CIP 2027 |
Boolean |
MP_CIP2028 |
CIP 2028 |
|
CIP 2028 |
Boolean |
MP_CIP2029 |
CIP 2029 |
|
CIP 2029 |
Boolean |
MP_CIP2030 |
CIP 2030 |
|
CIP 2030 |
Boolean |
MP_CIP2031 |
CIP 2031 |
|
CIP 2031 |
Boolean |
MP_CIP2032 |
CIP 2032 |
|
CIP 2032 |
Boolean |
MP_CIP2033 |
CIP 2033 |
|
CIP 2033 |
Boolean |
MP_CIP2034 |
CIP 2034 |
|
CIP 2034 |
Boolean |
MP_CIP2035 |
CIP 2035 |
|
CIP 2035 |
Boolean |
MP_CIP2036 |
CIP 2036 |
|
CIP 2036 |
Boolean |
MP_CIP2037 |
CIP 2037 |
|
CIP 2037 |
Boolean |
MP_CIP2038 |
CIP 2038 |
|
CIP 2038 |
Boolean |
MP_CIP2039 |
CIP 2039 |
|
CIP 2039 |
Boolean |
MP_CIP2040 |
CIP 2040 |
|
CIP 2040 |
Boolean |
MP_CIP_FLG |
CIP Flag |
|
CIP Flag |
Boolean |
MP_CO_PCT |
Change Order Pct |
nnn.nn |
Change Order Percentage |
Double |
MP_COCOST |
Change Order Cost |
-nnnnnnnn.nn |
Change Order Cost |
Double |
MP_COM_PCT |
Completed Pct |
nnn.nn |
Completed Percentage |
Double |
MP_COMPCT1 |
Enc/Paid 1 Pct |
nnn.nn |
% Complete Encumbered versus Paid Project Type 1 |
Double |
MP_COMPCT2 |
Enc/Paid 2 Pct |
nnn.nn |
% Complete Encumbered versus Paid Project Type 2 |
Double |
MP_COMPCT3 |
Enc/Paid 3 Pct |
nnn.nn |
% Complete Encumbered versus Paid Project Type 3 |
Double |
MP_COMPCT4 |
Enc/Paid 4 Pct |
nnn.nn |
% Complete Encumbered versus Paid Project Type 4 |
Double |
MP_COMPCT5 |
Enc/Paid 5 Pct |
nnn.nn |
% Complete Encumbered versus Paid Project Type 5 |
Double |
MP_COMPLETE |
Completed Flag |
|
Completed Flag |
Boolean |
MP_CON_PCT |
Contracted Pct |
nnn.nn |
Contracted Percentage |
Double |
MP_CON2_CD |
Contractor 2 |
20x |
Contractor 2 |
Text |
MP_CON2_TY |
Contractor 2 Text |
40x |
Contractor 2 Text |
Text |
MP_CONT_CD |
Contractor |
20x |
Contractor |
Text |
MP_CONT_TY |
Contractor Text |
40x |
Contractor Text |
Text |
MP_CONTAMT |
Contr Amount |
nnnnnnnnn.nn |
Contract Amount |
Double |
MP_CONTNUM |
Contr # |
20x |
Contract Number |
Text |
MP_CPAID |
Paid - Current Year |
-nnnnnnnnn.nn |
Current Year Paid |
Double |
MP_CPRI_CD |
Council Priority |
10x |
Council Priority |
String |
MP_CPRI_TY |
Council Priority Text |
40x |
Council Priority Text |
String |
MP_CRT_BY |
Created By |
25x |
Created By |
Text |
MP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
MP_CST_DT |
Contr Start |
mm/dd/yyyy |
Contract Start Date |
Date/Time |
MP_CYFUND |
Current Funding |
-nnnnnnnnn.nn |
Current Year Funding |
Double |
MP_DB_CD |
Drainage Basin |
nnn |
Drainage Basin |
Integer |
MP_DB_TY |
Drainage Basin Text |
25x |
Drainage Basin Text |
Text |
MP_DEPT_CD |
Department |
10x |
Department |
Text |
MP_DEPT_TY |
Department Text |
50x |
Department Text |
Text |
MP_DESC |
Description |
1000x |
Description |
Text |
MP_DH_CD |
Department Head |
10x |
Department Head |
String |
MP_DH_TY |
Department Head Text |
40x |
Department Head Text |
String |
MP_DIST_CD |
District |
nnn |
District |
Integer |
MP_DIST_TY |
District Text |
25x |
District Text |
Text |
MP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
MP_EA_ID |
|
|
Long Integer |
|
MP_ENC_1 |
Encumbrance - Type 1 |
-nnnnnnnn.nn |
Total Encumbrances for Project Type 1 |
Double |
MP_ENC_2 |
Encumbrance - Type 2 |
-nnnnnnnn.nn |
Total Encumbrances for Project Type 2 |
Double |
MP_ENC_3 |
Encumbrance - Type 3 |
-nnnnnnnn.nn |
Total Encumberances for Project Type 3 |
Double |
MP_ENC_4 |
Encumbrance - Type 4 |
-nnnnnnnn.nn |
Total Encumbrances for Project Type 4 |
Double |
MP_ENC_5 |
Encumbrance - Type 5 |
-nnnnnnnn.nn |
Total Encumbrances for Project Type 5 |
Double |
MP_ENC_T |
Encumbrance |
-nnnnnnnn.nn |
Total Encumbrances for All Project Types |
Double |
MP_ENG_CD |
Engineer |
10x |
Engineer |
Text |
MP_ENG_TY |
Engineer Text |
40x |
Engineer Text |
Text |
MP_EP_ID |
|
|
Long Integer |
|
MP_EPM |
External PM |
20x |
External Project Manager |
Text |
MP_EST |
Estimated |
-nnnnnnnn.nn |
Estimated Cost |
Double |
MP_EST_1 |
Project Type 1 |
-nnnnnnnn.nn |
Project Estimate for Project Type 1 |
Double |
MP_EST_2 |
Project Type 2 |
-nnnnnnnn.nn |
Project Estimate for Project Type 2 |
Double |
MP_EST_3 |
Project Type 3 |
-nnnnnnnn.nn |
Project Estimate for Project Type 3 |
Double |
MP_EST_4 |
Project Type 4 |
-nnnnnnnn.nn |
Project Estimate for Project Type 4 |
Double |
MP_EST_5 |
Project Type 5 |
-nnnnnnnn.nn |
Project Estimate for Project Type 5 |
Double |
MP_EST_T |
Total Project Types |
-nnnnnnnn.nn |
Total Project Estimate for All Project Types |
Double |
MP_ESTCOMP |
Est Completion Date |
mm/dd/yyyy |
Estimated Completion Date |
Date/Time |
MP_FC_CD |
Fund Center |
6x |
Fund Center |
Text |
MP_FC_TY |
Fund Center Text |
60x |
Fund Center Text |
Text |
MP_FD_CD |
Fund Detail |
10x |
Fund Detail |
String |
MP_FD_TY |
Fund Detail Text |
40x |
Fund Detail Text |
String |
MP_FG_CD |
Fund Group |
10x |
Fund Group |
String |
MP_FG_TY |
Fund Group Text |
50x |
Fund Group Text |
String |
MP_FLESSA |
Excess or Short |
-nnnnnnnnn.nn |
Amount in excess or short - Funded amount less Awarded Amount |
Double |
MP_FND_1 |
Funded - Type 1 |
-nnnnnnnnn.nn |
Funded - Type 1 |
Double |
MP_FND_2 |
Funded - Type 2 |
-nnnnnnnnn.nn |
Funded - Type 2 |
Double |
MP_FND_3 |
Funded - Type 3 |
-nnnnnnnnn.nn |
Funded - Type 3 |
Double |
MP_FND_4 |
Funded - Type 4 |
-nnnnnnnnn.nn |
Funded - Type 4 |
Double |
MP_FND_5 |
Funded - Type 5 |
-nnnnnnnnn.nn |
Funded - Type 5 |
Double |
MP_FND_T |
Funded |
-nnnnnnnnn.nn |
Funded - Total |
Double |
MP_FNDCOST |
Funded Cost |
nnnnnnnn.nn |
Funded Cost |
Double |
MP_FUNC_CD |
Function |
5x |
Function |
Text |
MP_FUNC_TY |
Function Text |
40x |
Function Text |
Text |
MP_FYEAR_CD |
Fiscal Year |
nnn |
Fiscal Year |
Integer |
MP_FYEAR_TY |
Fiscal Year Text |
25x |
Fiscal Year Text |
String |
MP_ID |
Master Proj Rec # |
nnnnnnnn |
Master Project Rec # |
Long Integer |
MP_INACTV |
Inactive |
|
Inactive |
Boolean |
MP_INSP_CD |
Inspector |
20x |
Internal Inspector |
Text |
MP_INSP_TY |
Inspector Text |
40x |
Internal Inspector Text |
Text |
MP_INV_1 |
Invoiced - Type 1 |
-nnnnnnnn.nn |
Invoiced Amount Project Type 1 |
Double |
MP_INV_2 |
Invoiced - Type 2 |
-nnnnnnnn.nn |
Invoiced Amount Project Type 2 |
Double |
MP_INV_3 |
Invoiced - Type 3 |
-nnnnnnnn.nn |
Invoiced Amount Project Type 3 |
Double |
MP_INV_4 |
Invoiced - Type 4 |
-nnnnnnnn.nn |
Invoiced Amount Project Type 4 |
Double |
MP_INV_5 |
Invoiced - Type 5 |
-nnnnnnnn.nn |
Invoiced Amount Project Type 5 |
Double |
MP_INV_T |
Invoiced |
-nnnnnnnn.nn |
Total Invoiced Amount |
Double |
MP_JURI1 |
Jurisdiction 1 |
|
Jurisdiction 1 |
Boolean |
MP_JURI10 |
Jurisdiction 10 |
|
Jurisdiction 10 |
Boolean |
MP_JURI11 |
Jurisdiction 11 |
|
Jurisdiction 11 |
Boolean |
MP_JURI12 |
Jurisdiction 12 |
|
Jurisdiction 12 |
Boolean |
MP_JURI13 |
Jurisdiction 13 |
|
Jurisdiction 13 |
Boolean |
MP_JURI14 |
Jurisdiction 14 |
|
Jurisdiction 14 |
Boolean |
MP_JURI15 |
Jurisdiction 15 |
|
Jurisdiction 15 |
Boolean |
MP_JURI16 |
Jurisdiction 16 |
|
Jurisdiction 16 |
Boolean |
MP_JURI17 |
Jurisdiction 17 |
|
Jurisdiction 17 |
Boolean |
MP_JURI18 |
Jurisdiction 18 |
|
Jurisdiction 18 |
Boolean |
MP_JURI19 |
Jurisdiction 19 |
|
Jurisdiction 19 |
Boolean |
MP_JURI2 |
Jurisdiction 2 |
|
Jurisdiction 2 |
Boolean |
MP_JURI20 |
Jurisdiction 20 |
|
Jurisdiction 20 |
Boolean |
MP_JURI3 |
Jurisdiction 3 |
|
Jurisdiction 3 |
Boolean |
MP_JURI4 |
Jurisdiction 4 |
|
Jurisdiction 4 |
Boolean |
MP_JURI5 |
Jurisdiction 5 |
|
Jurisdiction 5 |
Boolean |
MP_JURI6 |
Jurisdiction 6 |
|
Jurisdiction 6 |
Boolean |
MP_JURI7 |
Jurisdiction 7 |
|
Jurisdiction 7 |
Boolean |
MP_JURI8 |
Jurisdiction 8 |
|
Jurisdiction 8 |
Boolean |
MP_JURI9 |
Jurisdiction 9 |
|
Jurisdiction 9 |
Boolean |
MP_LDESC |
Location Description |
1000x |
Location Description |
String |
MP_LOC_CD |
Location |
5x |
Location |
Text |
MP_LOC_TY |
Location Text |
40x |
Location Text |
Text |
MP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
MP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
MP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
MP_NAME |
Name |
50x |
Name |
Text |
MP_NEWPROJ |
Create Sub Projects |
30x |
List of Sub Project Users want to add |
Text |
MP_NUM |
Master Project ID |
20x |
Project ID |
Text |
MP_OWN_CD |
Owner |
10x |
Owner |
Text |
MP_OWN_TY |
Owner Text |
40x |
Owner Text |
Text |
MP_PAID_1 |
Paid - Type 1 |
-nnnnnnnn.nn |
Total Amount Paid for Project Type 1 |
Double |
MP_PAID_2 |
Paid - Type 2 |
-nnnnnnnn.nn |
Total Amount Paid for Project Type 2 |
Double |
MP_PAID_3 |
Paid - Type 3 |
-nnnnnnnn.nn |
Total Amount Paid for Project Type 3 |
Double |
MP_PAID_4 |
Paid - Type 4 |
-nnnnnnnn.nn |
Total Amount Paid for Project Type 4 |
Double |
MP_PAID_5 |
Paid - Type 5 |
-nnnnnnnn.nn |
Total Amount Paid for Project Type 5 |
Double |
MP_PAID_T |
Paid |
-nnnnnnnn.nn |
Total Amount Paid for All Project Types |
Double |
MP_PCTCOMPDATE |
Estimated Percent Completion by Date |
nnnnnnnn.nn |
Estimated Percent Completion by Date |
Double |
MP_PED_DT |
Project End Date |
mm/dd/yyyy |
Project End Date |
DateTime |
MP_PG_ID |
Program Rec # |
nnnnnnnn |
Long Integer |
|
MP_PIR_CD |
PIR |
5x |
PIR |
Text |
MP_PIR_DT |
PIR Completion Date |
mm/dd/yyyy |
PIR Completion Date |
Date/Time |
MP_PIR_TY |
PIR Text |
40x |
PIR Text |
Text |
MP_PJUST |
Project Justification |
1000x |
Project Justification |
String |
MP_PM_CD |
Internal PM |
20x |
Internal Project Manager |
Text |
MP_PM_TY |
Internal PM Text |
40x |
Internal Project Manager Text |
Text |
MP_PM2_CD |
External PM |
20x |
Internal PM 2 |
Text |
MP_PM2_TY |
External PM Text |
40x |
Internal PM 2 Text |
Text |
MP_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
MP_PPAID |
Paid - Prior Year |
-nnnnnnnnn.nn |
Prior Years Paid |
Double |
MP_PREREQ |
Prerequisite |
255x |
Prerequisite |
Text |
MP_PRIORYR |
Prior Years |
-nnnnnnnnn.nn |
Prior Years |
Double |
MP_PROJA |
Project Approved |
mm/dd/yyyy |
Project Approved Date |
Date/Time |
MP_PSD_DT |
Project Start Date |
mm/dd/yyyy |
Project Start Date |
DateTime |
MP_RANK |
Ranking |
nnn |
Ranking |
Integer |
MP_REM_1 |
Remaining - Type 1 |
-nnnnnnnn.nn |
Total Amount Remaining for Project Type 1 |
Double |
MP_REM_2 |
Remaining - Type 2 |
-nnnnnnnn.nn |
Total Amount Remaining for Project Type 2 |
Double |
MP_REM_3 |
Remaining - Type 3 |
-nnnnnnnn.nn |
Total Amount Remaining for Project Type 3 |
Double |
MP_REM_4 |
Remaining - Type 4 |
-nnnnnnnn.nn |
Total Amount Remaining for Project Type 4 |
Double |
MP_REM_5 |
Remaining - Type 5 |
-nnnnnnnn.nn |
Total Amount Remaining for Project Type 5 |
Double |
MP_REM_T |
Remaining |
-nnnnnnnn.nn |
Total Amount Remaining for All Project Types |
Double |
MP_RET_1 |
Retained - Type 1 |
-nnnnnnnn.nn |
Total Amount Retained for Project Type 1 |
Double |
MP_RET_2 |
Retained - Type 2 |
-nnnnnnnn.nn |
Total Amount Retained for Project Type 2 |
Double |
MP_RET_3 |
Retained - Type 3 |
-nnnnnnnn.nn |
Total Amount Retained for Project Type 3 |
Double |
MP_RET_4 |
Retained - Type 4 |
-nnnnnnnn.nn |
Total Amount Retained for Project Type 4 |
Double |
MP_RET_5 |
Retained - Type 5 |
-nnnnnnnn.nn |
Total Amount Retained for Project Type 5 |
Double |
MP_RET_T |
Retained |
-nnnnnnnn.nn |
Total Amount Retained for All Project Types |
Double |
MP_ROUTE |
Route |
254x |
Route |
Text |
MP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
MP_SIMPACT |
Service Impact |
1000x |
Service Impact |
String |
MP_SPRI_CD |
Staff Priority |
10x |
Staff Priority |
String |
MP_SPRI_TY |
Staff Priority Text |
40x |
Staff Priority Text |
String |
MP_STAT_CD |
Status |
nnn |
Status |
Integer |
MP_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
MP_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
MP_STAT_TY |
Status Text |
25x |
Status Text |
Text |
MP_STRT_DT |
Start Date |
mm/dd/yyyy hh:mm am |
Start Date |
DateTime |
MP_SUB_CD |
Submitted By |
10x |
Submitted By |
String |
MP_SUB_TY |
Submitted By Text |
40x |
Submitted By Text |
String |
MP_SUCCESS |
Successor |
255x |
Successor |
Text |
MP_TAMOUNT |
Transfer Amount |
-nnnnnnnnn.nn |
The amount of money that is requested to be transfered into this account |
Double |
MP_TCOMPCT |
Enc/Paid Pct |
nnn.nn |
Total % Complete Encumbered versus Paid |
Double |
MP_TEM_FLG |
Proj Template |
|
Project Template Flag |
Boolean |
MP_TYPE_CD |
Project Type |
5x |
Project Type |
Text |
MP_TYPE_TY |
Project Type Text |
40x |
Project Type Text |
Text |
MP_UFND_1 |
Unfunded - Type 1 |
-nnnnnnnnn.nn |
Unfunded - Type 1 |
Double |
MP_UFND_2 |
Unfunded - Type 2 |
-nnnnnnnnn.nn |
Unfunded - Type 2 |
Double |
MP_UFND_3 |
Unfunded - Type 3 |
-nnnnnnnnn.nn |
Unfunded - Type 3 |
Double |
MP_UFND_4 |
Unfunded - Type 4 |
-nnnnnnnnn.nn |
Unfunded - Type 4 |
Double |
MP_UFND_5 |
Unfunded - Type 5 |
-nnnnnnnnn.nn |
Unfunded - Type 5 |
Double |
MP_UFND_T |
Unfunded |
-nnnnnnnnn.nn |
Unfunded - Total |
Double |
MP_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
MP_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
MP_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
MP_USER13 |
User 13 |
|
User 13 |
Boolean |
MP_USER14 |
User 14 |
|
User 14 |
Boolean |
MP_USER15 |
User 15 |
|
User 15 |
Boolean |
MP_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
MP_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
MP_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
MP_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
MP_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
MP_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
MP_USER4 |
User 4 |
30x |
User 4 |
Text |
MP_USER5 |
User 5 |
30x |
User 5 |
Text |
MP_USER6 |
User 6 |
30x |
User 6 |
Text |
MP_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
MP_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
MP_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
MP_UTIL_CD |
Utility |
5x |
Utility |
Text |
MP_UTIL_TY |
Utility Text |
40x |
Utility Text |
Text |
MP_WP_CD |
POW |
5x |
Work Plan |
Text |
MP_WP_TY |
POW Text |
40x |
Work Plan Text |
Text |