Worker View: Worker Intake Availability
View name: rpt.worker
Type: Record
Additional Description: Core Worker Information
Field | Data Type | Notes |
worker_id | integer |
|
entity_id | integer | References entity_id in rpt.entity |
worker_name | text |
|
worker_title | character varying (50) |
|
worker_qualification_id | integer |
|
worker_qualification | character varying (50) |
|
site_id | integer | References site_id in rpt.site |
Worker View: Worker Intake Availability
View name: rpt.worker_profile
Type: Profile
Additional Description: Worker Information
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
entity_id | integer | References entity_id in rpt.entity |
worker_name | text |
|
worker_title | character varying (50) |
|
worker_qualification_id | integer |
|
worker_qualification | character varying (50) |
|
site_id | integer | References site_id in rpt.site |
worker_report_to_worker_id | integer | References worker_id in rpt.worker |
worker_is_active | boolean |
|
worker_accepting_new_clients | boolean |
|
worker_notes | text |
|
worker_text_1 | text |
|
worker_text_2 | text |
|
worker_text_3 | text |
|
worker_text_4 | text |
|
worker_text_5 | text |
|
worker_text_6 | text |
|
worker_drop_down_1_id | integer |
|
worker_drop_down_1 | character varying (50) |
|
worker_drop_down_2_id | integer |
|
worker_drop_down_2 | character varying (50) |
|
worker_drop_down_3_id | integer |
|
worker_drop_down_3 | character varying (50) |
|
worker_drop_down_4_id | integer |
|
worker_drop_down_4 | character varying (50) |
|
worker_checkbox_1 | boolean |
|
worker_checkbox_2 | boolean |
|
worker_checkbox_3 | boolean |
|
worker_checkbox_4 | boolean |
|
worker_date_1 | date |
|
worker_date_2 | date |
|
worker_date_3 | date |
|
worker_date_4 | date |
|
worker_memo_1 | text |
|
worker_memo_2 | text |
|
worker_memo_3 | text |
|
worker_memo_4 | text |
|
worker_first_name | text |
|
worker_last_name | character varying (25) |
|
worker_client_facing_worker_name | character varying (250) |
|
worker_client_facing_profile_description | text |
|
Worker View: Worker Intake Availability
View name: rpt.worker_documents
Type: Cross Reference
Additional Description: Worker Completed Documents
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
document_id | integer | References document_id in rpt.document |
Worker View: Worker Intake Availability
View name: rpt.worker_categories
Type: List
Additional Description:
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
worker_category_id | integer |
|
worker_category | character varying (60) |
|
Worker View: Worker Intake Availability
View name: rpt.worker_intake_availability
Type: List
Additional Description:
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
worker_intake_availability_id | integer |
|
worker_intake_availability_type_id | character |
|
worker_intake_availability_type | character varying (50) |
|
worker_intake_availability_start_timestamp | timestamp without time zone |
|
worker_intake_availability_end_timestamp | timestamp without time zone |
|
worker_intake_availability_comment | character varying (100) |
|
Worker View: Worker Intake Availability
View name: rpt.worker_langauges
Type: List
Additional Description:
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
worker_language_id | integer |
|
worker_language | character varying (30) |
|
Worker View: Worker Intake Availability
View name: rpt.worker_rates
Type: List
Additional Description: Appear in Penelope on the User Defined tab
Field | Data Type | Notes |
worker_id | integer | References worker_id in rpt.worker |
worker_rate_id | integer |
|
worker_rate_name | character varying (60) |
|
worker_rate | numeric (10, 2) |
|