source: main/trunk/db/src/main/scripts/mysql/tab_c-initative.sql @ 17716

Last change on this file since 17716 was 17716, checked in by GarthBraithwaite_STG, 9 months ago

db, admin, view, java - Added INITIATIVE GOAL and BASELINE values to the db and beans. Added ability to publish the raw INITs. Added updated kendo code to deal with some charts not expanding to 100% when contained within a hidden block. Also added window event to resize the chart. Fixed chart title adding mult \n when grid sort clicked. Added inputOnChangeAttribute to the ContentContainer?.xslt to allow js event handling on expand/collapse. Updated IP and QM result script generations to be similar.

File size: 3.8 KB
Line 
1/* Replacement for HPO */
2
3use ibisph;
4
5create table INITIATIVE(
6  NAME                            varchar  (100)  not null,             /* HP2020, HP2010, State */
7  TITLE                           varchar  (100)  not null,             /* The main text shown to the left - the label */
8  DESCRIPTION                     varchar  (500),
9  /* */
10  URL                             varchar (1024),                               /* optional main page: https://www.healthypeople.gov/    or   https://www.healthypeople.gov/2020/topics-objectives */
11  /* */
12  SORT_ORDER                      int             default null,
13  ACTIVE_FLAG                     varchar    (1),
14  MODIFIED_DATE                   datetime,
15  /* */
16  constraint INITIATIVE_PK
17    primary key (NAME)
18);
19
20
21create table INITIATIVE_TOPIC(                                  /* Old HP Focus Area */
22  INITIATIVE_NAME                 varchar  (100)  not null,             /* HP2020 */
23  NAME                            varchar  (100)  not null,             /* HP2020.RespiratoryDiseases */
24  TITLE                           varchar  (100)  not null,             /* Respiratory Diseases */
25  DESCRIPTION                     varchar  (500),
26  /* */
27  NARRATIVE                       varchar (4000),                               /* optional overview/narrative text - this is the "other objectives" - correct??? */
28  URL                             varchar (1024),                               /* optional overview page/narrative text page: https://www.healthypeople.gov/2020/topics-objectives/topic/respiratory-diseases */
29  /* */
30  SORT_ORDER                      int             default null,
31  ACTIVE_FLAG                     varchar    (1),
32  MODIFIED_DATE                   datetime,
33  /* */
34  constraint INITIATIVE_TOPIC_PK
35    primary key (NAME)
36);
37
38
39create table INITIATIVE_TOPIC_OBJECTIVE(
40  INITIATIVE_TOPIC_NAME           varchar  (100)  not null,             /* HP2020.RespiratoryDiseases */
41  NAME                            varchar  (100)  not null,             /* HP2020.RespiratoryDiseases.RD-1 */
42  TITLE                           varchar  (100)  not null,             /* Healthy People 2020 Objective AHS-1 - user selection and on report page as the target's title */
43  DESCRIPTION                     varchar  (500),
44  /* */
45  NARRATIVE                       varchar (4000)  not null,             /* Text that appears below the main title.  Reduce asthma deaths blah, blah ... */
46  URL                             varchar (1024),                               /* optional link to details: https://www.healthypeople.gov/2020/topics-objectives/topic/respiratory-diseases/objectives */
47  /* */
48  TARGET_LABEL                    varchar   (30)  not null,             /* Label for the target on the view report.  U.S. Target */
49  TARGET_NARRATIVE                varchar (4000),                               /* provides additional target definitions for age groups etc. */ 
50  MEASURE_NAME                    varchar  (100),                               /* assoc with the values and used to get the desired value (0 - oo) and to match IP records */
51  TARGET_BASELINE_VALUE           double,                                               /* starting point value used for comparison*/
52  TARGET_GOAL_VALUE               double,                                               /* end point value used for comparison */
53  /* */
54  SORT_ORDER                      int             default null,
55  ACTIVE_FLAG                     varchar    (1),
56  MODIFIED_DATE                   datetime,
57  /* */
58  constraint INITIATIVE_TOPIC_OBJECTIVE_PK
59    primary key (NAME)
60);
61
62
63create table INITIATIV_TOPIC_OBJ_TO_INDICAT(
64  INITIATIVE_TOPIC_NAME           varchar  (100)  not null,             /* makes it easy to delete all assoc IP to ITO records. */
65  INITIATIVE_TOPIC_OBJECT_NAME    varchar  (100)  not null,
66  INDICATOR_NAME                  varchar  (100)  not null,
67  /* */
68  SORT_ORDER                      int             default null,
69  /* */
70  constraint INIT_TOPIC_OBJ_TO_INDICATOR_PK
71    primary key (INITIATIVE_TOPIC_OBJECT_NAME, INDICATOR_NAME)
72);
73
74/*------------------------------ END OF FILE ------------------------------*/
Note: See TracBrowser for help on using the repository browser.