CA Service Management

Factory loc < ca_location, usp_location >
Attributes:
id <location_uuid> UUID UNIQUE
producer_id LOCAL STRING(20)
persistent_id LOCAL STRING(60)
last_mod_by last_update_user STRING(64)
last_mod_dt last_update_date DATE
version_number INTEGER
creation_user STRING(64)
creation_date DATE
exclude_registration INTEGER
delete_time DATE
name location_name STRING(100) REQUIRED
delete_flag inactive SREL -> actbool.enum REQUIRED
description comment<comments> STRING(255)
site site_id SREL -> site.id
address1 address_1 STRING(50)
address2 address_2 STRING(50)
address3 address_3 STRING(50)
address4 address_4 STRING(50)
address5 address_5 STRING(50)
address6 address_6 STRING(50)
mail_address_1 STRING(50)
mail_address_2 STRING(50)
mail_address_3 STRING(50)
mail_address_4 STRING(50)
mail_address_5 STRING(50)
mail_address_6 STRING(50)
pri_phone_number STRING(40)
fax_number STRING(40)
city STRING(50)
state SREL -> state.id
primary_contact primary_contact_uuid SREL -> cnt.id
zip STRING(20)
country SREL -> country.id
county STRING(50)
contact_address_flag INTEGER
parent_location_uuid UUID
location_type_id INTEGER
service_groups BREL <- lrel_svc_locs_svc_groups.loc (LREL cnt) {loc = ?}
service_chgcat BREL <- lrel_svc_locs_svc_chgcat.loc (LREL chgcat) {loc= ?}
service_pcat BREL <- lrel_svc_locs_svc_pcat.loc (LREL pcat) {loc = ?}

service_isscat BREL <- lrel_svc_locs_svc_isscat.loc (LREL isscat) {loc= ?}
audit_userid LOCAL SREL -> cnt.id TENANCY_UNRESTRICTED
timezone SREL -> tz.code
linked_id_usp_location id<location_uuid> UUID UNIQUE

TABLE ca_location
address_1 address_2 address_3 address_4 address_5 address_6 city comment contact_address_flag country county creation_date creation_user delete_time exclude_registration fax_number geo_coord_type geo_coords id inactive last_update_date last_update_user location_name location_type_id mail_address_1 mail_address_2 mail_address_3 mail_address_4 mail_address_5 mail_address_6 parent_location_uuid pri_phone_number primary_contact_uuid site_id state tenant version_number zip
{ "5th Avenue" ,"" ,"" ,"" ,"" ,"" ,"NY", "comments" ,"" ,"255" ,"" ,"10/25/2016 18:11:12", "ServiceDesk" ,"" ,"" ,"" ,"" ,"" ,"42D7422F19E0D44499DCDA586339CC72" ,"0", "12/05/2016 17:28:12" ,"ServiceDesk" ,"NAME" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "" ,"" ,"" ,"" ,"" ,"" ,"3" ,"" }

TABLE ca_location
location_name
{ "TEST"}