Worker View

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)

Views and Standard Views