TMACUL

CA SDM::. Tabela da matrix de prioridade - pri_cal

Blog Post created by TMACUL Champion on May 30, 2017
select * from usp_pri_cal

 

 

 

 


bop_sinfo -dq pri_cal

 

 

Factory pri_cal < usp_pri_cal >
 Attributes:
   id                   INTEGER UNIQUE
   producer_id          LOCAL STRING(20)
   persistent_id        LOCAL STRING(60)
   name                 STRING(80) REQUIRED SKEY UNIQUE
   description          STRING(1024)
   delete_flag del      SREL -> actbool.enum REQUIRED
   in_flag              SREL -> bool.enum
   pr_flag              SREL -> bool.enum
   imp_def              SREL -> imp.enum
   urg_def              SREL -> urg.enum
   ci_imp               SREL -> bool.enum
   cat_urg              SREL -> bool.enum
   bk_window            INTEGER
   cnt_vip              INTEGER
   pri_5_4              SREL -> pri.enum
   pri_5_3              SREL -> pri.enum
   pri_5_2              SREL -> pri.enum
   pri_5_1              SREL -> pri.enum
   pri_5_0              SREL -> pri.enum
   pri_5_x              SREL -> pri.enum
   pri_4_4              SREL -> pri.enum
   pri_4_3              SREL -> pri.enum
   pri_4_2              SREL -> pri.enum
   pri_4_1              SREL -> pri.enum
   pri_4_0              SREL -> pri.enum
   pri_4_x              SREL -> pri.enum
   pri_3_4              SREL -> pri.enum
   pri_3_3              SREL -> pri.enum
   pri_3_2              SREL -> pri.enum
   pri_3_1              SREL -> pri.enum
   pri_3_0              SREL -> pri.enum
   pri_3_x              SREL -> pri.enum
   pri_2_4              SREL -> pri.enum
   pri_2_3              SREL -> pri.enum
   pri_2_2              SREL -> pri.enum
   pri_2_1              SREL -> pri.enum
   pri_2_0              SREL -> pri.enum
   pri_2_x              SREL -> pri.enum
   pri_1_4              SREL -> pri.enum
   pri_1_3              SREL -> pri.enum
   pri_1_2              SREL -> pri.enum
   pri_1_1              SREL -> pri.enum
   pri_1_0              SREL -> pri.enum
   pri_1_x              SREL -> pri.enum
   pri_0_4              SREL -> pri.enum
   pri_0_3              SREL -> pri.enum
   pri_0_2              SREL -> pri.enum
   pri_0_1              SREL -> pri.enum
   pri_0_0              SREL -> pri.enum
   pri_0_x              SREL -> pri.enum
   pri_x_4              SREL -> pri.enum
   pri_x_3              SREL -> pri.enum
   pri_x_2              SREL -> pri.enum
   pri_x_1              SREL -> pri.enum
   pri_x_0              SREL -> pri.enum
   pri_x_x              SREL -> pri.enum
   cap_reason           SREL -> bool.enum
   template_flag        SREL -> bool.enum
   last_mod_dt          DATE
   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED
   tenant               SREL -> tenant.id

Outcomes