Document View: Document
View name: rpt.document
Type: Record
Description: Completed Document Information
Field | Data Type | Notes |
document_id | integer |
|
document_description | text |
|
document_date | date |
|
document_is_locked | boolean |
|
document_template_id | integer | References document_template_id in rpt.document_template |
document_template_stage_id | integer | References document_template_stage_id in rpt.document_template_stage |
Document View: Document Body
View name: rpt.document_body
Type: Record
Description: Completed Document Body Information
Field | Data Type | Notes |
document_body_id | integer |
|
document_body_name | text |
|
document_template_id | integer | References document_template_id in rpt.document_template |
document_id | integer | References document_id in rpt.document |
entity_id | integer | References entity_id in rpt.entity |
Document View: Document Answer Details
View name: rpt.document_answer_details
Type: Detail
Description: Completed Document Answer Detail Information
Field | Data Type | Notes |
document_answer_details_id | integer |
|
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
other_answer | text |
|
answer_comment | text |
|
is_answered | boolean |
|
composite_key_document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
Document View: Document Answer Boolean
View name: rpt.document_answer_boolean
Type: Record
Description: Completed Answers to Boolean Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
answer_boolean | boolean |
Document View: Document Answer Boolean Profile
View name: rpt.document_answer_boolean_profile
Type: Record
Description: Completed Answers to Boolean Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
answer_boolean | boolean |
Document View: Document Answer Date
View name: rpt.document_answer_date
Type: Record
Description: Completed Answers to Date Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
answer_date | date |
|
|
|
Document View: Document Answer Date Profile
View name: rpt.document_answer_date_profile
Type: Record
Description: Completed Answers to Date Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
answer_date | date |
Document View: Document Answer List
View name: rpt.document_answer_list
Type: Record
Description: Completed Answers to List Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_template_list_item_id | integer | References document_template_list_item_id in rpt.document_template_list_item |
Document View: Document Answer List Profile
View name: rpt.document_answer_list_profile
Type: Record
Description: Completed Answers to List Questions including Other Answers
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
document_template_list_item_id | integer | References document_template_list_item_id in rpt.document_template_list_item - This value will be NULL for Other Answers |
answer_list | text | Text value of the List Item selected or the text that was entered in the othe answer. |
Document View: Document Answer Number
View name: rpt.document_answer_number
Type: Record
Description: Completed Answers to Number Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
answer_number | numeric(10,2) |
Document View: Document Answer Number Profile
View name: rpt.document_answer_number_profile
Type: Record
Description: Completed Answers to Number Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
answer_number | numeric(10,2) |
Document View: Document Answer Service
View name: rpt.document_answer_service
Type: Record
Description: Completed Answers to Service Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
service_id | integer | References service_id in rpt.service |
Document View: Document Answer Service Profile
View name: rpt.document_answer_service_profile
Type: Record
Description: Completed Answers to Service Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
service_id | integer | References service_id in rpt.service |
service_name | text |
Document View: Document Answer Site
View name: rpt.document_answer_site
Type: Record
Description: Completed Answers to Site Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
site_id | integer | References site_id in rpt.site |
Document View: Document Answer Site Profile
View name: rpt.document_answer_site_profile
Type: Record
Description: Completed Answers to Site Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
site_id | integer | References site_id in rpt.site |
site_name | text |
Document View: Document Answer Worker
View name: rpt.document_answer_worker
Type: Record
Description: Completed Answers to Worker Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
worker_id | integer | References worker_id in rpt.worker |
Document View: Document Answer Worker Profile
View name: rpt.document_answer_worker_profile
Type: Record
Description: Completed Answers to Worker Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
worker_id | integer | References worker_id in rpt.worker |
worker_name | text |
Document View: Document Answer Text
View name: rpt.document_answer_text
Type: Record
Description: Completed Answers to Text Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
answer_text | text |
Document View: Document Answer Text Profile
View name: rpt.document_answer_text_profile
Type: Record
Description: Completed Answers to Text Questions
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_question_id | integer | References document_template_question_id in rpt.document_template_question |
answer_text | text |
Document View: Document Scores
View name: rpt.document_scores
Type: Cross
Description: Completed Document Score Information
Field | Data Type | Notes |
document_body_id | integer | References document_body_id in rpt.document_body |
document_template_score_id | integer | References document_template_score_id in rpt.document_template_score |
score | numeric(12,4) |
Document View: Document Score Details
View name: rpt.document_score_details
Type: Details
Description: Completed Document Score Details Information
Field | Data Type | Notes |
document_answer_details_id | integer | References document_answer_details_id in rpt.document_answer_details |
document_template_score_id | integer | References document_template_score_id in rpt.document_template_score |
raw_score | numeric(10,2) |
|
weighted_score | numeric(12,4) |
Document View: Document Signatures
View name: rpt.document_signatures
Type: List
Description: Completed Document Signatures Information
Field | Data Type | Notes |
document_id | integer | References document_id in rpt.document |
document_signature_id | integer |
|
document_signature_type_id | integer |
|
document_signature_type | text |
|
entity_id | integer | References entity_id in rpt.entity |
document_signature_date | date |
|
document_signed_by | text |
|
document_signature_text | text |