CA Service Management

Dec 01, 2015 07:53 AM

TMACUL

How to load a survey

bop_sinfo -dq svy_tpl
Factory svy_tpl < Survey_Template > Attributes: id INTEGER UNIQUE producer_id LOCAL STRING(20) persistent_id persid STRING(30) sym STRING(60) REQUIRED SKEY UNIQUE description STRING(400) include_comment INTEGER REQUIRED comment_label STRING(80) conclude_text STRING(400) delete_flag del SREL -> actbool.enum REQUIRED last_mod_dt DATE last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED question_templates QREL <- svy_qtpl {owning_survey = ? AND delete_flag = 0} submit_cycle INTEGER tracking_flag INTEGER tenant SREL -> tenant.id

Factory svy_tpl < Survey_Template >

Attributes:

id INTEGER UNIQUE

producer_id LOCAL STRING(20)

persistent_id persid STRING(30)

sym STRING(60) REQUIRED SKEY UNIQUE

description STRING(400)

include_comment INTEGER REQUIRED

comment_label STRING(80)

conclude_text STRING(400)

delete_flag del SREL -> actbool.enum REQUIRED

last_mod_dt DATE

last_mod_by SREL -> cnt.id TENANCY_UNRESTRICTED

question_templates QREL <- svy_qtpl {owning_survey = ? AND delete_flag = 0}

submit_cycle INTEGER

tracking_flag INTEGER

tenant SREL -> tenant.id

pdm_extract Survey_Template
TABLE Survey_Template comment_label conclude_text cycle_counter del description id include_comment last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag

TABLE Survey_Template

comment_label conclude_text cycle_counter del description id include_comment last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag

pdm_load -v -i -f surveytemplate.txt
TABLE Survey_Template comment_label conclude_text cycle_counter del description id include_comment last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag { "" ,"" ,"" ,"0" ,"" ,"400001" ,"0" ,"F4C2A60100EA154695D233F90ABFFD21", "06/18/2015 16:37:25" ,"svy_tpl:400001" ,"1" ,"SURVEY" ,"" ,"" }

TABLE Survey_Template

comment_label conclude_text cycle_counter del description id include_comment last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag

{ "" ,"" ,"" ,"0" ,"" ,"400001" ,"0" ,"F4C2A60100EA154695D233F90ABFFD21", "06/18/2015 16:37:25" ,"svy_tpl:400001" ,"1" ,"SURVEY" ,"" ,"" }