SAP ABAP Table RN1_APPOINTMENT_SNAPSHOT (IS-H*MED: Snapshot Structure for Class CL_ISH_APPOINTMENT)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

Table Category	INTTAB	Structure
Structure	RN1_APPOINTMENT_SNAPSHOT	Table Relationship Diagram
Short Description	IS-H*MED: Snapshot Structure for Class CL_ISH_APPOINTMENT

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	SNAP_KEY	☐	ISHMED_SNAPKEY	N1I4	INT4	10	0	IS-H*MED: Key for Snapshot
2	MODUS	☐	ISH_MODUS	ISH_MODUS	CHAR	1	0	IS-H: Processing Mode for Data Records (I/U/D)
3	NTMN	☐	NTMN		STRU	0	0
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
5	TMNID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment
6	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
7	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
8	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
9	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
10	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
11	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
12	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
13	TMNLB	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
14	TMNOE	☐	ISH_TMNOE	ORGID	CHAR	8	0	IS-H: Planned Organizational Unit
15	TMNDT	☐	ISH_TMNDT	DATE	DATS	8	0	IS-H: Date of Appointment
16	TMNZT	☐	ISH_TMNZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment
17	TMNDR	☐	ISH_TMDAUER	ISH_DZEIT	NUMC	4	0	IS-H: Duration of Appointment
18	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
19	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
20	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
21	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
22	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
23	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
24	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
25	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
26	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
27	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
28	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
29	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
30	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
31	SOURC	☐	ISH_OBJSRC	ISH_OBJSRC	CHAR	1	0	IS-H: Application that Created Object
32	TMTAG	☐	ISH_TMTAG	XFELD	CHAR	1	0	IS-H: Appointment on Given Day
33	REFID	☐	ISH_REFTMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Reference Number of Next Appointment
34	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
35	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
36	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
37	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
38	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class
39	BNKZ	☐	ISH_APP_NOTI_WANTED	XFELD	CHAR	1	0	IS-H: Notification of Appointment Desired
40	BNDT	☐	ISH_BNDT	RI_DATUM	DATS	8	0	IS-H: Date on which patient was last notified
41	BNART	☐	ISH_BNART	KOMMART	CHAR	1	0	IS-H: Type of Notification (Tel., Written)
42	EINBDT	☐	ISH_EINBDT	RI_DATUM	DATS	8	0	IS-H: Date of Appointment of which Patient Last Notified
43	EINBZT	☐	ISH_EINBZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment of which Patient Last Notified
44	EINBOE	☐	ISH_EINBOE	ORGID	CHAR	8	0	Nursing Org. Unit of Patient's Last Scheduled Appointment
45	EINBPER	☐	ISH_EINBPER	RI_KUNNR	CHAR	10	0	IS-H: Person/Physician of Last Patient Appt Notification
46	EINBZIM	☐	ISH_EINBZIM	BAUID	CHAR	8	0	IS-H: Building Unit of Last Patient Notification
47	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
48	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
49	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
50	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
51	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category
52	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
53	TPART	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type
54	BWPRIO	☐	N1APRI_D	N1APRI	NUMC	3	0	Prioritization for Request/Movement (Internal)
55	MEDTX	☐	N1MEDTX	N1C050	CHAR	50	0	Medical Text
56	TMSTG	☐	ISH_TMSTG	N1STOID	CHAR	3	0	Cancellation Reason for an Appointment
57	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
58	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
59	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
60	VBUND	☐	ISH_TMVBD	XFELD	CHAR	1	0	Termin verbundrelevant
61	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions
62	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions
63	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician
64	TMPDT	☐	ISH_TMPDT	DATE	DATS	8	0	IS-H: Date Planned for Appointment
65	TMPZT	☐	ISH_TMPZT	UHRZT	TIMS	6	0	IS-H: Time Planned for Appointment
66	GPLVN	☐	N1GPLVN	USNAM	CHAR	12	0	IS-H*MED: Employee or User who Last Planned Appointment
67	GPLTY	☐	N1GPLTY	N1GPLTY	CHAR	1	0	IS-H*MED: Appointment Changed by: Employee/User ID
68	EMAIL	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
69	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
70	CHAINID	☐	ISH_APP_CHAINID	ISH_LNRAPP	CHAR	10	0	IS-H: Link ID for Interdependent Appointments
71	UNITID	☐	ISH_TREATM_UNITID	NUMC03	NUMC	3	0	IS-H: Treatment Unit ID
72	DISTMIN	☐	ISH_APPDIST_MIN	ISH_APPDIST	NUMC	3	0	IS-H: Minimum Interval Between Appointments
73	DISTMAX	☐	ISH_APPDIST_MAX	ISH_APPDIST	NUMC	3	0	IS-H: Maximum Interval Between Appointments
74	DISTUNIT	☐	ISH_APPDIST_UNIT	ISH_APPDIST_UNIT	NUMC	1	0	IS-H: Time Unit for Interval Between Two Appointments
75	CYCLE	☐	ISH_APPCYCLE	NUMC03	NUMC	3	0	IS-H: Appointment Cycle
76	CYCLEUNIT	☐	ISH_APPCYCLE_UNIT	ISH_APPCYCLE_UNIT	NUMC	1	0	IS-H: Time Unit for Appointment Cycle
77	VKGID	☐	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
78	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number
79	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
80	ENDPL	☐	N1ENDPL	ISH_TRUE_FALSE	CHAR	1	0	IS-H: Planning Complete
81	.INCLU--AP	☐				0	0	i.s.h.med: i.s.h.med-Specific Fields for Appointment
82	CAUSECHNG	☐	N1CAUSECHNG	N1CAUSECHNG	CHAR	50	0	Reason for Change
83	CSECHGID	☐	N1CSECHGID	NUMC3	NUMC	3	0	Reason for Change ID
84	T_NAPP	☐	ISH_T_NAPP		TTYP	0	0
85	NBEW	☐	NBEW		STRU	0	0
86	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
87	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
88	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
89	LFDNR	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
90	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
91	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
92	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
93	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
94	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
95	STATU	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit
96	BWPDT	☐	BWPDT	RI_DATUM	DATS	8	0	IS-H: Planned Date of Movement
97	BWPZT	☐	BWPZT	UHRZT	TIMS	6	0	IS-H: Planned Time of Movement
98	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
99	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
100	PLANE	☐	PLANE	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for End Date of Movement
101	LFDREF	☐	LFDREF	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Subsequent Movement
102	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
103	TVKZ	☐	TVKZ	XFELD	CHAR	1	0	IS-H: TV Indicator
104	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
105	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
106	NOTKZ	☐	RI_NOTKZ	XFELD	CHAR	1	0	IS-H: Emergency Case Indicator
107	UNFKZ	☐	UNFART	UNFART	CHAR	3	0	IS-H: Accident Type
108	UNFNR	☐	UNFNR	UNFNR	CHAR	12	0	IS-H: File Number / Processing Number for Accident
109	UNFOR	☐	ORT01_UNF	TEXT25	CHAR	25	0	IS-H: Accident Location
110	UNFZT	☐	UNFZT	UHRZT	TIMS	6	0	IS-H: Time of Accident
111	UNFDT	☐	UNFDT	RI_DATUM	DATS	8	0	IS-H: Accident date
112	UNFTX	☐	TEXT_UNF	TEXT50	CHAR	50	0	IS-H: Comment on Accident
113	UNLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
114	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management
115	AUFDS	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
116	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case
117	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case
118	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room
119	BETT	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location
120	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
121	DAUER	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
122	EXTKH	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital
123	ORGAU	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility
124	EZUST	☐	EZUST	ENTZU	CHAR	2	0	Disposition of Patient at Time of Discharge
125	TODUR	☐	TODUR	TODUR	CHAR	3	0	IS-H: Cause of Death
126	ARBUN	☐	ARBUN	RI_DATUM	DATS	8	0	IS-H: Work Incapacity To-Date
127	ABWGN	☐	ISH_ABWGN	XFELD	CHAR	1	0	IS-H: Indicator Whether Absence is Approved ('X')
128	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
129	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
130	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
131	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
132	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
133	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
134	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
135	UNFRN	☐	ISH_RETTNR	ISH_RETTNR	CHAR	15	0	IS-H: Number of the Emergency Service for Accident
136	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
137	NFGREF	☐	N1NFGREF	LFDBEW	NUMC	5	0	Reference to Subsequent Movement
138	VGNREF	☐	N1VGNREF	LFDBEW	NUMC	5	0	Reference to Prior Movement
139	AUFRF	☐	N1AUFRF	N1N002	NUMC	2	0	Number of Calls
140	MEDTX	☐	N1MEDTX	N1C050	CHAR	50	0	Medical Text
141	MELTX	☐	N1MELTX	N1C001	CHAR	1	0	Long Text Indicator
142	BWPRIO	☐	N1APRI_D	N1APRI	NUMC	3	0	Prioritization for Request/Movement (Internal)
143	STOID	☐	N1BSTOID	N1STOID	CHAR	3	0	IS-H: Reason for Canceling Movement
144	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling
145	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
146	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions
147	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions
148	TPART	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type
149	UNFVS	☐	N1FVS	XFELD	CHAR	1	0	IS-H: Third-Party Responsibility
150	INSEV	☐	ISH_BEW_EV	ISH_BEW_EV	CHAR	4	0	IS-H: Event which created the movement
151	OPART	☐	ISH_OPART	ISH_OPART	CHAR	2	0	IS-H: Type of Surgery
152	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class
153	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type
154	FACHR	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty
155	UNFRT	☐	ISH_RESCTY	ISH_RESCTY	CHAR	4	0	IS-H: Emergency Services
156	UNFAV	☐	ISH_ARRIVE	ISH_ARRIVE	CHAR	2	0	IS-H: Mode of Arrival
157	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List
158	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
159	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List
160	WLSTA	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status
161	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital
162	WLADT	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
163	BCODE	☐	ISH_BCODE	ISH_BCODE	CHAR	1	0	IS-H: Treatment Program
164	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
165	NWATARBU	☐	NWATARBU	NWATARBU	CHAR	1	0	IS-H AT: Arbeitsunfall / Berufskrankheit
166	NWATNOTF	☐	NWATNOTF	XFELD	CHAR	1	0	IS-H AT: Medizinischer Notfall
167	NWATBEGUT	☐	NWATFOLGE	XFELD	CHAR	1	0	IS-H AT: Folgebesuch
168	NWATMUTT	☐	NWATMUTT	NWATMUTT	CHAR	1	0	IS-H AT: Leistung aus dem Versicherungsfall der Mutterschaft
169	NWATSPENDE	☐	NWATUESCH	NWATUESCH	CHAR	1	0	IS-H AT: Art des Betreuungsscheines
170	NWATMETHOD	☐	NWATMETHOD	XFELD	CHAR	1	0	IS-H AT: Behandlungsmethode außerhalb des KH nicht vorhanden
171	NWATTRUNK	☐	NWATTRUNK	XFELD	CHAR	1	0	IS-H AT: Trunkenheit
172	NWATSUCHT	☐	NWATSUCHT	XFELD	CHAR	1	0	IS-H AT: Suchtgiftmissbrauch
173	NWATRAUF	☐	NWATRAUF	XFELD	CHAR	1	0	IS-H AT: Verdacht auf Raufhandel
174	NWATRZB	☐	NWATRZB_AK	XFELD	CHAR	1	0	IS-H AT: Rezeptgebührenbefreiung wegen anzeigepfl. Krankheit
175	NWATVPNR	☐	NWATVPNR	RI_KUNNR	CHAR	10	0	IS-H AT: Vertragspartnernummer
176	NWATBEFRGR	☐	NWATBEFRGR	NWATBEFRGR	CHAR	2	0	IS-H AT: Befreiungsgrund
177	BEXNR	☐	ISH_EXTNR_BEW	ISH_EXTNR_BEW	CHAR	20	0	IS-H: External Movement Identification
178	WPLID	☐	NWPLACEID	CHAR40	CHAR	40	0	Identification of the Work Environment
179	FACHS	☐	ISH_PLANCHARAC	ISH_PLANCHARAC	CHAR	8	0	IS-H: Occupancy Characteristic
180	WPLTY	☐	NWPLACETYPE	NWPLACETYPE	CHAR	3	0	Type of the Work Environment
181	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
182	.INCLUDE	☐				0	0	IS-H: Bewegungen zum Fall (Zusatzfelder für Österreich)
183	NWATSSW	☐	NWATSSW	NWATSSW	NUMC	2	0	Schwangerschaftswoche
184	NWATBEHAND	☐	NWATBEHAND	NWATBEHAND	CHAR	2	0	Ursache für Behandlung
185	NWATZUGART	☐	NWATZUGART	NWATZUGART	CHAR	1	0	Zugangsart
186	NWATABGART	☐	NWATABGART	NWATABGART	CHAR	1	0	Abgangsart
187	NWATZUGVA	☐	NWATVPNR	RI_KUNNR	CHAR	10	0	IS-H AT: Vertragspartnernummer
188	NWATAUFART	☐	NWATAUFART	NWATAUFART	CHAR	1	0	IS-H AT: Aufnahmeart 2
189	NWATEREFCD	☐	ISH_AT_EREFCD	ISH_AT_EREFCD	CHAR	5	0	e-Überweisungscode
190	NWATEREFNO	☐	ISH_AT_EREFNO	ISH_AT_EREFNO	CHAR	20	0	Nummer für den e-Überweisungscode
191	T_N1FAT	☐	ISHMED_T_VN1FAT		TTYP	0	0
192	T_N1FSZ	☐	ISHMED_T_VN1FSZ		TTYP	0	0
193	SNAPKEY_OBJCENTRAL	☐	ISHMED_SNAPKEY	N1I4	INT4	10	0	IS-H*MED: Key for Snapshot

History

Last changed by/on	SAP	20131127
SAP Release Created in	463