Document Template Views

Document View: Document Template

View name: rpt.document_template

Type: Record

Description: Document Template Information

Field	Data Type
document_template_id	integer
document_template_name	text
document_template_short_name	character varying(10)
document_template_is_active	boolean
document_template_class_id	integer
document_template_class	character varying(40)
document_template_entity_type_id	integer
document_template_entity_type	character varying(35)
document_template_drop_down_1_id	integer
document_template_drop_down_1	character varying(100)
document_template_drop_down_2_id	integer
document_template_drop_down_2	character varying(100)
document_template_description	text

Document View: Document Template Stage

View name: rpt.document_template_stage

Type: Record

Description: Document Template Stage Information

Field	Data Type	Notes
document_template_stage_id	integer
document_template_stage_name	text
document_template_id	integer	References document_template_id in rpt.document_template
document_template_stage_type_id	integer
document_template_stage_type	character varying(100)

Document View: Document Template Score

View name: rpt.document_template_score

Type: Record

Description: Document Template Score Information

Field	Data Type	Notes
document_template_score_id	integer
document_template_id	integer	References document_template_id in rpt.document_template
score_name	character varying(100)
parent_document_template_score_id	integer	References document_template_score_id in rpt.document_template_score
score_class_id	integer
score_class	character varying(20)

Document View: Document Template Question

View name: rpt.document_template_question

Type: Record

Description: Document Template Question Information

Field	Data Type	Notes
document_template_question_id	integer
question	text
question_type_id	integer
question_type	character varying(30)
question_is_multi_select	boolean
list_item_group_id	integer	References list_item_group_id in rpt.document_template_list_item

Document View: Document Template List Item

View name: rpt.document_template_list_item

Type: Record

Description: Document Template List Item Information

Field	Data Type
document_template_list_item_id	integer
list_item	text
list_item_group_id	integer
list_item_group	text

Views and Standard Views