CA SDM Loading Change category

Document created by TMACUL Champion on Jan 24, 2017Last modified by TMACUL Champion on Jan 25, 2017
Version 2Show Document
  • View in full screen mode

 

HowItWorks.jpgLoading Change category

 

The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.

 

Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.

 

1. BACKUP

 

BACKUP COMMAND
pdm_extract Change_Category > chgcat.txt

 

2. Structure table

 

bop_sinfo -dq chgcat

 

Factory chgcat < Change_Category >
Attributes:
id INTEGER UNIQUE
producer_id LOCAL STRING(20)
persistent_id persid STRING(30)
delete_flag del SREL -> actbool.enum REQUIRED
sym STRING(1000) REQUIRED SKEY
code STRING(12) REQUIRED SKEY UNIQUE
modified_date last_mod_dt DATE
last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED
description STRING(500)
organization SREL -> org.id
assignee SREL -> agt.id SERVICE_PROVIDER_ELIGIBLE
group group_id SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE
cab SREL -> grp.id SERVICE_PROVIDER_ELIGIBLE
children_ok INTEGER REQUIRED
service_type SREL -> sdsc.code
chgtype SREL -> chgtype.id
survey SREL -> svy_tpl.id
risk_survey SREL -> risk_svy_tpl.id
owning_contract SREL -> svc_contract.id
auto_assign INTEGER
ss_include SREL -> bool.enum REQUIRED
ss_sym STRING(128)
flow_flag INTEGER
caextwf_start_id SREL -> caextwf_sfrm.id
cawf_defid STRING(40)
cawf_defname LOCAL STRING(0)
cawf_desc LOCAL STRING(0)
cawf_active LOCAL STRING(0)
cawf_effective LOCAL INTEGER
cawf_cache LOCAL DATE
service_grps BREL <- lrel_svc_grps_svc_chgcat.chgcat (LREL cnt) {chgcat = ?}
service_locs BREL <- lrel_svc_locs_svc_chgcat.chgcat (LREL loc) {chgcat = ?}
service_schedules BREL <- lrel_svc_schedules_chgcat_svc.chgcat (LREL wrkshft) {chgcat = ?}
workflow_templates QREL <- wftpl {object_type = 'chg' AND object_attrval =? AND delete_flag = 0}
all_workflow_templates QREL <- wftpl {object_type = 'chg' AND object_attrval= ?}
property_templates QREL <- prptpl {object_type = 'chg' AND object_attrval =?}

 

 

 

Structure load: pdm_extract Change_Category

TABLE Change_Category
assignee auto_assign cab caextwf_start_id cawf_defid chgtype children_ok

code del description flow_flag group_id id last_mod_by last_mod_dt organ
ization
owning_contract persid risk_survey schedule service_type ss_include ss_s
ym
survey sym tenant
{ "" ,"" ,"" ,"" ,"" ,"" ,"1" ,"addITothr" ,"0", "Add an IT asset to the inventory that does not meet the other classifications.", 
"0" ,"" ,"6100" ,"171E5C822F5AA4409145FC5220142A50" ,"11/22/2016 23:49:23",
"" ,"" ,"chgcat:6100" ,"" ,"" ,"" ,"1" ,"Add.IT.Other" ,"" ,"Add.IT.Othe
r" ,"" }

 

 

 

3. Example

 

loading_chgcat.txt - Content

TABLE Change_Category
del description ss_include sym children_ok code
{"0" ,"MyChange description" ,"0", "MyChange", "1","mychange" }

 

 

 

 

know_more.png

pdm_load 

2 people found this helpful

Attachments

    Outcomes