| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Mandant | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | EINRI | IS-H: Einrichtung | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | PATNR | IS-H: Patientennummer | nvarchar | 10 | 0 | CHAR | (N' ') | No | NPAT | PATNR | Allow NULL? |
| 4 | DBCNR | Laufende Nummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | ISH_NL_DBCNR | Allow NULL? |
| 5 | DATUM | ISH_NL: Datum | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ISH_NL_DAT | Allow NULL? |
| 6 | TIME | Systemzeit | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | SYUZEIT | Allow NULL? |
| 7 | SPEM | Geisteskrankheit fachrichtung | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_GGZ_SPEM | Allow NULL? |
| 8 | DBC | Geisteskrankheit DBC bestandteile | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_DBC | Allow NULL? |
| 9 | BARNR | IS-H NL: Personalnummer des Arztes verantwortlich für DBC | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISH_NL_DBC_ARZT | Allow NULL? |
| 10 | NW_PATIENT | Geisteskrankheit neuer Patient | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_NW_PAT | Allow NULL? |
| 11 | CIRCUIT | Geisteskrankheit behandlungs kreis | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_CIRCUIT | Allow NULL? |
| 12 | CARETYPE | Geisteskrankheit Sorgetype | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_CARETYPE | Allow NULL? |
| 13 | DIAGN1 | Geisteskrankheit diagnosen 1 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_DIAGN1 | Allow NULL? |
| 14 | DIAGN2 | Geisteskrankheit diagnosen 2 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_DIAGN2 | Allow NULL? |
| 15 | DIAGN3 | Geisteskrankheit diagnosen 3 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_DIAGN3 | Allow NULL? |
| 16 | DIAGN4 | Geisteskrankheit diagnosen 4 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_DIAGN4 | Allow NULL? |
| 17 | DIAGN1_PRI | Geisteskrankheit primär Kennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PRI | Allow NULL? |
| 18 | DIAGN2_PRI | Geisteskrankheit primär Kennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_PRI | Allow NULL? |
| 19 | DIAGN2_LIKE | Geisteskrankheit Züge von | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_LIKE | Allow NULL? |
| 20 | GAF_START | Geisteskrankheit GAF start | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_GAF_START | Allow NULL? |
| 21 | GAF_HIGH | Geisteskrankheit GAF high | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_GAF_HIGH | Allow NULL? |
| 22 | GAF_END | Geisteskrankheit GAF end | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_GAF_END | Allow NULL? |
| 23 | BEGDT | ISH_NL: Anfang datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DBC_BEGDT | Allow NULL? |
| 24 | ENDDT | ISH_NL: Ende datum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_NL_DBC_ENDDT | Allow NULL? |
| 25 | AFCODE | Geisteskrankheit Abschlußkode | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ISH_NL_GGZ_AFCODE | Allow NULL? |
| 26 | STATUS | ISH_NL: DBC interner status | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_STATUS | Allow NULL? |
| 27 | ESTATUS | ISH_NL: Externer DBC status | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_NL_ESTATUS | Allow NULL? |
| 28 | STORN | IS-H: Stornokennzeichen | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 29 | DDBCNR | Laufende Nummer DBC-code | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | ISH_NL_DBCNR | Allow NULL? |
| 30 | DDBC | ISH_NL: DBC | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC | Allow NULL? |
| 31 | UPDAT | IS-H: Änderungsdatum | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 32 | UPUSR | IS-H: Name des ändernden Sachbearbeiters | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 33 | EVENT | IS-H NL: Ereignis, durch welches DBC's erzeugt wurden | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_NL_DBC_EVENT | Allow NULL? |
| 34 | OBJCT | IS-H NL: Objekt, durch das DBC's erzeugt wurden | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC_OBJECT | Allow NULL? |
| 35 | EVTUP | IS-H NL: Ereignis, durch welches DBC's geändert wurden | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ISH_NL_DBC_EVT_UP | Allow NULL? |
| 36 | OBJUP | IS-H NL: Objekt, durch das DBC's geändert wurden | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_NL_DBC_OBJ_UP | Allow NULL? |
| 37 | TCODE | Transaktionscode | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | TCODE | Allow NULL? |
| 38 | TIMESTAMP | UTC-Zeitstempel in Kurzform (JJJJMMTThhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
