Category:Data Processing

B

• Backup (2 C, 13 P)

C

• Centralized data push pull (17 P)
• CT Query (7 P)

D

• Data processing batch files (1 C, 6 P)
• Data Processor PC (4 P)
• Data Repository (2 C, 11 P)
• Data Sources (16 P)

L

• Legacy Data Processing (2 C, 34 P, 1 F)

M

• Manitoba Health (1 C, 8 P)
• MS Access Tips and Techniques (2 P)

P

• PL queries (9 P)

Q

• Query (2 P)

T

• Teleform (1 C, 3 P)
• TISS Scanning (1 C, 3 P)

• Data Processing
• Centralized data Vetting Process

"

• "copy patient demographics for questioning" button
• "Copying" Centralized data.mdb
• "email collector about patient data" button
• "Pulling" Centralized data.accdb
• "Pushing" Centralized data.accdb
• "Re-connect Data" button
• "Vet all sent" button

A

• Adding a CCI or ICD10 entry in CFE

B

• Biographic changes over time

C

• Calc created variables button
• Cat button
• CFE Inline Integrity Checks
• Changing D IDs
• Correcting suspect links
• CT Outstandings Dispo query
• CT Outstandings query
• CT queries
• CT Summary Discharges FiscalYear query
• CT Summary Discharges query

D

• Data Processing Priority
• Data Processor
• Deleting a duplicate record from the TISS pre-import file
• Deleting an item from TISS28.accdb
• Designated sending times
• Determine which sends have failed and need to be re-sent

E

• Encounter processing

F

• Finding a patient in EPR
• Finding a specific D ID in the PHI Archive
• Fixing a D ID in TISS28.accdb
• Frozen

G

• Gaps and overlaps
• Generate Person IDs
• Generating PseudoPHINs

K

• Known data errors

L

• L Communication Notes table
• L Problem table
• LastName field
• Link suspect dead then alive query
• Link suspect mismatch from ours incomplete query
• Link suspect mismatch pre inpt ours incomplete query
• Link suspect mismatch pre inpt should be ours incomplete query
• Link suspect mismatch to ours incomplete query
• Link suspect negative transit time query
• Lost/missing chart

N

• NDC
• Notes field (L PHI)

O

• Orphans in Centralized data.accdb

P

• PL 2Phin Fake or Blank
• PL Chart 9 Digit
• PL DiffPhin SameLN FN DOB
• PL SameCHART Site Diff PHIN
• PL SamePhin Diff DOB Sex
• PL SamePHIN Site Diff chart
• Populate linking pairs
• Pre-linking checks
• Procedure when there are differences between L Log and L PHI
• Processing errors in patient data

Q

• Quality Assurance queries in CFE
• Query check CCI TISS spont breath no tube
• Query NDC Bad Postal Code
• Query NDC Postal Code over time
• Query NDC VAP no TISS
• Questioning data back to collectors

R

• Re-sending data
• Reconnect CFE and initial error checks
• Reconnect check orphans query
• Restoring a "known good" version of the centralized data pair

S

• Scanning to network
• Standard data cleaning process

T

• Test data
• TISS error instruction at...
• TISS28 form images
• TISS28 Form Scanning

U

• Update query

V

• Validation against Patient Registry Data