 /
 delete from krew_rule_attr_t where nm='XMLSearchableAttributeStdDateTime'
 /
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.CampusAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.CampusSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.SchoolAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.SchoolSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.ViceChancellorforAcademicAffairsandDeanOfFacultiesAdHocNetworkIdRoleAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC.AffirmativeActionOfficerAdHocNetworkIdRoleAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLDepartmentSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='InitiatorAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLOAASearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLSchoolAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='DFAC_OAASearchStatusInformalOfferSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLSchoolSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLExpectedStartDateSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLSalaryGradeSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLTotalApplicantsSearchAttribute'
+/
+DELETE FROM KREW_RULE_ATTR_T WHERE NM ='EDLTotalAMFsReceievedSearchAttribute'
+/
 
 -- Rule Templates
 

/
delete from krew_rule_t where doc_typ_nm is not null and doc_typ_nm not in (select doc_typ_nm from krew_doc_typ_t)
/

-- EDL


/
delete from krew_doc_typ_t where doc_typ_nm like 'Recipe%'
/
delete from krew_doc_typ_t where doc_typ_nm='OfficeOfAffirmativeAction'
/
delete from krew_doc_typ_t where doc_typ_nm='DFAC_OAA.WorkgroupTypeDoctype'
/
delete from krew_doc_typ_t where doc_typ_nm='OfferRequest'
/
delete from krew_doc_typ_t where doc_typ_nm='SearchStatus'
/
delete from krew_doc_typ_t where doc_typ_nm='VacancyNotice'
/
delete from krew_doc_typ_t where doc_typ_nm='WaiverRequest'
/
delete from krew_doc_typ_t where doc_typ_nm='LoadTest'
/
delete from krew_doc_typ_t where doc_typ_nm='InterviewRequest'
/
delete from krew_doc_typ_attr_t where DOC_TYP_ID not in (select doc_typ_id from KREW_DOC_TYP_T)
/
delete from krew_doc_typ_plcy_reln_t where DOC_TYP_ID not in (select doc_typ_id from KREW_DOC_TYP_T)
