text: -- Activity Types
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_RESEARCH',  '1', 'CONFG',  '1', 'Code corresponding to Activity Type: Research.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_INSTRUCTION',  '1', 'CONFG',  '2', 'Code corresponding to Activity Type: Instruction.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_PUBLIC_SERVICE',  '1', 'CONFG',  '3', 'Code corresponding to Activity Type: Public Service.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_CLINICAL_TRIAL',  '1', 'CONFG',  '4', 'Code corresponding to Activity Type: Clinical Trial.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_OTHER',  '1', 'CONFG',  '5', 'Code corresponding to Activity Type: Other.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_FELLOWSHIP_PRE_DOCTORAL',  '1', 'CONFG',  '6', 'Code corresponding to Activity Type: Fellowship - Pre-Doctoral.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_FELLOWSHIP_POST_DOCTORAL',  '1', 'CONFG',  '7', 'Code corresponding to Activity Type: Fellowship - Post-Doctoral.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_STUDENT_SERVICES',  '1', 'CONFG',  '8', 'Code corresponding to Activity Type: Student Services.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'ACTIVITY_TYPE_CODE_CONSTRUCTION',  '1', 'CONFG',  '9', 'Code corresponding to Activity Type: Construction.', 'A');
  
  -- S2S Submission Types
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'S2S_SUBMISSION_TYPE_CODE_PREAPPLICATION',  '1', 'CONFG',  '1', 'Code corresponding to S2S Submission Type: Pre-Application.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'S2S_SUBMISSION_TYPE_CODE_APPLICATION',  '1', 'CONFG',  '2', 'Code corresponding to S2S Submission Type: Application.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'S2S_SUBMISSION_TYPE_CODE_CHANGE_CORRECTED_APPLICATION',  '1', 'CONFG',  '3', 'Code corresponding to S2S Submission Type: Change/Corrected Application.', 'A');
  
  -- Proposal Types
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_NEW',  '1', 'CONFG',  '1', 'Code corresponding to Proposal Type: New.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_RESUBMISSION',  '1', 'CONFG',  '2', 'Code corresponding to Proposal Type: Resubmission.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_RENEWAL',  '1', 'CONFG',  '3', 'Code corresponding to Proposal Type: Renewal.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_CONTINUATION',  '1', 'CONFG',  '4', 'Code corresponding to Proposal Type: Continuation.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_REVISION',  '1', 'CONFG',  '5', 'Code corresponding to Proposal Type: Revision.', 'A');
  
  INSERT INTO KRNS_PARM_T(APPL_NMSPC_CD, NMSPC_CD, PARM_DTL_TYP_CD, PARM_NM, VER_NBR, PARM_TYP_CD, TXT, PARM_DESC_TXT, CONS_CD)
  VALUES('KC', 'KC-PD', 'D', 'PROPOSAL_TYPE_CODE_TASK_ORDER',  '1', 'CONFG',  '6', 'Code corresponding to Proposal Type: Task Order.',  'A');
  
  COMMIT;