ELCAP

Electric Capacitor Unit Inventory

Field Name	Caption	Mask	Description	Field Type
CP_ACT_CD	Action	nnnn	Last Action	Integer
CP_ACT_TY	Action Text	25x	Last Action Text	Text
CP_AZONE_CD	Alternate Zone	10x	Alternate Zone	String
CP_AZONE_TY	Alternate Zone Text	60x	Alternate Zone Text	String
CP_BK_ID	Capacitor Bank Rec #	nnnnnnnn	Link to ELCAPB.BK_ID	Long Integer
CP_BR_CD	Default WO Cat	10x	Default WO Category Code	Text
CP_BR_TY	Default WO Cat Text	60x	Default WO Category Type	Text
CP_CL_ID	Capacitor Loc Rec #	nnnnnnnn	Link to ELCAPSL.CL_ID	Long Integer
CP_COND_CD	Overall Cond	nnnn	Last Condition	Integer
CP_COND_TY	Overall Cond Text	25x	Last Condition Text	Text
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 Available: Doc Flag	Boolean
CP_FTYP_CD	Fluid Type	nnnn	Fluid Type - Type of dielectric fluid used	Integer
CP_FTYP_TY	Fluid Type Text	25x	Fluid Type Text	Text
CP_ID	Capacitor Rec #	nnnnnnnn	Capacitor Rec ID	Long Integer
CP_IFREQ	Inspection Freq	nnn	Inspection Freq	Small Integer
CP_IFRQ_CD	Inspection Freq Units	nnn	Inspection Freq Units	Small Integer
CP_IFRQ_TY	Inspection Freq Units Text	10x	Inspection Freq Units Text	String
CP_INSP_DT	Last Inspection	mm/dd/yyyy	Last Inspection Date	Date/Time
CP_INSP_TM	Inspection Time	hh:mm am	Last Inspection Time	Date/Time
CP_INST_DT	Installation Date	mm/dd/yyyy	Installation Date	Date/Time
CP_KVAR_CD	kVar	nnnn	kVar - Capacitor Unit size in kVar	Integer
CP_KVAR_TY	kVar Text	25x	kVar Text	Text
CP_MANU_CD	Manufacturer	10x	Manufacturer	Text
CP_MANU_TY	Manufacturer Text	60x	Manufacturer Text	Text
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_MODEL	Model	30x	Model	Text
CP_MZONE_CD	Maintenance Zone	10x	Maintenance Zone	String
CP_MZONE_TY	Maintenance Zone Text	60x	Maintenance Zone Text	String
CP_NMNT_DT	Next Insp Date	mm/dd/yyyy	Next Inspection Date	Date/Time
CP_NOWORK	No WO/PM/Req		Not to be used in Work Orders PMs or Requests	Boolean
CP_NUMBER	Capacitor Number	30x	Capacitor Number	Text
CP_PHAS_CD	Phase Designation	nnnn	Phase Designation	Integer
CP_PHAS_TY	Phase Designation Text	25x	Phase Designation Text	Text
CP_PVALUE	Present Value	nnnnnnnnn.nn	Present Value	Double
CP_REPL_DT	Replacement Date	mm/dd/yyyy	Replacement Date	Date/Time
CP_RLIFE	Remaining Life	nnnn.nn	Remaining Life	Double
CP_ROWVER		mm/dd/yyyy hh:mm am	Rowversion for optimistic locking	Date/Time
CP_RVALUE	Replacement Value	nnnnnnnnn.nn	Replacement Value	Double
CP_SERIAL	Serial Number	30x	Serial Number	Text
CP_STAT_CD	Status	nnnn	Status	Integer
CP_STAT_TY	Status Text	25x	Status Text	Text
CP_TYPE_CD	Type	nnnn	Type	Integer
CP_TYPE_TY	Type Text	40x	Type Text	Text
CP_USER10CD	User 10	10x	User 10	Text
CP_USER10TY	User 10 Text	60x	User 10 Text	Text
CP_USER11	User 11	30x	User 11	Text
CP_USER12	User 12	30x	User 12	Text
CP_USER13	User 13	30x	User 13	Text
CP_USER14	User 14	30x	User 14	Text
CP_USER15	User 15	30x	User 15	Text
CP_USER16	User 16	nnnnnnnnn.nn	User 16	Double
CP_USER17	User 17	nnnnnnnnn.nn	User 17	Double
CP_USER18	User 18	nnnnnnnnn.nn	User 18	Double
CP_USER19	User 19	nnnnnnnnn.nn	User 19	Double
CP_USER1CD	User 1	nnnn	User 1	Integer
CP_USER1TY	User 1 Text	25x	User 1 Text	Text
CP_USER20	User 20	nnnnnnnnn.nn	User 20	Double
CP_USER21	User 21	mm/dd/yyyy	User 21	Date/Time
CP_USER22	User 22	mm/dd/yyyy	User 22	Date/Time
CP_USER23	User 23	mm/dd/yyyy	User 23	Date/Time
CP_USER24	User 24	mm/dd/yyyy	User 24	Date/Time
CP_USER25	User 25	mm/dd/yyyy	User 25	Date/Time
CP_USER26	User 26		User 26	Boolean
CP_USER27	User 27		User 27	Boolean
CP_USER28	User 28		User 28	Boolean
CP_USER29	User 29		User 29	Boolean
CP_USER2CD	User 2	nnnn	User 2	Integer
CP_USER2TY	User 2 Text	25x	User 2 Text	Text
CP_USER30	User 30		User 30	Boolean
CP_USER31CD	User 31	nnn	User 31	Small Integer
CP_USER31TY	User 31 Text	25x	User 31 Text	String
CP_USER32CD	User 32	nnn	User 32	Small Integer
CP_USER32TY	User 32 Text	25x	User 32 Text	String
CP_USER33CD	User 33	nnn	User 33	Small Integer
CP_USER33TY	User 33 Text	25x	User 33 Text	String
CP_USER34CD	User 34	nnn	User 34	Small Integer
CP_USER34TY	User 34 Text	25x	User 34 Text	String
CP_USER35CD	User 35	nnn	User 35	Small Integer
CP_USER35TY	User 35 Text	25x	User 35 Text	String
CP_USER36CD	User 36	10x	User 36	String
CP_USER36TY	User 36 Text	60x	User 36 Text	String
CP_USER37CD	User 37	10x	User 37	String
CP_USER37TY	User 37 Text	60x	User 37 Text	String
CP_USER38CD	User 38	10x	User 38	String
CP_USER38TY	User 38 Text	60x	User 38 Text	String
CP_USER39CD	User 39	10x	User 39	String
CP_USER39TY	User 39 Text	60x	User 39 Text	String
CP_USER3CD	User 3	nnnn	User 3	Integer
CP_USER3TY	User 3 Text	25x	User 3 Text	Text
CP_USER40CD	User 40	10x	User 40	String
CP_USER40TY	User 40 Text	60x	User 40 Text	String
CP_USER41	User 41	30x	User 41	String
CP_USER42	User 42	30x	User 42	String
CP_USER43	User 43	30x	User 43	String
CP_USER44	User 44	30x	User 44	String
CP_USER45	User 45	30x	User 45	String
CP_USER46	User 46	nnnnnnnnn.nn	User 46	Double
CP_USER47	User 47	nnnnnnnnn.nn	User 47	Double
CP_USER48	User 48	nnnnnnnnn.nn	User 48	Double
CP_USER49	User 49	nnnnnnnnn.nn	User 49	Double
CP_USER4CD	User 4	nnnn	User 4	Integer
CP_USER4TY	User 4 Text	25x	User 4 Text	Text
CP_USER50	User 50	nnnnnnnnn.nn	User 50	Double
CP_USER51	User 51	mm/dd/yyyy	User 51	DateTime
CP_USER52	User 52	mm/dd/yyyy	User 52	DateTime
CP_USER53	User 53	mm/dd/yyyy	User 53	DateTime
CP_USER54	User 54	mm/dd/yyyy	User 54	DateTime
CP_USER55	User 55	mm/dd/yyyy	User 55	DateTime
CP_USER56	User 56		User 56	Boolean
CP_USER57	User 57		User 57	Boolean
CP_USER58	User 58		User 58	Boolean
CP_USER59	User 59		User 59	Boolean
CP_USER5CD	User 5	nnnn	User 5	Integer
CP_USER5TY	User 5 Text	25x	User 5 Text	Text
CP_USER60	User 60		User 60	Boolean
CP_USER6CD	User 6	10x	User 6	Text
CP_USER6TY	User 6 Text	60x	User 6 Text	Text
CP_USER7CD	User 7	10x	User 7	Text
CP_USER7TY	User 7 Text	60x	User 7 Text	Text
CP_USER8CD	User 8	10x	User 8	Text
CP_USER8TY	User 8 Text	60x	User 8 Text	Text
CP_USER9CD	User 9	10x	User 9	Text
CP_USER9TY	User 9 Text	60x	User 9 Text	Text
CP_WO_COMM	WO Comment	250x	WO Comment	Text
CP_YEAR	Year Manufactured	30x	Year Manufactured	Text