RecordStatus field: Difference between revisions

(40 intermediate revisions by 5 users not shown)

Line 1:

~~Changes being worked on right now~~, ~~will become~~

''if you are looking for the field collectors can use for their own custom designations, see [[Record field]]

~~valid when~~ [[~~CCMDB.mdb_Change_Log_2013#ver_2013-04-24 |ver_2013-04-24~~]] ~~is rolled out.~~

~~The~~ RecordStatus ~~Field on~~ the ~~[[Patient Viewer]]~~ in ~~[[CCMDB~~.~~mdb]]~~.

{{Data_element

| field_name = RecordStatus

| CCMDB_label = Status

| CCMDB_tab = Top Row

| element_description = status of the data in the record. Possible values are complete, sent, questioned and vetted.

| in_table = L_Log table

| data_type = string

| datafield_length = 20

| program_collecting = Med and CC

| created_raw = Raw

| data_element_start_date = 2013-04-24

| data_element_sort_index = 80

}}

~~==checklist for Tina during implementing this ==~~

The field can be seen on the [[Patient Viewer]] and the [[Patient List]]. The setting of the field will affect processing as follows.

* translate current record/finalcheck state to new

* resolve all mentions of ~~finalcheck in VBA, eg~~. ~~but there may be more:~~

** sending

** error checking

* resolve all mentions of finalcheck in forms

==~~Legacy~~==

== Possible Values ==

~~This field replaces the [[Final Check]] box~~.

=== incomplete ===

A patient is automatically set to incomplete when a new record is created.

[[Category:~~IT Instructions~~]]

=== complete ===

Once a patient's record is complete and all checkboxes in the [[Patient Viewer]] are set, the collector will try to set the patient to "complete". This changes triggers the [[CCMDB.accdb Data Integrity Checks]] that are set to run on completion; if any problems are found, the record is set back to "incomplete". Records that are set to complete will be treated differently during the next [[sending]].

Ideally the collector will set the field to "complete" as soon as you have entered the last data for a patient, while they still have the chart to be able to fix errors without having to get the chart again. Also, it saves time during [[Sending Patients | sending]].

=== sent ===

At [[sending]], records that were set to "complete" will be changed to "sent" in both [[CCMDB.accdb]] and [[Centralized data.accdb]]. A record that is "sent" can no longer be edited or overwritten by CCMDB.accdb during sending. If a record needs to be re-sent, the data processor needs to change the setting to "incomplete" first.

In CCMDB.accdb, the [["Delete Sent Patients" button]] checks for this field to be set to "sent" to delete patients.

=== discontinued ===

"Discontinued" is used for the following scenarios:

* remnants of VIC Family Medicine patients which was collected after the consolidation for a period of one year from Oct 2017 to Oct 27, 2018. There were 30 patients still in the VIC units N4C, N5C and S5C by Oct 27,2018 when the decision to stop collection happened.

* [[Lost/missing chart]]s, see that page for details

=== only in [[CCMDB.mdb]] ===

==== deleted ====

=== only in [[Centralized_data.accdb]] ===

==== questioned ====

As part of the [[Centralized data Vetting Process]] the data processor runs queries to ensure data is valid. If any "sent" record has problems, she sets the recordstatus to "questioned".

''In the future'' a questioned record may be copied back to the collectors laptop automatically at the next send time to facilitate validation; likely the data processor would put an entry into the [[Notes field]] to tell the data collector what is wrong. See [[Questioning data back to collectors]].

==== vetted ====

At the end of the [[Centralized data Vetting Process]] the data processor will press the "Vet all sent" button. At this time, any sent records that have not been flagged as "questioned" should be clean, so the button will set all "sent" to "vetted".

== Data Integrity Checks ==

A lot of [[Data Integrity Checks]] are triggered when this field is set to complete.

=== Data checks that actually check validity of data in this field ===

== Related articles ==

[[Category:2013 data upgrades]]

[[Category:Data Collection Guide]]

[[Category:Patient Viewer]]

[[Category:Data structure]]

@@ Line 1: / Line 1: @@
- Changes being worked on right now, will become
+''if you are looking for the field collectors can use for their own custom designations, see [[Record field]]
- valid when [[CCMDB.mdb_Change_Log_2013#ver_2013-04-24 |ver_2013-04-24]] is rolled out.
-The RecordStatus Field on the [[Patient Viewer]] in [[CCMDB.mdb]].
+{{Data_element
+| field_name = RecordStatus
+| CCMDB_label = Status
+| CCMDB_tab = Top Row
+| element_description = status of the data in the record. Possible values are complete, sent, questioned and vetted.
+| in_table = L_Log table
+| data_type = string
+| datafield_length = 20
+| program_collecting = Med and CC
+| created_raw = Raw
+| data_element_start_date = 2013-04-24
+| data_element_sort_index = 80
+}}
-==checklist for Tina during implementing this ==
+The field can be seen on the [[Patient Viewer]] and the [[Patient List]]. The setting of the field will affect processing as follows.
-* translate current record/finalcheck state to new
-* resolve all mentions of finalcheck in VBA, eg. but there may be more:
-** sending
-** error checking
-* resolve all mentions of finalcheck in forms
-==Legacy==
+== Possible Values ==
-This field replaces the [[Final Check]] box.
+=== incomplete ===
+A patient is automatically set to incomplete when a new record is created.
-[[Category:IT Instructions]]
+=== complete ===
+Once a patient's record is complete and all checkboxes in the [[Patient Viewer]] are set, the collector will try to set the patient to "complete". This changes triggers the [[CCMDB.accdb Data Integrity Checks]] that are set to run on completion; if any problems are found, the record is set back to "incomplete". Records that are set to complete will be treated differently during the next [[sending]].
+Ideally the collector will set the field to "complete" as soon as you have entered the last data for a patient, while they still have the chart to be able to fix errors without having to get the chart again. Also, it saves time during [[Sending Patients | sending]].
+=== sent ===
+At [[sending]], records that were set to "complete" will be changed to "sent" in both [[CCMDB.accdb]] and [[Centralized data.accdb]]. A record that is "sent" can no longer be edited or overwritten by CCMDB.accdb during sending. If a record needs to be re-sent, the data processor needs to change the setting to "incomplete" first.
+In CCMDB.accdb, the [["Delete Sent Patients" button]] checks for this field to be set to "sent" to delete patients.
+=== discontinued ===
+"Discontinued" is used for the following scenarios:
+* remnants of VIC Family Medicine patients which was collected after the consolidation for a period of one year from Oct 2017 to Oct 27, 2018. There were 30 patients still in the VIC units N4C, N5C and S5C by Oct 27,2018 when the decision to stop collection happened.
+* [[Lost/missing chart]]s, see that page for details
+=== only in [[CCMDB.mdb]] ===
+==== deleted ====
+{{Logically deleted profiles}}
+=== only in [[Centralized_data.accdb]] ===
+==== questioned ====
+As part of the [[Centralized data Vetting Process]] the data processor runs queries to ensure data is valid. If any "sent" record has problems, she sets the recordstatus to "questioned".
+''In the future'' a questioned record may be copied back to the collectors laptop automatically at the next send time to facilitate validation; likely the data processor would put an entry into the [[Notes field]] to tell the data collector what is wrong. See [[Questioning data back to collectors]].
+==== vetted ====
+At the end of the [[Centralized data Vetting Process]] the data processor will press the "Vet all sent" button. At this time, any sent records that have not been flagged as "questioned" should be clean, so the button will set all "sent" to "vetted".
+== Data Integrity Checks ==
+A lot of [[Data Integrity Checks]] are triggered when this field is set to complete.
+=== Data checks that actually check validity of data in this field ===
+{{Data Integrity Check List}}
+== Related articles ==
+{{Related Articles}}
+[[Category:2013 data upgrades]]
+[[Category:Data Collection Guide]]
+[[Category:Patient Viewer]]
+[[Category:Data structure]]