Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 2.55 ms Record Count: 68 Cached: No Lazy: No SQL: SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_SCALE, COLUMN_KEY, COLUMN_DEFAULT, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, COLUMN_TYPE, EXTRA, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'prefcit' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION
	COLUMN_NAME	DATA_TYPE	NUMERIC_SCALE	COLUMN_KEY	COLUMN_DEFAULT	IS_NULLABLE	CHARACTER_MAXIMUM_LENGTH	COLUMN_TYPE	EXTRA	CHARACTER_SET_NAME
1	id	int	0	PRI		NO		int	auto_increment
2	BID	int	0		0	NO		int
3	PrimaryName	varchar				YES	50	varchar(50)		latin1
4	PrimaryEmail	varchar				YES	100	varchar(100)		latin1
5	AddressAttn	varchar				YES	255	varchar(255)		latin1
6	Address1	varchar				YES	255	varchar(255)		latin1
7	Address2	varchar				YES	255	varchar(255)		latin1
8	City	varchar				YES	255	varchar(255)		latin1
9	State	varchar				YES	255	varchar(255)		latin1
10	Zip	varchar				YES	255	varchar(255)		latin1
11	glEach	varchar			0	YES	50	varchar(50)		latin1
12	glFire	varchar			0	YES	50	varchar(50)		latin1
13	glMedExp	varchar			0	YES	50	varchar(50)		latin1
14	glGeneralAgg	varchar			0	YES	50	varchar(50)		latin1
15	glProducts	varchar			0	YES	50	varchar(50)		latin1
16	alCombined	varchar			0	YES	50	varchar(50)		latin1
17	alBodily	varchar			0	YES	50	varchar(50)		latin1
18	alProperty	varchar			0	YES	50	varchar(50)		latin1
19	galAuto	varchar			0	YES	50	varchar(50)		latin1
20	galOther	varchar			0	YES	50	varchar(50)		latin1
21	galEach	varchar			0	YES	50	varchar(50)		latin1
22	galAgg	varchar			0	YES	50	varchar(50)		latin1
23	elEach	varchar			0	YES	50	varchar(50)		latin1
24	elAgg	varchar			0	YES	50	varchar(50)		latin1
25	wcAccident	varchar			0	YES	50	varchar(50)		latin1
26	wcEmployee	varchar			0	YES	50	varchar(50)		latin1
27	wcPolicy	varchar			0	YES	50	varchar(50)		latin1
28	TenantAccess	varchar			no	NO	50	varchar(50)		latin1
29	VendorPassword	varchar				YES	10	varchar(10)		latin1
30	CertAccessCode	varchar				YES	50	varchar(50)		latin1
31	AddressCompany	varchar				YES	50	varchar(50)		latin1
32	propOccurrence	varchar			0	YES	50	varchar(50)		latin1
33	ExpirationDefaultText_Tenant	text				YES	65535	text		latin1
34	NonComplianceDefaultText_Tenant	text				YES	65535	text		latin1
35	ExpirationNotifyPref	varchar			off	YES	50	varchar(50)		latin1
36	NonComplianceNotifyPref	varchar			off	YES	50	varchar(50)		latin1
37	ExpirationDefaultText_Vendor	text				YES	65535	text		latin1
38	NonComplianceDefaultText_Vendor	text				YES	65535	text		latin1
39	CertApprovedDefaultText_Tenant	text				YES	65535	text		latin1
40	CertApprovedDefaultText_Vendor	text				YES	65535	text		latin1
41	CertDeniedDefaultText_Tenant	text				YES	65535	text		latin1
42	CertDeniedDefaultText_Vendor	text				YES	65535	text		latin1
43	crimeEmployeeDishonesty	varchar				YES	50	varchar(50)		latin1
44	eliEachOccurrence	varchar				YES	50	varchar(50)		latin1
45	eliAggregate	varchar				YES	50	varchar(50)		latin1
46	paiEachOccurrence	varchar				YES	50	varchar(50)		latin1
47	paiAggregate	varchar				YES	50	varchar(50)		latin1
48	cyberEachOccurrence	varchar				YES	50	varchar(50)		latin1
49	cyberAggregate	varchar				YES	50	varchar(50)		latin1
50	plEachOccurrence	varchar				YES	50	varchar(50)		latin1
51	plAggregate	varchar				YES	50	varchar(50)		latin1
52	showOptions	varchar			yes	NO	3	varchar(3)		latin1
53	showStatus	varchar			yes	NO	3	varchar(3)		latin1
54	showCertificateID	varchar			yes	NO	3	varchar(3)		latin1
55	showINearestExpiration	varchar			yes	NO	3	varchar(3)		latin1
56	showBuilding	varchar			yes	NO	3	varchar(3)		latin1
57	showGeneralLiabilityExp	varchar			yes	NO	3	varchar(3)		latin1
58	showInsuredCompany	varchar			yes	NO	3	varchar(3)		latin1
59	showContact	varchar			yes	NO	3	varchar(3)		latin1
60	showType	varchar			yes	NO	3	varchar(3)		latin1
61	RowsPerPage	int	0		15	NO		int
62	ExpirationNotifyAdminPref	varchar			off	YES	50	varchar(50)		latin1
63	NonComplianceTenantVendorNotifyPref	varchar				YES	50	varchar(50)		latin1
64	NoCertificateNotifyPref	varchar				YES	50	varchar(50)		latin1
65	NoCertificateDefaultText_Company	text				YES	65535	text		latin1
66	ENSNotifyTemplate	int	0		0	NO		int
67	TenantCertFormType	varchar			long	YES	50	varchar(50)		latin1
68	VendorCertFormType	varchar			long	YES	50	varchar(50)		latin1