Facility Attribute Names and Lengths

The following facility_table lists all CygNet facility attributes, by name, data type, length, and type.

Internal Name Name Data Type (Length in Bytes) Stored in Table User Defined
facility_attr0 - facility_attr2 Facility Attribute 0 - Facility Attribute 2 STRING (20) Check
facility_attr3 - facility_attr5 Facility Attribute 3 - Facility Attribute 5 STRING (40) Check
facility_attr6 - facility_attr9 Facility Attribute 6 - Facility Attribute 9 STRING (60) Check
facility_attr10 - facility_attr19 Facility Attribute 10 - Facility Attribute 19 STRING (20) Check
facility_attr20 - facility_attr26 Facility Attribute 20 - Facility Attribute 26 STRING (40) Check
facility_attr27 Facility Attribute 27 STRING (60) Check
facility_attr28 - facility_attr39 Facility Attribute 28 - Facility Attribute 39 STRING (80) Check
facility_category Facility Category STRING (10) SYSFCCAT  
facility_comment Facility Comment STRING (300) Check
facility_desc Facility Description STRING (32) Check
facility_id Facility ID (FAC) STRING (20) Check
facility_info0 Facility Info 0 (Location) STRING (50) Check
facility_info1 Facility Info 1 (Contact) STRING (50) Check
facility_is_active Facility Is Active STRING (1) YORN Check
facility_is_ref_any Facility Is Referenced by DDS or PNT STRING (1) YORN  
facility_is_ref_dds Facility Is Referenced by DDS STRING (1) YORN  
facility_is_ref_pcs Facility Is Referenced by PNT STRING (1) YORN  
facility_security_app Facility Security App STRING (8) Check
facility_service Facility Service Name STRING (8)  
facility_site Facility Site STRING (8)  
facility_table0 - facility_table59 Table Attrib 0 - Table Attrib 59 STRING (10) SYSFCT00 -
SYSFCT59
Check
facility_type Facility Type STRING (10) SYSFCTYP Check
facility_yes_no0 - facility_yes_no19 Yes/No Attrib 0 - Yes/No Attrib 19 STRING (1) YORN Check

Back to top