Sub Project
Field Name |
Caption |
Mask |
Description |
Field Type |
PJ_AC_ID |
Account Rec # |
nnnnnnnn |
Long Integer |
|
PJ_ACCOUNT |
Account # |
45x |
Account # |
Text |
PJ_ACTCOST |
Actual Cost To Date |
nnnnnnnn.nn |
Actual Cost To Date |
Double |
PJ_AMC |
Annual Maint Cost |
nnnnnnnn.nn |
Annual Maint Cost |
Double |
PJ_AWARD |
Awarded |
-nnnnnnnnn.nn |
Amount Awarded to Contractors |
Double |
PJ_AWR_DT |
Award Date |
mm/dd/yyyy |
Award Date |
Date/Time |
PJ_CC_DT |
Construct Compl |
mm/dd/yyyy |
Construction Completion Date |
Date/Time |
PJ_CIP |
CIP Number |
30x |
CIP Number |
Text |
PJ_CIPFY_CD |
CIP Fiscal Year |
nnn |
CIP Fiscal Year |
Integer |
PJ_CIPFY_TY |
CIP Fiscal Year Text |
25x |
CIP Fiscal Year Text |
String |
PJ_CLAS_CD |
Classification |
nnn |
Classification |
Integer |
PJ_CLAS_TY |
Classification Text |
25x |
Classification Text |
Text |
PJ_COM_PCT |
Paid/Encumbered Pct |
nnn.nn |
Completed Percentage |
Double |
PJ_COMMENT1 |
Long Note |
|
Long Note |
Memo |
PJ_COMPCT |
Enc/Paid Pct |
nnn.nn |
Enc/Paid Pct |
Double |
PJ_CON2_CD |
Contractor 2 |
20x |
Contractor 2 |
Text |
PJ_CON2_TY |
Contractor 2 Text |
40x |
Contractor 2 Text |
Text |
PJ_CONSTR |
Construction |
nnnnnnnn.nn |
Construction |
Double |
PJ_CONT_CD |
Contractor |
20x |
Contractor |
Text |
PJ_CONT_TY |
Contractor Text |
40x |
Contractor Text |
Text |
PJ_CONTNUM |
Contr # |
20x |
Contract Number |
Text |
PJ_CONTRAC |
Contract Number |
30x |
Contract Number |
Text |
PJ_CPAID |
Paid - Current Year |
-nnnnnnnnn.nn |
Current Year Paid |
Double |
PJ_CRT_BY |
Created By |
25x |
Created By |
Text |
PJ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PJ_CYFUND |
Current Funding |
-nnnnnnnnn.nn |
Current Year Funding |
Double |
PJ_DC_DT |
Design Compl |
mm/dd/yyyy |
Design Completion Date |
Date/Time |
PJ_DESC |
Description |
250x |
Description |
Text |
PJ_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
PJ_EA_ID |
Eden Account Rec # |
nnnnnnnn |
Long Integer |
|
PJ_ED |
Engineering/Design |
nnnnnnnn.nn |
Engineering/Design |
Double |
PJ_ENC |
Encumbered |
nnnnnnnn.nn |
Encumbered |
Double |
PJ_EP_ID |
Eden Project Rec # |
nnnnnnnn |
Long Integer |
|
PJ_EPM |
External PM |
20x |
External Project Manager |
Text |
PJ_EST |
Estimated |
-nnnnnnnnn.nn |
Estimated Funding Need |
Double |
PJ_ESTCOST |
Est Cost |
nnnnnnnn.nn |
Estimated Cost |
Double |
PJ_EXP |
Total Expenditure |
-nnnnnnnnn.nn |
Total Expenditure |
Double |
PJ_FLESSA |
Excess or Short |
-nnnnnnnnn.nn |
Amount in excess or short - Funded amount less Awarded Amount |
Double |
PJ_FUND_CD |
Expenditure Code |
5x |
Expenditure Code |
Text |
PJ_FUND_TY |
Expenditure Code Text |
60x |
Expenditure Code Text |
Text |
PJ_FUNDED |
Funded |
-nnnnnnnnn.nn |
Funded |
Double |
PJ_ID |
Project Rec # |
nnnnnnnn |
Project Rec # |
Long Integer |
PJ_INACTV |
Inactive |
|
Inactive |
Boolean |
PJ_INV |
Invoiced |
nnnnnnnn.nn |
Invoiced |
Double |
PJ_LAROW |
Land Acquistion/ROW |
nnnnnnnn.nn |
Land Acquistion/ROW |
Double |
PJ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PJ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PJ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PJ_MP_ID |
Master Project Rec # |
nnnnnnnn |
Long Integer |
|
PJ_MYSTART |
Maint Year Start |
nnn |
Maint Year Start |
Integer |
PJ_NAME |
Name |
50x |
Name |
Text |
PJ_NTP_DT |
Notice to Proceed |
mm/dd/yyyy |
Notice To Proceed Date |
Date/Time |
PJ_NUM |
Project ID |
20x |
Project ID |
Text |
PJ_PACT_DT |
Proj Act Compl Date |
mm/dd/yyyy |
Project Actual Completion Date |
Date/Time |
PJ_PACT_TM |
Proj Act Compl Time |
hh:mm am |
Project Actual Completion Time |
Date/Time |
PJ_PAID |
Paid |
nnnnnnnn.nn |
Paid |
Double |
PJ_PCLS_DT |
Proj Close Date |
mm/dd/yyyy |
Project Close Date |
Date/Time |
PJ_PCLS_TM |
Proj Cose Time |
hh:mm am |
Project Close Time |
Date/Time |
PJ_PCOST |
|
|
Project Cost - Used to determine amount of Grant Match |
Double |
PJ_PCTCOMP |
Est Percent Comp |
nnn.nn |
Percent Complete Est. |
Double |
PJ_PCTCOMPDATE |
Estimated Percent Completion by Date |
nnnnnnnn.nn |
Estimated Percent Completion by Date |
Double |
PJ_PDUR_CD |
Duration |
nnn |
Duration |
Integer |
PJ_PDUR_TY |
Duration Text |
25x |
Duration Text |
Text |
PJ_PEST_DT |
Proj Est Compl Date |
mm/dd/yyyy |
Project Estimated Completion Date |
Date/Time |
PJ_PEST_TM |
Proj Est Compl Time |
hh:mm am |
Project Estimated Completion Time |
Date/Time |
PJ_PM_CD |
Internal PM |
20x |
Project Manager |
Text |
PJ_PM_TY |
Internal PM Text |
40x |
Project Manager Text |
Text |
PJ_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
PJ_PPAID |
Paid - Prior Year |
-nnnnnnnnn.nn |
Prior Year Funding |
Double |
PJ_PST_DT |
Proj Start Date |
mm/dd/yyyy |
Project Start Date |
Date/Time |
PJ_PST_TM |
Proj Start Time |
hh:mm am |
Project Start Time |
Date/Time |
PJ_PTYP_CD |
Project Type |
nnn |
Project Type |
Integer |
PJ_PTYP_TY |
Project Type Text |
25x |
Project Type Text |
Text |
PJ_PYFUND |
Prior Year Funding |
-nnnnnnnnn.nn |
Current Year Funding |
Double |
PJ_REM |
Remaining |
nnnnnnnn.nn |
Remaining |
Double |
PJ_RET |
Retained |
nnnnnnnn.nn |
Retained |
Double |
PJ_RET_PCT |
Retainage Percent |
nnn.nn |
Retainage Percent |
Double |
PJ_REV |
Total Revenue |
-nnnnnnnnn.nn |
Total Revenue |
Double |
PJ_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PJ_STAT_CD |
Status |
nnn |
Status |
Integer |
PJ_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
PJ_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
PJ_STAT_TY |
Status Text |
25x |
Status Text |
Text |
PJ_STUDY |
Study Costs |
nnnnnnnn.nn |
Study Costs |
Double |
PJ_TEMPCIP |
Temp CIP Number |
30x |
Temp CIP Number |
Text |
PJ_TYPE_CD |
Project Type |
5x |
Project Type |
Text |
PJ_TYPE_TY |
Project Type Text |
40x |
Project Type Text |
Text |
PJ_UNFUND |
Unfunded |
-nnnnnnnnn.nn |
Unfunded |
Double |
PJ_USER_DT |
User Date |
mm/dd/yyyy |
User Date |
Date/Time |
PJ_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
PJ_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
PJ_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
PJ_USER13 |
User 13 |
|
User 13 |
Boolean |
PJ_USER14 |
User 14 |
|
User 14 |
Boolean |
PJ_USER15 |
User 15 |
|
User 15 |
Boolean |
PJ_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
PJ_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
PJ_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
PJ_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
PJ_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
PJ_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
PJ_USER4 |
User 4 |
30x |
User 4 |
Text |
PJ_USER5 |
User 5 |
30x |
User 5 |
Text |
PJ_USER6 |
User 6 |
30x |
User 6 |
Text |
PJ_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
PJ_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
PJ_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
PJ_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
PJ_USER16TY |
User 16 Text |
100x |
User 16 Text |
Text |
PJ_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
PJ_USER17TY |
User 17 Text |
100x |
User 17 Text |
Text |
PJ_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
PJ_USER18TY |
User 18 Text |
100x |
User 18 Text |
Text |
PJ_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
PJ_USER19TY |
User 19 Text |
100x |
User 19 Text |
Text |
PJ_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
PJ_USER20TY |
User 20 Text |
100x |
User 20 Text |
Text |
PJ_USER21CD |
User 21 |
20x |
User 21 |
Text |
PJ_USER21TY |
User 21 Text |
100x |
User 21 Text |
Text |
PJ_USER22CD |
User 22 |
20x |
User 22 |
Text |
PJ_USER22TY |
User 22 Text |
100x |
User 22 Text |
Text |
PJ_USER23CD |
User 23 |
20x |
User 23 |
Text |
PJ_USER23TY |
User 23 Text |
100x |
User 23 Text |
Text |
PJ_USER24CD |
User 24 |
20x |
User 24 |
Text |
PJ_USER24TY |
User 24 Text |
100x |
User 24 Text |
Text |
PJ_USER25CD |
User 25 |
20x |
User 25 |
Text |
PJ_USER25TY |
User 25 Text |
100x |
User 25 Text |
Text |
PJ_USER26 |
User 26 |
250x |
User 26 |
Text |
PJ_USER27 |
User 27 |
250x |
User 27 |
Text |
PJ_USER28 |
User 28 |
250x |
User 28 |
Text |
PJ_USER29 |
User 29 |
250x |
User 29 |
Text |
PJ_USER30 |
User 30 |
250x |
User 30 |
Text |
PJ_USER31 |
User 31 |
nnnnnnnn.nn |
User 31 |
Double |
PJ_USER32 |
User 32 |
nnnnnnnn.nn |
User 32 |
Double |
PJ_USER33 |
User 33 |
nnnnnnnn.nn |
User 33 |
Double |
PJ_USER34 |
User 34 |
nnnnnnnn.nn |
User 34 |
Double |
PJ_USER35 |
User 35 |
nnnnnnnn.nn |
User 35 |
Double |
PJ_USER36 |
User 36 |
mm/dd/yyyy hh:mm am |
User 36 |
DateTime |
PJ_USER37 |
User 37 |
mm/dd/yyyy hh:mm am |
User 37 |
DateTime |
PJ_USER38 |
User 38 |
mm/dd/yyyy hh:mm am |
User 38 |
DateTime |
PJ_USER39 |
User 39 |
mm/dd/yyyy hh:mm am |
User 39 |
DateTime |
PJ_USER40 |
User 40 |
mm/dd/yyyy hh:mm am |
User 40 |
DateTime |
PJ_USER41 |
User 41 |
|
User 41 |
Boolean |
PJ_USER42 |
User 42 |
|
User 42 |
Boolean |
PJ_USER43 |
User 43 |
|
User 43 |
Boolean |
PJ_USER44 |
User 44 |
|
User 44 |
Boolean |
PJ_USER45 |
User 45 |
|
User 45 |
Boolean |
PJ_USER46CD |
User 46 |
nnn |
User 46 |
Integer |
PJ_USER46TY |
User 46 Text |
100x |
User 46 Text |
Text |
PJ_USER47CD |
User 47 |
nnn |
User 47 |
Integer |
PJ_USER47TY |
User 47 Text |
100x |
User 47 Text |
Text |
PJ_USER48CD |
User 48 |
nnn |
User 48 |
Integer |
PJ_USER48TY |
User 48 Text |
100x |
User 48 Text |
Text |
PJ_USER49CD |
User 49 |
nnn |
User 49 |
Integer |
PJ_USER49TY |
User 49 Text |
100x |
User 49 Text |
Text |
PJ_USER50CD |
User 50 |
nnn |
User 50 |
Integer |
PJ_USER50TY |
User 50 Text |
100x |
User 50 Text |
Text |
PJ_USER51CD |
User 51 |
20x |
User 51 |
Text |
PJ_USER51TY |
User 51 Text |
100x |
User 51 Text |
Text |
PJ_USER52CD |
User 52 |
20x |
User 52 |
Text |
PJ_USER52TY |
User 52 Text |
100x |
User 52 Text |
Text |
PJ_USER53CD |
User 53 |
20x |
User 53 |
Text |
PJ_USER53TY |
User 53 Text |
100x |
User 53 Text |
Text |
PJ_USER54CD |
User 54 |
20x |
User 54 |
Text |
PJ_USER54TY |
User 54 Text |
100x |
User 54 Text |
Text |
PJ_USER55CD |
User 55 |
20x |
User 55 |
Text |
PJ_USER55TY |
User 55 Text |
100x |
User 55 Text |
Text |
PJ_USER56 |
User 56 |
250x |
User 56 |
Text |
PJ_USER57 |
User 57 |
250x |
User 57 |
Text |
PJ_USER58 |
User 58 |
250x |
User 58 |
Text |
PJ_USER59 |
User 59 |
250x |
User 59 |
Text |
PJ_USER60 |
User 60 |
250x |
User 60 |
Text |
PJ_USER61 |
User 61 |
nnnnnnnn.nn |
User 61 |
Double |
PJ_USER62 |
User 62 |
nnnnnnnn.nn |
User 62 |
Double |
PJ_USER63 |
User 63 |
nnnnnnnn.nn |
User 63 |
Double |
PJ_USER64 |
User 64 |
nnnnnnnn.nn |
User 64 |
Double |
PJ_USER65 |
User 65 |
nnnnnnnn.nn |
User 65 |
Double |
PJ_USER66 |
User 66 |
mm/dd/yyyy hh:mm am |
User 66 |
DateTime |
PJ_USER67 |
User 67 |
mm/dd/yyyy hh:mm am |
User 67 |
DateTime |
PJ_USER68 |
User 68 |
mm/dd/yyyy hh:mm am |
User 68 |
DateTime |
PJ_USER69 |
User 69 |
mm/dd/yyyy hh:mm am |
User 69 |
DateTime |
PJ_USER70 |
User 70 |
mm/dd/yyyy hh:mm am |
User 70 |
DateTime |
PJ_USER71 |
User 71 |
|
User 71 |
Boolean |
PJ_USER72 |
User 72 |
|
User 72 |
Boolean |
PJ_USER73 |
User 73 |
|
User 73 |
Boolean |
PJ_USER74 |
User 74 |
|
User 74 |
Boolean |
PJ_USER75 |
User 75 |
|
User 75 |
Boolean |