documents_legal_master


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of documents_legal_master.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

List of Master Docs to be signed

Columns

Column Type Size Nulls Auto Default Children Parents Comments
dlm_category INT UNSIGNED 10 √ NULL
dlm_subcategory INT UNSIGNED 10 √ NULL
dlm_document_id INT UNSIGNED 10 √ null
dlm_document_name VARCHAR 75 null
dlm_filepath VARCHAR 75 null
dlm_facility INT UNSIGNED 10 √ NULL
dlm_provider INT UNSIGNED 10 √ NULL
dlm_sign_height DOUBLE 22 null
dlm_sign_width DOUBLE 22 null
dlm_filename VARCHAR 45 null
dlm_effective_date DATETIME 19 null
dlm_version INT UNSIGNED 10 null
content VARCHAR 255 null
dlm_savedsign VARCHAR 255 √ NULL

0-Yes 1-No
dlm_review VARCHAR 255 √ NULL

0-Yes 1-No
dlm_upload_type TINYINT 3 √ 0

0-Provider Uploaded,1-Patient Uploaded

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc dlm_document_id

Relationships

Close relationships within degrees of separation