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
|