Centralized data front end.accdb: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m →L_Log_PHI: minor |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (17 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
'' see [[Centralized data front end. | '' see [[Centralized data front end.accdb Change Log]] and [[Centralized data front end.accdb Change Request]] for development info. | ||
Access front end to connect [[PHI.mdb]] to [[ | Access front end to connect [[PHI.mdb]] to [[Centralized_data.accdb]] to help with data processing tasks. | ||
See [[Centralized data | == File locations == | ||
*\\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end | |||
**ie x:\\CCMDB\centralized_front_end | |||
See also [[Setting up Centralized data on a new PC]] | |||
== Queries == | == Queries == | ||
| Line 10: | Line 13: | ||
* associated component scores | * associated component scores | ||
* ADL standard TOTAL | * ADL standard TOTAL | ||
* [[ | * [[ALERT Scale]]-version of ADL Total | ||
=== Charlson_Comorbid_Score === | === Charlson_Comorbid_Score === | ||
see [[ | see [[query Charlson_Score_pre_and_ICD10]] | ||
=== Created_Variables === | === Created_Variables === | ||
| Line 35: | Line 38: | ||
=== s_gcs_eye, s_gcs_motor, s_gcs_verbal === | === s_gcs_eye, s_gcs_motor, s_gcs_verbal === | ||
Limits s_gcs to only the options for one of the components. | Limits s_gcs to only the options for one of the components. | ||
== Modules and Functions == | == Modules and Functions == | ||
| Line 47: | Line 44: | ||
=== Module MOST_Score_Module === | === Module MOST_Score_Module === | ||
[[Category: | [[Category:ALERT Scale]] | ||
==== Function MOST_Score==== | ==== Function MOST_Score==== | ||
see [[ALERT Scale Calculation]] | |||
== Related articles == | |||
{{Related Articles}} | |||
[[category:2013 data upgrades]] | [[category:2013 data upgrades]] | ||
[[Category: | [[Category:Centralized_data_front_end.accdb| *]] | ||
Latest revision as of 14:51, 23 July 2025
see Centralized data front end.accdb Change Log and Centralized data front end.accdb Change Request for development info.
Access front end to connect PHI.mdb to Centralized_data.accdb to help with data processing tasks.
File locations
- \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end
- ie x:\\CCMDB\centralized_front_end
See also Setting up Centralized data on a new PC
Queries
ADL_scores
- chosen ADL options
- associated component scores
- ADL standard TOTAL
- ALERT Scale-version of ADL Total
Charlson_Comorbid_Score
see query Charlson_Score_pre_and_ICD10
Created_Variables
L_Log_PHI
Standard starting query that combines L_Log and L_ PHI
L_Tasks
Pulls only the tasks out of L_Dxs
Multiple_Encounter
start of implementing Multiple Encounter work left!
Primary_admit
- Primary Admit Dx
NDC_* queries
see Centralized data Vetting Process
s_gcs_eye, s_gcs_motor, s_gcs_verbal
Limits s_gcs to only the options for one of the components.
Modules and Functions
Function Fiscal_Year
Fiscal_Year(date) will return the fiscal year that date is in.