| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRFNMWCNPATH | MSMP Path | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
2 | GRFNMWCNPATHT | MSMP Path Description | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
3 | GRFNMWCNPATHV | MSMP Path : Versions | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
4 | GRFNMWCNROUTE | MSMP Route Mapping | 9 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
5 | GRFNMWCNROUTEV | MSMP Routing Rules : Versions | 10 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
6 | GRFNMWCNSTG | MSMP Stage | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
7 | GRFNMWCNSTGT | MSMP Stage Description | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
8 | GRFNMWCNSTGV | MSMP Stage Version | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
9 | GRFNMWNOTIFRECPT | MSMP Stage Notification Recipents | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
10 | GRFNMWNOTIFRECPV | MSMP Stage Notification Recipents - Versions | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
11 | GRFNMWRTDATLG | MSMP Runtime - Instance Execution Data Log | 5 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
12 | GRFNMWRTEXDET | MSMP Runtime - Instance Execution Details | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
13 | GRFNMWRTEXDETH | MSMP Runtime - Instance Execution Details | 9 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
14 | GRFNMWRTFWDRET | MSMP Runtime - Forward and Return for Line Item | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
15 | GRFNMWRTINSTWI | MSMP Runtime - Work Item execution context cache | 10 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
16 | GRFNMWRTKEY | MSMP Runtime - Workflow Instances | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
17 | GRFNMWRTMSGLG | MSMP Runtime - Instance Execution Message Log | 4 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
18 | GRFNMWRTNOTLG | MSMP Runtime - Instance Notification Log | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
19 | GRFNMWRTROUTE | MSMP Runtime - Routing Results History | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
20 | GRFNMWRTSTAPPR | MSMP Runtime - Stage Line Item Approvers | 3 | PATH_ID | Path ID | nvarchar | 20 | 0 | | |
TOPClinical System |
21 | N2GL_ACT | pathways Activity | 3 | PATH_ID | Patient Pathway Key | nvarchar | 32 | 0 | | |
TOPEnterprise Search Integration |
22 | CRMD_ES_ATTR | Node attributes | 7 | PATH_ID | Path ID | nvarchar | 32 | 0 | | |
23 | CRMD_ES_PATHS | Node paths | 4 | PATH_ID | Path ID | nvarchar | 32 | 0 | | |
24 | CRMD_ES_PATHSTEP | Path steps | 5 | PATH_ID | Path ID | nvarchar | 32 | 0 | | |
TOPGRC Access Control Plug-In |
25 | /VIRSA/RULEDET | HR Triggers - Rule Details | 6 | PATH_ID | Character field, 8 characters long | nvarchar | 8 | 0 | | |
TOPRecords and Case Management |
26 | RMPSCASETYPE | Additional Characteristics of Case Types | 4 | PATH_ID | Process Route Template of a Case Type | nvarchar | 12 | 0 | | |