Skip to main content
Standard Views | Policy
Updated over 10 months ago

Standard Views: Policy

View name: rpt.std_policy

Description: Basic information for Policies

Field

Data Type

Notes

policy_id

integer

References policy_id in rpt.policy

policy_name

text

policy_class_id

integer

policy_class

character varying (25)

funder_group_policy_id

integer

References funder_group_policy_id in rpt.funder_group_policy

policy_type_id

integer

policy_type

character varying (25)

policy_is_active

boolean

bluebook_id

integer

References bluebook_id in rpt.bluebook

bluebook_name

text

policy_is_disable_ffs

boolean

policy_is_disable_fee_override

boolean

policy_signed_on_date

date

policy_is_confirmed

boolean

policy_is_accept_assignment

boolean

policy_type_of_contract_is_inclusive

boolean

policy_type_of_service_is_corporate

boolean

policy_notes

text

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

tax_schedule_name

character varying (30)

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_public_policy_id

integer

References funder_public_policy_id in rpt.funder_public_policy

funder_public_policy_name

character varying (50)

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

Did this answer your question?