Standard Views | Worker

View name: rpt.std_worker

Description: Worker Profile information including basic information about the Report To Worker, with worker_languages linked in.

Field	Data Type	Notes
worker_id	integer	References worker_id in rpt.worker
worker_entity_id	integer	References entity_id in rpt.entity
worker_name	text
worker_title	character varying
worker_qualification_id	integer
worker_qualification	character varying
worker_site_id	integer	Refences site_id in rpt.site
worker_site_name	character varying
worker_report_to_worker_id	integer	References worker_id in rpt.worker
worker_report_to_worker_entity_id	integer	References entity_id in rpt.entity
worker_report_to_worker_name	text
worker_report_to_worker_title	character varying
worker_report_to_worker_qualification_id	integer
worker_report_to_worker_qualification	character varying
worker_report_to_worker_site_id	integer	Refences site_id in rpt.site
worker_report_to_worker_site_name	character varying
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
worker_drop_down_2_id	integer
worker_drop_down_2	character varying
worker_drop_down_3_id	integer
worker_drop_down_3	character varying
worker_drop_down_4_id	integer
worker_drop_down_4	character varying
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_language_1_id	integer
worker_language_1	character varying
worker_language_2_id	integer
worker_language_2	character varying
worker_language_3_id	integer
worker_language_3	character varying

Views and Standard Views