Work Permits
Field Name |
Caption |
Mask |
Description |
Field Type |
PP_ADDR |
Project Address |
75x |
Project Address |
Text |
PP_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
PP_ADR_B22 |
Street 2 Post Bldg No |
8x |
Cross Street Post Building No |
Text |
PP_ADR_BDG |
Address |
nnnnnn |
Building Number |
Long Integer |
PP_ADR_DIR |
Street Direction |
2x |
Street Direction |
Text |
PP_ADR_PT |
Street Prefix Type |
5x |
Street Prefix Type |
Text |
PP_ADR_SFX |
Street Suffix |
5x |
Street Suffix |
Text |
PP_ADR_STR |
Street Name |
50x |
Street Name |
Text |
PP_ADR_TY |
Street Type |
5x |
Street Type |
Text |
PP_ADR2_PT |
Street 2 Prefix Type |
5x |
Cross Street Prefix Type |
Text |
PP_ADRBDG2 |
Address 2 |
nnnnnn |
Cross Street Addr |
Long Integer |
PP_ADRDIR2 |
Street 2 |
2x |
Cross Street Direction |
Text |
PP_ADRSFX2 |
Street Suffix 2 |
5x |
Cross Street Suffix |
Text |
PP_ADRSTR2 |
Street Name 2 |
50x |
Cross Street Name |
Text |
PP_ADRTY2 |
Street Type 2 |
5x |
Cross Street Type |
Text |
PP_APM |
Agency PM |
75x |
Agency Project Manager |
Text |
PP_APM_CD |
Agency PM |
6x |
Agency PM |
Text |
PP_APM_TY |
Agency PM Text |
60x |
Agency PM Text |
Text |
PP_APPR_BY |
Approved By |
75x |
Permit Approved By |
Text |
PP_APPR_DT |
Approved Date |
mm/dd/yyyy |
Date Permit Approved |
Date/Time |
PP_BPHONE1 |
Provider Phone1 |
15x |
Barricade Provider Phone 1 |
Text |
PP_BPHONE2 |
Provider Phone2 |
15x |
Barricade Provider Phone 2 |
Text |
PP_BSERV |
Barricade Provider |
75x |
Barricade Provider |
Text |
PP_CADDR1 |
Con Address 1 |
75x |
Contractor Address 1 |
Text |
PP_CADDR2 |
Con Address 2 |
75x |
Contractor Address 2 |
Text |
PP_CCOMP |
Contractor |
75x |
Contractor Company |
Text |
PP_CNAME |
Contr Contact |
75x |
Contractor Contact Name |
Text |
PP_COMMENT1 |
Long Note |
|
Long Note |
Memo |
PP_CPHONE1 |
Con Phone 1 |
15x |
Contractor Phone 1 |
Text |
PP_CPHONE2 |
Con Phone 2 |
15x |
Contractor Phone 2 |
Text |
PP_CPHONE3 |
Con Phone 3 |
15x |
Contractor Phone 3 |
Text |
PP_CRT_BY |
Created By |
25x |
Created By |
Text |
PP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PP_DELIV |
Deliverer |
75x |
Deliverer of Materials or Supplies |
Text |
PP_DELV_DT |
Delivery Date |
mm/dd/yyyy |
Delivery Date |
Date/Time |
PP_DELV_TM |
Delivery Time |
hh:mm am |
Delivery Time |
Date/Time |
PP_DESC |
Description |
250x |
Description |
Text |
PP_DETOUR |
Detour Route |
250x |
Detour Route |
Text |
PP_DIV_CD |
Division |
10x |
Division |
Text |
PP_DIV_TY |
Division Text |
40x |
Division Text |
Text |
PP_DLOC |
Delivery Location |
250x |
Delivery Location |
Text |
PP_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
PP_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
PP_END_TM |
End Time |
hh:mm am |
End Time |
Date/Time |
PP_FEE |
Permit Fee |
nnnnn.nn |
Permit Fee |
Double |
PP_ID |
Permit Rec # |
nnnnnnnn |
Permit Rec ID |
Long Integer |
PP_IFREQ |
Inspection Freq |
nnn |
Inspection Freq |
Integer |
PP_IFRQ_CD |
Inspection Freq Units |
nnn |
Inspection Freq Units |
Integer |
PP_IFRQ_TY |
Inspection Freq Units Text |
10x |
Inspection Freq Units Text |
Text |
PP_INSP_DT |
Inspection Date |
mm/dd/yyyy hh:mm am |
Inspection Date |
DateTime |
PP_ISS_DT |
Date Issued |
mm/dd/yyyy |
Date Permit Issued |
Date/Time |
PP_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PP_NEXT_DT |
Next Inspection Date |
mm/dd/yyyy hh:mm am |
Next Inspection Date |
DateTime |
PP_NUM |
Permit Number |
20x |
Permit Number |
Text |
PP_PADDR1 |
Address 1 |
75x |
Permittee Address 1 |
Text |
PP_PADDR2 |
Address 2 |
75x |
Permittee Address 2 |
Text |
PP_PARCEL |
Parcel Number |
40x |
Parcel |
Text |
PP_PCOMP |
Business |
75x |
Permittee Company |
Text |
PP_PEMAIL |
Permit Email |
150x |
Permittee Email |
Text |
PP_PFIRST |
Name |
30x |
Permittee First Name |
Text |
PP_PJ_ID |
Project Record # |
nnnnnnnn |
Long Integer |
|
PP_PLAST |
Last Name |
30x |
Permittee Last Name |
Text |
PP_PMI |
M.I. |
15x |
Permittee Name Middle Initial |
Text |
PP_PMPHONE |
PM Phone |
15x |
Project Manager Phone |
Text |
PP_PNAME |
Permit Contact |
75x |
Permittee Contact Name |
Text |
PP_PPHONE1 |
Phone 1 |
15x |
Permittee Phone 1 |
Text |
PP_PPHONE2 |
Phone 2 |
15x |
Permittee Phone 2 |
Text |
PP_PPHONE3 |
Phone 3 |
15x |
Permittee Phone 3 |
Text |
PP_PROPTAG |
Property ID Tag |
20x |
Property ID |
Text |
PP_PROV_CD |
Barricade Provider |
6x |
Barricade Provider |
Text |
PP_PROV_TY |
Barricade Provider Text |
60x |
Barricade Provider Text |
Text |
PP_REASON |
Reason |
250x |
Reason |
Text |
PP_REMOV |
Remover |
75x |
Remover of Materials or Supplies |
Text |
PP_REMV_CD |
Remover |
6x |
Remover |
Text |
PP_REMV_DT |
Removal Date |
mm/dd/yyyy |
Removal Date |
Date/Time |
PP_REMV_TM |
Removal Time |
hh:mm am |
Removal Time |
Date/Time |
PP_REMV_TY |
Remover Text |
60x |
Remover Text |
Text |
PP_RES_CD |
Overall Result |
nnn |
Overall Result |
Integer |
PP_RES_TY |
Overall Result Text |
100x |
Overall Result Text |
Text |
PP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PP_RQ_ID |
Request # |
nnnnnnnn |
Long Integer |
|
PP_STAT_CD |
Status Code |
nnn |
Status Code |
Integer |
PP_STAT_TY |
Status Code Text |
25x |
Status Text |
Text |
PP_STRT_DT |
Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
PP_STRT_TM |
Start Time |
hh:mm am |
Start Time |
Date/Time |
PP_TBCOOR |
TB Coordinates |
30x |
TB Coordinates |
Text |
PP_TBPAGE |
TB Page |
30x |
TB Page |
Text |
PP_TBYEAR |
TB Year |
30x |
TB Year |
Text |
PP_TYPE_CD |
Permit Type |
10x |
Permit Type |
Text |
PP_TYPE_TY |
Permit Type Text |
40x |
Permit Type Text |
Text |
PP_USA |
USA # |
30x |
USA # |
Text |
PP_USA_DT |
USA Expired Date |
mm/dd/yyyy |
USA Expiration Date |
Date/Time |
PP_USR1_CD |
User 1 |
nnn |
User 1 |
Integer |
PP_USR1_TY |
User 1 Text |
25x |
User 1 Text |
Text |
PP_USR2_CD |
User 2 |
nnn |
User 2 |
Integer |
PP_USR2_TY |
User 2 Text |
25x |
User 2 Text |
Text |
PP_USR3_CD |
User 3 |
nnn |
User 3 |
Integer |
PP_USR3_TY |
User 3 Text |
25x |
User 3 Text |
Text |
PP_USR4_CD |
User 4 |
nnn |
User 4 |
Integer |
PP_USR4_TY |
User 4 Text |
25x |
User 4 Text |
Text |
PP_USR5_CD |
User 5 |
nnn |
User 5 |
Integer |
PP_USR5_TY |
User 5 Text |
25x |
User 5 Text |
Text |
PP_USER6 |
User 6 |
100x |
User 6 |
Text |
PP_USER7 |
User 7 |
100x |
User 7 |
Text |
PP_USER8 |
User 8 |
100x |
User 8 |
Text |
PP_USER9 |
User 9 |
100x |
User 9 |
Text |
PP_USER10 |
User 10 |
100x |
User 10 |
Text |
PP_USER11 |
User 11 |
-nnnnnnnn.nn |
User 11 |
Double |
PP_USER12 |
User 12 |
-nnnnnnnn.nn |
User 12 |
Double |
PP_USER13 |
User 13 |
-nnnnnnnn.nn |
User 13 |
Double |
PP_USER14 |
User 14 |
-nnnnnnnn.nn |
User 14 |
Double |
PP_USER15 |
User 15 |
-nnnnnnnn.nn |
User 15 |
Double |
PP_US16_DT |
User 16 |
mm/dd/yyyy |
User 16 Date |
Date/Time |
PP_US17_DT |
User 17 |
mm/dd/yyyy |
User 17 Date |
Date/Time |
PP_US18_DT |
User 18 |
mm/dd/yyyy |
User 18 Date |
Date/Time |
PP_US19_DT |
User 19 |
mm/dd/yyyy |
User 19 Date |
Date/Time |
PP_US19_TM |
User 19 Time |
hh:mm am |
User 19 Time |
Date/Time |
PP_US20_DT |
User 20 |
mm/dd/yyyy |
User 20 Date |
Date/Time |
PP_US20_TM |
User 20 Time |
hh:mm am |
User 20 Time |
Date/Time |
PP_USER21 |
User 21 |
|
User 21 |
Boolean |
PP_USER22 |
User 22 |
|
User 22 |
Boolean |
PP_USER23 |
User 23 |
|
User 23 |
Boolean |
PP_USER24 |
User 24 |
|
User 24 |
Boolean |
PP_USER25 |
User 25 |
|
User 25 |
Boolean |
PP_USER26 |
User 26 |
|
User 26 |
Boolean |
PP_USER27 |
User 27 |
|
User 27 |
Boolean |
PP_USER28 |
User 28 |
|
User 28 |
Boolean |
PP_USR30_CD |
User 30 |
nnn |
User 30 |
Integer |
PP_USR30_TY |
User 30 Text |
25x |
User 30 Text |
String |
PP_USR31_CD |
User 31 |
nnn |
User 31 |
Integer |
PP_USR31_TY |
User 31 Text |
25x |
User 31 Text |
String |
PP_USR32_CD |
User 32 |
nnn |
User 32 |
Integer |
PP_USR32_TY |
User 32 Text |
25x |
User 32 Text |
String |
PP_USR33_CD |
User 33 |
nnn |
User 33 |
Integer |
PP_USR33_TY |
User 33 Text |
25x |
User 33 Text |
String |
PP_USR34_CD |
User 34 |
nnn |
User 34 |
Integer |
PP_USR34_TY |
User 34 Text |
25x |
User 34 Text |
String |
PP_USER35 |
User 35 |
100x |
User 35 |
String |
PP_USER36 |
User 36 |
100x |
User 36 |
String |
PP_USER37 |
User 37 |
100x |
User 37 |
String |
PP_USER38 |
User 38 |
100x |
User 38 |
String |
PP_USER39 |
User 39 |
100x |
User 39 |
String |
PP_USER40 |
User 40 |
nnnnnnnn.nn |
User 40 |
Double |
PP_USER41 |
User 41 |
nnnnnnnn.nn |
User 41 |
Double |
PP_USER42 |
User 42 |
nnnnnnnn.nn |
User 42 |
Double |
PP_USER43 |
User 43 |
nnnnnnnn.nn |
User 43 |
Double |
PP_USER44 |
User 44 |
nnnnnnnn.nn |
User 44 |
Double |
PP_US45_DT |
User 45 Date |
mm/dd/yyyy hh:mm am |
User 45 Date |
DateTime |
PP_US46_DT |
User 46 Date |
mm/dd/yyyy hh:mm am |
User 46 Date |
DateTime |
PP_US47_DT |
User 47 Date |
mm/dd/yyyy hh:mm am |
User 47 Date |
DateTime |
PP_US48_DT |
User 48 Date |
mm/dd/yyyy hh:mm am |
User 48 Date |
DateTime |
PP_US48_TM |
User 48 Time |
mm/dd/yyyy hh:mm am |
User 48 Time |
DateTime |
PP_US49_DT |
User 49 Date |
mm/dd/yyyy hh:mm am |
User 49 Date |
DateTime |
PP_US49_TM |
User 49 Time |
mm/dd/yyyy hh:mm am |
User 49 Time |
DateTime |
PP_US50_DT |
User 50 Date |
mm/dd/yyyy hh:mm am |
User 50 Date |
DateTime |
PP_US50_TM |
User 50 Time |
mm/dd/yyyy hh:mm am |
User 50 Time |
DateTime |
PP_USER51 |
User 51 |
|
User 51 |
Boolean |
PP_USER52 |
User 52 |
|
User 52 |
Boolean |
PP_USER53 |
User 53 |
|
User 53 |
Boolean |
PP_USER54 |
User 54 |
|
User 54 |
Boolean |
PP_USER55 |
User 55 |
|
User 55 |
Boolean |
PP_USER56 |
User 56 |
|
User 56 |
Boolean |
PP_USER57 |
User 57 |
|
User 57 |
Boolean |
PP_USER58 |
User 58 |
|
User 58 |
Boolean |
PP_USER59 |
User 59 |
|
User 59 |
Boolean |
PP_USER60 |
User 60 |
|
User 60 |
Boolean |
PP_USR61_CD |
User 61 |
nnn |
User 61 |
Integer |
PP_USR61_TY |
User 61 Text |
50x |
User 61 Text |
String |
PP_USR62_CD |
User 62 |
nnn |
User 62 |
Integer |
PP_USR62_TY |
User 62 Text |
50x |
User 62 Text |
String |
PP_USR63_CD |
User 63 |
nnn |
User 63 |
Integer |
PP_USR63_TY |
User 63 Text |
50x |
User 63 Text |
String |
PP_USR64_CD |
User 64 |
nnn |
User 64 |
Integer |
PP_USR64_TY |
User 64 Text |
50x |
User 64 Text |
String |
PP_USR65_CD |
User 65 |
nnn |
User 65 |
Integer |
PP_USR65_TY |
User 65 Text |
50x |
User 65 Text |
String |
PP_USR66_CD |
User 66 |
nnn |
User 66 |
Integer |
PP_USR66_TY |
User 66 Text |
50x |
User 66 Text |
String |
PP_USR67_CD |
User 67 |
nnn |
User 67 |
Integer |
PP_USR67_TY |
User 67 Text |
50x |
User 67 Text |
String |
PP_USR68_CD |
User 68 |
nnn |
User 68 |
Integer |
PP_USR68_TY |
User 68 Text |
50x |
User 68 Text |
String |
PP_USR69_CD |
User 69 |
nnn |
User 69 |
Integer |
PP_USR69_TY |
User 69 Text |
50x |
User 69 Text |
String |
PP_USR70_CD |
User 70 |
nnn |
User 70 |
Integer |
PP_USR70_TY |
User 70 Text |
50x |
User 70 Text |
String |
PP_USR71_CD |
User 71 |
12x |
User 71 |
String |
PP_USR71_TY |
User 71 Text |
60x |
User 71 Text |
String |
PP_USR72_CD |
User 72 |
12x |
User 72 |
String |
PP_USR72_TY |
User 72 Text |
60x |
User 72 Text |
String |
PP_USR73_CD |
User 73 |
12x |
User 73 |
String |
PP_USR73_TY |
User 73 Text |
60x |
User 73 Text |
String |
PP_USR74_CD |
User 74 |
12x |
User 74 |
String |
PP_USR74_TY |
User 74 Text |
60x |
User 74 Text |
String |
PP_USR75_CD |
User 75 |
12x |
User 75 |
String |
PP_USR75_TY |
User 75 Text |
60x |
User 75 Text |
String |
PP_USR76_CD |
User 76 |
12x |
User 76 |
String |
PP_USR76_TY |
User 76 Text |
60x |
User 76 Text |
String |
PP_USR77_CD |
User 77 |
12x |
User 77 |
String |
PP_USR77_TY |
User 77 Text |
60x |
User 77 Text |
String |
PP_USR78_CD |
User 78 |
12x |
User 78 |
String |
PP_USR78_TY |
User 78 Text |
60x |
User 78 Text |
String |
PP_USR79_CD |
User 79 |
12x |
User 79 |
String |
PP_USR79_TY |
User 79 Text |
60x |
User 79 Text |
String |
PP_USR80_CD |
User 80 |
12x |
User 80 |
String |
PP_USR80_TY |
User 80 Text |
60x |
User 80 Text |
String |
PP_USER81 |
User 81 |
100x |
User 81 |
String |
PP_USER82 |
User 82 |
100x |
User 82 |
String |
PP_USER83 |
User 83 |
100x |
User 83 |
String |
PP_USER84 |
User 84 |
100x |
User 84 |
String |
PP_USER85 |
User 85 |
100x |
User 85 |
String |
PP_USER86 |
User 86 |
100x |
User 86 |
String |
PP_USER87 |
User 87 |
100x |
User 87 |
String |
PP_USER88 |
User 88 |
100x |
User 88 |
String |
PP_USER89 |
User 89 |
100x |
User 89 |
String |
PP_USER90 |
User 90 |
100x |
User 90 |
String |
PP_USER91 |
User 91 |
nnnnnnnn.nn |
User 91 |
Double |
PP_USER92 |
User 92 |
nnnnnnnn.nn |
User 92 |
Double |
PP_USER93 |
User 93 |
nnnnnnnn.nn |
User 93 |
Double |
PP_USER94 |
User 94 |
nnnnnnnn.nn |
User 94 |
Double |
PP_USER95 |
User 95 |
nnnnnnnn.nn |
User 95 |
Double |
PP_USER96 |
User 96 |
nnnnnnnn.nn |
User 96 |
Double |
PP_USER97 |
User 97 |
nnnnnnnn.nn |
User 97 |
Double |
PP_USER98 |
User 98 |
nnnnnnnn.nn |
User 98 |
Double |
PP_USER99 |
User 99 |
nnnnnnnn.nn |
User 99 |
Double |
PP_USER100 |
User 100 |
nnnnnnnn.nn |
User 100 |
Double |
PP_US101_DT |
User 101 Date |
mm/dd/yyyy hh:mm am |
User 101 Date |
DateTime |
PP_US102_DT |
User 102 Date |
mm/dd/yyyy hh:mm am |
User 102 Date |
DateTime |
PP_US103_DT |
User 103 Date |
mm/dd/yyyy hh:mm am |
User 103 Date |
DateTime |
PP_US104_DT |
User 104 Date |
mm/dd/yyyy hh:mm am |
User 104 Date |
DateTime |
PP_US105_DT |
User 105 Date |
mm/dd/yyyy hh:mm am |
User 105 Date |
DateTime |
PP_US106_DT |
User 106 Date |
mm/dd/yyyy hh:mm am |
User 106 Date |
DateTime |
PP_US107_DT |
User 107 Date |
mm/dd/yyyy hh:mm am |
User 107 Date |
DateTime |
PP_US108_DT |
User 108 Date |
mm/dd/yyyy hh:mm am |
User 108 Date |
DateTime |
PP_US109_DT |
User 109 Date |
mm/dd/yyyy hh:mm am |
User 109 Date |
DateTime |
PP_US110_DT |
User 110 Date |
mm/dd/yyyy hh:mm am |
User 110 Date |
DateTime |
PP_USER111 |
User 111 |
|
User 111 |
Boolean |
PP_USER112 |
User 112 |
|
User 112 |
Boolean |
PP_USER113 |
User 113 |
|
User 113 |
Boolean |
PP_USER114 |
User 114 |
|
User 114 |
Boolean |
PP_USER115 |
User 115 |
|
User 115 |
Boolean |
PP_USER116 |
User 116 |
|
User 116 |
Boolean |
PP_USER117 |
User 117 |
|
User 117 |
Boolean |
PP_USER118 |
User 118 |
|
User 118 |
Boolean |
PP_USER119 |
User 119 |
|
User 119 |
Boolean |
PP_USER120 |
User 120 |
|
User 120 |
Boolean |
PP_X |
X Coordinate |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
PP_XC_ID |
Contract Rec # - link to WKPROJC |
nnnnnnnn |
Contract Rec # - link to WKPROJC |
Long Integer |
PP_XSTR |
Cross Street |
75x |
Cross Street |
Text |
PP_Y |
Y Coordinate |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |