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

Views and Standard Views