Changeset 21419 in main


Ignore:
Timestamp:
08/30/20 21:53:31 (4 weeks ago)
Author:
GarthBraithwaite_STG
Message:

db - updated topic paths to match NM content.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/db/src/main/scripts/mysql/data-topic.sql

    r19916 r21419  
    33delete from TOPIC;
    44
    5 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Characteristics", "Demographic Characteristics", "topic/population/demographics/characteristics/Detail.html", "Population: Demographic Characteristics selection.", 10, "x", now() );
    6 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Education", "Education",                         "topic/population/socialdeterminant/education/Detail.html", "Social Determinants of Health: Education selection.", 11, "x", now() );
    7 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "EconomicStability", "Economic Stability",        "topic/population/socialdeterminant/economic/Detail.html", "Social Determinants of Health: Income and Poverty selection.", 12, "x", now() );
    8 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "NeighborhoodEnv", "Neighborhood and Built Environment", "topic/population/socialdeterminant/neighborhood/Detail.html", "Neighborhood and built environments.", 15, "x", now() );
    9 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SocialCommunity", "Social and Community Context",       "topic/population/socialdeterminant/community/Detail.html", "Social and community settings in which people live and act.", 16, "x", now() );
     5insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Characteristics",   "Demographic Characteristics",        "topic/population/demographics/characteristics/Detail.html", "Population: Demographic Characteristics selection.", 10, "x", now() );
     6insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Education",         "Education",                          "topic/population/socialdeterminant/education/Detail.html", "Social Determinants of Health: Education selection.", 11, "x", now() );
     7insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "EconomicStability", "Economic Stability",                 "topic/population/socialdeterminant/economic/Detail.html", "Social Determinants of Health: Income and Poverty selection.", 12, "x", now() );
     8insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "NeighborhoodEnv",   "Neighborhood and Built Environment", "topic/population/socialdeterminant/neighborhood/Detail.html", "Neighborhood and built environments.", 15, "x", now() );
     9insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SocialCommunity",   "Social and Community Context",       "topic/population/socialdeterminant/community/Detail.html", "Social and community settings in which people live and act.", 16, "x", now() );
    1010
    1111
    1212insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Availability", "Availability",        "topic/healthcare/access/availability/Detail.html", "Access to Care: Availability selection.", 30, "x", now() );
    13 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Insurance", "Insurance",              "topic/healthcare/access/insurance/Detail.html", "Access to Health Insurance.", 31, "x", now() );
     13insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Insurance",    "Insurance",           "topic/healthcare/access/insurance/Detail.html", "Access to Health Insurance.", 31, "x", now() );
    1414
    1515insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "CancerScreening", "Cancer Screening", "topic/healthcare/utilization/screening/cancer/Detail.html", "Use of Preventive Services: Cancer Screening selection.", 40, "x", now() );
     
    2020
    2121
    22 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Alcohol", "Alcohol",            "topic/risk_resiliency/behavior/alcohol/Detail.html", "Health Behaviors: Alcohol selection.", 51, "x", now() );
    23 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Injury", "Injury",              "topic/risk_resiliency/behavior/injury/Detail.html", "Health Behaviors: Injury selection.", 52, "x", now() );
    24 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Nutrition", "Nutrition",        "topic/risk_resiliency/behavior/nutrition/Detail.html", "Health Behaviors: Nutrition selection.", 53, "x", now() );
    25 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "PhysicalActivity", "Physical Activity", "topic/risk_resiliency/behavior/activity/Detail.html", "Health Behaviors: Physical Activity selection.", 54, "x", now() );
    26 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "PhysicalEnvironment",           "Physical Environment", "topic/risk_resiliency/environment/physical/Detail.html", "Risk and Resiliency: Physical Environment selection.", 55, "x", now() );
    27 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Tobacco", "Tobacco",            "topic/risk_resiliency/behavior/tobacco/Detail.html", "Health Behaviors: Tobacco selection.", 56, "x", now() );
    28 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "WeightStatus", "Weight Status", "topic/risk_resiliency/behavior/weight/Detail.html", "Health Behaviors: Weight Status selection.", 57, "x", now() );
     22insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Alcohol", "Alcohol",            "topic/lifestyle/behavior/alcohol/Detail.html", "Health Behaviors: Alcohol selection.", 51, "x", now() );
     23insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Injury", "Injury",              "topic/lifestyle/behavior/injury/Detail.html", "Health Behaviors: Injury selection.", 52, "x", now() );
     24insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Nutrition", "Nutrition",        "topic/lifestyle/behavior/nutrition/Detail.html", "Health Behaviors: Nutrition selection.", 53, "x", now() );
     25insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "PhysicalActivity", "Physical Activity", "topic/lifestyle/behavior/activity/Detail.html", "Health Behaviors: Physical Activity selection.", 54, "x", now() );
     26insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "PhysicalEnvironment",           "Physical Environment", "topic/lifestyle/environment/physical/Detail.html", "Risk and Resiliency: Physical Environment selection.", 55, "x", now() );
     27insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Tobacco", "Tobacco",            "topic/lifestyle/behavior/tobacco/Detail.html", "Health Behaviors: Tobacco selection.", 56, "x", now() );
     28insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "WeightStatus", "Weight Status", "topic/lifestyle/behavior/weight/Detail.html", "Health Behaviors: Weight Status selection.", 57, "x", now() );
    2929
    3030
    31 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Cancer", "Cancer",                              "topic/healthoutcome/cancer/Detail.html", "Health Outcomes: Cancer selection.", 61, "x", now() );
    32 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "ChronicDisease", "Chronic Diseases and Conditions", "topic/healthoutcome/chronic/Detail.html", "Health Outcomes: Chronic Diseases and Conditions selection.", 62, "x", now() );
    33 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "InfectiousDiseases", "Infectious Diseases",     "topic/healthoutcome/infectious/Detail.html", "Health Outcomes: Infectious Diseases selection.", 63, "x", now() );
    34 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "InjuryViolence", "Injury and Violence",         "topic/healthoutcome/injury/Detail.html", "Health Outcomes: Injury and Violence selection.", 64, "x", now() );
    35 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "LeadingCausesDeath", "Leading Causes of Death", "topic/healthoutcome/death/Detail.html", "Health Outcomes: Leading Causes of Death selection.", 65, "x", now() );
    36 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "MentalHealth", "Mental Health",                 "topic/healthoutcome/mental/Detail.html", "Health Outcomes: Mental Health selection.", 66, "x", now() );
    37 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "MCH", "Mothers and Infants",                    "topic/healthoutcome/mch/Detail.html", "Health Outcomes: Mothers and Infants selection.", 67, "x", now() );
    38 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SubstanceAbuse", "Substance Abuse",             "topic/healthoutcome/substance/Detail.html", "Health Outcomes: Substance Abuse selection.", 68, "x", now() );
    39 insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SummaryMeasures", "Summary Measures of Health Status", "topic/healthoutcome/measures/Detail.html", "Health Outcomes: Summary Measures of Health Status selection.", 69, "x", now() );
     31insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Cancer", "Cancer",                              "topic/healthstatus/cancer/Detail.html", "Health Outcomes: Cancer selection.", 61, "x", now() );
     32insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "ChronicDisease", "Chronic Diseases and Conditions", "topic/healthstatus/disease/chronic/Detail.html", "Health Outcomes: Chronic Diseases and Conditions selection.", 62, "x", now() );
     33insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "InfectiousDiseases", "Infectious Diseases",     "topic/healthstatus/disease/infectious/Detail.html", "Health Outcomes: Infectious Diseases selection.", 63, "x", now() );
     34insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "InjuryViolence", "Injury and Violence",         "topic/healthstatus/injury/Detail.html", "Health Outcomes: Injury and Violence selection.", 64, "x", now() );
     35insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "LeadingCausesDeath", "Leading Causes of Death", "topic/healthstatus/death/Detail.html", "Health Outcomes: Leading Causes of Death selection.", 65, "x", now() );
     36insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "MentalHealth", "Mental Health",                 "topic/healthstatus/mental/Detail.html", "Health Outcomes: Mental Health selection.", 66, "x", now() );
     37insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "MCH", "Mothers and Infants",                    "topic/healthstatus/mch/Detail.html", "Health Outcomes: Mothers and Infants selection.", 67, "x", now() );
     38insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SubstanceAbuse", "Substance Abuse",             "topic/healthstatus/substance/Detail.html", "Health Outcomes: Substance Abuse selection.", 68, "x", now() );
     39insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "SummaryMeasures", "Summary Measures of Health Status", "topic/healthstatus/measures/Detail.html", "Health Outcomes: Summary Measures of Health Status selection.", 69, "x", now() );
    4040
     41/* not used by Lois */
    4142insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "Employment", "Employment",                              "topic/population/socialdeterminant/employment/Detail.html", "Social Determinants of Health: Employment selection.", 13, null, now() );
    4243insert into TOPIC (NAME, TITLE, URL, DESCRIPTION, SORT_ORDER, ACTIVE_FLAG, MODIFIED_DATE) values ( "HealthcareAccessCost", "Health Care Coverage and Cost", "topic/population/socialdeterminant/access/Detail.html", "Access to Care: Health Care Coverage and Cost selection.", 14, null, now() );
Note: See TracChangeset for help on using the changeset viewer.