SAP ABAP Table NICP (IS-H: Surgical Procedure Codes Performed)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NICP	Table Relationship Diagram
Short Description	IS-H: Surgical Procedure Codes Performed

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	LNRIC	☑	ISH_LNRIC	ISH_LNRIC	CHAR	10	0	IS-H: Sequence Number of Surgical Procedure Code
3	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
4	ICPMK	☐	ICPM_ID	TARID	CHAR	2	0	IS-H: Identification of Surgical Procedure Coding Catalog	TNK01
5	ICPML	☐	ICPM_LS	TARLS	CHAR	10	0	IS-H: Surgical Procedure Code (Service)	NTPK
6	ICPHC	☐	ICPM_HCODE	XFELD	CHAR	1	0	IS-H: Main Surgical Procedure Code
7	ANZOP	☐	ISH_ANZOP	NUMC3	NUMC	3	0	IS-H: Number of Additional Surgeries
8	BGDOP	☐	ISH_BEGDT_ICP	RI_DATUM	DATS	8	0	IS-H: Date when Surgical Procedure Code Performed
9	BZTOP	☐	ISH_BEGZT_ICP	UHRZT	TIMS	6	0	IS-H: Time when Surg. Procedure Code Performance Begins
10	EZTOP	☐	ISH_ENDZT_ICP	UHRZT	TIMS	6	0	IS-H: Time when Surgical Procedure was Concluded
11	LSLOK	☐	ISH_PROC_LOC	N2_DIALO	CHAR	2	0	IS-H: Localization of a Procedure	TN26E
12	IDENT	☐	ISH_IDENT	ISH_REFKY	CHAR	20	0	IS-H: Identification from External System
13	OPART	☐	ISH_OPART	ISH_OPART	CHAR	2	0	IS-H: Type of Surgery	TN14O
14	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
15	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
16	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
17	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
18	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
19	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application	*
20	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
21	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
22	BTEXT	☐	ISH_PROCTEXT	ISH_CHAR50	CHAR	50	0	IS-H: User-Defined Comment on Procedure
23	EVENT	☐	PROC_EVENT	PROC_EVENT	NUMC	2	0	IS-H: Event that Triggers Creation of Procedure
24	OBJCT	☐	PROC_OBJECT	ISH_OBJECT	CHAR	10	0	IS-H: Object that Created the Procedure
25	DRG_SEQNO	☐	ISH_DRG_PROC_SEQNO	ISH_SEQNO	NUMC	3	0	IS-H: Entry Sequence of DRG-Relevant Procedure
26	DRG_CATEGORY	☐	ISH_DRG_PROC_CATEGORY	ISH_DRG_PROC_CATEGORY	CHAR	1	0	IS-H: Category of DRG Procedure (Principal, Secondary)
27	DRG_RELEVANT	☐	ISH_DRG_PROC_RELEVANT	ISH_ON_OFF	CHAR	1	0	IS-H: Indicator "Used to Determine DRG"
28	BEMKZ	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
29	ORGFA	☐	ISH_FACHOE_PROC	ORGID	CHAR	8	0	IS-H: Departmental Organizational Unit of Procedure	*
30	ORGPF	☐	ISH_ERBOE_PROC	ORGID	CHAR	8	0	IS-H: Date when Surgical Procedure Code Was Completed	*
31	ENDOP	☐	ISH_ENDDT_ICP	RI_DATUM	DATS	8	0	IS-H: Date when Surgical Procedure Code Was Completed
32	PRTYP	☐	ISH_PROC_TYPE	ISH_PROC_TYPE	CHAR	2	0	IS-H: Procedure Type
33	EVTUP	☐	PROC_EVTUP	PROC_EVTUP	NUMC	2	0	IS-H: Event that Caused Procedure to Be Modified
34	OBJUP	☐	PROC_OBJUP	ISH_OBJ_UP	CHAR	10	0	IS-H: Object That Caused Procedure to Be Modified
35	TIMESTAMP	☐	ISH_TIMESTAMP	TZNTSTMPS	DEC	15	0	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
36	QUANTITY	☐	ISH_PROC_QUANTITY	ISH_PROC_QUANTITY	QUAN	20	8	Procedure Quantity
37	UNIT	☐	ISH_PROC_UNIT	MEINS	UNIT	3	0	Unit of Measure for Procedure	T006
38	LNRIC_REF	☐	ISH_LNRIC_REF	ISH_LNRIC	CHAR	10	0	Sequence Number of Reference Surgical Procedure Code
39	LNRLM	☐	ISH_LNRLP	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of Material Consumption
40	DRG_IMPACT	☐	ISH_PROC_DRG_IMPACT	ISH_DRG_IMPACT	CHAR	2	0	Impact of Procedure on DRG Determination
41	CCL	☐	ISH_CCL_PROC	ISH_CCL_TYPE	NUMC	3	0	Complication Level of Procedure (for DRGs)
42	OPLEBSPEN	☐	ISH_OPLEBSPEN	XFELD	CHAR	1	0	OPS Living Donor Transplantation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NICP	EINRI	TN01	EINRI	REF	1	CN
2	NICP	FALNR	NFAL	FALNR	REF	1	CN
3	NICP	ICPMK	TNK01	KATID	REF	1	CN
4	NICP	ICPML	NTPK	TALST	REF	1	CN
5	NICP	LFDBEW	NBEW	LFDNR	REF	1	CN
6	NICP	LSLOK	TN26E	DIALO	KEY	1	CN
7	NICP	MANDT	T000	MANDT	KEY	1	CN
8	NICP	OPART	TN14O	OPART	REF	1	CN
9	NICP	UNIT	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in