| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1POPAKTE | IS-H*Med: Patient Organizer - Redundant Structure | 63 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
2 | N2BIRESPW | ISHMED: Base Items Result Table Pathways | 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
3 | N2GL_TM_KEY_DOC | IS-H*MED: Key of Document Created Using Pathways | 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
4 | N2GL_TM_KEY_REQ | IS-H*MED: Key of Request Created Using Pathways | 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
5 | N2GL_TM_PROF | IS-H*MED: Occupational Groups for Subsequent Activity | 3 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
6 | N2GL_TM_SCHEDULE | pathways Patient Pathway | 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
7 | N2GL_TM_STEP | pathways Step of Patient Pathway | 2 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
8 | N2VDNOTE_CONTEXT | IS-H*MED PD: Context of a Progress Entry | 13 | SCHEDULE_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
TOPLine Maintenance |
9 | /ISDFPS/CLMSH1 | PM: Activate Time Update | 2 | SCHEDULE_ID | ID for Scheduler Control (Time Update) | nvarchar | 4 | 0 | | |
10 | /ISDFPS/CLMSH2 | PM: Control Time Update | 2 | SCHEDULE_ID | ID for Scheduler Control (Time Update) | nvarchar | 4 | 0 | | |
TOPNon Profit Organizations |
11 | T7UNPF_YI_SCHE | UNJSPF Yearly Interface data table | 3 | SCHEDULE_ID | Schedule Identifier | nvarchar | 1 | 0 | | |
TOPTools |
12 | HRPYO_D_CYCL | Cycles | 3 | SCHEDULE_ID | Entity Id | nvarchar | 32 | 0 | | |
13 | HRPYO_D_DEPCY | Schedule Dependency | 10 | SCHEDULE_ID | Entity Id | nvarchar | 32 | 0 | | |
14 | HRPYO_D_SCHDL | Schedule | 2 | SCHEDULE_ID | Entity Id | nvarchar | 32 | 0 | | |
15 | HRPYO_D_SCHDLT | Text table for schedule | 3 | SCHEDULE_ID | Entity Id | nvarchar | 32 | 0 | | |
16 | HRPYO_D_SHPROFIL | Schedule profile | 2 | SCHEDULE_ID | Entity Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Application |
17 | WFA_AGT_SCHST | Agent Schedule Statistics | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
18 | WFA_SCHDL_AUD | Schedule Audit - OBSOLETE | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
19 | WFA_SCHEDULE | Schedule Table | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
20 | WFA_SCHE_BENF | Actual imported benefits table | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
21 | WFA_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
22 | WFA_SCH_STATS | Schedule Stats - by Workarea | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
23 | WFA_SHIFT | Shift Table | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
24 | WFA_SHIFT_SG2 | Shifts Segments for WFM Schedule | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
25 | WFA_VIOLATION | Violations | 7 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
TOPWorkforce Management Core |
26 | WFMCAS_AGT_SCHST | Agent Schedule Statistics | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
27 | WFMCAS_SCHDL_AUD | Schedule Audit - OBSOLETE | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
28 | WFMCAS_SCHEDULE | Schedule Table | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
29 | WFMCAS_SCHE_BENF | Actual imported benefits table | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
30 | WFMCAS_SCH_AGTST | Schedule Stats - by Workarea and by Agent | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
31 | WFMCAS_SCH_STATS | Schedule Stats - by Workarea | 2 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
32 | WFMCAS_SHIFT | Shift Table | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
33 | WFMCAS_SHIFT_SG2 | Shifts Integrated with WFD Server | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
34 | WFMCAS_VIOLATION | Violations | 7 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |
35 | WFMCAS_WRK_SEG | Actual Work Segment - OBSOLETE | 3 | SCHEDULE_ID | Schedule Id | nvarchar | 32 | 0 | | |