Skip to main content
Standard Views | Worker
Updated over 3 years ago

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

Did this answer your question?