WKBPERM

Work Building Permits

Field Name

Caption

Mask

Description

Field Type

BP_1000AMP

901 - 1000 Amp

nnnn

901 - 1000 Amp

Integer

BP_1000AMPTCST

1000 Amp Total Cost

nnnnnnnn.nn

1000 Amp Total Cost

Double

BP_1000AMPUCST

1000 Amp Unit Cost

nnnnnnnn.nn

1000 Amp Unit Cost

Double

BP_100AMP

1 - 100 Amp

nnnn

1 - 100 Amp

Integer

BP_100AMPTCST

100 Amp Total Cost

nnnnnnnn.nn

100 Amp Total Cost

Double

BP_100AMPUCST

100 Amp Unit Cost

nnnnnnnn.nn

100 Amp Unit Cost

Double

BP_200AMP

101 - 200 Amp

nnnn

101 - 200 Amp

Integer

BP_200AMPTCST

200 Amp Total Cost

nnnnnnnn.nn

200 Amp Total Cost

Double

BP_200AMPUCST

200 Amp Unit Cost

nnnnnnnn.nn

200 Amp Unit Cost

Double

BP_300AMP

201 - 300 Amp

nnnn

201 - 300 Amp

Integer

BP_300AMPTCST

300 Amp Total Cost

nnnnnnnn.nn

300 Amp Total Cost

Double

BP_300AMPUCST

300 Amp Unit Cost

nnnnnnnn.nn

300 Amp Unit Cost

Double

BP_400AMP

301 - 400 Amp

nnnn

301 - 400 Amp

Integer

BP_400AMPTCST

400 Amp Total Cost

nnnnnnnn.nn

400 Amp Total Cost

Double

BP_400AMPUCST

400 Amp Unit Cost

nnnnnnnn.nn

400 Amp Unit Cost

Double

BP_500AMP

401 - 500 Amp

nnnn

401 - 500 Amp

Integer

BP_500AMPTCST

500 Amp Total Cost

nnnnnnnn.nn

500 Amp Total Cost

Double

BP_500AMPUCST

500 Amp Unit Cost

nnnnnnnn.nn

500 Amp Unit Cost

Double

BP_600AMP

501 - 600 Amp

nnnn

501 - 600 Amp

Integer

BP_600AMPTCST

600 Amp Total Cost

nnnnnnnn.nn

600 Amp Total Cost

Double

BP_600AMPUCST

600 Amp Unit Cost

nnnnnnnn.nn

600 Amp Unit Cost

Double

BP_700AMP

601 - 700 Amp

nnnn

601 -700 Amp

Integer

BP_700AMPTCST

700 Amp Total Cost

nnnnnnnn.nn

700 Amp Total Cost

Double

BP_700AMPUCST

700 Amp Unit Cost

nnnnnnnn.nn

700 Amp Unit Cost

Double

BP_800AMP

701 - 800 Amp

nnnn

701 - 800 Amp

Integer

BP_800AMPTCST

800 Amp Total Cost

nnnnnnnn.nn

800 Amp Total Cost

Double

BP_800AMPUCST

800 Amp Unit Cost

nnnnnnnn.nn

800 Amp Unit Cost

Double

BP_900AMP

801 - 900 Amp

nnnn

801 - 900 Amp

Integer

BP_900AMPTCST

900 Amp Total Cost

nnnnnnnn.nn

900 Amp Total Cost

Double

BP_900AMPUCST

900 Amp Unit Cost

nnnnnnnn.nn

900 Amp Unit Cost

Double

BP_A_ADDRES1

Architect Address

50x

Architect/Engineer Address

Text

BP_A_ADDRES2

Architect Address 2

50x

Architect/Engineer Address 2

Text

BP_A_BUSNAME

Architect Business

50x

Architect/Engineer Business Name

Text

BP_A_CELL_PHN

Architect Cell Phone

25x

Architect/Engineer Cell Phone #

Text

BP_A_CITY

Architect City

25x

Architect/Engineer City

Text

BP_A_CONTACT

Architect Contact

30x

Architect/Engineer Contact

Text

BP_A_EMAIL

Architect Email

150x

Architect/Engineer Email

Text

BP_A_FAX_PHN

Architect Fax Phone #

25x

Architect/Engineer Fax Phone #

Text

BP_A_HM_PHN

Architect Home Phone #

25x

Architect/Engineer Home Phone #

Text

BP_A_LICNO

License Number

25x

Architect/Engineer License #

Text

BP_A_POSTAL

Architect Zip Code

15x

Architect/Engineer Zip Code

Text

BP_A_STATE

Architect State

25x

Architect/Engineer State

Text

BP_A_WK_PHN

Architect Work Phone #

25x

Architect/Engineer Work Phone #

Text

BP_ADDLAMP

Total Addl Amps

nnnn

Total Addl Amps

Integer

BP_ADDLAMPTCST

Addl Amps Total Cost

nnnnnnnn.nn

Total Addl Amps Total Cost

Double

BP_ADDLAMPUCST

Addl Amps Unit Cost

nnnnnnnn.nn

Total Addl Amps Unit Cost

Double

BP_AE_ID

Architect/Engineer

nnnnnnnn

this is the architects/engineers ID chosen from valuelookup

Long Integer

BP_AGBLDGSIZE

Ag Building Size

nnnnnnnn.

Ag Building Size

Double

BP_ASBESTOS

Asbestos Control

 

Asbestos Control

Boolean

BP_BAREA

Basement Area

nnnnnnnn.

Basement Area

Double

BP_BATHROOM

# of Bathrooms

nnnnnnnn.

# of Bathrooms

Double

BP_BCIRCUITCST

Branch Circuit Cost

nnnnnnnn.nn

Branch Circuit Cost

Double

BP_BCIRCUITS

# of Branch Circuits

nnn

# of Branch Circuits

Integer

BP_BDESC_CD

Building Description

nnnn

Building Desc

Integer

BP_BDESC_TY

Building Description Text

30x

Building Desc Text

Text

BP_BEDROOMS

# of Bedrooms

nnnn

# of Bedrooms

Integer

BP_BFD

Backflow Dev

nnnn

Backflow Device

Integer

BP_BFDTCST

Backflow Dev Total Cost

nnnnnnnn.nn

Backflow Device Total Cost

Double

BP_BFDUCST

Backflow Dev Unit Cost

nnnnnnnn.nn

Backflow Device Unit Cost

Double

BP_BLDGT_CD

Building Type

5x

Building Type

Text

BP_BLDGT_TY

Building Type Text

40x

Building Type Text

Text

BP_BLOCK

Block

5x

Block

Text

BP_BONDEXP_DT

Bond Expires

mm/dd/yyyy

Bond Expiration Date

Date/Time

BP_C_ADDRES1

Contractor Address

50x

Contractor Address

Text

BP_C_ADDRES2

Contractor Address 2

50x

Contractor Address 2

Text

BP_C_BUSNAME

Contractor Business

50x

Contractor Business Name

Text

BP_C_CELL_PHN

Contractor Cell Phone

25x

Contractor Cell Phone #

Text

BP_C_CITY

Contractor City

25x

Contractor City

Text

BP_C_CONTACT

Contractor Contact

30x

Contractor Contact

Text

BP_C_EMAIL

Contractor Email

150x

Contractor Email

Text

BP_C_FAX_PHN

Contractor Fax Phone #

25x

Contractor Fax Phone #

Text

BP_C_HM_PHN

Contractor Home Phone #

25x

Contractor Home Phone #

Text

BP_C_POSTAL

Contractor Zip Code

15x

Contractor Zip Code

Text

BP_C_STATE

Contractor State

25x

Contractor State

Text

BP_C_WK_PHN

Contractor Work Phone #

25x

Contractor Work Phone #

Text

BP_CARPORT

Carport Size

nnnnnn

Carport Size

Long Integer

BP_CBATHTUB

C Bath tub

nnnn

Commercial Bath tub

Integer

BP_CBATHTUBTCST

C Bath tub Total Cost

nnnnnnnn.nn

Commercial Bath tub Total Cost

Double

BP_CBATHTUBUCST

C Bath tub Unit Cost

nnnnnnnn.nn

Commercial Bath tub Unit Cost

Double

BP_CBDESC_CD

Com Build Desc

nnnn

Commercial Building Desc

Integer

BP_CBDESC_TY

Com Build Desc Text

30x

Commercial Building Desc Text

Text

BP_CDF

C Drink Fount

nnnn

Commercial Drinking Fountain

Integer

BP_CDFTCST

C Drink Fount Total Cost

nnnnnnnn.nn

Commercial Drinking Fountain Total Cost

Double

BP_CDFUCST

C Drink Fount Unit Cost

nnnnnnnn.nn

Commercial Drinking Fountain Unit Cost

Double

BP_CDW

C Dishwasher

nnnn

Commercial Dishwasher

Integer

BP_CDWTCST

C Dishwasher Total Cost

nnnnnnnn.nn

Commercial Dishwasher Total Cost

Double

BP_CDWUCST

C Dishwasher Unit Cost

nnnnnnnn.nn

Commercial Dishwasher Unit Cost

Double

BP_CFDRAIN

C Floor Drain

nnnn

Commercial Floor Drain

Integer

BP_CFDRAINTCST

C Floor Drain Total Cost

nnnnnnnn.nn

Commercial Floor Drain Total Cost

Double

BP_CFDRAINUCST

C Floor Drain Unit Cost

nnnnnnnn.nn

Commercial Floor Drain Unit Cost

Double

BP_CKSINK

C Kitchen Sink

nnnn

Commercial Kitchen Sink

Integer

BP_CKSINKTCST

C Kitchen Sink Total Cost

nnnnnnnn.nn

Commercial Kitchen Sink Total Cost

Double

BP_CKSINKUCST

C Kitchen Sink Unit Cost

nnnnnnnn.nn

Commercial Kitchen Sink Unit Cost

Double

BP_CLAV

C Lavatory

nnnn

Commercial Lavatory

Integer

BP_CLAVTCST

C Lavatory Total Cost

nnnnnnnn.nn

Commercial Lavatory Total Cost

Double

BP_CLAVUCST

C Lavatory Unit Cost

nnnnnnnn.nn

Commercial Lavatory Unit Cost

Double

BP_CLSINK

C Laundry Sink

nnnn

Commercial Laundry Sink

Integer

BP_CLSINKTCST

C Laundry Sink Total Cost

nnnnnnnn.nn

Commercial Laundry Sink Total Cost

Double

BP_CLSINKUCST

C Laundry Sink Unit Cost

nnnnnnnn.nn

Commercial Laundry Sink Unit Cost

Double

BP_CN_ID

Contractor

nnnnnnnn

this is the contractors ID chosen from valuelookup

Long Integer

BP_CPORCH

Covered Porch Size

nnnnnn

Covered Porch Size

Long Integer

BP_CRT_BY

Created By

25x

Created By

Text

BP_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

BP_CSHOWER

C Shower

nnnn

Commercial Shower

Integer

BP_CSHOWERTCST

C Shower Total Cost

nnnnnnnn.nn

Commercial Shower Total Cost

Double

BP_CSHOWERUCST

C Shower Unit Cost

nnnnnnnn.nn

Commercial Shower Unit Cost

Double

BP_CURINAL

C Urinal

nnnn

Commercial Urinal

Integer

BP_CURINALTCST

C Urinal Total Cost

nnnnnnnn.nn

Commercial Urinal Total Cost

Double

BP_CURINALUCST

C Urinal Unit Cost

nnnnnnnn.nn

Commercial Urinal Unit Cost

Double

BP_CWC

C WC

nnnn

Commercial Water Closet

Integer

BP_CWCTCST

C WC Total Cost

nnnnnnnn.nn

Commercial Water Closet Total Cost

Double

BP_CWCUCST

C WC Unit Cost

nnnnnnnn.nn

Commercial Water Closet Unit Cost

Double

BP_CWM

C Wash Machine

nnnn

Commercial Washing Machine

Integer

BP_CWMTCST

C Wash Machine Total Cost

nnnnnnnn.nn

Commercial Washing Machine Total Cost

Double

BP_CWMUCST

C Wash Machine Unit Cost

nnnnnnnn.nn

Commercial Washing Machine Unit Cost

Double

BP_CWSOFT

C Water Soft

nnnn

Commercial Water Softener

Integer

BP_CWSOFTTCST

C Water Soft Total Cost

nnnnnnnn.nn

Commercial Water Softener Total Cost

Double

BP_CWSOFTUCST

C Water Soft Unit Cost

nnnnnnnn.nn

Commercial Water Softener Unit Cost

Double

BP_CWTRHEAT

C Water Heater

nnnn

Commercial Water Heater

Integer

BP_CWTRHEATTCST

C Water Heater Total Cost

nnnnnnnn.nn

Commercial Water Heater Total Cost

Double

BP_CWTRHEATUCST

C Water Heater Unit Cost

nnnnnnnn.nn

Commercial Water Heater Unit Cost

Double

BP_DECK

Deck Size

nnnnnn

Deck Size

Long Integer

BP_DOC_FLG

Document Available

 

Document Available

Boolean

BP_DWELLING

Dwelling Size

nnnnnn

Dwelling Size

Long Integer

BP_EAREA

Existing Area

nnnnnnnn.

Existing Area

Double

BP_ECONSTR

Existing Construction

25x

Existing Construction

Text

BP_ECTRAP

C Exist Trap

nnnn

Commercial Exist Trap

Integer

BP_ECTRAPTCST

C Exist Trap Total Cost

nnnnnnnn.nn

Commercial Exist Trap Total Cost

Double

BP_ECTRAPUCST

C Exist Trap Unit Cost

nnnnnnnn.nn

Commercial Exist Trap Unit Cost

Double

BP_EES

Exist Electrical Serv

nnn

Existing Electrical Service

Integer

BP_EESCST

Exist Elec Serv Cost

nnnnnnnn.nn

Existing Electrical Service Cost

Double

BP_EOCCUP

Existing Occupancy

25x

Existing Occupancy

Text

BP_ESTCOST

Estimated Cost

nnnnnnnn.nn

Estimated Cost

Double

BP_FAPANEL

Fire Alarm Panel

nnn

Fire Alarm Panel

Integer

BP_FAPANELCST

Fire Alarm Panel Cost

nnnnnnnn.nn

Fire Alarm Panel Cost

Double

BP_FAZONE

Fire Alarm Zone

nnn

Fire Alarm Zone

Integer

BP_FAZONECST

Fire Alarm Zone Cost

nnnnnnnn.nn

Fire Alarm Zone Cost

Double

BP_FEEDUE

Fee Due

nnnnnnnn.nn

Fee Due

Double

BP_FENCED

Site Fenced

 

Site Fenced

Boolean

BP_FOCCUP

Future Occupancy

25x

Future Occupancy

Text

BP_GARAGE

Garage Size

nnnnnn

Garage Size

Long Integer

BP_GAS

Gas Contacted

 

Gas Contacted

Boolean

BP_GASPIPE

Gas Piping

nnnn

Gas Piping

Integer

BP_GASPIPETCST

Gas Piping Total Cost

nnnnnnnn.nn

CoGas Piping Total Cost

Double

BP_GASPIPEUCST

Gas Piping Unit Cost

nnnnnnnn.nn

Gas Piping Unit Cost

Double

BP_HSIGN

Height of new Sign

nnnnnnnn.

Height of New Sign

Double

BP_ID

Building Permit Rec #

nnnnnnnn

Building Permit Rec #

Long Integer

BP_ISBY_CD

Issued By

5x

Issued By

Text

BP_ISBY_TY

Issued By Text

40x

Issued By Text

Text

BP_JS_ADR_APT

Apt./Suite

25x

Job Site Apartment/Suite

Text

BP_JS_ADR_B2

Street Post Building No

8x

Job Site Street Post Building No

Text

BP_JS_ADR_BDG

Building Address

nnnnnn

Job Site Building Number

Long Integer

BP_JS_ADR_DIR

Street Direction

2x

Job Site Street Direction

Text

BP_JS_ADR_PT

Street Prefix Type

5x

Job Site Street Prefix Type

Text

BP_JS_ADR_SFX

Street Suffix

5x

Job Site Street Suffix

Text

BP_JS_ADR_STR

Street Name

50x

Job Site Street Name

Text

BP_JS_ADR_TY

Street Type

5x

Job Site Street Type

Text

BP_JS_CITY

Job Site City

25x

Job Site City

Text

BP_JS_POSTAL

Job Site Zip Code

15x

Job Site Zip Code

Text

BP_JS_STATE

Job Site State

25x

Job Site State

Text

BP_LICEXP_DT

License Expires

mm/dd/yyyy

License Expiration Date

Date/Time

BP_LOT

Lot

5x

Lot

Text

BP_LOTSIZE

Lot Size

nnnnnnnn.

Lot Size

Double

BP_LVCC

Low Volt Control Circuit

nnn

Low Volt Control Circuit

Integer

BP_LVCCCST

Low Volt Circuit Cost

nnnnnnnn.nn

Low Volt Control Circuit Cost

Double

BP_LVCP

Low Volt Control Panel

nnn

Low Volt Control Panel

Integer

BP_LVCPCST

Low Volt Panel Cost

nnnnnnnn.nn

Low Volt Control Panel Cost

Double

BP_MHPS

Mobile Park Sewer

nnnn

Mobile Home Park Sewer Connection

Integer

BP_MHPSTCST

Mobile Sewer Total Cost

nnnnnnnn.nn

Mobile Home Park Sewer Connection Total Cost

Double

BP_MHPSUCST

Mobile Sewer Unit Cost

nnnnnnnn.nn

Mobile Home Park Sewer Connection Unit Cost

Double

BP_MLW

ML&W Contacted

 

ML&W Contacted

Boolean

BP_MOD_BY

Last Modified By

25x

Last Modified By

Text

BP_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

BP_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

BP_NAREA

New Area

nnnnnnnn.

New Area

Double

BP_NCTRAP

C New Trap

nnnn

Commercial New Trap

Integer

BP_NCTRAPTCST

C New Trap Total Cost

nnnnnnnn.nn

Commercial New Trap Total Cost

Double

BP_NCTRAPUCST

C New Trap Unit Cost

nnnnnnnn.nn

Commercial New Trap Unit Cost

Double

BP_NUMBER

Permit #

25x

Permit Number

Text

BP_O_ADDRES1

Owner Address

50x

Owner Address

Text

BP_O_ADDRES2

Owner Address 2

50x

Owner Address 2

Text

BP_O_BUSNAME

Owner Business

50x

Owner Business Name

Text

BP_O_CELL_PHN

Owner Cell Phone

25x

Owner Cell Phone #

Text

BP_O_CITY

Owner City

25x

Owner City

Text

BP_O_CONTACT

Owner Contact

30x

Owner Contact

Text

BP_O_EMAIL

Owner Email

150x

Owner Email

Text

BP_O_FAX_PHN

Owner Fax Phone #

25x

Owner Fax Phone #

Text

BP_O_HM_PHN

Owner Home Phone #

25x

Owner Home Phone #

Text

BP_O_POSTAL

Owner Zip Code

15x

Owner Zip Code

Text

BP_O_STATE

Owner State

25x

Owner State

Text

BP_O_WK_PHN

Owner Work Phone #

25x

Owner Work Phone #

Text

BP_OTHER

Other Size

nnnnnn

Other Size

Long Integer

BP_OTHERBDDESC

Other Building Descr

50x

Other Building Description

Text

BP_OTHERDESC

Other Description

50x

Other Size Description

Text

BP_OTHSIGN

Sign Other

50x

Sign Other

Text

BP_OTHSIZE

Other Size

nnnnnnnn.

Other Size

Double

BP_OTHSIZEDESC

Other Building Descr

50x

Other Building Size Description

Text

BP_PAID

Paid

nnnnnnnn.nn

Paid

Double

BP_PHONETV

Phone/TV Contacted

 

Phone/TV Contacted

Boolean

BP_PTYPE_CD

Permit Type

5x

Permit Type

Text

BP_PTYPE_TY

Permit Type Text

40x

Permit Type Text

Text

BP_RABATH

R Addtl Baths

nnnn

Residential Additional Bath

Integer

BP_RABATHTCST

R Add Bath Total Cost

nnnnnnnn.nn

Residential Additional Bath Total Cost

Double

BP_RABATHUCST

R Add Bath Unit Cost

nnnnnnnn.nn

Residential Additional Bath Unit Cost

Double

BP_RAHBATH

R Add 1/2 Bath

nnnn

Residential Additional Half Bath

Integer

BP_RAHBATHTCST

R Add 1/2 Bath Total Cost

nnnnnnnn.nn

Residential Additional Half Bath Total Cost

Double

BP_RAHBATHUCST

R Add 1/2 Bath Unit Cost

nnnnnnnn.nn

Residential Additional Half Bath Unit Cost

Double

BP_RBATH

R Bath

nnnn

Residential Bath

Integer

BP_RBATHTCST

R Bath Total Cost

nnnnnnnn.nn

Residential Bath Total Cost

Double

BP_RBATHUCST

R Bath Unit Cost

nnnnnnnn.nn

Residential Bath Unit Cost

Double

BP_RBDESC_CD

Res Building Desc

nnnn

Residential Building Desc

Integer

BP_RBDESC_TY

Res Building Desc Text

30x

Residential Building Desc Text

Text

BP_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

BP_SHEDSIZE

Shed Size

nnnnnnnn.

Shed Size

Double

BP_SIGNAREA

Area of New Sign

nnnnnnnn.

Area of New Sign

Double

BP_SIGNC_CD

Sign Class

5x

Sign Class

Text

BP_SIGNC_TY

Sign Class Text

40x

Sign Class Text

Text

BP_SPRINK

Sprinkler

nnnn

Sprinkler

Integer

BP_SPRINKTCST

Sprinkler Total Cost

nnnnnnnn.nn

Sprinkler Total Cost

Double

BP_SPRINKUCST

Sprinkler Unit Cost

nnnnnnnn.nn

Sprinkler Unit Cost

Double

BP_STAT_CD

Status

nnn

Status

Integer

BP_STAT_TY

Status Text

25x

Status Text

Text

BP_STATE

State Contacted

 

State Contacted

Boolean

BP_STORY

Number of Stories

nnn

Number of Stories

Integer

BP_SUBD_CD

Subdivision

10x

Subdivision

Text

BP_SUBD_TY

Subdivision Text

60x

Subdivision Text

Text

BP_SWC

Sewer/Water Contacted

 

Sewer/Water Contacted

Boolean

BP_TCONS_CD

Type of Construction

nnnn

Type of Construction

Integer

BP_TCONS_TY

Type of Construction Text

30x

Type of Construction Text

Text

BP_TWORK_CD

Type of Work

5x

Type of Work

Text

BP_TWORK_TY

Type of Work Text

40x

Type of Work Text

Text

BP_USER1

User 1

 

User 1

Boolean

BP_USER2

User 2

 

User 2

Boolean

BP_USER3

User 3

 

User 3

Boolean

BP_USER4

User 4

 

User 4

Boolean

BP_USER5

User 5

 

User 5

Boolean

BP_USER6

User 6

 

User 6

Boolean

BP_USER7

User 7

 

User 7

Boolean

BP_USER8

User 8

 

User 8

Boolean

BP_WSINSPCST

W/S Inspection Cost

nnnnnnnn.nn

Water/Sewer Inspection Cost

Double

BP_ZONE_CD

Zoning

5x

Zoning

Text

BP_ZONE_TY

Zoning Text

40x

Zoning Text

Text

BP_ZONING_CD

Zoning Type

5x

Zoning Type

Text

BP_ZONING_TY

Zoning Type Text

40x

Zoning Type Text

Text