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