Table/Structure Field list used by SAP ABAP Program DBEHS_OH001SEL (Selektionen der logischen Datenbank EHS_OH001)
SAP ABAP Program 
DBEHS_OH001SEL (Selektionen der logischen Datenbank EHS_OH001) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
EHS_EXA_AUD - TEST_NO | Medical Test Number | |
| 2 | Table/Structure Field |
EHS_EXA_LAB - TEST_NO | Medical Test Number | |
| 3 | Table/Structure Field |
EHS_EXA_LAB - TEST_RESULT | Value Assignment of Test Result | |
| 4 | Table/Structure Field |
EHS_EXA_LAB - TEST_VALUE | Physical Value of a Medical Test | |
| 5 | Table/Structure Field |
EHS_EXA_LAB - UNIT | Unit of Measurement of Result | |
| 6 | Table/Structure Field |
EHS_EXA_PHY - TEST_NO | Medical Test Number | |
| 7 | Table/Structure Field |
EHS_EXA_PHY - TEST_VALUE | Physical Value of a Medical Test | |
| 8 | Table/Structure Field |
EHS_EXA_PHY - UNIT | Unit of Measurement of Result | |
| 9 | Table/Structure Field |
EHS_EXA_PUL - TEST_NO | Medical Test Number | |
| 10 | Table/Structure Field |
EHS_PERNR - ABKRS | Payroll Area | |
| 11 | Table/Structure Field |
EHS_PERNR - BTRTL | Personnel Subarea | |
| 12 | Table/Structure Field |
EHS_PERNR - BUKRS | Company Code | |
| 13 | Table/Structure Field |
EHS_PERNR - DAYPS | EHS: Selection Period for Persons | |
| 14 | Table/Structure Field |
EHS_PERNR - FAMST | Marital Status Key | |
| 15 | Table/Structure Field |
EHS_PERNR - GBDAT | Date of Birth | |
| 16 | Table/Structure Field |
EHS_PERNR - GBLND | Country of Birth | |
| 17 | Table/Structure Field |
EHS_PERNR - GESCH | Gender Key | |
| 18 | Table/Structure Field |
EHS_PERNR - GSBER | Business Area | |
| 19 | Table/Structure Field |
EHS_PERNR - HCENT | Health Center | |
| 20 | Table/Structure Field |
EHS_PERNR - KOSTL | Cost Center | |
| 21 | Table/Structure Field |
EHS_PERNR - MSTBR | Supervisor Area | |
| 22 | Table/Structure Field |
EHS_PERNR - NATIO | Nationality | |
| 23 | Table/Structure Field |
EHS_PERNR - ORGEH | Organizational Unit | |
| 24 | Table/Structure Field |
EHS_PERNR - PERSG | Employee Group | |
| 25 | Table/Structure Field |
EHS_PERNR - PERSK | Employee Subgroup | |
| 26 | Table/Structure Field |
EHS_PERNR - PERSON_FLAG | Person Group: Employee / Applicant / External Person | |
| 27 | Table/Structure Field |
EHS_PERNR - PERSON_ID | Person Identification | |
| 28 | Table/Structure Field |
EHS_PERNR - PLANS | Position | |
| 29 | Table/Structure Field |
EHS_PERNR - SNAME | Employee's Name (Sortable by LAST NAME FIRST NAME) | |
| 30 | Table/Structure Field |
EHS_PERNR - SPRSL | Language Key | |
| 31 | Table/Structure Field |
EHS_PERNR - STAT2 | Employment Status | |
| 32 | Table/Structure Field |
EHS_PERNR - STELL | Job | |
| 33 | Table/Structure Field |
EHS_PERNR - WERKS | Personnel Area | |
| 34 | Table/Structure Field |
EHS_PERPROSC - PGROUP | Health Surveillance Protocol Category | |
| 35 | Table/Structure Field |
EHS_PERPROSC - PNUMBER | Protocol Number | |
| 36 | Table/Structure Field |
EHS_PERPROSC - STATUS_PROT | Status of Assignment | |
| 37 | Table/Structure Field |
EHS_SERVICE - PHYSFLAG | Internal/External Person | |
| 38 | Table/Structure Field |
EHS_SERVICE - SRV_CLOSUREDATE | Service Closed On | |
| 39 | Table/Structure Field |
EHS_SERVICE - SRV_NUMBER | Number of Medical Service | |
| 40 | Table/Structure Field |
EHS_SERVICE - SRV_PHYSICIAN | Physician Responsible | |
| 41 | Table/Structure Field |
EHS_SERVICE - SRV_STATUS | Status of Medical Service | |
| 42 | Table/Structure Field |
EHS_SRV_DIA - DIAG_CODE | Diagnosis Code | |
| 43 | Table/Structure Field |
EHS_SRV_DIA - DIAG_CTLG | Diagnosis Catalog | |
| 44 | Table/Structure Field |
EHS_SRV_DIA - DIAG_PHYSICIAN | Physician Responsible for Diagnosis/Test Result | |
| 45 | Table/Structure Field |
EHS_SRV_DIA - DIAG_RECDATE | Examination Date | |
| 46 | Table/Structure Field |
EHS_SRV_DIA - PHYSFLAG | Internal/External Person | |
| 47 | Table/Structure Field |
EHS_SRV_DIAS - DIAG_CODE | Diagnosis Code | |
| 48 | Table/Structure Field |
EHS_SRV_DIAS - DIAG_CTLG | Diagnosis Catalog | |
| 49 | Table/Structure Field |
EHS_SRV_EXA - EXAM_CODE | Examination Number | |
| 50 | Table/Structure Field |
EHS_SRV_EXA - EXAM_GROUP | Examination Category | |
| 51 | Table/Structure Field |
EHS_SRV_EXA - SRV_EXAM_DATE | Examination Date | |
| 52 | Table/Structure Field |
EHS_SRV_EXA - SRV_EXAM_RES | Value Assignment of Examination Result | |
| 53 | Table/Structure Field |
EHS_SRV_LIM - LIMI_ENDDATE | Restriction End Date | |
| 54 | Table/Structure Field |
EHS_SRV_LIM - LIMI_STRDATE | Restriction Start Date | |
| 55 | Table/Structure Field |
EHS_SRV_LIM - LIMI_TYPE | Restriction | |
| 56 | Table/Structure Field |
EHS_SRV_LIMS - LIMI_ENDDATE | Restriction End Date | |
| 57 | Table/Structure Field |
EHS_SRV_LIMS - LIMI_STRDATE | Restriction Start Date | |
| 58 | Table/Structure Field |
EHS_SRV_LIMS - LIMI_TYPE | Restriction | |
| 59 | Table/Structure Field |
EHS_SRV_PROT - DATE_PERFORMED | Date Health Surveillance Protocol Performed | |
| 60 | Table/Structure Field |
EHS_SRV_PROT - PGROUP | Health Surveillance Protocol Category | |
| 61 | Table/Structure Field |
EHS_SRV_PROT - PHYSFLAG | Internal/External Person | |
| 62 | Table/Structure Field |
EHS_SRV_PROT - PNUMBER | Protocol Number | |
| 63 | Table/Structure Field |
EHS_SRV_PROT - SRV_PHYSICIAN | Physician Responsible | |
| 64 | Table/Structure Field |
EHS_SRV_PROT - SRV_PROT_UDAT | Planned Examination Date | |
| 65 | Table/Structure Field |
EHS_SRV_SCH - SRV_PHYSFLAG_INT | Internal Person | |
| 66 | Table/Structure Field |
EHS_SRV_SCH - SRV_PHYSICIAN | Physician Responsible | |
| 67 | Table/Structure Field |
EHS_SRV_SCH - SRV_SCHED_DATE | Date of Appointment at Health Center | |
| 68 | Table/Structure Field |
EHS_SRV_SCH - SRV_SCHED_STATUS | Scheduling Status | |
| 69 | Table/Structure Field |
EHS_SRV_SCH - SRV_SCHED_TIME | Time of Appointment | |
| 70 | Table/Structure Field |
T7EHS00_EXA_AUD - TEST_NO | Medical Test Number | |
| 71 | Table/Structure Field |
T7EHS00_EXA_LAB - TEST_NO | Medical Test Number | |
| 72 | Table/Structure Field |
T7EHS00_EXA_LAB - TEST_RESULT | Value Assignment of Test Result | |
| 73 | Table/Structure Field |
T7EHS00_EXA_LAB - TEST_VALUE | Physical Value of a Medical Test | |
| 74 | Table/Structure Field |
T7EHS00_EXA_LAB - UNIT | Unit of Measurement of Result | |
| 75 | Table/Structure Field |
T7EHS00_EXA_PHY - TEST_NO | Medical Test Number | |
| 76 | Table/Structure Field |
T7EHS00_EXA_PHY - TEST_VALUE | Physical Value of a Medical Test | |
| 77 | Table/Structure Field |
T7EHS00_EXA_PHY - UNIT | Unit of Measurement of Result | |
| 78 | Table/Structure Field |
T7EHS00_EXA_PUL - TEST_NO | Medical Test Number | |
| 79 | Table/Structure Field |
T7EHS00_PERPROSC - PGROUP | Health Surveillance Protocol Category | |
| 80 | Table/Structure Field |
T7EHS00_PERPROSC - PNUMBER | Protocol Number | |
| 81 | Table/Structure Field |
T7EHS00_PERPROSC - STATUS_PROT | Status of Assignment | |
| 82 | Table/Structure Field |
T7EHS00_SERVICE - PHYSFLAG | Internal/External Person | |
| 83 | Table/Structure Field |
T7EHS00_SERVICE - SRV_CLOSUREDATE | Service Closed On | |
| 84 | Table/Structure Field |
T7EHS00_SERVICE - SRV_NUMBER | Number of Medical Service | |
| 85 | Table/Structure Field |
T7EHS00_SERVICE - SRV_PHYSICIAN | Physician Responsible | |
| 86 | Table/Structure Field |
T7EHS00_SERVICE - SRV_STATUS | Status of Medical Service | |
| 87 | Table/Structure Field |
T7EHS00_SRV_DIA - DIAG_CODE | Diagnosis Code | |
| 88 | Table/Structure Field |
T7EHS00_SRV_DIA - DIAG_CTLG | Diagnosis Catalog | |
| 89 | Table/Structure Field |
T7EHS00_SRV_DIA - DIAG_PHYSICIAN | Physician Responsible for Diagnosis/Test Result | |
| 90 | Table/Structure Field |
T7EHS00_SRV_DIA - DIAG_RECDATE | Examination Date | |
| 91 | Table/Structure Field |
T7EHS00_SRV_DIA - PHYSFLAG | Internal/External Person | |
| 92 | Table/Structure Field |
T7EHS00_SRV_EXA - EXAM_CODE | Examination Number | |
| 93 | Table/Structure Field |
T7EHS00_SRV_EXA - EXAM_GROUP | Examination Category | |
| 94 | Table/Structure Field |
T7EHS00_SRV_EXA - SRV_EXAM_DATE | Examination Date | |
| 95 | Table/Structure Field |
T7EHS00_SRV_EXA - SRV_EXAM_RES | Value Assignment of Examination Result | |
| 96 | Table/Structure Field |
T7EHS00_SRV_LIM - LIMI_ENDDATE | Restriction End Date | |
| 97 | Table/Structure Field |
T7EHS00_SRV_LIM - LIMI_STRDATE | Restriction Start Date | |
| 98 | Table/Structure Field |
T7EHS00_SRV_LIM - LIMI_TYPE | Restriction | |
| 99 | Table/Structure Field |
T7EHS00_SRV_PROT - DATE_PERFORMED | Date Health Surveillance Protocol Performed | |
| 100 | Table/Structure Field |
T7EHS00_SRV_PROT - PGROUP | Health Surveillance Protocol Category | |
| 101 | Table/Structure Field |
T7EHS00_SRV_PROT - PHYSFLAG | Internal/External Person | |
| 102 | Table/Structure Field |
T7EHS00_SRV_PROT - PNUMBER | Protocol Number | |
| 103 | Table/Structure Field |
T7EHS00_SRV_PROT - SRV_PHYSICIAN | Physician Responsible | |
| 104 | Table/Structure Field |
T7EHS00_SRV_PROT - SRV_PROT_UDAT | Planned Examination Date | |
| 105 | Table/Structure Field |
T7EHS00_SRV_SCH - SRV_PHYSFLAG_INT | Internal Person | |
| 106 | Table/Structure Field |
T7EHS00_SRV_SCH - SRV_PHYSICIAN | Physician Responsible | |
| 107 | Table/Structure Field |
T7EHS00_SRV_SCH - SRV_SCHED_DATE | Date of Appointment at Health Center | |
| 108 | Table/Structure Field |
T7EHS00_SRV_SCH - SRV_SCHED_STATUS | Scheduling Status | |
| 109 | Table/Structure Field |
T7EHS00_SRV_SCH - SRV_SCHED_TIME | Time of Appointment |
