CA Service Management

Factory org < ca_organization, usp_organization >

Attributes:

   id <organization_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 org_name        STRING(100) REQUIRED

   delete_flag inactive SREL -> actbool.enum REQUIRED

   contact contact_uuid SREL -> cnt.id SERVICE_PROVIDER_ELIGIBLE

   company company_uuid SREL -> ca_cmpny.id

   description          STRING(255)

   org_num abbreviation STRING(30)

   phone_number pri_phone_number STRING(32)

   fax_phone fax_number STRING(32)

   alt_phone alt_phone_number STRING(32)

   email_addr email_address STRING(120)

   pemail_addr pager_email_address STRING(120)

   location location_uuid SREL -> loc.id

   billing_code cost_center SREL -> cost_cntr.id

   comment <comments>   STRING(255)

   oenv                 BREL <- lrel_oenv_orgref.org (LREL nr) {org = ?}

   all_creq             QREL <- cr {customer.organization = ? AND active = 1 AND

customer.organization IS NOT NULL}

   all_chg              QREL <- chg {requestor.organization = ? AND active = 1 A

ND

requestor.organization IS NOT NULL}

   all_iss              QREL <- iss {requestor.organization = ? AND active = 1 A

ND

requestor.organization IS NOT NULL}

   all_open_creq        QREL <- cr {customer.organization = ? AND active = 1 AND

customer.organization IS NOT NULL}

   my_****              BREL <- cnt.organization {organization = ?}

   audit_userid         LOCAL SREL -> cnt.id TENANCY_UNRESTRICTED

   tenant               SREL -> tenant.id

   service_type iorg_service_type SREL -> no_contract_sdsc.code

   owning_contract      SREL -> svc_contract.id SERVICE_PROVIDER_ELIGIBLE

   linked_id_usp_organization id<organization_uuid> UUID UNIQUE

TABLE ca_organization

        abbreviation alt_phone_cc alt_phone_number comment company_uuid contact_uuid         cost_center creation_date creation_user delete_time description email_address

        exclude_registration fax_cc fax_number id inactive last_update_date last_update_user        location_uuid org_name pager_email_address parent_org_uuid pri_phone_cc

        pri_phone_number tenant version_number

TABLE ca_organization

org_name  inactive

{"name","0"}