insert into IA_PARTY(ID,PARTY_TYPE,NAME) VALUES (1,1,'SuperUser');
insert into IA_PARTY(ID,PARTY_TYPE,NAME) VALUES (2,1,'Admin');

insert into AI_AUTH_DETAILS(ID,USER_ID,USERNAME,PASSWORD,IDX) values (1, 1, 'admin', 'password', 0 );
insert into AI_AUTH_DETAILS(ID,USER_ID,USERNAME,PASSWORD,IDX) values (2, 2, 'sysadmin', 'password', 0 );

insert into PERMS_ROLE values ( 'com.k_int.apps.lpf.user', 'User');
insert into PERMS_ROLE values ( 'com.k_int.apps.lpf.admin', 'Administrator');
insert into PERMS_ROLE values ( 'com.k_int.apps.lpf.sysadmin', 'System Administrator');

insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (1,'admin','com.k_int.apps.lpf.user');
insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (2,'admin','com.k_int.apps.lpf.admin');
insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (3,'admin','com.k_int.apps.lpf.sysadmin');

insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (4,'sysadmin','com.k_int.apps.lpf.user');
insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (5,'sysadmin','com.k_int.apps.lpf.admin');
insert into PERMS_ROLE_GRANT_PARTY(ID,USERNAME,ROLE) VALUES (6,'sysadmin','com.k_int.apps.lpf.sysadmin');

insert into KICE_UI_DEVICE(ID,DEVICE_NAME) VALUES ( 1,'HTTP-BROWSER' );

insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (1,'com.k_int.apps.lpf.datamodel.ControlledTermHDO','Controlled Term');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (2,'com.k_int.apps.lpf.datamodel.ImplementationHDO','Implementation');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (3,'com.k_int.apps.lpf.datamodel.RequirementHDO','Requirement');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (4,'com.k_int.apps.lpf.datamodel.VocabHDO','Vocabulary');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (5,'com.k_int.apps.lpf.datamodel.SpecificationHDO','Specification');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (6,'com.k_int.svc.identity.datamodel.RegisteredUserHDO','User');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) VALUES (7,'com.k_int.apps.lpf.datamodel.ConceptLinkDTO','Concept Link');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) 
VALUES (8,'com.k_int.apps.lpf.datamodel.ControlledTermLinkDTO','Controlled Term Link');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) 
VALUES (9,'com.k_int.apps.lpf.datamodel.RequirementImplementationLinkDTO','Requirement Link');
insert into KICE_REGISTERED_MODEL ( ID, MODEL_CLASS_NAME, DESCRIPTION ) 
VALUES (10,'com.k_int.svc.identity.datamodel.AuthenticationDetailsHDO','Authentication Details');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (1,1,'lpf.ControlledTerm','Controlled Term');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (1,0,'Controlled Term','/WEB-INF/jsp/tiles/entity_templates/controlled_term/controlled_term.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (2,1,'lpf.Implementation','Implementation');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (2,0,'Implementation','/WEB-INF/jsp/tiles/entity_templates/implementation/implementation.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (3,1,'lpf.Requirement','Requirement');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (3,0,'Requirement','/WEB-INF/jsp/tiles/entity_templates/requirement/requirement.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (4,1,'lpf.Vocabulary','Vocabulary');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (3,0,'Requirement','/WEB-INF/jsp/tiles/entity_templates/requirement/requirement.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (4,1,'lpf.Vocabulary','Vocabulary');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (4,0,'Vocabulary','/WEB-INF/jsp/tiles/entity_templates/vocabulary/vocabulary.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (5,1,'lpf.Specification','Specification');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (5,0,'Specification','/WEB-INF/jsp/tiles/entity_templates/specification/specification.jsp');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (5,1,'LPF','/WEB-INF/jsp/tiles/entity_templates/specification/lpf.jsp');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (5,2,'IMP','/WEB-INF/jsp/tiles/entity_templates/specification/imp.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (6,1,'lpf.ConceptLink','Concept Link');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (6,0,'Concept Link','/WEB-INF/jsp/tiles/entity_templates/concept_link/concept_link.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (7,1,'lpf.User','User');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (7,0,'User Details','/WEB-INF/jsp/tiles/entity_templates/user/user.jsp');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (7,1,'User Roles','/WEB-INF/jsp/tiles/entity_templates/user/roles.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (8,1,'lpf.SpecType','Specification Type');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (8,0,'Specification Type','/WEB-INF/jsp/tiles/entity_templates/specification/specification_type.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (9,1,'lpf.RequirementType','Requirement Type');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (9,0,'User Details','/WEB-INF/jsp/tiles/entity_templates/requirement/requirement_type.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (10,1,'lpf.SectorRelevance','Sector Relevance');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (10,0,'User Details','/WEB-INF/jsp/tiles/entity_templates/requirement/sector_relevance.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (11,1,'lpf.ImplLink','Implementation Link');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (11,0,'Implementation','/WEB-INF/jsp/tiles/entity_templates/requirement/impl_link.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (12,1,'lpf.UserAuth','User Authentication');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (12,0,'Authentication','/WEB-INF/jsp/tiles/entity_templates/user/auth_method.jsp');

insert into KICE_LAYOUT(ID,LAYOUT_TYPE,LAYOUT_CODE,DESCRIPTION) VALUES (13,1,'lpf.RequirementCoverage','Requirement Coverage');
insert into KICE_WEB_LAYOUT_TABS(LAYOUT_ID,IND,TAB_LABEL,TILE_PATH) VALUES (13,0,'Requirement Coverage','/WEB-INF/jsp/tiles/entity_templates/specification/requirement_coverage.jsp');

insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 1, 1, 1,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 2, 2, 2,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 3, 3, 3,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 4, 4, 4,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 5, 5, 5,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 6, 6, 7,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 7, 7, 6,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 8, 8, 9,'lpf.RequirementType',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES ( 9, 8,10,'lpf.SectorRelevance',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES (10, 9,11,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES (11, 8, 8,'lpf.SpecType',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES (12, 10, 12,'DEFAULT',1);
insert into KICE_UI_MODEL_LAYOUT(ID,MODEL,LAYOUT,CONTEXT,DEVICE) VALUES (13, 8, 13,'lpf.RequirementCoverage',1);

insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (1, 'heading', 'Heading');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1001, 'Assessment',NULL,NULL,1,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1002, 'Metadata',NULL,NULL,1,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1003, 'Learner',NULL,NULL,1,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1004, 'Runtime',NULL,NULL,1,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1005, 'Services',NULL,NULL,1,4);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1006, 'Vocabularies',NULL,NULL,1,5);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1007, 'Other',NULL,NULL,1,6);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (2, 'type','Type');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1051, 'Binding',NULL,NULL,2,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1052, 'Data model',NULL,NULL,2,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1053, 'Guidelines',NULL,NULL,2,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1054, 'Mapping',NULL,NULL,2,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1055, 'Protocol',NULL,NULL,2,4);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1056, 'Technical',NULL,NULL,2,5);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1057, 'Vocabulary',NULL,NULL,2,6);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1058, 'Other',NULL,NULL,2,7);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (3, 'reqtype','Requirement Type');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1101, 'Administrative',NULL,NULL,3,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1102, 'Pedagogical',NULL,NULL,3,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1103, 'Support',NULL,NULL,3,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1104, 'Technical',NULL,NULL,3,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1105, 'Usability',NULL,NULL,3,4);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1106, 'Other',NULL,NULL,3,5);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (4, 'lpfstatus','LPF Status');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1201, 'A-Adopted',NULL,NULL,4,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1202, 'R-Recommended',NULL,NULL,4,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1203, 'U-Under Consideration',NULL,NULL,4,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1204, 'X-Will not be included',NULL,NULL,4,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1205, 'W-Withdrawn',NULL,NULL,4,4);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (5, 'sector_relevance','Sector Relevance');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1301, 'None',NULL,NULL,5,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1302, 'Pre-School',NULL,NULL,5,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1303, 'Primary School',NULL,NULL,5,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1304, 'Middle School',NULL,NULL,5,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1305, 'Secondary School',NULL,NULL,5,4);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1306, 'Post-16',NULL,NULL,5,5);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1307, 'Higher',NULL,NULL,5,6);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1308, 'Lifelong',NULL,NULL,5,7);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1309, 'Other',NULL,NULL,5,8);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (6, 'levelofimp','Level Of Implementation');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1401, '0 - None',NULL,NULL,6,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1402, '1 - Low',NULL,NULL,6,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1403, '2 - Medium',NULL,NULL,6,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1404, '3 - High',NULL,NULL,6,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1405, '4 - Complete (or Almost)',NULL,NULL,6,4);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (7, 'platcon','Platform Concepts');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1601, 'Accessibility for learners',NULL,NULL,7,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1602, 'Accessible Content',NULL,NULL,7,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1603, 'Assessment',NULL,NULL,7,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1604, 'Caching',NULL,NULL,7,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1605, 'Collaboration',NULL,NULL,7,4);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1606, 'Content Packaging',NULL,NULL,7,5);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1607, 'Content Runtime Behaviour',NULL,NULL,7,6);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1608, 'Content Sequencing',NULL,NULL,7,7);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1609, 'Digital Identifiers',NULL,NULL,7,8);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1610, 'Digital Rights',NULL,NULL,7,9);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1611, 'Exchange Protocols',NULL,NULL,7,10);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1612, 'Learner Competencies',NULL,NULL,7,11);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1613, 'Learner Support',NULL,NULL,7,12);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1614, 'Learning Design',NULL,NULL,7,13);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1615, 'Logistics',NULL,NULL,7,14);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1616, 'Metadata',NULL,NULL,7,15);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1701, 'Standard',NULL,NULL,9,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1702, 'Specification',NULL,NULL,9,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1703, 'Application Profile',NULL,NULL,9,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1704, 'Document Profile',NULL,NULL,9,3);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (10, 'status','Status');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1801, 'Draft',NULL,NULL,10,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1802, 'Final',NULL,NULL,10,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1803, 'Revised',NULL,NULL,10,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1804, 'Unavailable',NULL,NULL,10,3);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (11, 'fit','Level of fit');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1901, '0 - No fit',NULL,NULL,11,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1902, '1 - Low Partial Fit',NULL,NULL,11,1);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1903, '2 - High Partial Fit',NULL,NULL,11,2);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1904, '3 - Close or Exact Fit',NULL,NULL,11,3);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 1905, '4 - Essential Component',NULL,NULL,11,4);
insert into LPF_VOCAB (ID,NAME,DESCRIPTION) VALUES (12, 'termStatus','Term Status');
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 2001, 'Term is in use',NULL,NULL,12,0);
insert into LPF_CONTROLLED_TERM(ID,TERM,DESCRIPTION,NOTES,OWNER,IDX) VALUES ( 2002, 'Deprecated',NULL,NULL,12,0);
