This page (revision-17) was last changed on 26-Nov-2021 10:22 by mmcfarland

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
17 26-Nov-2021 10:22 14 KB mmcfarland to previous
16 26-Nov-2021 10:22 14 KB mmcfarland to previous | to last
15 26-Nov-2021 10:22 15 KB JMyers to previous | to last
14 26-Nov-2021 10:22 15 KB JMyers to previous | to last
13 26-Nov-2021 10:22 15 KB RForbes to previous | to last
12 26-Nov-2021 10:22 15 KB Administrator to previous | to last
11 26-Nov-2021 10:22 15 KB Administrator to previous | to last
10 26-Nov-2021 10:22 15 KB Administrator to previous | to last
9 26-Nov-2021 10:22 15 KB Administrator to previous | to last PRESCRIPTION_REFERENCE ==> PRSCRIPTION_REFERENCE
8 26-Nov-2021 10:22 15 KB Administrator to previous | to last
7 26-Nov-2021 10:22 15 KB Administrator to previous | to last
6 26-Nov-2021 10:22 15 KB Administrator to previous | to last HEATH_AS_OF_DATE ==> HEALTH_AS_OF_DATE
5 26-Nov-2021 10:22 15 KB Administrator to previous | to last
4 26-Nov-2021 10:22 15 KB Administrator to previous | to last
3 26-Nov-2021 10:22 15 KB Administrator to previous | to last
2 26-Nov-2021 10:22 15 KB Administrator to previous | to last
1 26-Nov-2021 10:22 1 KB Administrator to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 7 changed one line
The definition data for the Maintain Health Record screen is stored in the [P2K_SH_HEALTH_RECORDS], [P2K_SH_MEDICAL_EXAMS], [P2K_SH_MEDICAL_TESTS], [P2K_SH_MEDICATIONS], [P2K_SH_HEALTH_COSTS] and [P2K_SH_INOCULATIONS] table.
The definition data for the Maintain Health Record screen is stored in the [P2K_SH_HEALTH_RECORDS] and related tables: [P2K_SH_MEDICAL_EXAMS], [P2K_SH_MEDICAL_TESTS], [P2K_SH_MEDICATIONS], [P2K_SH_HEALTH_COSTS] and [P2K_SH_INOCULATIONS] table.
At line 26 changed one line
;[Cared For By|CARED_FOR_BY]: If the employee receiving caretaking from another person, that individual is identified here. Cared_For_By from IECT (P2K_HR_CONTACTS) is an optional field you must fill through the LOV.
;Cared For By: If the employee is receiving caretaking from another person, that individual is identified here. The link to [IECI] ([P2K_HR_CONTACTS]) is an optional field you must fill through the LOV.
At line 35 added 3 lines
The definition data for the Maintain Exam tab is stored in the [P2K_SH_MEDICAL_EXAMS] and [P2K_SH_HEALTH_COSTS] tables.
At line 36 changed one line
;[Medical Type|MEDICAL_TYPE]" This field indicates the type of medical exam that was given to the employee. Medical_Type from IHTP (P2K_SH_MEDICAL_EXAM_TYPES) is a mandatory field you must fill through the LOV.
;[Medical Type|MEDICAL_TYPE]: This field indicates the type of medical exam that was given to the employee. Medical_Type from IHTP (P2K_SH_MEDICAL_EXAM_TYPES) is a mandatory field you must fill through the LOV.
At line 38 changed 3 lines
;[Treatment Source|TREATMENT_SOURCE]: This field identifies where the employee received medical treatment. Treatment_Source is an optional field you may fill with a selection from the fixed lexicon
X_TREATMENT_SOURCE
;[Health Issue Case #|HEALTH_ISSUE_CASE]: If the exam is the result of a health issue case, that case is identified in this field. Health_Issue_Case from IHHI (P2K_SH_HEALTH_ISSUES) is an optional field you may fill through the LOV.
;[Treatment Source|TREATMENT_SOURCE]: This field identifies where the employee received medical treatment. Treatment_Source is an optional field you may fill with a selection from the fixed lexicon X_TREATMENT_SOURCE
;Health Issue Case #: If the exam is the result of a health issue case, that case is identified in this field. Health_Issue_Case from [IHHI] ([P2K_SH_HEALTH_ISSUES]) is an optional field you may fill through the LOV.
At line 43 changed 2 lines
;Performed By: This field indicates who performed the medical exam. Performed_By from [IECT] ([P2K_HR_CONTACTS]) is an optional field you must fill through the LOV.
;Conducted In: This field indicates where the treatment took place. Conducted_In from [IECT] ([P2K_HR_CONTACTS]) is an optional field you must fill through the LOV.
;Performed By: This field indicates who performed the medical exam. The link to [IECI] ([P2K_HR_CONTACTS]) is an optional field made through the foreign key [ECT_ID].
;Conducted In: This field indicates where the treatment took place. The link to [IECI] ([P2K_HR_CONTACTS]) is an optional field made through the foreign key [ECT_ID_CONDUCTED_IN]
At line 68 changed one line
If medical tests (i.e. blood tests) are required, the information for that test will be recorded on this tab.
If medical tests (i.e. blood tests) are required, the information for that test will be recorded on this tab. The definition data for the Maintain Test tab is stored in the [P2K_SH_MEDICAL_TESTS] and [P2K_SH_HEALTH_COSTS] tables.
At line 72 added one line
At line 72 changed one line
;[Description]" This field provides detailed information on the medical test. Description is an optional 4000-character alphanumeric field you may fill manually.
;[Description]: This field provides detailed information on the medical test. Description is an optional 4000-character alphanumeric field you may fill manually.
At line 75 changed 2 lines
;[From Medical Exam|FROM_MEDICAL_EXAM]: If the medical tests are a result of a medical exam, that exam will be identified in this field. From_Medical_Exam from IHME (P2K_SH_MEDICAL_EXAMS) is an optional field you must fill
through the LOV.
;From Medical Exam: If the medical tests are a result of a medical exam, that exam will be identified in this field. From_Medical_Exam from IHME (P2K_SH_MEDICAL_EXAMS) is an optional field you must fill through the LOV.
At line 98 added 3 lines
The definition data for the Medication tab is stored in the [P2K_SH_MEDICATIONS] table.
At line 116 added 2 lines
The definition data for the Inoculation tab is stored in the [P2K_SH_INOCULATIONS] table.
At line 119 removed one line