SAP ABAP Table EHS00S_TERM_SELCT (Structure: Selection Criteria for Displaying Med. Service)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HEA (Application Component) Occupational Health
     ⤷ P99Q1 (Package) EH&S: Occupational Health

Basic Data

Table Category	INTTAB	Structure
Structure	EHS00S_TERM_SELCT	Table Relationship Diagram
Short Description	Structure: Selection Criteria for Displaying Med. Service

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CB_TERMIN_NEW	☐	EHS00_TERMIN_NEW	BOOLEAN	CHAR	1	0	New Appointment
2	CB_TERMIN_NCON	☐	EHS00_TERMIN_NCON	BOOLEAN	CHAR	1	0	Appointment Not Confirmed
3	CB_TERMIN_CON	☐	EHS00_TERMIN_CON	BOOLEAN	CHAR	1	0	Appointment Confirmed
4	CB_TERMIN_NSHOW	☐	EHS00_TERMIN_NSHOW	BOOLEAN	CHAR	1	0	Appointment Not Kept
5	CB_TERMIN_DECL	☐	EHS00_TERMIN_DECL	BOOLEAN	CHAR	1	0	Appointment Canceled
6	RB_TIMEINT	☐	EHS00_SRV_RTI	BOOLEAN	CHAR	1	0	Selection Button: Period
7	RB_ACTWEEK	☐	EHS00_SRV_RAW	BOOLEAN	CHAR	1	0	Selection Button: Current Week
8	RB_ACTMONTH	☐	EHS00_SRV_RAM	BOOLEAN	CHAR	1	0	Selection Button: Current Month
9	RB_OVERDUE	☐	EHS00_TERMIN_ODU	BOOLEAN	CHAR	1	0	Overdue Health Surveillance Protocols Button
10	RB_ALLES	☐	EHS00_SRV_RAL	BOOLEAN	CHAR	1	0	Selection Button: No Time Restriction
11	PHYSICIANT	☐	EHS00_PHYSICIANT	TEXT80	CHAR	80	0	Physician/Health Center
12	PHYSICIAN	☐	EHS00_SRVPHYSICIAN	BU_PARTNER	CHAR	10	0	Physician Responsible	*
13	RB_NO_DATE	☐	EHS00_NO_DATE	BOOLEAN	CHAR	1	0	Without Date Assigned Button
14	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
15	RB_TODAY	☐	EHS00_SRV_RAD	BOOLEAN	CHAR	1	0	Today Button
16	DATE_FROM	☐	EHS00_SRV_SDATE	DATUM	DATS	8	0	Date of Appointment at Health Center
17	DATE_TO	☐	EHS00_SRV_SDATE	DATUM	DATS	8	0	Date of Appointment at Health Center
18	CB_NPROT_NSRV	☐	EHS00E_NPROT_NSRV_FLG	BOOLEAN	CHAR	1	0	Without Health Surveillance Protocol/Without Medical Service
19	CB_PROT_NSRV	☐	EHS00E_PROT_NSRV_FLG	BOOLEAN	CHAR	1	0	With Health Surveillance Protocol/Without Medical Service
20	CB_PROT_SRV	☐	EHS00E_PROT_SRV_FLG	BOOLEAN	CHAR	1	0	With Health Surveillance Protocol/With Medical Service
21	CB_NPROT_SRV	☐	EHS00E_NPROT_SRV_FLG	BOOLEAN	CHAR	1	0	Without Health Surveillance Protocol/With Medical Service
22	PGROUP	☐	EHS00_PGROUP	EHS00_PGROUP	CHAR	3	0	Health Surveillance Protocol Category	T7EHS00_PGROUP
23	PNUMBER	☐	EHS00_PNUMBER	CHAR3	CHAR	3	0	Protocol Number	T7EHS00_PROT
24	PGROUPNAM	☐	EHS00_PGROUPNAM	TEXT20	CHAR	20	0	Description of Health Surveillance Protocol Category
25	PNAME	☐	EHS00_PNAME	TEXT40	CHAR	40	0	Description of Health Surveillance Protocol
26	SEL_PROT_UDAT	☐	EHS00E_PROT_UDAT_IDX	CHAR1	CHAR	1	0	Planned/Next Appointment for Health Surveillance Protocol
27	PROT_UDAT_FROM	☐	EHS00_SRV_PCLT	DATUM	DATS	8	0	Planned Examination Date
28	PROT_UDAT_TO	☐	EHS00_SRV_PCLT	DATUM	DATS	8	0	Planned Examination Date
29	CB_PROT_ASS_ACT	☐	EHS00E_PROT_ASS_ACT_FLG	BOOLEAN	CHAR	1	0	Assignment to Person Active
30	CB_PROT_ASS_INACT	☐	EHS00E_PROT_ASS_INACT_FLG	BOOLEAN	CHAR	1	0	Assignment to Person Inactive
31	SEL_SRV_DAT	☐	EHS00E_SRV_SCHED_DATE_IDX	CHAR1	CHAR	1	0	Service Date
32	CB_APP_SHOW_ALL	☐	EHS00E_APP_SHOW_ALL_FLG	BOOLEAN	CHAR	1	0	Output All Appointments for Service
33	CB_PROT_SELCT	☐	EHS00E_PROT_SELCT	BOOLEAN	CHAR	1	0	Protocol Category: Health Surveillance Protocol
34	CB_VACC_SELCT	☐	EHS00E_VACC_SELCT	BOOLEAN	CHAR	1	0	Protocol Category: Vaccination
35	PHYSFLAG_INT	☐	EHS00E_INEXFLAG_APP_PHYS	EHS00D_INEXFLAG_APP_PHYS	CHAR	1	0	Internal Person

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHS00S_TERM_SELCT	PGROUP	T7EHS00_PGROUP	PGROUP
2	EHS00S_TERM_SELCT	PNUMBER	T7EHS00_PROT	PNUMBER

History

Last changed by/on	SAP	20110901
SAP Release Created in