Document Views
Updated over a week ago

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

Did this answer your question?