CA SDM CI - contracts  - conx -  ci_contract

Document created by TMACUL Champion on Jan 26, 2016Last modified by TMACUL Champion on Jan 26, 2016
Version 2Show Document
  • View in full screen mode

1. BACKUP

 

BACKUP COMMAND
pdm_extract conx > conx.txt

 

2. Structure table

 

bop_sinfo -dq conx

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)

 

 

3. extract

Structure : pdm_extract conx

 

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

 

4. SQL Command

MS SQL Querys

 

 

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

 

Contract Family - CA Service Management - 14.1 - CA Technologies Documentation

Família Contrato - CA Service Management - 14.1 - Portuguese - Brazil - CA Technologies Documentation

Familia Contrato - CA Service Management - 14.1 - Spanish - Spain - CA Technologies Documentation

Famille Contrat - CA Service Management - 14.1 - French - France - CA Technologies Documentation

Contract(契約)ファミリ - CA Service Management - 14.1 - Japanese - Japan - CA Technologies Documentation

 

pdm_load

Summary CA Service Management Community

Service Desk Manager 15 days Implementation

Attachments

    Outcomes