| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1PLATH | IS-H*MED: Day-Related Planning Authority | 4 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
2 | N1TPGL | IS-H*MED: Service quotas for daily program | 3 | POBNR | Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
3 | N1TPGO | IS-H*MED: Day program: Assign OU time segments | 3 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
TOPPatient Management |
4 | N1TPGA | IS-H: Admission Quotas | 3 | POBNR | Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
5 | NAPP | IS-H: Provisional Appointments for Visit Scheduling | 13 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
6 | NAPP_POB | IS-H: Dummy table for lock object ENAPP_ENQ | 2 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
7 | NATM | IS-H/IS-H*MED: Time Slot Modification | 4 | POBNR | IS-H/IS-H*MED: Modification Planning Object | nvarchar | 10 | 0 | | |
8 | NLOC | IS-H: Time Slot Substitutions for Visit Scheduling | 11 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
9 | NPOB | IS-H: Planning Objects for Outpatient Clinic Scheduling | 2 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
10 | NTPGK | IS-H: Day program header data for outpatient dept mgmt | 3 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
11 | NTPGP | IS-H: Day program items (possible appointments) | 3 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
12 | NWPG | IS-H: Week programs for outpatient department management | 3 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
TOPPlanning |
13 | N1APPLAN | IS-H*MED: Plan | 4 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
14 | N1POBDC | ISHMED: Day Comments for Planning Objects | 3 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
15 | N1WVIEW_PG_CL | IS-H*MED: Planning Grid Settings of Planning Objects | 5 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
16 | N1WVIEW_PG_PO | IS-H*MED: Planning Grid Tab Page for Plan. Object View Type | 5 | POBNR | IS-H: Internal Sequence Number of Planning Object | nvarchar | 10 | 0 | | |
TOPResourcen Management |
17 | PNPOBA | RMS-RCP: Attributes of "Process Action" POB Node | 5 | POBNR | Item Number of a Dependent Process Element | nvarchar | 4 | 0 | | |
18 | PNPOBO | RMS-RCP: Attributes of the "Process Operation" POB Node | 5 | POBNR | Item Number of a Dependent Process Element | nvarchar | 4 | 0 | | |
19 | PNPOBS | RMS-RCP: Attributes of POB Nodes, Process and Stage | 5 | POBNR | Item Number of a Dependent Process Element | nvarchar | 4 | 0 | | |