| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TMNID | IS-H: Identification of Appointment | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_TMNID | Allow NULL? |
| 3 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 4 | PATNR | IS-H: Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NPAT | PATNR | Allow NULL? |
| 5 | PZIFF | Check Digit for Patient | char | 1 | 0 | CHAR | (N' ') | Yes | | PZIFF_PAT | Allow NULL? |
| 6 | EXTNR | IS-H: External Patient Identification | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | EXT_PATNR | Allow NULL? |
| 7 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NFAL | FALNR | Allow NULL? |
| 8 | FZIFF | Check Digit for Case | char | 1 | 0 | CHAR | (N' ') | Yes | | PZIFF_FALL | Allow NULL? |
| 9 | FALAR | IS-H: Case Type | char | 1 | 0 | CHAR | (N' ') | Yes | | FALLART | Allow NULL? |
| 10 | TMNLB | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | NBEW | LFDBEW | Allow NULL? |
| 11 | TMNOE | IS-H: Planned Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ISH_TMNOE | Allow NULL? |
| 12 | TMNDT | IS-H: Date of Appointment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_TMNDT | Allow NULL? |
| 13 | TMNZT | IS-H: Time of Appointment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_TMNZT | Allow NULL? |
| 14 | TMNDR | IS-H: Duration of Appointment | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_TMDAUER | Allow NULL? |
| 15 | NNAME | Patient Last Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | NNAME_PAT | Allow NULL? |
| 16 | VNAME | IS-H: Patient First Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | VNAME_PAT | Allow NULL? |
| 17 | NNAMS | IS-H: Standardized Last Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | NNAMES_PAT | Allow NULL? |
| 18 | VNAMS | Standardized First Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | VNAMES_PAT | Allow NULL? |
| 19 | TITEL | IS-H: Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | RI_TITEL | Allow NULL? |
| 20 | NAMZU | IS-H: Name Affix | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | RI_NAMZU | Allow NULL? |
| 21 | VORSW | IS-H: Name Prefix | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | RI_VORSW | Allow NULL? |
| 22 | GBNAM | IS-H: Birthname | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | GBNAM | Allow NULL? |
| 23 | GBNAS | IS-H: Standardized Birth Name | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | GBNAMS_PAT | Allow NULL? |
| 24 | GBDAT | IS-H: Birthdate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_GBDAT | Allow NULL? |
| 25 | GSCHL | IS-H: Sex Indicator - Internal | char | 1 | 0 | CHAR | (N' ') | Yes | | GSCHL | Allow NULL? |
| 26 | TELF1 | IS-H: Patient Telephone Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELF_PAT | Allow NULL? |
| 27 | TODKZ | IS-H: Patient Is Deceased | char | 1 | 0 | CHAR | (N' ') | Yes | | PAT_TOD | Allow NULL? |
| 28 | SOURC | IS-H: Application that Created Object | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_OBJSRC | Allow NULL? |
| 29 | TMTAG | IS-H: Appointment on Given Day | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_TMTAG | Allow NULL? |
| 30 | REFID | IS-H: Reference Number of Next Appointment | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_REFTMNID | Allow NULL? |
| 31 | NOTAN | IS-H: Emergency Admission Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | NOTAUF | Allow NULL? |
| 32 | KRZAN | IS-H: Quick Admission Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KURZAUF | Allow NULL? |
| 33 | BEKAT | Treatment Category | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN24 | BEKAT | Allow NULL? |
| 34 | RISKF | IS-H: Risk Information Exists for the Patient | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_RISIKO | Allow NULL? |
| 35 | CLASS | IS-H: Patient Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TNP01 | ISH_PAYCL | Allow NULL? |
| 36 | BNKZ | IS-H: Notification of Appointment Desired | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_APP_NOTI_WANTED | Allow NULL? |
| 37 | BNDT | IS-H: Date on which patient was last notified | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_BNDT | Allow NULL? |
| 38 | BNART | IS-H: Type of Notification (Tel., Written) | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_BNART | Allow NULL? |
| 39 | EINBDT | IS-H: Date of Appointment of which Patient Last Notified | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_EINBDT | Allow NULL? |
| 40 | EINBZT | IS-H: Time of Appointment of which Patient Last Notified | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_EINBZT | Allow NULL? |
| 41 | EINBOE | Nursing Org. Unit of Patient's Last Scheduled Appointment | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ISH_EINBOE | Allow NULL? |
| 42 | EINBPER | IS-H: Person/Physician of Last Patient Appt Notification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_EINBPER | Allow NULL? |
| 43 | EINBZIM | IS-H: Building Unit of Last Patient Notification | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ISH_EINBZIM | Allow NULL? |
| 44 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 45 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 46 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 47 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 48 | FATYP | Case Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN15C | ISH_CASETYPE | Allow NULL? |
| 49 | BWART | IS-H: Movement Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RI_BWART | Allow NULL? |
| 50 | TPART | Transport Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | N1TA | N1TPAE | Allow NULL? |
| 51 | BWPRIO | Prioritization for Request/Movement (Internal) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1APRI_D | Allow NULL? |
| 52 | MEDTX | Medical Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | N1MEDTX | Allow NULL? |
| 53 | TMSTG | Cancellation Reason for an Appointment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | N1STGR | ISH_TMSTG | Allow NULL? |
| 54 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 55 | STUSR | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
| 56 | STDAT | Date of Cancellation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORN_DAT | Allow NULL? |
| 57 | VBUND | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 58 | BWGR1 | Movement Reason - 1st and 2nd Positions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN14G | ISH_BWGR1 | Allow NULL? |
| 59 | BWGR2 | Movement Reason - 3rd and 4th Positions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN14G | ISH_BWGR2 | Allow NULL? |
| 60 | UARNR | IS-H: Personnel Number of Referring Physician | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NGPA | UARNR | Allow NULL? |
| 61 | TMPDT | IS-H: Date Planned for Appointment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_TMPDT | Allow NULL? |
| 62 | TMPZT | IS-H: Time Planned for Appointment | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ISH_TMPZT | Allow NULL? |
| 63 | GPLVN | IS-H*MED: Employee or User who Last Planned Appointment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | N1GPLVN | Allow NULL? |
| 64 | GPLTY | IS-H*MED: Appointment Changed by: Employee/User ID | char | 1 | 0 | CHAR | (N' ') | Yes | | N1GPLTY | Allow NULL? |
| 65 | EMAIL | IS-H: Internet Mail (SMTP) Address | nvarchar | 241 | 0 | CHAR | (N' ') | Yes | | ISH_SMTPADR | Allow NULL? |
| 66 | BEWTY | Movement Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BEWTY | Allow NULL? |
| 67 | CHAINID | IS-H: Link ID for Interdependent Appointments | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_APP_CHAINID | Allow NULL? |
| 68 | UNITID | IS-H: Treatment Unit ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_TREATM_UNITID | Allow NULL? |
| 69 | DISTMIN | IS-H: Minimum Interval Between Appointments | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_APPDIST_MIN | Allow NULL? |
| 70 | DISTMAX | IS-H: Maximum Interval Between Appointments | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_APPDIST_MAX | Allow NULL? |
| 71 | DISTUNIT | IS-H: Time Unit for Interval Between Two Appointments | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_APPDIST_UNIT | Allow NULL? |
| 72 | CYCLE | IS-H: Appointment Cycle | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ISH_APPCYCLE | Allow NULL? |
| 73 | CYCLEUNIT | IS-H: Time Unit for Appointment Cycle | char | 1 | 0 | NUMC | (N'0') | Yes | | ISH_APPCYCLE_UNIT | Allow NULL? |
| 74 | VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | N1VKGID | Allow NULL? |
| 75 | PAPID | IS-H: Provisional Patient Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NPAP | ISH_PAPID | Allow NULL? |
| 76 | APCNID | IS-H: Identification of an Appointment Template | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | N1APCNID | Allow NULL? |
| 77 | ENDPL | IS-H: Planning Complete | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ENDPL | Allow NULL? |
| 78 | TIMESTAMP | Timestamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | ISH_TIMESTAMP | |
| 79 | CAUSECHNG | Reason for Change | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | N1CAUSECHNG | Allow NULL? |
| 80 | CSECHGID | Reason for Change ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1CSECHGID | Allow NULL? |
