desired_outcome_filter_rule

17 rows


Description

stores rules about when a desired outcome should be filtered out.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
desired_outcome_filter_rule_match_data.desired_outcome_filter_rule_id fk__referral_desired_outcome__referralR

the desired outcome filter rule unique identifier

desired_outcome_id uuid 2147483647 null
desired_outcome.id fk__desired_outcome_filter_rule__desired_outcomeR

the id of the desired outcome the filter rule is for

rule_type rule_type 2147483647 null

the type of rule the desired outcome is for. EXCLUSION or INCLUSION

match_type text 2147483647 null

the type of data that the rule should be compared against. Commonly contract-reference

Indexes

Constraint Name Type Sort Column(s)
desired_outcome_filter_rule_pkey Primary key Asc id

Relationships