SAP ABAP Table RN1PLANNING_HISTORY (IS-H: Appointment History)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H-PM (Application Component) Patient Management
     ⤷ N1APMG (Package) IS-H: Appointment Management; TSA Development

Basic Data

Table Category	INTTAB	Structure
Structure	RN1PLANNING_HISTORY	Table Relationship Diagram
Short Description	IS-H: Appointment History

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	APP_OBJ	☐	N1APPOINTMENT_OBJECT	CL_ISH_APPOINTMENT	REF	0	0	IS-H: Appointment Object
2	ATTRID	☐	N1ATTRID		NUMC	8	0	IS-H: ID of Attribute for Planning
3	NUMBER	☐	N1_HIST_NUMBER	N1I4	INT4	10	0	IS-H: Number of Entry in History
4	APP_HEAD	☐	NTMN		STRU	0	0
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
6	TMNID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment
7	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
8	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
9	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
10	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
11	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
12	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
13	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
14	TMNLB	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
15	TMNOE	☐	ISH_TMNOE	ORGID	CHAR	8	0	IS-H: Planned Organizational Unit
16	TMNDT	☐	ISH_TMNDT	DATE	DATS	8	0	IS-H: Date of Appointment
17	TMNZT	☐	ISH_TMNZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment
18	TMNDR	☐	ISH_TMDAUER	ISH_DZEIT	NUMC	4	0	IS-H: Duration of Appointment
19	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
20	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
21	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
22	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
23	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
24	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
25	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
26	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
27	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
28	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
29	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
30	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
31	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
32	SOURC	☐	ISH_OBJSRC	ISH_OBJSRC	CHAR	1	0	IS-H: Application that Created Object
33	TMTAG	☐	ISH_TMTAG	XFELD	CHAR	1	0	IS-H: Appointment on Given Day
34	REFID	☐	ISH_REFTMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Reference Number of Next Appointment
35	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
36	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
37	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
38	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
39	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class
40	BNKZ	☐	ISH_APP_NOTI_WANTED	XFELD	CHAR	1	0	IS-H: Notification of Appointment Desired
41	BNDT	☐	ISH_BNDT	RI_DATUM	DATS	8	0	IS-H: Date on which patient was last notified
42	BNART	☐	ISH_BNART	KOMMART	CHAR	1	0	IS-H: Type of Notification (Tel., Written)
43	EINBDT	☐	ISH_EINBDT	RI_DATUM	DATS	8	0	IS-H: Date of Appointment of which Patient Last Notified
44	EINBZT	☐	ISH_EINBZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment of which Patient Last Notified
45	EINBOE	☐	ISH_EINBOE	ORGID	CHAR	8	0	Nursing Org. Unit of Patient's Last Scheduled Appointment
46	EINBPER	☐	ISH_EINBPER	RI_KUNNR	CHAR	10	0	IS-H: Person/Physician of Last Patient Appt Notification
47	EINBZIM	☐	ISH_EINBZIM	BAUID	CHAR	8	0	IS-H: Building Unit of Last Patient Notification
48	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
49	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
50	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
51	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
52	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category
53	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
54	TPART	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type
55	BWPRIO	☐	N1APRI_D	N1APRI	NUMC	3	0	Prioritization for Request/Movement (Internal)
56	MEDTX	☐	N1MEDTX	N1C050	CHAR	50	0	Medical Text
57	TMSTG	☐	ISH_TMSTG	N1STOID	CHAR	3	0	Cancellation Reason for an Appointment
58	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
59	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
60	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
61	VBUND	☐	ISH_TMVBD	XFELD	CHAR	1	0	Termin verbundrelevant
62	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions
63	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions
64	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician
65	TMPDT	☐	ISH_TMPDT	DATE	DATS	8	0	IS-H: Date Planned for Appointment
66	TMPZT	☐	ISH_TMPZT	UHRZT	TIMS	6	0	IS-H: Time Planned for Appointment
67	GPLVN	☐	N1GPLVN	USNAM	CHAR	12	0	IS-H*MED: Employee or User who Last Planned Appointment
68	GPLTY	☐	N1GPLTY	N1GPLTY	CHAR	1	0	IS-H*MED: Appointment Changed by: Employee/User ID
69	EMAIL	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
70	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
71	CHAINID	☐	ISH_APP_CHAINID	ISH_LNRAPP	CHAR	10	0	IS-H: Link ID for Interdependent Appointments
72	UNITID	☐	ISH_TREATM_UNITID	NUMC03	NUMC	3	0	IS-H: Treatment Unit ID
73	DISTMIN	☐	ISH_APPDIST_MIN	ISH_APPDIST	NUMC	3	0	IS-H: Minimum Interval Between Appointments
74	DISTMAX	☐	ISH_APPDIST_MAX	ISH_APPDIST	NUMC	3	0	IS-H: Maximum Interval Between Appointments
75	DISTUNIT	☐	ISH_APPDIST_UNIT	ISH_APPDIST_UNIT	NUMC	1	0	IS-H: Time Unit for Interval Between Two Appointments
76	CYCLE	☐	ISH_APPCYCLE	NUMC03	NUMC	3	0	IS-H: Appointment Cycle
77	CYCLEUNIT	☐	ISH_APPCYCLE_UNIT	ISH_APPCYCLE_UNIT	NUMC	1	0	IS-H: Time Unit for Appointment Cycle
78	VKGID	☐	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
79	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number
80	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
81	ENDPL	☐	N1ENDPL	ISH_TRUE_FALSE	CHAR	1	0	IS-H: Planning Complete
82	.INCLU--AP	☐				0	0	i.s.h.med: i.s.h.med-Specific Fields for Appointment
83	CAUSECHNG	☐	N1CAUSECHNG	N1CAUSECHNG	CHAR	50	0	Reason for Change
84	CSECHGID	☐	N1CSECHGID	NUMC3	NUMC	3	0	Reason for Change ID
85	APP_RES	☐	ISH_T_NAPP		TTYP	0	0
86	APP_OBJ_OLD	☐	N1APPOINTMENT_OBJECT	CL_ISH_APPOINTMENT	REF	0	0	IS-H: Appointment Object

History

Last changed by/on	SAP	20130529
SAP Release Created in	472