def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnablePullingProviderInformationFromNPPESForChartReview', 'EnablePullingProviderInformationFromNPPESForMedicalClaim')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) enable_chart_review = IPreProcessScript.to_boolean(configurations[ 'EnablePullingProviderInformationFromNPPESForChartReview']) enable_claim = IPreProcessScript.to_boolean(configurations[ 'EnablePullingProviderInformationFromNPPESForMedicalClaim']) if enable_chart_review is False and enable_claim is False: return False self._load_npi_configurations() if enable_chart_review and enable_claim: return True is_chart_review = self.file_name.startswith('ChartReview_Merged_') if enable_chart_review and is_chart_review: return True elif enable_claim and is_chart_review is False: return True return False
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableClaimDiagnosisFlattening')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnableClaimDiagnosisFlattening']) is False: return False self.claim_id_index = self.map_columns.where( lambda x: x['redshift_name' ] == 'claim_id_medical_claim_header').first()['index'] claim_type_code_field = self.map_columns.where(lambda x: x[ 'redshift_name'] == 'medical_claim_type_code_medical_claims_header' ).first_or_default() if claim_type_code_field is None: return False self.claim_type_code_index = claim_type_code_field['index'] claim_line_number_field = self.map_columns.where( lambda x: x['redshift_name'] == 'claim_line_number_medical_claims_detail').first_or_default() if claim_line_number_field is None: return False self.claim_line_number_index = claim_line_number_field['index'] return True
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableLinkedClaimIdPopulationFromPreviousClaimId')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean(configurations['EnableLinkedClaimIdPopulationFromPreviousClaimId']) is False: return False return self.has_required_column()
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableClaimHICNReplacement', 'MBITransitionDate')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnableClaimHICNReplacement']) is False: return False self.mbi_transition_date = configurations['MBITransitionDate'] return self._has_required_column()
def will_execute(self): query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableDataLoadingFilterCriteria', 'DataLoadingFilterCriteria')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnableDataLoadingFilterCriteria'] ) is False or configurations['DataLoadingFilterCriteria'].strip( ) == '': return False self.data_loading_filter_criteria = FilterExpressionParser( configurations['DataLoadingFilterCriteria'].lower(), self.header_columns).to_filter_expression() if self.data_loading_filter_criteria: return True return False
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableLoadingWeeklyPaidClaims')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnableLoadingWeeklyPaidClaims']) is False: return False paid_date_field = self.map_columns.where( lambda x: x['redshift_name'] == 'paid_date_medical_claims_header' ).first_or_default() if paid_date_field: self.paid_date_index = paid_date_field['index'] return True return False
def will_execute(self): if self.entity_type not in ['Claim', 'DentalClaim']: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableDentalAndMedicalClaimExtractor')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean(configurations['EnableDentalAndMedicalClaimExtractor']) is False: return False if self.entity_type == 'DentalClaim': procedure_code = self.map_columns.where(lambda x: x['redshift_name'] == 'procedure_code_dental_claim_detail').first_or_default() else: procedure_code = self.map_columns.where(lambda x: x['redshift_name'] == 'procedure_code_medical_claims_detail').first_or_default() if procedure_code is None: return False self.procedure_code_index = procedure_code['index'] return True
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnableChartPOSTOBPopulation')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnableChartPOSTOBPopulation']) is False: return False is_chart_review = rds_provider.fetch_one( 'SELECT IsChartReview FROM ControlFiles WHERE Id={}'.format( self.control_file_id))[0] if is_chart_review is False: return False provider_type_field = self.map_columns.where(lambda x: x[ 'redshift_name'] == 'medical_claim_type_code_medical_claims_header' ).first_or_default() if provider_type_field is None: return False self.provider_type_code_index = provider_type_field['index'] place_of_service_code_field = self.map_columns.where( lambda x: x['redshift_name'] == 'place_of_service_code_medical_claims_header').first_or_default() if place_of_service_code_field is not None: self.place_of_service_code_index = place_of_service_code_field[ 'index'] type_of_bill_code_field = self.map_columns.where( lambda x: x['redshift_name'] == 'type_of_bill_code_medical_claims_header').first_or_default() if type_of_bill_code_field is not None: self.type_of_bill_code_index = type_of_bill_code_field['index'] if place_of_service_code_field is None and type_of_bill_code_field is None: return False return True
def will_execute(self): if self.entity_type != EntityType.Claim.name: return False query = "SELECT [Key],Value FROM Configurations WHERE [Key] IN ('EnablePopulatingDiagnosisPointer')" data = rds_provider.fetch_all(query) configurations = dict((k[0], k[1]) for k in data) if IPreProcessScript.to_boolean( configurations['EnablePopulatingDiagnosisPointer']) is False: return False is_chart_review = self.file_name.startswith('ChartReview_Merged_') if is_chart_review: return False claim_type_code_field = self.map_columns.where(lambda x: x[ 'redshift_name'] == 'medical_claim_type_code_medical_claims_header' ).first_or_default() if claim_type_code_field is None: return False self.claim_type_code_index = claim_type_code_field['index'] return True