SAP ABAP Table NFAL (IS-H: Cases)

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	TRANSP	Transparent table
Transparent table	NFAL	Table Relationship Diagram
Short Description	IS-H: Cases

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	FALNR	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
4	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
5	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
6	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
7	ABRKZ	☐	ABRKZ_FALL	ABRKZ_FALL	CHAR	1	0	IS-H: Billing Indicator for Case
8	SICHV	☐	SICHV	XFELD	CHAR	1	0	IS-H: Indicator for Restricted Patient
9	EINZG	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
10	KZTXT	☐	TEXT_NFAL	RI_BEMERK	CHAR	30	0	IS-H: Comment on Case
11	KUALF	☐	LLFDKUA	LFDKUA	CHAR	10	0	IS-H: Last IV Request Number Assigned
12	BEWLF	☐	LLFDBEW	LFDBEW	NUMC	5	0	IS-H: Last Movement Number Assigned	*
13	DGNLF	☐	LLFDDIA	LFDDIA	NUMC	3	0	IS-H: Obsolete
14	PGRLF	☐	LLFDPGF	LFDPGF	NUMC	3	0	IS-H: Last Sequence Number for Patient Group (NPGF)
15	INFKZ	☐	INFKZ	XFELD	CHAR	1	0	IS-H: Infectious Disease Indicator
16	STATU	☐	FALLSTATUS	FALLSTATUS	CHAR	1	0	IS-H: Case Status
17	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
18	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
19	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
20	ENDAT	☐	ENTDAT	RI_DATUM	DATS	8	0	IS-H: Date of Delivery
21	ENTIM	☐	ENTZEIT	UHRZT	TIMS	6	0	IS-H: Time of Delivery
22	FGTYP	☐	GEBTYP	GEBTYP	CHAR	1	0	Delivery Category	TN15F
23	KZKOM	☐	ISH_KZKOM	XFELD	CHAR	1	0	IS-H: Indicator that Complications Arose
24	KOMTX	☐	TEXT_ENTB	TEXT50	CHAR	50	0	IS-H: Comment on Delivery
25	KOLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
26	ARBUN	☐	ARBUN	RI_DATUM	DATS	8	0	IS-H: Work Incapacity To-Date
27	ENDDT	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
28	FSPER	☐	FSPER	ISH_FSPER	CHAR	1	0	IS-H: Billing Block for Case
29	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
30	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
31	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
32	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
33	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
34	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
35	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
36	VORPT	☐	ISH_VORPT	ISH_VORPT	NUMC	3	0	IS-H: Number of Days of Previous Treatmt in Calendar Year
37	BEGDT	☐	BEGDT_FAL	RI_DATUM	DATS	8	0	IS-H: Start Date of Case
38	STASP	☐	ISH_STASP	XFELD	CHAR	1	0	IS-H: Indicator for Admission Type "Statistics Block"
39	KV_KZ	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
40	EAUFN	☐	ISH_EAUFN	AUFNR	CHAR	12	0	IS-HCO: Receiver (Order)	*
41	KVUEB	☐	ISH_KVUEB	KV_STATUS	CHAR	1	0	IS-H: Status of PPA Billing Case
42	VORGR	☐	VOR_GRVER	GRVER	NUMC	3	0	IS-H: Previous Days to Be Deducted from Max. Length of Stay
43	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
44	RESID	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
45	CHILD	☐	ISH_CHILD	ISH_CHILD	CHAR	2	0	IS-H: Number of Children
46	FOREI	☐	ISH_FOREIG	XFELD	CHAR	1	0	IS-H: Foreign Case
47	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
48	EMTYP	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	TN15G
49	KTTAR	☐	NCH_TARCDE	NCH_TARCDE	CHAR	3	0	IS-H CH: Canton Tariff	TNCH12
50	KTABK	☐	NCH_AGREEMENT	NCH_AGREEMENT	CHAR	3	0	IS-H CH: Convention (Hospital <-> Canton)	TNCH13
51	GSTA1	☐	NCH_GESTA1	NCH_GESTA	NUMC	3	0	IS-H CH: Gestational Age 1
52	GSTA2	☐	NCH_GESTA2	NCH_GESTA	NUMC	3	0	IS-H CH: Gestational Age 2
53	ANZSC	☐	NCH_ANZSCH	NCH_ANZSCH	NUMC	2	0	IS-H CH: Number of Previous Pregnancies
54	ANZTD	☐	NCH_ANZTOT	NCH_ANZSCH	NUMC	2	0	IS-H CH: Number of Previous Miscarriages or Stillbirths
55	ANZAB	☐	NCH_ANZABB	NCH_ANZSCH	NUMC	2	0	IS-H CH: Number of Previous Terminations of Pregnancy
56	LGBIS	☐	NWCH_GENBIS	DATUM	DATS	8	0	IS-H CH: Service Generation Date to
57	FPEDT	☐	ISH_FPEDT	ISH_FPEDT	DATS	8	0	IS-H: Date of Wound Healing
58	APSTATE	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
59	FACHR	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	TNKFA
60	ENDTYP	☐	ISH_CASEEND	ISH_CASEEND	CHAR	2	0	IS-H: Type of Case End	TN15D
61	DOCTY	☐	ISH_LPASSTY	ISH_PASSTY	CHAR	2	0	IS-H: Subvention Document Type (Long)	TN17D
62	DOCNR	☐	ISH_LPASSNR	ISH_LPASSNR	CHAR	30	0	IS-H: Subvention Document Number (Long)
63	WKAT	☐	ISH_WKAT	ISH_WKAT	CHAR	1	0	IS-H: Choice of Ward Class	TN15H
64	DOCW	☐	ISH_DOCWKZ	XFELD	CHAR	1	0	IS-H: Named Referral Indicator
65	PATW	☐	ISH_PATWKZ	XFELD	CHAR	1	0	IS-H: Patient Requested Referral Indicator
66	PATGEW	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
67	GWEIN	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	T006
68	PATGRO	☐	ISH_PATGRO	ISH_GROESS	QUAN	5	2	IS-H: Height of Patient at Admission
69	GREIN	☐	ISH_EINGRO	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Size	T006
70	RESPI	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
71	FEXNR	☐	ISH_EXTNR_FAL	ISH_EXTNR_FAL	CHAR	20	0	IS-H: External Case Identification
72	TIMESTAMP	☐	ISH_TIMESTAMP	TZNTSTMPS	DEC	15	0	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
73	TOB	☐	ISH_TOB		NUMC	3	0	IS-H: Days Without Calculation
74	PLSNR	☐	ISH_EXTNR_PLS	ISH_EXTNR_PLS	CHAR	20	0	IS-H: PRS Number
75	.INCLUDE	☐				0	0	IS-H CH: Stammdaten Fall - Zusatzfelder Schweiz
76	INV_COPY	☐	ISH_INV_COPY	XFELD	CHAR	1	0	Kennzeichen Rechnungskopie an Patient
77	MHLS	☐	ISH_MHLS	ISH_MHLS	CHAR	1	0	Mental Health Legal Status
78	READM	☐	ISH_READM	ISH_ON_OFF	CHAR	1	0	Indicator for Possible Readmission Case
79	CONSENT	☐	ISH_CONSENT	XFELD	CHAR	1	0	PKV P301: Einwilligung zur elektronischen Datenübertragung

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NFAL	APSTATE	TNC301SA	APSTATE	REF	1	CN
2	NFAL	BEKAT	TN24	BEKAT	REF	C	CN
3	NFAL	DOCTY	TN17D	PASSTY	REF	1	CN
4	NFAL	EINRI	TN01	EINRI	KEY	1	CN
5	NFAL	EMTYP	TN15G	EMTYP	REF	1	CN
6	NFAL	ENDTYP	TN15D	ENDTYP	REF	1	CN
7	NFAL	FACHR	TNKFA	FACHR	REF	1	CN
8	NFAL	FATYP	TN15C	CASETY	KEY	1	CN
9	NFAL	FGTYP	TN15F	GBTYP	REF	1	CN
10	NFAL	GREIN	T006	MSEHI	REF	1	CN
11	NFAL	GWEIN	T006	MSEHI	REF	1	CN
12	NFAL	KTABK	TNCH13	AGREEMENT	KEY	1	CN
13	NFAL	KTTAR	TNCH12	TARCDE	KEY	1	CN
14	NFAL	MANDT	T000	MANDT	KEY	1	CN
15	NFAL	PATNR	NPAT	PATNR	REF	1	CN
16	NFAL	WKAT	TN15H	WKAT	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in