| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IAM/D_DSIG_ACT | Digital Signature for Activity | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
2 | /IAM/D_DSIG_ISS | Digital Signature for Issue | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
3 | /XFT/SRMCYCLE30 | Cycle: Signature Metadata Table | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
4 | DRAW_DS | Digital Signature for Document Info Records | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
5 | FIGEKWC_ROLESEQ | Assign Form Signatures to Roles | 4 | SIGN_ID | Signature ID for Legal Forms | nvarchar | 10 | 0 | | |
6 | FILFGNC_ROLESEQ | Assign Form Signatures to Roles | 4 | SIGN_ID | SIgnature ID for FI legal forms | nvarchar | 10 | 0 | | |
7 | ZPHT_IDES_RECORD | Meta Data Table for IDES Pharma Demo (Regulatory Submission) | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPAudit Management |
8 | PLM_AUDIT_DS | Digital Signature for Audit Management Objects | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPBrowser-Based PI Sheet Cockpit |
9 | POC_DB_DEV_SIGN | Signature Key: Metadata Signature Process Step | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
10 | POC_DB_EVT_SIGN | Signature Keys: Metadata for Event Log | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
11 | POC_DB_STEP_SIGN | Signature Key: Metadata Signature Process Step | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPDigital Signature |
12 | DSIG_META_EX | Signature Tool: Sample Database Table for Metadata | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
13 | SIGNDO | Digital Signature: Documents to Sign | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
14 | SIGNH | Digital Signature: Header Data | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
15 | SIGNS | Transaction Data for Digital Signatures | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPEngineering Change Record |
16 | /PLMB/ER_DS_META | Engineering Record - Digital Signature Meta Data table | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPFinancial Supply Chain Management |
17 | BNK_META_LOG | Meta Table: Logs for Signature Bank Communication | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPGovernance, Risk and Compliance |
18 | GRFN_ESIG_TAB2 | master data table for grc pc fda e-sig, v3 | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPLogbook |
19 | DIACL_DIS_SIG | DS : Order operation within Logbook (For Distribution) | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
20 | DIACL_DS | Logbook digital signatures | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPMaintenance History |
21 | AFVC_DIS_SIG | Digital Signature of Order Operation for Distribution | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
22 | AFVC_DS | Digital signatures for Order Operation | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPProcess Controls |
23 | GRPC_ESIG_TAB | master data table for grc pc fda e-sig | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
24 | GRPC_T_FDA_ESIG | DB meta data table for GRC FDA E-Sig | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPProcess Management |
25 | CMX_XSR_DS_META | Metadata Table for Digital Signature for SXS Versions | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
26 | CMX_XSR_VER_SIGN | Metadata Table for Digital Signatures for SXS Versions | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPProduction Orders |
27 | COCF_SR_DSIGMETA | Signature Tool: Metadata for Shift Report | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPQuality Inspection |
28 | QLOT_DS | Digital Signature for Inspection Lots | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPQuality Management |
29 | QNOTIF_HEADER_DS | Digital Signature for Notifications - Header Level | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
30 | QNOTIF_TASK_DS | Digital Signature for Notifications - Task Level | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
31 | ZQMEL_EVT_SIGN | PH: Event log table for digital signature extensions | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |
TOPResults Recording |
32 | QAMR | Characteristic results during inspection processing | 84 | SIGN_ID | Digital Signature for Process | nvarchar | 22 | 0 | | |
33 | QASR | Sample results for inspection characteristics | 80 | SIGN_ID | Digital Signature for Process | nvarchar | 22 | 0 | | |
TOPSample Management |
34 | QSAMPLE_DS | Digital Signature for Samples | 2 | SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | nvarchar | 22 | 0 | | |