Loading Tenants - tenant ca_tenant inquilino

Document created by TMACUL Champion on Jan 7, 2016
Version 1Show Document
  • View in full screen mode
bop_sinfo -dq tenant

 

 

 

bop_sinfo -dq tenant

 

 

Factory tenant < ca_tenant >

Attributes:

   id                   UUID UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id        LOCAL STRING(60)

   name                 STRING(255) REQUIRED

   tenant_number        STRING(30)

   service_provider     INTEGER

   contact              SREL -> cnt.id SERVICE_PROVIDER_ELIGIBLE

   logo                 STRING(255)

   description          STRING(1024)

   phone_number         STRING(255)

   fax_number           STRING(255)

   alt_phone            STRING(255)

   location             SREL -> loc.id

   delete_flag inactive SREL -> actbool.enum REQUIRED

   version_number       INTEGER

   creation_user        STRING(64)

   creation_date        DATE

   last_update_user     STRING(64)

   last_update_date     DATE

   ldap_tenant_group    SREL -> ldap_group.id

   groups               BREL <- tgm_groups.tenant_id {tenant_id = ?}

   search_sources       BREL <- lrel_search_source_tenants.tenant_id (LREL searc

h_source) {tenant_id = ?}

   parent               SREL -> tenant.id TENANCY_UNRESTRICTED

   fkey_group           SREL -> tenant_group.id

   subtenants_ok        SREL -> bool.enum

   supertenant_group    SREL -> tenant_group.id

   subtenant_group      SREL -> tenant_group.id

   relatedtenant_group  SREL -> tenant_group.id

   tenant_depth         INTEGER

   terms_of_usage tou_id SREL -> ca_tou.id

   in_apc_flag          LOCAL INTEGER

   pr_apc_flag          LOCAL INTEGER

   tenant               SREL -> tenant.id REQUIRED

 

 

 

 

 

 

 

SQL Commands - tenant

 

select * from ca_tenant

 

Extract - tenant

 

pdm_extract -f "select * from ca_tenant "

 

pdm_extract tenant

TABLE ca_tenant

        alt_phone contact creation_date creation_user description fax_number fkey_group id inactive last_update_date last_update_user ldap_tenant_group location logo name parent phone_number relatedtenant_group service_provider subtenant_group subtenants_ok supertenant_group tenant tenant_depth tenant_number tou_id version_number

 

pdm_load -v -i -f tenant.txt

TABLE ca_tenant

name inactive

  {"My tenant","0"}

 

 

 

know_more.png

Implementing Multi-Tenancy / Tenant - Configure the Tenancy Settings in CA Service Desk Manager

Carga Estados Brasileiros / Brazilian State load - ca_state_province

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

Category.xlsx Schema - CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

CA SDM Load department using pdm_load - dept - ca_resource_department

DEREF - pdm_deref - Everthing do you need know

CA SDM::. position - ca_job_title

CA SDM carregando contatos ca_contact/usp_contact usando pdm_load

 

CA SDM Loading contacts pdm_load

CA SDM Loading groups pdm_load

CA SDM Loading group members pdm_load

 

Root Cause - rootcause - rc / Causa raiz - 根本原因 -

Resolution Method - usp_resolution_method - resomethod - Método de resolução - Resolución - 解決

Resolution Code - usp_resolution_code - resocode - Código de resolução - Resolución - 解決

 

CA SDM how to delete location?

MS SQL - Turn upper case for first letter/character on phrase

CA SDM caractere inválido na carga - pdm_load -  Invalid character

CA SDM pdm_load 537  Invalid character encountered in input - error

3 people found this helpful

Attachments

    Outcomes