WKPROJCI

Daily Inspection for Contracts

Field Name	Caption	Mask	Description	Field Type
XN_AMWORK	AM Work Performed	2000x	AM Work Performed	String
XN_AWCON_CD	AM Working Conditions	nnn	AM Working Conditions	integer
XN_AWCON_TY	AM Working Conditions Text	50x	AM Working Conditions Text	String
XN_AWTH_CD	AM Weather	nnn	AM Weather	integer
XN_AWTH_TY	AM Weather Text	50x	AM Weather Text	String
XN_CDAY	Contract Day	nnn	Contract Day	integer
XN_CDAYS	Total Contract Days	nnn	Total Contract Days	integer
XN_CINS_CD	Contract Inspector	20x	Contract Inspector	String
XN_CINS_TY	Contract Inspector Text	40x	Contract Inspector Text	String
XN_COMMENT1	Long Note		Long Note	Memo
XN_CONT_CD	Contractor	10x	Contractor	String
XN_CONT_TY	Contractor Text	60x	Contractor Text	String
XN_CRT_BY	Created By	25x	Created By	String
XN_CRT_DTTM	Creation Date Time	mm/dd/yyyy hh:mm am	Creation Date Time	DateTime
XN_DOC_FLG	Document Available		Document Available	Boolean
XN_FWCL	Common Labor Count	nnn	Common Labor Count	integer
XN_FWFOR	Foreman Count	nnn	Foreman Count	integer
XN_FWSL	Skilled Labor Count	nnn	Skilled Labor Count	integer
XN_FWSUP	Superintendant Count	nnn	Superintendant Count	integer
XN_HTEMP	High Temperature	nnnnnnnn.nn	High Temperature	Double
XN_ID	Daily Contract Insp Rec #	nnnnnnnn	Daily Contract Insp AutoID	Long Integer
XN_INBY_CD	Inspected By	nnn	Inspected By	integer
XN_INBY_TY	Inspected By Text	50x	Inspected By Text	String
XN_INSP_DT	Inspection Date (required field)	mm/dd/yyyy hh:mm am	Inspection Date (required field)	DateTime
XN_INSP_TM	Inspection Time (allows for more than one Record per Day)	mm/dd/yyyy hh:mm am	Inspection Time (allows for more than one Record per Day)	DateTime
XN_ISSUES	Issues and Conflicts	1000x	Issues and Conflicts	String
XN_LAB_PHN	Testing Lab Phone	25x	Testing Lab Phone	String
XN_LATEST	Most Recent Inspection		Most Recent Inspection	Boolean
XN_LTEMP	Low Temperature	nnnnnnnn.nn	Low Temperature	Double
XN_MOD_BY	Last Modified By	25x	Last Modified By	String
XN_MOD_DT	Last Modified Date	mm/dd/yyyy hh:mm am	Last Modified Date	DateTime
XN_MOD_TM	Modified Time	mm/dd/yyyy hh:mm am	Modified Time	DateTime
XN_PDAY	Permit Day	nnn	Permit Day	integer
XN_PDAYS	Total Permitted Days	nnn	Total Permitted Days	integer
XN_PMWORK	PM Work Performed	2000x	PM Work Performed	String
XN_POTHER	Other Permit		Other Permit	Boolean
XN_PREC	Precipitation	nnnnnnnn.nn	Precipitation	Double
XN_PSEWER	Sewer Permit		Sewer Permit	Boolean
XN_PSTORM	Stormwater Permit		Stormwater Permit	Boolean
XN_PTRANS	Transportation Permit		Transportation Permit	Boolean
XN_PWATER	Water Permit		Water Permit	Boolean
XN_PWCON_CD	PM Working Conditions	nnn	PM Working Conditions	integer
XN_PWCON_TY	PM Working Conditions Text	50x	PM Working Conditions Text	String
XN_PWTH_CD	PM Weather	nnn	PM Weather	integer
XN_PWTH_TY	PM Weather Text	50x	PM Weather Text	String
XN_QREC	Quantities Recorded		Quantities Recorded	Boolean
XN_ROWVER	Rowversion for optimistic locking		Rowversion for optimistic locking	TimeStamp
XN_SCOM_DT	Substantially Complete Date	mm/dd/yyyy hh:mm am	Substantially Complete Date	DateTime
XN_STRT_DT	Start Date	mm/dd/yyyy hh:mm am	Start Date	DateTime
XN_SUP_CELL	Super Cell Phone	25x	Super Cell Phone	String
XN_SUPER	Superintendant Name	50x	Superintendant Name	String
XN_TLAB_CD	Testing Lab	10x	Testing Lab	String
XN_TLAB_TY	Testing Lab Text	60x	Testing Lab Text	String
XN_TPERFORM	Lab Tests Performed	1000x	Lab Tests Performed	String
XN_TYPE_CD	Contract Type	nnn	Contract Type	integer
XN_TYPE_TY	Contract Type Text	50x	Contract Type Text	String
XN_USER10CD	User 10	20x	User 10	String
XN_USER10TY	User 10 Text	60x	User 10 Text	String
XN_USER11	User 11	250x	User 11	String
XN_USER12	User 12	250x	User 12	String
XN_USER13	User 13	250x	User 13	String
XN_USER14	User 14	250x	User 14	String
XN_USER15	User 15	250x	User 15	String
XN_USER16	User 16	nnnnnnnn.nn	User 16	Double
XN_USER17	User 17	nnnnnnnn.nn	User 17	Double
XN_USER18	User 18	nnnnnnnn.nn	User 18	Double
XN_USER19	User 19	nnnnnnnn.nn	User 19	Double
XN_USER1CD	User 1	nnn	User 1	integer
XN_USER1TY	User 1 Text	100x	User 1 Text	String
XN_USER20	User 20	nnnnnnnn.nn	User 20	Double
XN_USER21	User 21	mm/dd/yyyy hh:mm am	User 21	DateTime
XN_USER22	User 22	mm/dd/yyyy hh:mm am	User 22	DateTime
XN_USER23	User 23	mm/dd/yyyy hh:mm am	User 23	DateTime
XN_USER24	User 24	mm/dd/yyyy hh:mm am	User 24	DateTime
XN_USER25	User 25	mm/dd/yyyy hh:mm am	User 25	DateTime
XN_USER26	User 26		User 26	Boolean
XN_USER27	User 27		User 27	Boolean
XN_USER28	User 28		User 28	Boolean
XN_USER29	User 29		User 29	Boolean
XN_USER2CD	User 2	nnn	User 2	integer
XN_USER2TY	User 2 Text	100x	User 2 Text	String
XN_USER30	User 30		User 30	Boolean
XN_USER31CD	User 31	nnn	User 31	integer
XN_USER31TY	User 31 Text	100x	User 31 Text	String
XN_USER32CD	User 32	nnn	User 32	integer
XN_USER32TY	User 32 Text	100x	User 32 Text	String
XN_USER33CD	User 33	nnn	User 33	integer
XN_USER33TY	User 33 Text	100x	User 33 Text	String
XN_USER34CD	User 34	nnn	User 34	integer
XN_USER34TY	User 34 Text	100x	User 34 Text	String
XN_USER35CD	User 35	nnn	User 35	integer
XN_USER35TY	User 35 Text	100x	User 35 Text	String
XN_USER36CD	User 36	20x	User 36	String
XN_USER36TY	User 36 Text	60x	User 36 Text	String
XN_USER37CD	User 37	20x	User 37	String
XN_USER37TY	User 37 Text	60x	User 37 Text	String
XN_USER38CD	User 38	20x	User 38	String
XN_USER38TY	User 38 Text	60x	User 38 Text	String
XN_USER39CD	User 39	20x	User 39	String
XN_USER39TY	User 39 Text	60x	User 39 Text	String
XN_USER3CD	User 3	nnn	User 3	integer
XN_USER3TY	User 3 Text	100x	User 3 Text	String
XN_USER40CD	User 40	20x	User 40	String
XN_USER40TY	User 40 Text	60x	User 40 Text	String
XN_USER41	User 41	250x	User 41	String
XN_USER42	User 42	250x	User 42	String
XN_USER43	User 43	250x	User 43	String
XN_USER44	User 44	250x	User 44	String
XN_USER45	User 45	250x	User 45	String
XN_USER46	User 46	nnnnnnnn.nn	User 46	Double
XN_USER47	User 47	nnnnnnnn.nn	User 47	Double
XN_USER48	User 48	nnnnnnnn.nn	User 48	Double
XN_USER49	User 49	nnnnnnnn.nn	User 49	Double
XN_USER4CD	User 4	nnn	User 4	integer
XN_USER4TY	User 4 Text	100x	User 4 Text	String
XN_USER50	User 50	nnnnnnnn.nn	User 50	Double
XN_USER51	User 51	mm/dd/yyyy hh:mm am	User 51	DateTime
XN_USER52	User 52	mm/dd/yyyy hh:mm am	User 52	DateTime
XN_USER53	User 53	mm/dd/yyyy hh:mm am	User 53	DateTime
XN_USER54	User 54	mm/dd/yyyy hh:mm am	User 54	DateTime
XN_USER55	User 55	mm/dd/yyyy hh:mm am	User 55	DateTime
XN_USER56	User 56		User 56	Boolean
XN_USER57	User 57		User 57	Boolean
XN_USER58	User 58		User 58	Boolean
XN_USER59	User 59		User 59	Boolean
XN_USER5CD	User 5	nnn	User 5	integer
XN_USER5TY	User 5 Text	100x	User 5 Text	String
XN_USER60	User 60		User 60	Boolean
XN_USER6CD	User 6	20x	User 6	String
XN_USER6TY	User 6 Text	60x	User 6 Text	String
XN_USER7CD	User 7	20x	User 7	String
XN_USER7TY	User 7 Text	60x	User 7 Text	String
XN_USER8CD	User 8	20x	User 8	String
XN_USER8TY	User 8 Text	60x	User 8 Text	String
XN_USER9CD	User 9	20x	User 9	String
XN_USER9TY	User 9 Text	60x	User 9 Text	String
XN_VISITORS	Visitors	1000x	Visitors	String
XN_WK_PHN	Contractor Work Phone	30x	Contractor Work Phone	String
XN_XC_ID	Contract Rec # - Link to WKPROJC table	nnnnnnnn	Link to WKPROJC.XC_ID	Long Integer