Friday, June 21, 2013

HEALTH CARE DOMAIN

The prevention, treatment, and management of illness and the preservation of mental and physical well-being through the services offered by the medical and allied health professions

Health care embraces all the goods and services designed to promote health, including “preventive, curative and palliative interventions, whether directed to individuals or to populations”.


Specialities in medicine

Anesthesia     The branch of medicine which deals with anesthesia and anesthetics
Cardiology :  Specializes in disorders of the Heart and associated structures
Dermatology : Deals with the skin and its appendages (hair, nails, sweat glands etc).
Endocrinology : Concerned with the endocrine system (i.e. endocrine glands and hormones) and its diseases, including diabetes and thyroid diseases.
Gastroenterology : Concerned with the alimentary tract
Nephrology : Concerned with diseases of the kidneys.
Pulmonology : Concerned with diseases of the lungs and the respiratory system.
Neurology : Treating central, peripheral nervous system, and spinal column diseases
Obstetrics and gynecology : The branches of medicine which deals with female reproductive organs, pregnancy, and childbirth
Ophthalmology : Branch of medical practice dealing with the diseases and surgery of the visual pathways, including the eyes, brain etc.
Pediatrics : Deals with the medical care of infants, children, and adolescents (from newborn to age 16-21, depending on the country).   
Oncology : Devoted to the study, diagnosis, and treatment of cancer and other malignant diseases
Psychiatry : Devoted to the treatment and study of mental disorder.
Family Medicine :  This provides continuing, comprehensive health care for the individual and family.


Types of Hospitals

General

            The best-known type of hospital is the general hospital, which is set up to deal with many kinds of disease and injury.
            A general hospital is typically the major health care facility in its region, with large numbers of beds for intensive care and long-term care

Specialized

            Hospitals for dealing with specific medical needs, certain disease categories, and so forth

Teaching

            A teaching hospital (or university hospital) combines assistance to patients with teaching to medical students and is often linked to a medical school.

Clinics

            A medical facility smaller than a hospital is generally called a clinic, Clinics generally provide only outpatient services.

Kind of patients

Outpatient

            a patient who is not hospitalized overnight but who visits a hospital, clinic, or associated facility for diagnosis or treatment

Inpatient

            An inpatient on the other hand is "admitted" to the hospital and stays overnight or for an indeterminate time, usually several days or weeks.



Health Care Team

Attending Physicians

            The attending Physicians examines patients, monitors daily progress, plans care, and oversees treatment

Residents

            Residents are licensed doctors who are receiving additional specialty training. During their residency program, they provide care under the supervision of the attending doctor

Physician Assistants

            Physician assistants are health professionals certified to practice medicine with doctor supervision. They make medical decisions and provide a broad range of diagnostic and therapeutic services.

Nurses

            Many types of nurses will help care for patients. They provide care and treatment and will be a very important part of your daily experience.

Dietitians

            Dietitians help ensure that patient receive appropriate nutrition to support healing. They are available to explain special diets if needed..

Pharmacists        

            Pharmacists prepare and dispense medications. They work closely with doctors and nurses to monitor drug therapies and to prevent or correct drug interactions.

Phlebotomists

            These staff members draw blood for laboratory tests.

Physical Therapists

            Physical therapists evaluate the patient’s developmental and functional skills. They treat physical, developmental, and neurological problems, and help you learn to use your body through exercise.


Glossary

Chief complaint

             Concise statement describing the symptom, problem, condition. Or other factor that is the reason for a medical encounter.

History of the present illness

             Refers to a detailed interview prompted by the chief complaint or presenting symptom (for example, pain).

Signs versus symptoms

             A symptom is experienced and reported by the patient
             A sign is discovered by the physician during                                        examination of the patient

Review of systems

             A review of systems is a component of an encounter note covering the organ systems, with a focus upon the subjective symptoms perceived by the patient.

Physical examination

             Is the process by which a health care provider investigates the body of a patient for signs of disease.

Diagnosis

             Is the process of identifying a medical condition or disease by its signs, symptoms, and from the results of various diagnostic procedures.

ICD (International Statistical Classification of Diseases and Related Health Problems)

             Provides codes to classify diseases and a wide variety of signs, symptoms, abnormal findings, complaints, social circumstances, and external causes of injury or disease

Current Procedural Terminology (CPT)

             The CPT code set accurately describes medical, surgical, and diagnostic services and is designed to communicate uniform information about medical services and procedures among physicians, coders, patients, accreditation organizations, and payers for administrative, financial, and analytical purposes.

OD

             omne in die – Once-daily

BD

            bis in die Twice-daily

TID

             ter in die – Thrice-daily

Pro re nata

            as needed

DAW

            Dispense as written

SOAP note

            The SOAP note (an acronym for subjective, objective, assessment, and plan) is a method of documentation employed by health care providers to write out notes in a patient's chart

Subjective component

            This describes the patient's current condition in narrative form recorded in the patient's own words.

Objective component

            Vital signs
            Findings from physical examinations, such as posture, bruising, and abnormalities
            Results from laboratory tests
            Measurements, such as age and weight of the patient.

Assessment

            Is a quick summary of the patient with main symptoms/diagnosis including a differential diagnosis

Plan

            This is what the health care provider will do to treat the patient's concerns. Advised with the patient as well as timings for further review or follow-up.


OUT PATIENT FLOW IN CLINIC





Thursday, June 20, 2013

C# : Get Distinct Records from the DT

If you want to get a Distinct records from the C# DataTable here is the code to get it working !!!

Steps to follow :
1. Call the SelectDistinct, and pass the parameter to that.
2. Return DataTable will have all the distinct records.

 #region Get the Distinct Records from the Table

        private static DataTable SelectDistinct(DataTable SourceTable, params string[] FieldNames)
        {
            object[] lastValues;
            DataTable newTable;
            DataRow[] orderedRows;

            if (FieldNames == null || FieldNames.Length == 0)
                throw new ArgumentNullException("FieldNames");

            lastValues = new object[FieldNames.Length];
            newTable = new DataTable();

            foreach (string fieldName in FieldNames)
                newTable.Columns.Add(fieldName, SourceTable.Columns[fieldName].DataType);

            orderedRows = SourceTable.Select("", string.Join(", ", FieldNames));

            foreach (DataRow row in orderedRows)
            {
                if (!fieldValuesAreEqual(lastValues, row, FieldNames))
                {
                    newTable.Rows.Add(createRowClone(row, newTable.NewRow(), FieldNames));

                    setLastValues(lastValues, row, FieldNames);
                }
            }

            return newTable;
        }

        private static bool fieldValuesAreEqual(object[] lastValues, DataRow currentRow, string[] fieldNames)
        {
            bool areEqual = true;

            for (int i = 0; i < fieldNames.Length; i++)
            {
                if (lastValues[i] == null || !lastValues[i].Equals(currentRow[fieldNames[i]]))
                {
                    areEqual = false;
                    break;
                }
            }

            return areEqual;
        }

        private static DataRow createRowClone(DataRow sourceRow, DataRow newRow, string[] fieldNames)
        {
            foreach (string field in fieldNames)
                newRow[field] = sourceRow[field];

            return newRow;
        }

        private static void setLastValues(object[] lastValues, DataRow sourceRow, string[] fieldNames)
        {
            for (int i = 0; i < fieldNames.Length; i++)
                lastValues[i] = sourceRow[fieldNames[i]];
        }

        #endregion

SQL Date Time Formats

Standard Date Formats
Date Format
Standard
SQL Statement
Sample Output
Mon DD YYYY 1
HH:MIAM (or PM)
Default
SELECT CONVERT(VARCHAR(20), GETDATE(), 100)
Jan 1 2005 1:29PM 1
MM/DD/YY
USA
SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]
11/23/98
MM/DD/YYYY
USA
SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]
11/23/1998
YY.MM.DD
ANSI
SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]
72.01.01
YYYY.MM.DD
ANSI
SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD]
1972.01.01
DD/MM/YY
British/French
SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]
19/02/72
DD/MM/YYYY
British/French
SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]
19/02/1972
DD.MM.YY
German
SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY]
25.12.05
DD.MM.YYYY
German
SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY]
25.12.2005
DD-MM-YY
Italian
SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]
24-01-98
DD-MM-YYYY
Italian
SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY]
24-01-1998
DD Mon YY 1
-
SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]
04 Jul 06 1
DD Mon YYYY 1
-
SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]
04 Jul 2006 1
Mon DD, YY 1
-
SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY]
Jan 24, 98 1
Mon DD, YYYY 1
-
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]
Jan 24, 1998 1
HH:MM:SS
-
SELECT CONVERT(VARCHAR(8), GETDATE(), 108)
03:24:53
Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1
Default + 
milliseconds
SELECT CONVERT(VARCHAR(26), GETDATE(), 109)
Apr 28 2006 12:32:29:253PM1
MM-DD-YY
USA
SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY]
01-01-06
MM-DD-YYYY
USA
SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]
01-01-2006
YY/MM/DD
-
SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD]
98/11/23
YYYY/MM/DD
-
SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD]
1998/11/23
YYMMDD
ISO
SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD]
980124
YYYYMMDD
ISO
SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]
19980124
DD Mon YYYY HH:MM:SS:MMM(24h)1
Europe default + milliseconds
SELECT CONVERT(VARCHAR(24), GETDATE(), 113)
28 Apr 2006 00:34:55:190 1
HH:MI:SS:MMM(24H)
-
SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]
11:34:23:013
YYYY-MM-DD HH:MI:SS(24h)
ODBC Canonical
SELECT CONVERT(VARCHAR(19), GETDATE(), 120)
1972-01-01 13:42:24
YYYY-MM-DD HH:MI:SS.MMM(24h)
ODBC Canonical
(with milliseconds)
SELECT CONVERT(VARCHAR(23), GETDATE(), 121)
1972-02-19 06:35:24.489
YYYY-MM-DDTHH:MM:SS:MMM
ISO8601
SELECT CONVERT(VARCHAR(23), GETDATE(), 126)
1998-11-23T11:25:43:250
DD Mon YYYY HH:MI:SS:MMMAM 1
Kuwaiti
SELECT CONVERT(VARCHAR(26), GETDATE(), 130)
28 Apr 2006 12:39:32:429AM1
DD/MM/YYYY HH:MI:SS:MMMAM
Kuwaiti
SELECT CONVERT(VARCHAR(25), GETDATE(), 131)
28/04/2006 12:39:32:429AM

Extended Date Formats
Date Format
SQL Statement
Sample Output
YY-MM-DD
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD]
99-01-24
YYYY-MM-DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD]
1999-01-24
MM/YY
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY]
08/99
MM/YYYY
SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY]
12/2005
YY/MM
SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM]
99/08
YYYY/MM
SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]
2005/12
Month DD, YYYY 1
SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY]
July 04, 2006 1
Mon YYYY1
SELECT SUBSTRING(CONVERT(VARCHAR(11), GETDATE(), 113), 4, 8) AS [Mon YYYY]
Apr 2006 1
Month YYYY 1
SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY]
February 2006 1
DD Month1
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD Month]
11 September1
Month DD1
SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD]
September 11 1
DD Month YY 1
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [DD Month YY]
19 February 72 1
DD Month YYYY 1
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY]
11 September 2002 1
MM-YY
SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 5), 5) AS [MM-YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 5), 4, 5) AS [MM-YY]
12/92
MM-YYYY
SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 105), 7) AS [MM-YYYY]
05-2006
YY-MM
SELECT RIGHT(CONVERT(VARCHAR(7), GETDATE(), 120), 5) AS [YY-MM]
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 5) AS [YY-MM]
92/12
YYYY-MM
SELECT CONVERT(VARCHAR(7), GETDATE(), 120) AS [YYYY-MM]
2006-05
MMDDYY
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/', '') AS [MMDDYY]
122506
MMDDYYYY
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') AS [MMDDYYYY]
12252006
DDMMYY
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') AS [DDMMYY]
240702
DDMMYYYY
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103), '/', '') AS [DDMMYYYY]
24072002
Mon-YY 1
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '-') AS [Mon-YY]
Sep-02 1
Mon-YYYY1
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY]
Sep-20021
DD-Mon-YY 1
SELECT REPLACE(CONVERT(VARCHAR(9), GETDATE(), 6), ' ', '-') AS [DD-Mon-YY]
25-Dec-051
DD-Mon-YYYY 1
SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YYYY]
25-Dec-2005 1
1 To make the month name in upper case, simply use the UPPER string function.