SWBLDG

Building Inspections

Field Name	Caption	Mask	Description	Field Type
BD_ADDID	Address Rec #		Link to CMADDR.AD_ID	Long Integer
BD_ADR_APT	Apartment/Suite	8x	Apartment/Suite	Text
BD_ADR_B2	Street Post Bldg No	8x	Street Post Building No	Text
BD_ADR_BDG	Address	nnnnnn	Address - Building Number	Long Integer
BD_ADR_DIR	Street Dir	2x	Street Direction	Text
BD_ADR_PT	Street Prefix Type	5x	Street Prefix Type	Text
BD_ADR_SFX	Street Suffix	5x	Street Suffix	Text
BD_ADR_STR	Street Name	50x	Street Name	Text
BD_ADR_TY	Street Type	5x	Street Type	Text
BD_BFIN_CD	Basement Finished	nnn	Basement Finished Code	Integer
BD_BFIN_TY	Basmnt Finished Text	25x	Basement Finished Text	Text
BD_BLDG_CD	Building Type	nnn	Building Type : Code	Integer
BD_BLDG_TY	Building Type Text	100x	Building Type Description	Text
BD_BLDGID	Building Rec #	nnnnnnnn	Unique ID	Long Integer
BD_BRPT_CD	Backup Reported	nnn	Backup Reported Code	Integer
BD_BRPT_TY	Backup Reported Text	25x	Backup Reported Text	Text
BD_CFR_CD	Cleaning Freq	nnn	Cleaning Frequency	Integer
BD_CFR_TY	Cleaning Freq Text	25x	Cleaning Frequency Text	Text
BD_CHEM_CD	Chemicals Used	nnn	Chemicals Used	Integer
BD_CHEM_TY	Chemicals Used Text	25x	Chemicals Used Text	Text
BD_CITY_CD	City	nnn	City	Integer
BD_CITY_TY	City Text	50x	City Text	Text
BD_CLN_CD	Cleaned By	nnn	Cleaned By	Integer
BD_CLN_DT	Last Cleaning Date	mm/dd/yyyy	Last Cleaning Date	Date/Time
BD_CLN_TY	Cleaned By Text	25x	Cleaned By Text	Text
BD_COMMENT1	Long Note		Long Note	Memo
BD_COND_CD	Overall Cond	nnn	Overall Condition	Integer
BD_COND_TY	Overall Cond Text	25x	Overall Condition Text	Text
BD_CONTACT	Contact Name	40x	Contact Name	Text
BD_CREW	Inspection Crew	30x	Inspection Crew	Text
BD_CRT_BY	Created By	25x	Created By	Text
BD_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	Date/Time
BD_DOC_FLG	Document Available		Document Available	Boolean
BD_DT_INSP			Inspection Date	Date/Time
BD_ELVS_CD	Elev of Serv Pipe	nnn	Elevation of Service Lateral Code	Integer
BD_ELVS_TY	Elv of Srv Pipe Text	25x	Elevation of Service Lateral Type	Text
BD_FLDL_CD	Flooding Source	nnn	Flooding Source Code	Integer
BD_FLDL_TY	Flooding Source Text	25x	Flooding Source Text	Text
BD_FLDR_CD	Exist Floor Drains	nnn	Existing Floor Drains Code	Integer
BD_FLDR_TY	Exist Flr Drns Text	25x	Existing Floor Drains Text	Text
BD_FND_CD	Foundation Type	nnn	Foundation Type Code	Integer
BD_FND_TY	Foundation Type Text	25x	Foundation Type Text	Text
BD_GPM	Total GPM	nnnn.nn	Total GPM	Double
BD_GPM_REM	Remaining GPM	nnnn.nn	Remaining GPM	Double
BD_IMG_FLG			Image Available	Boolean
BD_INBY_CD	Inspected By	5x	Inspected By	Text
BD_INBY_TY	Inspected By Text	30x	Inspected By Text	Text
BD_INSP_CD	Inspection Status	nnn	Inspection Status Code	Integer
BD_INSP_DT	Inspection Date	mm/dd/yyyy	Inspection Date :	Date/Time
BD_INSP_TM	Inspection Time	mm/dd/yyyy hh:mm am	Inspection Time	DateTime
BD_INSP_TY	Inspect Status Text	25x	Inspection Status Text	Text
BD_LATEST	Most Recent Inspect		Most Recent Inspection	Boolean
BD_MAINTREQ	Maint Requested		Maint Requested	Boolean
BD_MOD_BY	Modified By	25x	Modified By	Text
BD_MOD_DT	Modified Date	mm/dd/yyyy	Modified Date	Date/Time
BD_MOD_TM	Last Modified Time	hh:mm am	Modified Time	Date/Time
BD_MON_ID	Monitor ID	30x	Monitor ID	Text
BD_MOV_FLG			Movie Available	Boolean
BD_NAME	Business	50x	Business Name: Name of Place	Text
BD_NEEDREP	Needs Repair		Needs Repair	Boolean
BD_NETID	Pipe Rec #	nnnnnnnn	Link to SWNET.NT_ID	Long Integer
BD_NXT_DT	Next Insp Date	mm/dd/yyyy	Next Inspection Date	Date/Time
BD_OBSSTAT	Exterior Source Stat	nnn	Observation Status	Integer
BD_PARCEL	Parcel Number	40x	Parcel	Text
BD_PFLD_CD	Previous Flooding	nnn	Previous Flooding Code	Integer
BD_PFLD_TY	Previous Flood Text	25x	Previous Flooding Text	Text
BD_PHONE	Contact Phone	30x	Contact Phone	Text
BD_PROPTAG	Property ID Tag	52x	Property ID Tag	Text
BD_REC_CD	Recommendations	nnn	Recommendations	Integer
BD_REC_TY	Recommendations Text	25x	Recommendations Text	Text
BD_REQNUMB	Request #	25x	Request #	String
BD_ROWVER			Rowversion for optimistic locking	Date/Time
BD_RQ_ID	Request Rec #	nnnnnnnn	Link to WKREQ.RQ_ID	Long Integer
BD_SMPL_DT	Sample Taken	mm/dd/yyyy	Sample Taken Date	Date/Time
BD_SMPL_TM	Sample Taken Time	hh:mm am	Sample Take Time	Date/Time
BD_SMPSTAT	Sump Status	nnn	Sump Status	Integer
BD_STAT_TY	Building Status	25x	Building Status	Text
BD_TYPE_CD	Inspection Type	nnn	Inspection Type	Integer
BD_TYPE_TY	Inspection Type Text	25x	Inspection Type Text	Text
BD_USER1CD	User 1	nnn	User 1	Integer
BD_USER1TY	User 1 Text	25x	User 1 Text	Text
BD_USER2CD	User 2	nnn	User 2	Integer
BD_USER2TY	User 2 Text	25x	User 2 Text	Text
BD_USER3CD	User 3	nnn	User 3	Integer
BD_USER3TY	User 3 Text	25x	User 3 Text	Text
BD_USER4	User 4	nnnnnnnnn.nn	User 4	Double
BD_USER5	User 5	30x	User 5	Text
BD_USER6	User 6		User 6	Boolean
BD_USER7	User 7		User 7	Boolean
BD_USER8	User 8		User 8	Boolean
BD_USER9	User 9	mm/dd/yyyy	User 9	Date/Time
BD_USER10	User 10	mm/dd/yyyy	User 10	Date/Time
BD_USER11	User 11	mm/dd/yyyy	User 11	Date/Time
BD_USER12	User 12	-nnnnnnnnn.nn	User 12	Double
BD_USER13	User 13	-nnnnnnnnn.nn	User 13	Double
BD_USER14	User 14	30x	User 14	Text
BD_USER15	User 15	30x	User 15	Text
BD_USR16CD	User 16	10x	User 16 Code	Text
BD_USR16TY	User 16 Text	60x	User 16 Text	Text
BD_USER17CD	User 17	nnn	User 17	Integer
BD_USER17TY	User 17 Text	50x	User 17 Text	String
BD_USER18CD	User 18	nnn	User 18	Integer
BD_USER18TY	User 18 Text	50x	User 18 Text	String
BD_USER19CD	User 19	nnn	User 19	Integer
BD_USER19TY	User 19 Text	50x	User 19 Text	String
BD_USER20CD	User 20	nnn	User 20	Integer
BD_USER20TY	User 20 Text	50x	User 20 Text	String
BD_USER21	User 21	50x	User 21	String
BD_USER22	User 22	50x	User 22	String
BD_USER23	User 23	50x	User 23	String
BD_USER24	User 24	50x	User 24	String
BD_USER25	User 25	50x	User 25	String
BD_USER26	User 26	nnnnnnnn.nn	User 26	Double
BD_USER27	User 27	nnnnnnnn.nn	User 27	Double
BD_USER28	User 28	nnnnnnnn.nn	User 28	Double
BD_USER29	User 29	nnnnnnnn.nn	User 29	Double
BD_USER30	User 30	nnnnnnnn.nn	User 30	Double
BD_USER31	User 31	mm/dd/yyyy hh:mm am	User 31	DateTime
BD_USER32	User 32	mm/dd/yyyy hh:mm am	User 32	DateTime
BD_USER33	User 33	mm/dd/yyyy hh:mm am	User 33	DateTime
BD_USER34	User 34	mm/dd/yyyy hh:mm am	User 34	DateTime
BD_USER35	User 35	mm/dd/yyyy hh:mm am	User 35	DateTime
BD_USER36	User 36		User 36	Boolean
BD_USER37	User 37		User 37	Boolean
BD_USER38	User 38		User 38	Boolean
BD_USER39	User 39		User 39	Boolean
BD_USER40	User 40		User 40	Boolean
BD_WINS_CD	Work Employee	20x	Work Employee	String
BD_WINS_TY	Work Employee Text	40x	Work Employee Text	String
BD_WO_ID	Work Order Rec #	nnnnnnnn	Link to WKORDER.WO_ID	Long Integer
BD_WONUMB	Work Order #	25x	Work Order #	String

Related Tables

Tables this table links to

Target Table	Target Field	Linking Field	Purpose
CMADDR	AD_ID	BD_ADDID	Links the building inspection to a address.
SWNET	NT_ID	BD_NETID	Links the building inspection to a sewer pipe.
WQREQ	RQ_ID	BD_RQ_ID	Links the inspection to Work Request. Example: *SELECT FROM WKREQ INNER JOIN SWBLDG WHERE RQ_ID = BD_RQ_ID**
WKWOASSET	AS_WO_ID AS_INV_ID	BD_WO_ID BD_NETID	Links the inspection to a Work Order Asset. Example: *SELECT FROM WKWOASSET INNER JOIN SWBLDG ON AS_WO_ID = BD_WO_ID AND AS_INV_ID = BD_NETID WHERE AS_CAT_INV = (SELECT CI_ID FROM WKCATINV WHERE CI_TBLNAME = 'SWNET')**

Tables that link to this table

Linking Table	Linking Field	Target Field	Purpose
SWBLDGOB	BO_BLDGID	BD_BLDGID	Links an observation to the building inspection.
SWBLDGSUMP	BB_BLDGID	BD_BLDGID	Links a sump record to the building inspection.