text: DELIMITER /
  update KRMS_TYP_T set NMSPC_CD='KC-KRMS' where SRVC_NM in 
  	('{http://kc.kuali.org/core/v5_0}javaFunctionTermResolverTypeService',
  		'{http://kc.kuali.org/core/v5_0}storedFunctionTermResolverTypeService') and NMSPC_CD='KC-PD'
  /
  -- public String multiplePI(DevelopmentProposal developmentProposal);    
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2028','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='multiplePI' and NMSPC_CD='KC-PD'),
  					'Check multi-pis for proposal','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2025',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='multiplePI' and NMSPC_CD='KC-PD')),
  			1,'Check multi-pis for proposal')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2028','KC-PD-CONTEXT',
  					(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='multiplePI' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='multiplePI' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2024','KC-PD','Multi PI Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='multiplePI' and NMSPC_CD='KC-PD')),'Y',1)
  /
  -- public String s2sBudgetRule(DevelopmentProposal developmentProposal, String formNames);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2029','KC-PD',
  				(select FUNC_ID from KRMS_FUNC_T where  NM='s2sBudgetRule' and NMSPC_CD='KC-PD'),
  				'Has specified s2s form exists','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2029','KC-PD-CONTEXT',
  					(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sBudgetRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sBudgetRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2025','KC-PD','S2s form includes Resolver',
  		(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  		(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sBudgetRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2023', 
  			(select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='S2s form includes Resolver' and NMSPC_CD='KC-PD'), 'S2s forms', 1)
  /
  -- public String monitoredSponsorRule(DevelopmentProposal developmentProposal, String monitoredSponsorHirearchies);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2030','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='monitoredSponsorRule' and NMSPC_CD='KC-PD'),
  			'Check proposal has a sponsor monitored for COI','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2030','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='monitoredSponsorRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='monitoredSponsorRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2026','KC-PD','Coi monitored sponsor resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  	(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='monitoredSponsorRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2024', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Coi monitored sponsor resolver' and NMSPC_CD='KC-PD'), 
  				'Sponsored hirearchies (comma delimited)', 1)
  /
  -- public String s2sResplanRule(DevelopmentProposal developmentProposal, String narativeTypes, String maxNumber);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2031','KC-PD',
  			(select FUNC_ID from KRMS_FUNC_T where  NM='s2sResplanRule' and NMSPC_CD='KC-PD'),
  			'Maximum number of the narrative types','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2031','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sResplanRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sResplanRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2027','KC-PD','Max Narrative Types Resolver',
  					(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  					(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sResplanRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2025', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Max Narrative Types Resolver' and NMSPC_CD='KC-PD'), 'Narrative Type (comma delimited)', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2026', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Max Narrative Types Resolver' and NMSPC_CD='KC-PD'), 'Max Number', 1)
  /
  -- public String grantsFormRule(DevelopmentProposal developmentProposal, String formName);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2032','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='grantsFormRule' and NMSPC_CD='KC-PD'),
  		'Proposal has associated the s2s form passed in','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2032','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='grantsFormRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='grantsFormRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2028','KC-PD','Grants.Gov Form Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='grantsFormRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2027', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Grants.Gov Form Resolver' and NMSPC_CD='KC-PD'), 'Grants.Gov Form Name', 1)
  /
  --    public String biosketchFileNameRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2033','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='biosketchFileNameRule' and NMSPC_CD='KC-PD'),
  				'Biosketch name contains any restricted characters','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2026',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='biosketchFileNameRule' and NMSPC_CD='KC-PD')),
  					1,'Biosketch name contains any restricted characters')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2033','KC-PD-CONTEXT','KC2033','Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='biosketchFileNameRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2029','KC-PD','Biosketch Name Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='biosketchFileNameRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String ospAdminPropPersonRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2034','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='ospAdminPropPersonRule' and NMSPC_CD='KC-PD'),
  			'is OSP administrator also a personal person','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2027',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='ospAdminPropPersonRule' and NMSPC_CD='KC-PD')),
  					1,'OSP administrator also a personal person')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2034','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='ospAdminPropPersonRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='ospAdminPropPersonRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2030','KC-PD','OSP Admin Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  	(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='ospAdminPropPersonRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String divisionCodeRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2035','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeRule' and NMSPC_CD='KC-PD'),
  	'is proposal division code null','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2028',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeRule' and NMSPC_CD='KC-PD')),
  					1,'Is proposal division code null?')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2035','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2031','KC-PD','Division Code Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String agencyProgramCodeNullRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2036','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='agencyProgramCodeNullRule' and NMSPC_CD='KC-PD'),
  			'Is agency program code null?','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2029',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='agencyProgramCodeNullRule' and NMSPC_CD='KC-PD')),
  					1,'Is agency program code null?')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2036','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='agencyProgramCodeNullRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='agencyProgramCodeNullRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2032','KC-PD','Agency Program Code Check Resolver',
  			(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='agencyProgramCodeNullRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String proposalGrantsRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2038','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='proposalGrantsRule' and NMSPC_CD='KC-PD'),
  			'Has it submitted to Grants.Gov?','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2031',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalGrantsRule' and NMSPC_CD='KC-PD')),
  					1,'Has the proposal submitted to Grants.Gov?')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2038','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalGrantsRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalGrantsRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2034','KC-PD','Grants.Gov Submission Check Resolver',
  		(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  		(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalGrantsRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String narrativeFileName(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2039','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeFileName' and NMSPC_CD='KC-PD'),
  		'Check special character in the file name','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2032',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeFileName' and NMSPC_CD='KC-PD')),
  					1,'Check special character in the file name')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2039','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeFileName' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeFileName' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2035','KC-PD','Narrative Filename Check Resolver',
  			(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeFileName' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String narrativeTypeRule(DevelopmentProposal developmentProposal,String narrativeTypeCode);
  insert into KRMS_FUNC_PARM_T (FUNC_PARM_ID,FUNC_ID,NM,DESC_TXT,TYP,SEQ_NO) 
  	values ('KC0090',(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeTypeRule' and NMSPC_CD='KC-PD'),
  			'Narrative Type Code','Narrative Type Code','java.lang.String',1)
  /
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2040','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeTypeRule' and NMSPC_CD='KC-PD'),
  			'Check specified narrative type','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2040','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeTypeRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeTypeRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2036','KC-PD','Narrative Type Check Resolver',
  			(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='narrativeTypeRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2028', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Narrative Type Check Resolver' and NMSPC_CD='KC-PD'), 
  				'Narrative Type Code', 1)
  /
  --    public String costElementVersionLimit(DevelopmentProposal developmentProposal, String versionNumber, String costElementName, String limit);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2041','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='costElementVersionLimit' and NMSPC_CD='KC-PD'),
  	'Check specified narrative type','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2041','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementVersionLimit' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementVersionLimit' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2037','KC-PD','Cost Limit Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementVersionLimit' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2029', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Cost Limit Check Resolver' and NMSPC_CD='KC-PD'), 'Budget Version', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2030', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Cost Limit Check Resolver' and NMSPC_CD='KC-PD'), 'Cost Element', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2031', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Cost Limit Check Resolver' and NMSPC_CD='KC-PD'), 'Cost Limit', 1)
  /
  --    public String divisionCodeIsFellowship(DevelopmentProposal developmentProposal, String fellowshipCodes);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2042','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeIsFellowship' and NMSPC_CD='KC-PD'),
  				'Check specified narrative type','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2042','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeIsFellowship' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeIsFellowship' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2038','KC-PD','Fellowship Code Check Resolver',
  			(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='divisionCodeIsFellowship' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2032', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Fellowship Code Check Resolver' and NMSPC_CD='KC-PD'), 'Fellowship Codes', 1)
  /
  --    public String investigatorKeyPersonCertificationRule(DevelopmentProposal developmentProposal);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2043','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='investigatorKeyPersonCertificationRule' and NMSPC_CD='KC-PD'),
  				'Check Investigator Certified','java.lang.Boolean','Y',1)
  /
  insert into KRMS_TERM_T(TERM_ID,TERM_SPEC_ID,VER_NBR,DESC_TXT) 
  	values ('KC2033',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='investigatorKeyPersonCertificationRule' and NMSPC_CD='KC-PD')),1,'Check Investigator Certified')
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2043','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='investigatorKeyPersonCertificationRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='investigatorKeyPersonCertificationRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2039','KC-PD','Certify Investigator Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  					(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='investigatorKeyPersonCertificationRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  --    public String checkProposalPerson(DevelopmentProposal developmentProposal, String personId);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2044','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='checkProposalPerson' and NMSPC_CD='KC-PD'),
  				'Check Proposal Person','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2044','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='checkProposalPerson' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='checkProposalPerson' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2040','KC-PD','Proposal Person Check Resolver',
  				(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  				(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='checkProposalPerson' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2033', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Proposal Person Check Resolver' and NMSPC_CD='KC-PD'), 'Person Id', 1)
  /
  --    public String proposalLeadUnitInHierarchy(DevelopmentProposal developmentProposal, String unitNumberToCheck);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2045','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='proposalLeadUnitInHierarchy' and NMSPC_CD='KC-PD'),
  			'Check unit number','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2045','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalLeadUnitInHierarchy' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalLeadUnitInHierarchy' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2041','KC-PD','Lead Unit Check Resolver',
  				(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  				(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='proposalLeadUnitInHierarchy' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2034', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Lead Unit Check Resolver' and NMSPC_CD='KC-PD'), 'Unit Number', 1)
  /
  --    public String s2sSubawardRule(DevelopmentProposal developmentProposal, String rrFormNames, String phsFromNames);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2046','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='s2sSubawardRule' and NMSPC_CD='KC-PD'),
  		'Check RR forms and Phs Forms','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2046','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sSubawardRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sSubawardRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2042','KC-PD','RR Form Check Resolver',(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2sSubawardRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2035', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='RR Form Check Resolver' and NMSPC_CD='KC-PD'), 'RR Form names', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2036', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='RR Form Check Resolver' and NMSPC_CD='KC-PD'), 'Phs Form names', 1)
  /
  --    public String s2s398CoverRule(DevelopmentProposal developmentProposal, String PHSCoverLetters, String narrativeTypeCode);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2047','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='s2s398CoverRule' and NMSPC_CD='KC-PD'),
  					'Check Narrative requirements for Phs Forms','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2047','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2s398CoverRule' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2s398CoverRule' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2043','KC-PD','Phs form narrative check Resolver',
  				(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  				(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='s2s398CoverRule' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2037', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Phs form narrative check Resolver' and NMSPC_CD='KC-PD'), 'Phs Cover Letter forms', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2038', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Phs form narrative check Resolver' and NMSPC_CD='KC-PD'), 'Narrative Type Code', 1)
  /
  --    public String costElementInVersion(DevelopmentProposal developmentProposal, String versionNumber, String costElement);
  insert into KRMS_TERM_SPEC_T (TERM_SPEC_ID, NMSPC_CD, NM, DESC_TXT, TYP, ACTV, VER_NBR) 
  	values ('KC2048','KC-PD',(select FUNC_ID from KRMS_FUNC_T where  NM='costElementInVersion' and NMSPC_CD='KC-PD'),
  			'Check Cost Element in Budget version','java.lang.Boolean','Y',1)
  /
  insert into KRMS_CNTXT_VLD_TERM_SPEC_T (CNTXT_TERM_SPEC_PREREQ_ID, CNTXT_ID, TERM_SPEC_ID, PREREQ) 
  	values ('KC2048','KC-PD-CONTEXT',(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementInVersion' and NMSPC_CD='KC-PD')),'Y')
  /
  insert into KRMS_TERM_SPEC_CTGRY_T (TERM_SPEC_ID, CTGRY_ID) 
  	values ((select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementInVersion' and NMSPC_CD='KC-PD')), 
  			(select CTGRY_ID from KRMS_CTGRY_T where NMSPC_CD='KC-PD' and NM='Function'))
  /
  insert into KRMS_TERM_RSLVR_T (TERM_RSLVR_ID, NMSPC_CD, NM, TYP_ID, OUTPUT_TERM_SPEC_ID, ACTV, VER_NBR) 
  	values ('KC2044','KC-PD','Cost Element check Resolver',
  			(select TYP_ID from KRMS_TYP_T where NM='Function Term Resolver Type Service' and NMSPC_CD='KC-KRMS'),
  			(select TERM_SPEC_ID from KRMS_TERM_SPEC_T where NMSPC_CD='KC-PD' and 
  					NM=(select FUNC_ID from KRMS_FUNC_T where  NM='costElementInVersion' and NMSPC_CD='KC-PD')),'Y',1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2039', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Cost Element check Resolver' and NMSPC_CD='KC-PD'), 'Budget Version Number', 1)
  /
  insert into KRMS_TERM_RSLVR_PARM_SPEC_T (TERM_RSLVR_PARM_SPEC_ID, TERM_RSLVR_ID, NM, VER_NBR) 
  	values ('KC2040', (select TERM_RSLVR_ID from KRMS_TERM_RSLVR_T where NM='Cost Element check Resolver' and NMSPC_CD='KC-PD'), 'Cost Element', 1)
  /
  
  DELIMITER ;
  