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_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 |
100x |
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 |