CA Service Management

Factory svy_qtpl < Survey_Question_Template >

Attributes:

   id                   INTEGER UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id persid STRING(30)

   text txt             STRING(400)

   sequence             INTEGER REQUIRED

   owning_survey        SREL -> svy_tpl.id REQUIRED

   delete_flag del      SREL -> actbool.enum REQUIRED

   last_mod_dt          DATE

   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED

   answer_templates     QREL <- svy_atpl {owning_survey_question = ? AND delete_flag = 0}

   resp_required        INTEGER

   include_qcomment     INTEGER

   mult_resp_flag       INTEGER

   qcomment_label       STRING(80)

   tenant               SREL -> tenant.id

TABLE Survey_Question_Template

        del id include_qcomment last_mod_by last_mod_dt mult_resp_flag owning_survey

TABLE Survey_Question_Template

  del id include_qcomment last_mod_by last_mod_dt mult_resp_flag owning_survey   persid qcomment_label resp_required sequence tenant txt

  { "0" ,"400001" ,"0" ,"",   "" ,"0" ,"400001" ,"svy_qtpl:400001" ,"" ,"0" ,"10" ,"" ,"What is your own question?" }

select * from survey_qtpl