Parcels Table
Field Name |
Default Caption |
Mask |
Description |
Field Type |
|
CP_AACCOUNT |
Asset Account # |
45x |
Asset Account # |
Text |
|
CP_ACT_CD |
Activity |
nnn |
Activity |
Small Integer |
|
CP_ACT_TY |
Activity Text |
100 |
Activity Text |
String |
|
CP_ADDR |
Postal Address |
255 |
Postal Address |
String |
|
CP_APNUMACT |
Asset Proj No - Acct |
40x |
Asset Proj No - Acct |
Text |
|
CP_AREA |
Area |
|
Area |
Double |
|
CP_AZONE_CD |
Alternate Zone |
10 |
Alternate Zone |
String |
|
CP_AZONE_TY |
Alternate Zone Text |
60 |
Alternate Zone Text |
String |
|
CP_BLDGARE |
Building Area |
|
Building Area |
Double |
|
CP_BLOCK |
Block Number |
10 |
Block Number |
String |
|
CP_BR_CD |
Default Category Code |
10 |
Default Category Code |
String |
|
CP_BR_TY |
Default Category Text |
60 |
Default Category Text |
String |
|
CP_BUILD |
Building Number |
50 |
Building Number |
String |
|
CP_CITY |
Postal City |
255 |
Postal City |
String |
|
CP_COMMENT1 |
Long Note |
|
Long Note |
Memo |
|
CP_COMMENT2 |
Property Description |
|
Property Description |
Memo |
|
CP_CONDO |
Condo Name |
255 |
Condo Name |
String |
|
CP_CRT_BY |
Created By |
25x |
Created By |
Text |
|
CP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
|
CP_DOC_FLG |
|
|
Doc Available: Doc Flag |
Boolean |
|
CP_DUPS |
Duplicate Section |
1 |
Duplicate Section |
String |
|
CP_DUPT |
Duplicate Township |
1 |
Duplicate Township |
String |
|
CP_ENCU_CD |
Encumbrance Type Code |
10 |
Encumbrance Type Code |
String |
|
CP_ENCU_TY |
Encumbrance Type Text |
50 |
Encumbrance Type Text |
String |
|
CP_FLOOR |
Floor Number |
nnn |
Floor Number |
Small Integer |
|
CP_FLOORC |
Floor Count |
nnn |
Floor Count |
Small Integer |
|
CP_FLORARE |
Floor Area |
|
Floor Area |
Double |
|
CP_FUNC_CD |
Function |
nnn |
Function |
Small Integer |
|
CP_FUNC_TY |
Function Text |
100 |
Function Text |
String |
|
CP_GISNEED_CD |
Needs GIS |
nnn |
Needs GIS |
Integer |
|
CP_GISNEED_TY |
Needs GIS Text |
100x |
Needs GIS Text |
Text |
|
CP_HOOD_CD |
Neighborhood Code |
10 |
Neighborhood Code |
String |
|
CP_HOOD_TY |
Neighborhood Text |
50 |
Neighborhood Text |
String |
|
CP_ID |
AutoNumber |
nnnnnnnn |
Auto ID |
Long Integer |
|
CP_INMAP |
|
|
In Map Flag |
Boolean |
|
CP_LOTU_CD |
Sub or Condo Type Code |
10 |
Sub or Condo Type Code |
String |
|
CP_LOTU_TY |
Sub or Condo Type Text |
50 |
Sub or Condo Type Text |
String |
|
CP_LSD_DT |
Legal Start Date |
mm/dd/yyyy |
Legal Start Date |
DateTime |
|
CP_LTD_CD |
Local Taxing District Code |
4 |
Local Taxing District Code |
String |
|
CP_LTD_TY |
Local Taxing District Text |
50 |
Local Taxing District Text |
String |
|
CP_LUSE_CD |
Land Use Code |
10 |
Land Use Code |
String |
|
CP_LUSE_TY |
Land Use Text |
60 |
Land Use Text |
String |
|
CP_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy |
Last WO Task Date |
DateTime |
|
CP_MOD_BY |
Last Modified By |
25x |
Last Modified By: |
Text |
|
CP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date: |
Date/Time |
|
CP_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
|
CP_MZONE_CD |
Maintenance Zone |
10 |
Maintenance Zone |
String |
|
CP_MZONE_TY |
Maintenance Zone Text |
60 |
Maintenance Zone Text |
String |
|
CP_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
|
CP_NUMBER |
Parcel Number |
40x |
Parcel Number |
Text |
|
CP_OWN1 |
Owner Name 1 |
255 |
Owner Name 1 |
String |
|
CP_OWN2 |
Owner Name 2 |
255 |
Owner Name 2 |
String |
|
CP_OWNR_CD |
Ownership |
nnn |
Ownership |
Small Integer |
|
CP_OWNR_TY |
Ownership Text |
100 |
Ownership Text |
String |
|
CP_PCLA_CD |
Property Class Code |
10 |
Property Class Code |
String |
|
CP_PCLA_TY |
Property Class Text |
60 |
Property Class Text |
String |
|
CP_PLSSID |
PLSS Identification |
16 |
PLSS Identification |
String |
|
CP_PMER_CD |
Principal Meridian Code |
10 |
Principal Meridian Code |
String |
|
CP_PMER_TY |
Principal Meridian Text |
40 |
Principal Meridian Text |
String |
|
CP_PSD_CD |
Public School District Code |
4 |
Public School District Code |
String |
|
CP_PSD_TY |
Public School District Text |
50 |
Public School District Text |
String |
|
CP_QSNUMB |
Quarter Section Number |
50 |
Quarter Section Number |
String |
|
CP_QSSUFFIX |
Quarter Section Suffix |
10 |
Quarter Section Suffix |
String |
|
CP_QSTY_CD |
Quarter Section Type Code |
10 |
Quarter Section Type Code |
String |
|
CP_QSTY_TY |
Quarter Section Type Text |
50 |
Quarter Section Type Text |
String |
|
CP_RANGEF |
Activity |
1 |
Activity |
String |
|
CP_RANGEN |
Range Number |
3 |
Range Number |
String |
|
CP_RDIR_CD |
Range Direction Code |
1 |
Range Direction Code |
String |
|
CP_RDIR_TY |
Range Direction Text |
10 |
Range Direction Text |
String |
|
CP_ROWVER |
|
mm/dd/yyyy hh:mm am |
Rowversion for optimistic locking |
TimeStamp |
|
CP_RPR_CD |
Reason Parcel Retired Code |
10 |
Reason Parcel Retired Code |
String |
|
CP_RPR_TY |
Reason Parcel Retired Text |
50 |
Reason Parcel Retired Text |
String |
|
CP_SAREA |
Stated Area |
50 |
Stated Area |
String |
|
CP_SITADDR |
Site Address |
255 |
Site Address |
String |
|
CP_SITE_CD |
Site |
nnn |
Site |
Small Integer |
|
CP_SITE_TY |
Site Text |
100 |
Site Text |
String |
|
CP_SORC_CD |
Sub or Condo Type Code |
10 |
Sub or Condo Type Code |
String |
|
CP_SORC_TY |
Sub or Condo Type Text |
50 |
Sub or Condo Type Text |
String |
|
CP_SORCNUM |
Sub or Condo Number |
10 |
Sub or Condo Number |
String |
|
CP_SRT |
Separated Right Type |
50 |
Separated Right Type |
String |
|
CP_SSNOTES |
Special Survey Notes |
50 |
Special Survey Notes |
String |
|
CP_SSNUMB |
Special Survey Number |
50 |
Special Survey Number |
String |
|
CP_SSSUFFIX |
Special Survey Suffix |
10 |
Special Survey Suffix |
String |
|
CP_SSTY_CD |
Special Survey Type Code |
10 |
Special Survey Type Code |
String |
|
CP_SSTY_TY |
Special Survey Type Text |
50 |
Special Survey Type Text |
String |
|
CP_STATE |
Postal State |
5 |
Postal State |
String |
|
CP_STRC_CD |
Structure |
nnn |
Structure |
Small Integer |
|
CP_STRC_TY |
Structure Text |
100 |
Structure Text |
String |
|
CP_STYP_CD |
Section Type Code |
10 |
Section Type Code |
String |
|
CP_STYP_TY |
Section Type Text |
50 |
Section Type Text |
String |
|
CP_TDIR_CD |
Township Direction Code |
1 |
Township Direction Code |
String |
|
CP_TDIR_TY |
Township Direction Text |
10 |
Township Direction Text |
String |
|
CP_TOWNF |
Township Fraction |
1 |
Township Fraction |
String |
|
CP_TOWNN |
Township Number |
3 |
Township Number |
String |
|
CP_TSTR_CD |
Structure Type Code |
10 |
Structure Type Code |
String |
|
CP_TSTR_TY |
Structure Type Text |
60 |
Structure Type Text |
String |
|
CP_UNIT |
Unit Number |
50 |
Unit Number |
String |
|
CP_USE_CD |
Assessors Use Code |
4 |
Assessors Use Code |
String |
|
CP_USE_TY |
Assessors Use Text |
50 |
Assessors Use Text |
String |
|
CP_USER1CD |
User 1 |
nnn |
User 1 |
Small Integer |
|
CP_USER1TY |
User 1 Text |
50 |
User 1 Text |
String |
|
CP_USER2CD |
User 2 |
nnn |
User 2 |
Small Integer |
|
CP_USER2TY |
User 2 Text |
50 |
User 2 Text |
String |
|
CP_USER3CD |
User 3 |
nnn |
User 3 |
Small Integer |
|
CP_USER3TY |
User 3 Text |
50 |
User 3 Text |
String |
|
CP_USER4CD |
User 4 |
nnn |
User 4 |
Small Integer |
|
CP_USER4TY |
User 4 Text |
50 |
User 4 Text |
String |
|
CP_USER5CD |
User 5 |
nnn |
User 5 |
Small Integer |
|
CP_USER5TY |
User 5 Text |
50 |
User 5 Text |
String |
|
CP_USER6 |
User 6 |
50 |
User 6 |
String |
|
CP_USER7 |
User 7 |
50 |
User 7 |
String |
|
CP_USER8 |
User 8 |
50 |
User 8 |
String |
|
CP_USER9 |
User 9 |
50 |
User 9 |
String |
|
CP_USER10 |
User 10 |
50 |
User 10 |
String |
|
CP_USER11 |
User 11 |
|
User 11 |
Double |
|
CP_USER12 |
User 12 |
|
User 12 |
Double |
|
CP_USER13 |
User 13 |
|
User 13 |
Double |
|
CP_USER14 |
User 14 |
|
User 14 |
Double |
|
CP_USER15 |
User 15 |
|
User 15 |
Double |
|
CP_USER16 |
User 16 |
mm/dd/yyyy |
User 16 |
DateTime |
|
CP_USER17 |
User 17 |
mm/dd/yyyy |
User 17 |
DateTime |
|
CP_USER18 |
User 18 |
mm/dd/yyyy |
User 18 |
DateTime |
|
CP_USER19 |
User 19 |
mm/dd/yyyy |
User 19 |
DateTime |
|
CP_USER20 |
User 20 |
mm/dd/yyyy |
User 20 |
DateTime |
|
CP_USER21 |
User 21 |
|
User 21 |
Boolean |
|
CP_USER22 |
User 22 |
|
User 22 |
Boolean |
|
CP_USER23 |
User 23 |
|
User 23 |
Boolean |
|
CP_USER24 |
User 24 |
|
User 24 |
Boolean |
|
CP_USER25 |
User 25 |
|
User 25 |
Boolean |
|
CP_USER26CD |
User 26 |
nnn |
User 26 |
Small Integer |
|
CP_USER26TY |
User 26 Text |
50 |
User 26 Text |
String |
|
CP_USER27CD |
User 27 |
nnn |
User 27 |
Small Integer |
|
CP_USER27TY |
User 27 Text |
50 |
User 27 Text |
String |
|
CP_USER28CD |
User 28 |
nnn |
User 28 |
Small Integer |
|
CP_USER28TY |
User 28 Text |
50 |
User 28 Text |
String |
|
CP_USER29CD |
User 29 |
nnn |
User 29 |
Small Integer |
|
CP_USER29TY |
User 29 Text |
50 |
User 29 Text |
String |
|
CP_USER30CD |
User 30 |
nnn |
User 30 |
Small Integer |
|
CP_USER30TY |
User 30 Text |
50 |
User 30 Text |
String |
|
CP_USER31 |
User 31 |
50 |
User 31 |
String |
|
CP_USER32 |
User 32 |
50 |
User 32 |
String |
|
CP_USER33 |
User 33 |
50 |
User 33 |
String |
|
CP_USER34 |
User 34 |
50 |
User 34 |
String |
|
CP_USER35 |
User 35 |
50 |
User 35 |
String |
|
CP_USER36 |
User 36 |
|
User 36 |
Double |
|
CP_USER37 |
User 37 |
|
User 37 |
Double |
|
CP_USER38 |
User 38 |
|
User 38 |
Double |
|
CP_USER39 |
User 39 |
|
User 39 |
Double |
|
CP_USER40 |
User 40 |
|
User 40 |
Double |
|
CP_USER41 |
User 41 |
mm/dd/yyyy |
User 41 |
DateTime |
|
CP_USER42 |
User 42 |
mm/dd/yyyy |
User 42 |
DateTime |
|
CP_USER43 |
User 43 |
mm/dd/yyyy |
User 43 |
DateTime |
|
CP_USER44 |
User 44 |
mm/dd/yyyy |
User 44 |
DateTime |
|
CP_USER45 |
User 45 |
mm/dd/yyyy |
User 45 |
DateTime |
|
CP_USER46 |
User 46 |
|
User 46 |
Boolean |
|
CP_USER47 |
User 47 |
|
User 47 |
Boolean |
|
CP_USER48 |
User 48 |
|
User 48 |
Boolean |
|
CP_USER49 |
User 49 |
|
User 49 |
Boolean |
|
CP_USER50 |
User 50 |
|
User 50 |
Boolean |
|
CP_USER51CD |
User 51 |
nnn |
User 51 |
Integer |
|
CP_USER51TY |
User 51 Text |
50x |
User 51 Text |
String |
|
CP_USER52CD |
User 52 |
nnn |
User 52 |
Integer |
|
CP_USER52TY |
User 52 Text |
50x |
User 52 Text |
String |
|
CP_USER53CD |
User 53 |
nnn |
User 53 |
Integer |
|
CP_USER53TY |
User 53 Text |
50x |
User 53 Text |
String |
|
CP_USER54CD |
User 54 |
nnn |
User 54 |
Integer |
|
CP_USER54TY |
User 54 Text |
50x |
User 54 Text |
String |
|
CP_USER55CD |
User 55 |
nnn |
User 55 |
Integer |
|
CP_USER55TY |
User 55 Text |
50x |
User 55 Text |
String |
|
CP_USER56CD |
User 56 |
nnn |
User 56 |
Integer |
|
CP_USER56TY |
User 56 Text |
50x |
User 56 Text |
String |
|
CP_USER57CD |
User 57 |
nnn |
User 57 |
Integer |
|
CP_USER57TY |
User 57 Text |
50x |
User 57 Text |
String |
|
CP_USER58CD |
User 58 |
nnn |
User 58 |
Integer |
|
CP_USER58TY |
User 58 Text |
50x |
User 58 Text |
String |
|
CP_USER59CD |
User 59 |
nnn |
User 59 |
Integer |
|
CP_USER59TY |
User 59 Text |
50x |
User 59 Text |
String |
|
CP_USER60CD |
User 60 Code |
nnn |
User 60 Code |
Integer |
|
CP_USER60TY |
User 60 Text |
50x |
User 60 Text |
String |
|
CP_USER61CD |
User 61 Code |
10x |
User 61 Code |
String |
|
CP_USER61TY |
User 61 Text |
60x |
User 61 Text |
String |
|
CP_USER62CD |
User 62 Code |
10x |
User 62 Code |
String |
|
CP_USER62TY |
User 62 Text |
60x |
User 62 Text |
String |
|
CP_USER63CD |
User 63 Code |
10x |
User 63 Code |
String |
|
CP_USER63TY |
User 63 Text |
60x |
User 63 Text |
String |
|
CP_USER64CD |
User 64 Code |
10x |
User 64 Code |
String |
|
CP_USER64TY |
User 64 Text |
60x |
User 64 Text |
String |
|
CP_USER65CD |
User 65 Code |
10x |
User 65 Code |
String |
|
CP_USER65TY |
User 65 Text |
60x |
User 65 Text |
String |
|
CP_USER66CD |
User 66 Code |
10x |
User 66 Code |
String |
|
CP_USER66TY |
User 66 Text |
60x |
User 66 Text |
String |
|
CP_USER67CD |
User 67 Code |
10x |
User 67 Code |
String |
|
CP_USER67TY |
User 67 Text |
60x |
User 67 Text |
String |
|
CP_USER68CD |
User 68 Code |
10x |
User 68 Code |
String |
|
CP_USER68TY |
User 68 Text |
60x |
User 68 Text |
String |
|
CP_USER69CD |
User 69 Code |
10x |
User 69 Code |
String |
|
CP_USER69TY |
User 69 Text |
60x |
User 69 Text |
String |
|
CP_USER70CD |
User 70 Code |
10x |
User 70 Code |
String |
|
CP_USER70TY |
User 70 Text |
60x |
User 70 Text |
String |
|
CP_USER71 |
User 71 |
nnnnnnnn.nn |
User 71 |
Double |
|
CP_USER72 |
User 72 |
nnnnnnnn.nn |
User 72 |
Double |
|
CP_USER73 |
User 73 |
nnnnnnnn.nn |
User 73 |
Double |
|
CP_USER74 |
User 74 |
nnnnnnnn.nn |
User 74 |
Double |
|
CP_USER75 |
User 75 |
nnnnnnnn.nn |
User 75 |
Double |
|
CP_USER76 |
User 76 |
nnnnnnnn.nn |
User 76 |
Double |
|
CP_USER77 |
User 77 |
nnnnnnnn.nn |
User 77 |
Double |
|
CP_USER78 |
User 78 |
nnnnnnnn.nn |
User 78 |
Double |
|
CP_USER79 |
User 79 |
nnnnnnnn.nn |
User 79 |
Double |
|
CP_USER80 |
User 80 |
nnnnnnnn.nn |
User 80 |
Double |
|
CP_USER81 |
User 81 |
mm/dd/yyyy hh:mm am |
User 81 |
DateTime |
|
CP_USER82 |
User 82 |
mm/dd/yyyy hh:mm am |
User 82 |
DateTime |
|
CP_USER83 |
User 83 |
mm/dd/yyyy hh:mm am |
User 83 |
DateTime |
|
CP_USER84 |
User 84 |
mm/dd/yyyy hh:mm am |
User 84 |
DateTime |
|
CP_USER85 |
User 85 |
mm/dd/yyyy hh:mm am |
User 85 |
DateTime |
|
CP_USER86 |
User 86 |
mm/dd/yyyy hh:mm am |
User 86 |
DateTime |
|
CP_USER87 |
User 87 |
mm/dd/yyyy hh:mm am |
User 87 |
DateTime |
|
CP_USER88 |
User 88 |
mm/dd/yyyy hh:mm am |
User 88 |
DateTime |
|
CP_USER89 |
User 89 |
mm/dd/yyyy hh:mm am |
User 89 |
DateTime |
|
CP_USER90 |
User 90 |
mm/dd/yyyy hh:mm am |
User 90 |
DateTime |
|
CP_USER91 |
User 91 |
|
User 91 |
Boolean |
|
CP_USER92 |
User 92 |
|
User 92 |
Boolean |
|
CP_USER93 |
User 93 |
|
User 93 |
Boolean |
|
CP_USER94 |
User 94 |
|
User 94 |
Boolean |
|
CP_USER95 |
User 95 |
|
User 95 |
Boolean |
|
CP_USER96 |
User 96 |
|
User 96 |
Boolean |
|
CP_USER97 |
User 97 |
|
User 97 |
Boolean |
|
CP_USER98 |
User 98 |
|
User 98 |
Boolean |
|
CP_USER99 |
User 99 |
|
User 99 |
Boolean |
|
CP_USER100 |
User 100 |
|
User 100 |
Boolean |
|
CP_WO_COMM |
Short WO Comment |
255 |
Short WO Comment |
String |
|
CP_X |
X |
|
X Coordinate |
Double |
|
CP_Y |
Y |
|
Y Coordinate |
Double |
|
CP_YRBUILT |
Year Built |
nnn |
Year Built |
Small Integer |
|
CP_ZCLA_CD |
Zoning Class Code |
10 |
Zoning Class Code |
String |
|
CP_ZCLA_TY |
Zoning Class Text |
60 |
Zoning Class Text |
String |
|
CP_ZIP4 |
Postal Zip +4 |
5 |
Postal Zip +4 |
String |
|
CP_ZIP5 |
Postal Zip 5 |
5 |
Postal Zip 5 |
String |
|
Related Tables
Tables that link to this table
Linking Table |
Linking Field |
Target Field |
Purpose |
PA_AD_ID |
AD_ID |
Linking table between Addresses and Parcels. |