SAP ABAP Table RNSTAT (IS-H: INTTAB table for statistical evaluations)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NBAS (Package) Appl. development Hospital System master data, catalogs

Basic Data

Table Category	INTTAB	Structure
Structure	RNSTAT	Table Relationship Diagram
Short Description	IS-H: INTTAB table for statistical evaluations

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	FATYP	☑	FATYP	FATYP	CHAR	1	0	IS-H: Category of Specialty Key
3	EINRI	☐	STATEINRI	EINRI	CHAR	4	0	IS-H: Institution to Be Evaluated	TN01
4	FACHR	☐	STATFACHR	ISH_FACHR	CHAR	4	0	IS-H: Specialty to Be Evaluated in Statistics	TNKFA
5	ORGID	☐	STATORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit to Be Evaluated in Statistics	NORG
6	AUSBEGDT	☐	STATBEGDTA	RI_DATUM	DATS	8	0	IS-H: Start of Evaluation Period
7	AUSENDDT	☐	STATENDDTA	RI_DATUM	DATS	8	0	IS-H: End of Evaluation Period
8	VERBEGDT	☐	STATBEGDTV	RI_DATUM	DATS	8	0	IS-H: Start Date of Comparison Period
9	VERENDDT	☐	STATENDDTV	RI_DATUM	DATS	8	0	IS-H: End of Comparison Period
10	FILENAME	☐	STATFILE	TEXT45	CHAR	45	0	Identification of Sequence File
11	LINE_SIZE	☐	LINE_SZ	NUM03	NUMC	3	0	IS-H: Line Width in Statistics and Lists
12	TITLE_LIN1	☐	TITLE_LIN1	TEXT254	CHAR	254	0	Header 1st Line FORM Routine STAT_HEAD Prog. STATFORM
13	TITLE_LIN2	☐	TITLE_LIN2	TEXT254	CHAR	254	0	Header 2nd line FORM Routine STAT_HEAD Prog. STATFORM
14	REPID	☐	PROGRAMM	PROGRAMM	CHAR	40	0	ABAP Program Name	*
15	ULINE	☐	ULINE	CHAR1	CHAR	1	0	IS-H: Exit List Header with Underscore?
16	STATGMANN	☐	STATGMANN	XFELD	CHAR	1	0	IS-H: Indicator Separate Output Male Patients
17	STATGWEIB	☐	STATGWEIB	XFELD	CHAR	1	0	IS-H: Indicator Separate Output Female Patients
18	STATGUNB	☐	STATGUNB	XFELD	CHAR	1	0	IS-H: Indicator Separate Output Patients with Unknown Sex
19	STATFSTAT	☐	STATFSTAT	XFELD	CHAR	1	0	IS-H: Checkbox Case Type Inpatient in Evaluations
20	STATFAMBU	☐	STATFAMBU	XFELD	CHAR	1	0	IS-H: Checkbox Case Type Outpatient in Evaluations
21	STATFTSTA	☐	STATFTSTA	XFELD	CHAR	1	0	IS-H: Checkbox for Case Type Day Patient in Evaluations
22	STATNEUSE	☐	STATNEUSE	XFELD	CHAR	1	0	IS-H: Checkbox New Page per Specialty/Org. Unit in Stats
23	STATUNTOE	☐	STATUNTOE	XFELD	CHAR	1	0	IS-H: Checkbox for Display of Lower-Level Org. Units
24	STATSIFACH	☐	STATSIFACH	XFELD	CHAR	1	0	IS-H: Checkbox for Specialty View in Statistics
25	STATSIPFLE	☐	STATSIPFLE	XFELD	CHAR	1	0	IS-H: Checkbox for Nursing View in Statistics
26	STATPROT	☐	ISH_PROT	XFELD	CHAR	1	0	IS-H: Call Log Display in Statistics
27	BEGMONAUS	☐	ISH_STMOAB	ISH_MONAT	NUMC	2	0	IS-H: Start Month of Evaluation Period
28	BEGJAAUS	☐	ISH_STJAAB	GJAHR	NUMC	4	0	IS-H: Start Year of Evaluation Period
29	ENDMONAUS	☐	ISH_STMOAE	ISH_MONAT	NUMC	2	0	IS-H: End Month of Evaluation Period
30	ENDJAAUS	☐	ISH_STJAAE	GJAHR	NUMC	4	0	IS-H: End year of the Evaluation Period
31	BEGMONVER	☐	ISH_STMOVB	ISH_MONAT	NUMC	2	0	IS-H: Start Month of Comparison Period
32	BEGJAVER	☐	ISH_STJAVB	GJAHR	NUMC	4	0	IS-H: Start Year of Comparison Period
33	ENDMONVER	☐	ISH_STMOVE	ISH_MONAT	NUMC	2	0	IS-H: End Month of Comparison Period
34	ENDJAVER	☐	ISH_STJAVE	GJAHR	NUMC	4	0	IS-H: End Year of Comparison Period
35	KZNLSU	☐	ISH_KZNLSU	XFELD	CHAR	1	0	IS-H: Checkbox for Creation of NLSU Statistics File
36	STATID_VOR	☐	STATISID	STATID	CHAR	4	0	IS-H: Identification of Statistics	TNS20
37	STATID	☐	STATISID	STATID	CHAR	4	0	IS-H: Identification of Statistics	TNS20
38	ZETXT	☐	ISH_ZENAME	TEXT40	CHAR	40	0	IS-H: Name of Row in Statistics
39	DRUKZ	☐	ISH_DRKZ	ISH_DRKZ	CHAR	1	0	IS-H: Parameter for Output of Rows in Statistics
40	TARID	☐	TARID	TARID	CHAR	2	0	IS-H: Service Catalog Identification Key	TNK01
41	LEVON	☐	ISH_LEILOW	TARLS	CHAR	10	0	IS-H: Lower Value of Service in Range Tables	*
42	LEBIS	☐	ISH_LEIHIG	TARLS	CHAR	10	0	IS-H: Upper Value of Service in Range Tables	*
43	LEOPT	☐	ISH_OPTION	ISH_OPTION	CHAR	2	0	IS-H: OPTION Parameter of Range Table
44	LESIG	☐	ISH_SESIGN	ISH_SESIGN	CHAR	1	0	IS-H: SIGN Parameter of Range Table
45	OEVON	☐	ISH_OELOW	ORGID	CHAR	8	0	IS-H: Lower Limit of Org. Unit in Range Table	*
46	OEBIS	☐	ISH_OEHIGH	ORGID	CHAR	8	0	IS-H: Upper Limit of Org. Unit in a Range Table	*
47	OEOPT	☐	ISH_OPTION	ISH_OPTION	CHAR	2	0	IS-H: OPTION Parameter of Range Table
48	OESIG	☐	ISH_SESIGN	ISH_SESIGN	CHAR	1	0	IS-H: SIGN Parameter of Range Table
49	DIASTAT	☐	ISH_DISTAT	ISH_DISTAT	CHAR	5	0	IS-H: Start of Diagnosis Code (5 Characters)
50	OPSTAT	☐	ISH_OPSTAT	ISH_OPSTAT	CHAR	7	0	IS-H: Start of Surgical Procedure Code (7 Characters)
51	KHART	☐	ISH_KHART	ISH_KHART	NUMC	1	0	IS-H: Type of Hospital
52	TRART	☐	ISH_TRART	ISH_TRART	NUMC	1	0	IS-H: Type of Hospital Operator
53	AUSBTH	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
54	AUSBDI	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
55	AUSBHE	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
56	AUSBGY	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
57	AUSBPF	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
58	AUSBKI	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
59	AUSBHF	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
60	AUSBML	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
61	AUSBMR	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
62	AUSBLO	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
63	AUSBOR	☐	ISH_AUSBST	ISH_AUSBST	NUMC	3	0	IS-H: Number of Training Organizations
64	ARZNEI	☐	ISH_ARZNEI	ISH_ARZNEI	NUMC	1	0	IS-H: Pharmaceutical Supply of Hospital
65	MTGRCT	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
66	MTGREC	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
67	MTGRGK	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
68	MTGRMR	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
69	MTGRKA	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
70	MTGRSA	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
71	MTGRKB	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
72	MTGRKT	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
73	MTGRLB	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
74	MTGRSL	☐	ISH_MTGR	ISH_MTGR	NUMC	2	0	IS-H: Number of Large Technical Medical Devices
75	COR_MOD_PR	☐	COR_MOD_PR	XFELD	CHAR	1	0	IS-H: Correction Proc. for PPR Data Carrier Exchng.(Germany)
76	STASP	☐	ISH_STASPS	XFELD	CHAR	1	0	IS-H: Take into Account Statistics Block for Statistics
77	FPROT	☐	ISH_FPROT	XFELD	CHAR	1	0	IS-H: Checkbox for Case Logging in Statistics
78	MOD_ALL_PR	☐	ISH_PPRALL	XFELD	CHAR	1	0	IS-H: Nursing Acuity Evaluation for All Patients (Germany)
79	MOD_ENT_PR	☐	ISH_PPRENT	XFELD	CHAR	1	0	IS-H: Nrs. Acuity Case Eval. of Patients Discharged in Prd
80	MOD_ERW_PR	☐	ISH_PPRERW	XFELD	CHAR	1	0	IS-H: Nusing Acuity Evaluation for 'Adults' Age-Group
81	MOD_JUG_PR	☐	ISH_PPRJUG	XFELD	CHAR	1	0	IS-H: Nurs. Acuity Evaluation for 'Adolescents' Age-Group
82	MOD_KLK_PR	☐	ISH_PPRKLK	XFELD	CHAR	1	0	IS-H: Nurs. Acuity Evaluataion for 'Infant' Age-Group
83	MOD_NGB_PR	☐	ISH_PPRNGB	XFELD	CHAR	1	0	IS-H: Nurs. Acuity Evaluation for 'Newborns' Age-Group
84	MOD_OE_PPR	☐	ISH_PPROE	XFELD	CHAR	1	0	IS-H: Summarize Nurs.Acuity Evaluation Variants per Nrs. OU
85	MOD_QU_PPR	☐	ISH_PPRQU	XFELD	CHAR	1	0	IS-H: Quantitative Display of Nursing Acuity Evaluation
86	MOD_PR_PPR	☐	ISH_PPRPR	XFELD	CHAR	1	0	IS-H: Percentage Display of Nursing Acuity Evaluation
87	MOD_M1_PPR	☐	ISH_PPRM1	XFELD	CHAR	1	0	IS-H: Minute Display I for Nursing Acuity Evaluation
88	MOD_M2_PPR	☐	ISH_PPRM2	XFELD	CHAR	1	0	IS-H: Minute Display II for Nursing Acuity Evaluation
89	MOD_FP_PPR	☐	ISH_PPRFP	XFELD	CHAR	1	0	IS-H: Daily Output of Missing Nursing Acuities in Log
90	ZIBETT_OFF	☐	ISH_ZIBEOF	XFELD	CHAR	1	0	IS-H: Do not Take Room/Bed Assignment into Account
91	CODEP	☐	ISH_FILECP	CPCODEPAGE	NUMC	4	0	IS-H: Character Set of File to Be Imported	TCP00

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNSTAT	CODEP	TCP00	CPCODEPAGE
2	RNSTAT	EINRI	TN01	EINRI
3	RNSTAT	FACHR	TNKFA	FACHR
4	RNSTAT	ORGID	NORG	ORGID
5	RNSTAT	STATID	TNS20	STATID
6	RNSTAT	STATID_VOR	TNS20	STATID
7	RNSTAT	TARID	TNK01	KATID

History

Last changed by/on	SAP	20130529
SAP Release Created in