| 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 | ORGID | Identification Key of Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | | ORGID | Allow NULL? |
| 3 | ORGTY | IS-H: Category of Organizational Unit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN10A | ORGTYP | Allow NULL? |
| 4 | ORGNA | IS-H: Organizational Unit Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ORGNA | Allow NULL? |
| 5 | ORGZU | Additional Name of Organizational Unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ORGZU | Allow NULL? |
| 6 | ORGKB | IS-H: Organizational Unit Short Text | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ORGKB | Allow NULL? |
| 7 | OKURZ | IS-H: Identifier of Organizational Unit in the Application | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OEKURZ | Allow NULL? |
| 8 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 9 | ARCHV | IS-H: Archived Data Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ARCHIV | Allow NULL? |
| 10 | LAND | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 11 | PSTLZ | IS-H: Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | RI_PLZ | Allow NULL? |
| 12 | ORT | City | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT01 | Allow NULL? |
| 13 | STRAS | IS-H: Street and Street Number of Organizational Unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | STRAS_ORG | Allow NULL? |
| 14 | TELNR | IS-H: Telephone Number of Organizational Unit | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELF_ORG | Allow NULL? |
| 15 | TELFX | Fax Number of Organizational Unit | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TELFX_ORG | Allow NULL? |
| 16 | TELTX | IS-H: Teletex number of organizational unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TELTX_ORG | Allow NULL? |
| 17 | KZTXT | IS-H: Comment on Organizational Unit | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_ORG | Allow NULL? |
| 18 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 19 | FACHR | Specialty According to Federal Regulation for Hospitals | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY1 | Allow NULL? |
| 20 | FACHR2 | Specialty According to German Statistical Regulatory Req. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY2 | Allow NULL? |
| 21 | FACHR3 | Specialty According to Nursing Staff Regulation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY3 | Allow NULL? |
| 22 | SPERR | Blocking Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_SPERR | Allow NULL? |
| 23 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 24 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ENDDT | Allow NULL? |
| 25 | BELEG | OU May Assign Patients to Beds on OU of Other Dept | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_BELKZ | Allow NULL? |
| 26 | FREIG | Release Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FREIG | Allow NULL? |
| 27 | FAZUW | Indicator that Departmental Assignment Is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | FAZUW | Allow NULL? |
| 28 | PFZUW | Nursing Assignment Is Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PFZUW | Allow NULL? |
| 29 | AUFKZ | Admitting Facility Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGAUF | Allow NULL? |
| 30 | INTKZ | Interdepartmental Bed Assignment Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_INTKZ | Allow NULL? |
| 31 | INTEN | Intensive Care Indicator of Organizational Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_INTENS | Allow NULL? |
| 32 | AMBES | Outpatient Visit Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | AMBES | Allow NULL? |
| 33 | ORGDS | Data Protection Applies to an Organizational Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | ORGDS | Allow NULL? |
| 34 | PPRKZ | Ind. That OU Excluded from Nursing Acuity Classification | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PPRKZ | Allow NULL? |
| 35 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 36 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 37 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 38 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 39 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 40 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 41 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 42 | ARCOE | IS-H: Organizational Unit is Medical Record Archive | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ARCORG | Allow NULL? |
| 43 | SPVON | Blocking Date From (Entry Block) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_SPERRV | Allow NULL? |
| 44 | SPBIS | IS-H: Blocking Date To (Entry Block To) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ISH_SPERRB | Allow NULL? |
| 45 | FACHR9 | Specialty - User-Definable | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY9 | Allow NULL? |
| 46 | PAEDKZ | Indicator for Pediatrics | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PAED | Allow NULL? |
| 47 | ABRKZ | IS-H: Indicator whether OU is Authorized to Bill Indepndtly | char | 1 | 0 | CHAR | (N' ') | Yes | | ABR_ORGID | Allow NULL? |
| 48 | KSTKZ | IS-H: Allocation Indicator Cost Center | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KSTKZ | Allow NULL? |
| 49 | N1ANFGP | Locked for Request | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ANFGP | Allow NULL? |
| 50 | N1ANFKZ | Can be Requested Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ANFKZ | Allow NULL? |
| 51 | N1DIKZ | Scheduling Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1DIKZ | Allow NULL? |
| 52 | N1ERBRKZ | Performability Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1ERBRKZ | Allow NULL? |
| 53 | N1AUFANZ | Number of Standard Calls | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | N1AUFANZ | |
| 54 | N1AUFZR | Call Period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | N1AUFZR | Allow NULL? |
| 55 | N1CODEKZ | Encoding Requirement Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1CODEKZ | Allow NULL? |
| 56 | N1EXANKZ | External Requestability Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1EXANKZ | Allow NULL? |
| 57 | N1KABKZ | Changing Room Assignment Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1KABKZ | Allow NULL? |
| 58 | N1LEZWKZ | Registration Dept. Indicator Obligatory | char | 1 | 0 | CHAR | (N' ') | Yes | | N1LEZWKZ | Allow NULL? |
| 59 | N1LSTTYP | Service Facility Categories | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TN1LST | N1LST_TYP | Allow NULL? |
| 60 | N1TERVKZ | Appointment Allocation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | N1TERVKZ | Allow NULL? |
| 61 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TARLS | Allow NULL? |
| 62 | ADDIN | Additional Per Diem Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ADD_IND | Allow NULL? |
| 63 | FACHR1 | Specialty According to Federal Regulation for Hospitals 1995 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY0 | Allow NULL? |
| 64 | FACHR4 | Specialty According to KRAZAF | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY4 | Allow NULL? |
| 65 | FACHR5 | Specialty for Physicians | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY5 | Allow NULL? |
| 66 | FACHRA | Specialty - User-Definable | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY9 | Allow NULL? |
| 67 | FACHRB | Specialty - User-Definable | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY9 | Allow NULL? |
| 68 | FACHRC | Specialty - User-Definable | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY9 | Allow NULL? |
| 69 | FACHR6 | Specialty According to POLIS | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY6 | Allow NULL? |
| 70 | CALEN | IS-H: Calendar of an Organizational Unit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | ISH_ORGCAL | Allow NULL? |
| 71 | ADRNR | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NADR | ISH_ADRNR | Allow NULL? |
| 72 | ADROB | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 73 | FACHR7 | Specialty for Organizational Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTY7 | Allow NULL? |
| 74 | SLWRK | Plant of Care Unit Storage Facility for Org. Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TNM01 | ISH_MOEWERKS | Allow NULL? |
| 75 | SLLGO | Plant of Care Unit Storage Facility for Org. Unit | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001L | ISH_MOELGORT | Allow NULL? |
| 76 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | ISH_EANNR | Allow NULL? |
| 77 | BELAB | External Physician Department | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_EXTDPT | Allow NULL? |
| 78 | FACHRD | Specialty acc. to KHStatV for Special Institutions | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FACHRTYD | Allow NULL? |
| 79 | MIGRATED_OBJID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | HROBJID | Allow NULL? |
| 80 | ESTABCODE | Establishment Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_ESTABCODE | Allow NULL? |
| 81 | AMBCODE | Ambulatory Code | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | TN50AC | ISH_IT_AMBCODE | Allow NULL? |
