Work Project Management Program
Field Name |
Caption |
Mask |
Description |
Field Type |
PG_AWARD |
Awarded |
-nnnnnnnnn.nn |
Amount Awarded to Contractors |
Double |
PG_BCE |
BCE Comment |
254x |
BCE Comment |
Text |
PG_BCE_CD |
BCE |
5x |
BCE |
Text |
PG_BCE_DT |
BCE Completion Date |
mm/dd/yyyy |
BCE Completion Date |
Date/Time |
PG_BCE_TY |
BCE Text |
40x |
BCE Text |
Text |
PG_CIP2005 |
CIP 2005 |
|
CIP 2005 |
Boolean |
PG_CIP2006 |
CIP 2006 |
|
CIP 2006 |
Boolean |
PG_CIP2007 |
CIP 2007 |
|
CIP 2007 |
Boolean |
PG_CIP2008 |
CIP 2008 |
|
CIP 2008 |
Boolean |
PG_CIP2009 |
CIP 2009 |
|
CIP 2009 |
Boolean |
PG_CIP2010 |
CIP 2010 |
|
CIP 2010 |
Boolean |
PG_CIP2011 |
CIP 2011 |
|
CIP 2011 |
Boolean |
PG_CIP2012 |
CIP 2012 |
|
CIP 2012 |
Boolean |
PG_CIP2013 |
CIP 2013 |
|
CIP 2013 |
Boolean |
PG_CIP2014 |
CIP 2014 |
|
CIP 2014 |
Boolean |
PG_CIP2015 |
CIP 2015 |
|
CIP 2015 |
Boolean |
PG_CIP2016 |
CIP 2016 |
|
CIP 2016 |
Boolean |
PG_CIP2017 |
CIP 2017 |
|
CIP 2017 |
Boolean |
PG_CIP2018 |
CIP 2018 |
|
CIP 2018 |
Boolean |
PG_CIP2019 |
CIP 2019 |
|
CIP 2019 |
Boolean |
PG_CIP2020 |
CIP 2020 |
|
CIP 2020 |
Boolean |
PG_CIP2021 |
CIP 2021 |
|
CIP 2021 |
Boolean |
PG_CIP2022 |
CIP 2022 |
|
CIP 2022 |
Boolean |
PG_CIP2023 |
CIP 2023 |
|
CIP 2023 |
Boolean |
PG_CIP2024 |
CIP 2024 |
|
CIP 2024 |
Boolean |
PG_CIP2025 |
CIP 2025 |
|
CIP 2025 |
Boolean |
PG_CIP2026 |
CIP 2026 |
|
CIP 2026 |
Boolean |
PG_CIP2027 |
CIP 2027 |
|
CIP 2027 |
Boolean |
PG_CIP2028 |
CIP 2028 |
|
CIP 2028 |
Boolean |
PG_CIP2029 |
CIP 2029 |
|
CIP 2029 |
Boolean |
PG_CIP2030 |
CIP 2030 |
|
CIP 2030 |
Boolean |
PG_CIP2031 |
CIP 2031 |
|
CIP 2031 |
Boolean |
PG_CIP2032 |
CIP 2032 |
|
CIP 2032 |
Boolean |
PG_CIP2033 |
CIP 2033 |
|
CIP 2033 |
Boolean |
PG_CIP2034 |
CIP 2034 |
|
CIP 2034 |
Boolean |
PG_CIP2035 |
CIP 2035 |
|
CIP 2035 |
Boolean |
PG_CIP2036 |
CIP 2036 |
|
CIP 2036 |
Boolean |
PG_CIP2037 |
CIP 2037 |
|
CIP 2037 |
Boolean |
PG_CIP2038 |
CIP 2038 |
|
CIP 2038 |
Boolean |
PG_CIP2039 |
CIP 2039 |
|
CIP 2039 |
Boolean |
PG_CIP2040 |
CIP 2040 |
|
CIP 2040 |
Boolean |
PG_COMPCT |
Enc/Paid Pct |
nnn.nn |
Enc/Paid Pct |
Double |
PG_CPAID |
Current Year Paid |
-nnnnnnnnn.nn |
Current Year Paid |
Double |
PG_CRT_BY |
Created By |
25x |
Created By |
Text |
PG_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PG_CYFUND |
Current Funding |
-nnnnnnnnn.nn |
Current Year Funding |
Double |
PG_DEPT_CD |
Department |
10x |
Department |
Text |
PG_DEPT_TY |
Department Description |
50x |
Department Text |
Text |
PG_DESC |
Short Description |
250x |
Short Description |
Text |
PG_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
PG_ENCUMB |
Encumbered |
-nnnnnnnn.nn |
Encumbered |
Double |
PG_EST |
Estimated |
-nnnnnnnn.nn |
Estimated |
Double |
PG_FC_CD |
Fund Center |
6x |
Fund Center |
Text |
PG_FC_TY |
Fund Center Text |
60x |
Fund Center Text |
Text |
PG_FLESSA |
Excess or Short |
-nnnnnnnnn.nn |
Amount in excess or short - Funded amount less Awarded Amount |
Double |
PG_FUNDED |
Funded |
-nnnnnnnnn.nn |
Funded |
Double |
PG_FYEAR_CD |
Fiscal Year |
nnn |
Fiscal Year |
Integer |
PG_FYEAR_TY |
Fiscal Year Text |
25x |
Fiscal Year Text |
String |
PG_ID |
Program Rec # |
nnnnnnnn |
Program Rec # |
Long Integer |
PG_INACTV |
Inactive |
|
Inactive |
Boolean |
PG_INVOIC |
Invoiced |
-nnnnnnnn.nn |
Invoiced |
Double |
PG_IPM_CD |
Internal PM |
20x |
Internal Project Manager |
Text |
PG_IPM_TY |
Internal PM Text |
40x |
Internal Project Manager Text |
Text |
PG_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PG_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PG_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PG_NAME |
Program Name |
50x |
Program Name |
Text |
PG_NUM |
Program ID |
20x |
Program ID |
Text |
PG_OM |
O M Impact Desc |
254x |
O&M Impact Desc |
Text |
PG_OM_CST |
O M Impact Cost |
-nnnnnnnn.nn |
O&M Impact Cost |
Double |
PG_PAID |
Paid |
-nnnnnnnn.nn |
Paid |
Double |
PG_PIR_CD |
PIR |
5x |
PIR |
Text |
PG_PIR_DT |
PIR Completion Date |
mm/dd/yyyy |
PIR Completion Date |
Date/Time |
PG_PIR_TY |
PIR Text |
40x |
PIR Text |
Text |
PG_POW_DT |
POW Completion Date |
mm/dd/yyyy |
POW Completion Date |
Date/Time |
PG_PPAID |
Prior Years Paid |
-nnnnnnnnn.nn |
Prior Years Paid |
Double |
PG_PRIORYR |
Prior Years |
-nnnnnnnnn.nn |
Prior Years |
Double |
PG_REMAIN |
Remaining |
-nnnnnnnn.nn |
Remaining |
Double |
PG_RETAIN |
Retained |
-nnnnnnnn.nn |
Retained |
Double |
PG_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PG_STAT_CD |
Status |
nnn |
Status |
Integer |
PG_STAT_DT |
Status Date |
mm/dd/yyyy |
Status Date |
Date/Time |
PG_STAT_TM |
Status Time |
hh:mm am |
Status Time |
Date/Time |
PG_STAT_TY |
Status Text |
25x |
Status Text |
Text |
PG_UNFUND |
Unfunded |
-nnnnnnnnn.nn |
Unfunded |
Double |
PG_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
PG_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
PG_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
PG_USER13 |
User 13 |
|
User 13 |
Boolean |
PG_USER14 |
User 14 |
|
User 14 |
Boolean |
PG_USER15 |
User 15 |
|
User 15 |
Boolean |
PG_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
PG_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
PG_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
PG_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
PG_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
PG_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
PG_USER4 |
User 4 |
30x |
User 4 |
Text |
PG_USER5 |
User 5 |
30x |
User 5 |
Text |
PG_USER6 |
User 6 |
30x |
User 6 |
Text |
PG_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
PG_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
PG_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
PG_UTIL_CD |
Utility |
5x |
Utility |
Text |
PG_UTIL_TY |
Utility Text |
40x |
Utility Text |
Text |
PG_WP_CD |
POW |
5x |
Work Plan |
Text |
PG_WP_TY |
POW Text |
40x |
Work Plan Text |
Text |