RecordStatus field: Difference between revisions

(9 intermediate revisions by 2 users not shown)

Line 26:

=== sent ===

At [[sending]], records that were set to "complete" will be changed to "sent" in both [[CCMDB.accdb]] and [[~~Centralized_data~~.~~mdb~~]]. 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.

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 ===

~~{{Discuss | who = Julie | question =~~

"Discontinued" is used for the following scenarios:

* ~~I just found 30~~ of ~~these~~..~~. what does~~ that ~~value mean?~~

* 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 ====

~~When the [["Delete Sent Patients" button]] is used, part of the record is actually retained for use by [[Cognos Report Integrator]] and [[EPR Reports Integrator]]. Records that are set to "~~deleted" don't show up in the [[Patient List]]. These records are deleted by the [["Delete Sent Patients" button]] when they are more than 90 days old. The entries of child tables are deleted at the time the record is set to "deleted", with the exception of the tmp projects, which are retained for access to [[Boarding Loc]], which is relevant for [[Cognos Report Integrator]].

~~Use the [["Previous entry" button]] to see records that have been deleted within the last 3 months.~~

=== only in [[~~Centralized data~~.~~mdb~~]] ===

=== 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".

Line 56:

Line 55:

[[Category: 2013 data upgrades]]

[[Category:2013 data upgrades]]

[[Category: Data Collection Guide]]

[[Category:Data Collection Guide]]

[[Category: Patient Viewer]]

[[Category:Patient Viewer]]

[[Category: Data structure]]

[[Category:Data structure]]

@@ Line 26: / Line 26: @@
 === sent ===
-At [[sending]], records that were set to "complete" will be changed to "sent" in both [[CCMDB.accdb]] and [[Centralized_data.mdb]]. 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.
+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 ===
-{{Discuss | who = Julie | question =
+"Discontinued" is used for the following scenarios:
-* I just found 30 of these... what does that value mean?
+* 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 ====
-When the [["Delete Sent Patients" button]] is used, part of the record is actually retained for use by [[Cognos Report Integrator]] and [[EPR Reports Integrator]]. Records that are set to "deleted" don't show up in the [[Patient List]]. These records are deleted by the [["Delete Sent Patients" button]] when they are more than 90 days old. The entries of child tables are deleted at the time the record is set to "deleted", with the exception of the tmp projects, which are retained for access to [[Boarding Loc]], which is relevant for [[Cognos Report Integrator]].
+{{Logically deleted profiles}}
-Use the [["Previous entry" button]] to see records that have been deleted within the last 3 months.
-=== only in [[Centralized data.mdb]] ===
+=== 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".
@@ Line 56: / Line 55: @@
 {{Related Articles}}
-[[Category: 2013 data upgrades]]
+[[Category:2013 data upgrades]]
-[[Category: Data Collection Guide]]
+[[Category:Data Collection Guide]]
-[[Category: Patient Viewer]]
+[[Category:Patient Viewer]]
-[[Category: Data structure]]
+[[Category:Data structure]]