Funder Views

Funder_Views Standard Views

Updated over a week ago

Funder View: Funder

View name: rpt.funder

Type: Record

Description: Funder Core Information

Field

Data Type

funder_id

integer

funder_name

character varying (50)

Funder View: Funder Profile

View name: rpt.funder_profile

Type: Profile

Description: Funder Information

Field

Data Type

Notes

funder_id

integer

References funder_id in rpt.funder

funder_name

character varying (50)

funder_status_id

integer

funder_status

character varying (25)

funder_statement_cycle_id

integer

funder_statement_cycle

character varying (25)

funder_type_id

integer

funder_type

character varying (60)

funder_type_2_id

integer

funder_type_2

character varying (50)

funder_bill_to

character varying (50)

funder_class_id

integer

funder_class

text

tax_schedule_id

integer

References tax_schedule_id on rpt.tax_schedule

funder_notes

text

funder_text_1

character varying

funder_text_2

character varying

funder_drop_down_1_id

integer

funder_drop_down_1

character varying (50)

funder_drop_down_2_id

integer

funder_drop_down_2

character varying (50)

funder_checkbox_1

boolean

funder_checkbox_2

boolean

funder_date_1

date

funder_date_2

date

funder_memo_1

text

funder_memo_2

text

Funder View: Funder Public Policy

View name: rpt.funder_public_policy

Type: Record

Description: Funder Public Policy

Field

Data Type

Notes

funder_public_policy_id

integer

funder_public_policy_name

character varying (50)

funder_id

integer

References funder_id in rpt.funder

funder_public_policy_is_active

boolean

funder_public_policy_no

character varying

funder_public_policy_category_id

integer

funder_public_policy_category

character varying (25)

funder_public_policy_start_date

date

funder_public_policy_end_date

date

funder_public_policy_notes

text

Funder View: Funder Public Policy Rates

View name: rpt.funder_public_policy_rates

Type: Cross Reference

Description: Funder Public Policy Rates

Field

Data Type

Notes

funder_public_policy_id

integer

References funder_public_policy_id in rpt.funder_public_policy

service_unit_id

integer

References service_unit_id in rpt.service_unit

funder_public_policy_rate_by_dollar_rate

numeric

funder_public_policy_rate_by_percent_rate

numeric

funder_public_policy_rate_copay

numeric (10, 2)

Funder View: Funder Group Policy

View name: rpt.funder_group_policy

Type: Record

Description: Funder Group Policy

Field

Data Type

Notes

funder_group_policy_id

integer

funder_group_policy_name

character varying

funder_id

integer

References funder_id in rpt.funder

funder_group_policy_type_id

integer

funder_group_policy_type

character varying (25)

funder_group_policy_is_active

boolean

bluebook_id

integer

References bluebook_id in rpt.bluebook

funder_group_policy_is_disable_ffs

boolean

funder_group_policy_is_disable_fee_override

boolean

funder_group_policy_is_confirmed

boolean

funder_group_policy_type_of_contract_is_inclusive

boolean

funder_group_policy_type_of_service_is_corporate

boolean

funder_group_policy_notes

text

Funder View: Funder Group Policy Coverage

View name: rpt.funder_group_policy_coverage

Type: Record

Description: Funder Group Policy Coverage

Field

Data Type

Notes

funder_group_policy_coverage_id

integer

funder_group_policy_id

integer

References funder_group_policy_id in rpt.funder_group_policy

funder_group_policy_coverage_is_active

boolean

funder_group_policy_coverage_authorization

character varying

funder_group_policy_coverage_is_confirmed

boolean

funder_group_policy_coverage_no_show

numeric (6, 4)

funder_group_policy_coverage_item_limit

numeric (10, 2)

funder_group_policy_coverage_start_limit_date

date

funder_group_policy_coverage_end_limit_date

date

funder_group_policy_coverage_dollar_limit

numeric (10, 2)

funder_group_policy_coverage_notes

text

reauthorize_funder_group_policy_coverage_id

integer

References funder_group_policy_coverage_id in rpt.funder_group_policy_coverage

Funder View: Funder Group Policy Coverage Rates

View name: rpt.funder_group_policy_coverage_rates

Type: Cross Reference

Description: Funder Group Policy Coverage Rates

Field

Data Type

Notes

funder_group_policy_coverage_id

integer

References funder_group_policy_coverage_id in rpt.funder_group_policy_coverage

service_unit_id

integer

References service_unit_id in rpt.service_unit

funder_group_policy_coverage_rate_by_dollar_rate

numeric

funder_group_policy_coverage_rate_by_percent_rate

numeric

funder_group_policy_coverage_rate_copay

numeric (10, 2)

Funder View: Funder Documents

View name: rpt.funder_documents

Type: Cross Reference

Description: Funder Documents

Field

Data Type

Notes

funder_id

integer

References funder_id in rpt.funder

document_id

integer

References document_id in rpt.document

Funder View: Funder Service Unit Aliases

View name: rpt.funder_service_unit_aliases

Type: Cross Reference

Description: Funder Service Unit Aliases

Field

Data Type

Notes

funder_id

integer

References funder_id in rpt.funder

service_unit_id

integer

References service_unit_id in rpt.service_unit

funder_service_unit_alias

character varying (50)

Funder View: Funder Department

View name: rpt.funder_department

Type: List

Description: Funder Department

Field

Data Type

Notes

funder_department_id

integer

funder_department_name

text

funder_id

integer

References funder_id in rpt.funder

Funder View: Funder Population

View name: rpt.funder_population

Type: List

Description: Funder Population

Field

Data Type

Notes

funder_population_id

integer

funder_population

integer

funder_id

integer

References funder_id in rpt.funder

funder_population_date

date

funder_population_notes

text

Did this answer your question?