CA Service Management

C:\>bop_sinfo -dq conx

Factory conx < conx >

Attributes:

   id <own_resource_uuid> SREL -> nr.id UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id        LOCAL STRING(60)

   proj_code            STRING(50)

   con_num              STRING(50)

   con_ref              STRING(50)

   con_status           SREL -> bms.status_no

   con_type             STRING(50)

   con_start_date       DATE

   con_end_date         DATE

   con_renewal_date     DATE

   con_comments         STRING(200)

   delete_flag del      SREL -> actbool.enum REQUIRED

   version_number       INTEGER

   creation_date        DATE

   creation_user        STRING(64)

   last_mod_dt last_update_date DATE

   last_mod_by last_update_user STRING(64)

   mdr_name             LOCAL STRING(0)

   mdr_class            LOCAL STRING(0)

   audit_userid         LOCAL SREL -> cnt.id TENANCY_UNRESTRICTED

   warning_msg          LOCAL STRING(0)

C:\>pdm_extract conx

TABLE conx

        con_comments con_end_date con_num con_ref con_renewal_date con_start_date con_status con_type creation_date creation_user del id last_update_date

        last_update_user proj_code version_number

select * from ci_contract

select nr.resource_name, conx.*

from ci_contract as conx

inner join ca_owned_resource as nr on nr.own_resource_uuid = conx.own_resource_uuid