SAP ABAP Table NORG (IS-H: Organizational Units)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NBAS (Package) Appl. development Hospital System master data, catalogs
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NBAS (Package) Appl. development Hospital System master data, catalogs
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | NORG | Table Relationship Diagram |
Short Description | IS-H: Organizational Units |
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 | ORGID | ORGID | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit Identification Key | ||
3 | ORGTY | ORGTYP | ORGTYP | CHAR | 2 | 0 | IS-H: Category of Organizational Unit | TN10A | |
4 | ORGNA | ORGNA | TEXT30 | CHAR | 30 | 0 | IS-H: Organizational Unit Name | ||
5 | ORGZU | ORGZU | TEXT30 | CHAR | 30 | 0 | IS-H: Additional Name of Organizational Unit | ||
6 | ORGKB | ORGKB | TEXT12 | CHAR | 12 | 0 | IS-H: Organizational Unit Short Text | ||
7 | OKURZ | OEKURZ | ORGKZ | CHAR | 5 | 0 | IS-H: Identifier of Organizational Unit in the Application | ||
8 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
9 | ARCHV | ARCHIV | XFELD | CHAR | 1 | 0 | IS-H: Archived Data Indicator | ||
10 | LAND | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
11 | PSTLZ | RI_PLZ | PSTLZ | CHAR | 10 | 0 | IS-H: Postal Code | ||
12 | ORT | ORT01 | TEXT25 | CHAR | 25 | 0 | City | ||
13 | STRAS | STRAS_ORG | TEXT30 | CHAR | 30 | 0 | IS-H: Street and Street Number of Organizational Unit | ||
14 | TELNR | TELF_ORG | TEXT16 | CHAR | 16 | 0 | IS-H: Telephone Number of Organizational Unit | ||
15 | TELFX | TELFX_ORG | TEXT31 | CHAR | 31 | 0 | Fax Number of Organizational Unit | ||
16 | TELTX | TELTX_ORG | TEXT30 | CHAR | 30 | 0 | IS-H: Teletex number of organizational unit | ||
17 | KZTXT | TEXT_ORG | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Organizational Unit | ||
18 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
19 | FACHR | FACHRTY1 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty acc. to Federal Reg. for Hospitals (Germany) | * | |
20 | FACHR2 | FACHRTY2 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty acc. to German Statistical Regulatory Req. | * | |
21 | FACHR3 | FACHRTY3 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty according to Nursing Staff Regulation | * | |
22 | SPERR | RI_SPERR | XFELD | CHAR | 1 | 0 | Blocking Indicator | ||
23 | BEGDT | RI_BEGDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Record | ||
24 | ENDDT | RI_ENDDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-To Date of Record | ||
25 | BELEG | RI_BELKZ | XFELD | CHAR | 1 | 0 | IS-H: OU May Assign Patients to Beds on OU of Other Dept | ||
26 | FREIG | FREIG | XFELD | CHAR | 1 | 0 | IS-H: Release Indicator | ||
27 | FAZUW | FAZUW | XFELD | CHAR | 1 | 0 | Indicator that Departmental Assignment Is Allowed | ||
28 | PFZUW | ISH_PFZUW | XFELD | CHAR | 1 | 0 | IS-H: Nursing Assignment is Allowed | ||
29 | AUFKZ | ORGAUF | XFELD | CHAR | 1 | 0 | IS-H: Admitting Facility Indicator | ||
30 | INTKZ | RI_INTKZ | XFELD | CHAR | 1 | 0 | IS-H: OU Can Be Assigned Patients From Other Department | ||
31 | INTEN | ISH_INTENS | XFELD | CHAR | 1 | 0 | IS-H: Intensive Care Indicator of Organizational Unit | ||
32 | AMBES | AMBES | XFELD | CHAR | 1 | 0 | IS-H: Outpatient Visit Allowed | ||
33 | ORGDS | ORGDS | XFELD | CHAR | 1 | 0 | IS-H: Data Protection Applies to OU | ||
34 | PPRKZ | ISH_PPRKZ | XFELD | CHAR | 1 | 0 | IS-H: OU Excluded from Nursing Acuity Classification | ||
35 | LOEKZ | RI_LOEKZ | XFELD | CHAR | 1 | 0 | Deletion Flag/Indicator | ||
36 | LOUSR | RI_LOUSR | USNAM | CHAR | 12 | 0 | IS-H: User who Deleted Record | ||
37 | LODAT | RI_LODAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Deletion | ||
38 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
39 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
40 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
41 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
42 | ARCOE | ISH_ARCORG | XFELD | CHAR | 1 | 0 | IS-H: Organizational Unit is Medical Record Archive | ||
43 | SPVON | ISH_SPERRV | RI_DATUM | DATS | 8 | 0 | IS-H: Blocking Date from (Entry Block) | ||
44 | SPBIS | ISH_SPERRB | RI_DATUM | DATS | 8 | 0 | IS-H: Blocking Date To (Entry Block To) | ||
45 | FACHR9 | FACHRTY9 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty - User-Definable | * | |
46 | PAEDKZ | ISH_PAED | ISH_XFELD | CHAR | 1 | 0 | IS-H: Indicator for Pediatrics | ||
47 | ABRKZ | ABR_ORGID | XFELD | CHAR | 1 | 0 | IS-H: Indicator whether OU is Authorized to Bill Indepndtly | ||
48 | KSTKZ | ISH_KSTKZ | XFELD | CHAR | 1 | 0 | IS-H: Allocation Indicator Cost Center | ||
49 | N1ANFGP | N1ANFGP | XFELD | CHAR | 1 | 0 | Locked for Request | ||
50 | N1ANFKZ | N1ANFKZ | XFELD | CHAR | 1 | 0 | Can be Requested Indicator | ||
51 | N1DIKZ | N1DIKZ | XFELD | CHAR | 1 | 0 | Scheduling Indicator | ||
52 | N1ERBRKZ | N1ERBRKZ | XFELD | CHAR | 1 | 0 | Performability Indicator | ||
53 | N1AUFANZ | N1AUFANZ | INT1 | INT1 | 3 | 0 | Number of Standard Calls | ||
54 | N1AUFZR | N1AUFZR | INT3 | NUMC | 3 | 0 | Call Period | ||
55 | N1CODEKZ | N1CODEKZ | XFELD | CHAR | 1 | 0 | Encoding Requirement Indicator | ||
56 | N1EXANKZ | N1EXANKZ | XFELD | CHAR | 1 | 0 | External Requestability Indicator | ||
57 | N1KABKZ | N1KABKZ | XFELD | CHAR | 1 | 0 | Changing Room Assignment Indicator | ||
58 | N1LEZWKZ | N1LEZWKZ | XFELD | CHAR | 1 | 0 | Registration Dept. Indicator Obligatory | ||
59 | N1LSTTYP | N1LST_TYP | N1LST_TYP | CHAR | 3 | 0 | Service Facility Categories | TN1LST | |
60 | N1TERVKZ | N1TERVKZ | XFELD | CHAR | 1 | 0 | Appointment Allocation Indicator | ||
61 | TALST | TARLS | TARLS | CHAR | 10 | 0 | IS-H: Service in Service Catalog | * | |
62 | FACHR1 | FACHRTY0 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty According to Fed. Reg. Hosp. 1995 (Germany) | * | |
63 | FACHR4 | FACHRTY4 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty according to Krazaf (Austria) | * | |
64 | FACHR5 | FACHRTY5 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Physician Specialty | * | |
65 | FACHRA | FACHRTY9 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty - User-Definable | * | |
66 | FACHRB | FACHRTY9 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty - User-Definable | * | |
67 | FACHRC | FACHRTY9 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty - User-Definable | * | |
68 | FACHR6 | FACHRTY6 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty according to POLIS (Netherlands) | * | |
69 | CALEN | ISH_ORGCAL | WFCID | CHAR | 2 | 0 | IS-H: Calendar of an Organizational Unit | TFACD | |
70 | ADRNR | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | NADR | |
71 | ADROB | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
72 | FACHR7 | FACHRTY7 | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty for Organizational Unit | * | |
73 | SLWRK | ISH_MOEWERKS | WERKS | CHAR | 4 | 0 | IS-H MM: Plant of Care Unit Storage Facility for Org. Unit | TNM01 | |
74 | SLLGO | ISH_MOELGORT | LGORT | CHAR | 4 | 0 | IS-H MM: Plant of Care Unit Storage Facility for Org. Unit | T001L | |
75 | EANNR | ISH_EANNR | CHAR013 | CHAR | 13 | 0 | IS-H: International Article Number (EAN) | ||
76 | BELAB | ISH_EXTDPT | XFELD | CHAR | 1 | 0 | IS-H: External Physician Department | ||
77 | FACHRD | FACHRTYD | ISH_FACHR | CHAR | 4 | 0 | IS-H: Specialty Acc. to KHStatV for Special Institutions | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | NORG | ADRNR | NADR | ADRNR | |||
2 | NORG | CALEN | TFACD | IDENT | 1 | CN | |
3 | NORG | EINRI | TN01 | EINRI | REF | 1 | CN |
4 | NORG | LAND | T005 | LAND1 | KEY | 1 | CN |
5 | NORG | MANDT | T000 | MANDT | KEY | 1 | CN |
6 | NORG | N1LSTTYP | TN1LST | N1LSTTYP | REF | C | CN |
7 | NORG | ORGTY | TN10A | ORGTY | REF | 1 | CN |
8 | NORG | SLLGO | T001L | LGORT | KEY | 1 | CN |
9 | NORG | SLWRK | TNM01 | WERKS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |