Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (6) | ALLSCRIP_SIG_CD | char(15) | 15 | NOT NULL | | Key to the ALLSCRIP_SIG table |
(2) | DAILY_METRIC_QTY | float | 8 | NOT NULL | | Indicates the number of units of the medication to be consumed per day. |
(2) | SIG_DESC_ENGLISH | varchar(1000) | 1000 | NULL allowed | | SIG Description in English |
 | SIG_DESC_SPANISH | varchar(1000) | 1000 | NULL allowed | | SIG Description in Spanish |
(2) | DOSE_FREQ | int | 4 | NULL allowed | | Number of times per day to take the medication. |
 | TRAN_CD | char(1) | 1 | NOT NULL | | Indicates Status of SIG. A for Appended, D for Deleted |
 ![Check Constraints CK_ALLSCRIP_SIG_ACTV_IND : ([ACTV_IND]='N' OR [ACTV_IND]='Y') Check Constraints CK_ALLSCRIP_SIG_ACTV_IND : ([ACTV_IND]='N' OR [ACTV_IND]='Y')](../../../../Images/c-constraint.png) | ACTV_IND | char(1) | 1 | NOT NULL | ('Y') | Indicates Active or Non Active record. Ex: Y for Active , N for Non Active |
| USER_ID_REC_CREATE | char(20) | 20 | NOT NULL | ('SYSTEM') | Record Created by. |
| DATETIME_REC_CREATE | datetime | 8 | NOT NULL | (getdate()) | Record created date time. |
| USER_ID_LAST_MOD | char(20) | 20 | NOT NULL | ('SYSTEM') | Record last modified by |
| DATETIME_LAST_MOD | datetime | 8 | NULL allowed | (getdate()) | Date and Time of record last modified. |
(2)![Foreign Keys FK1_ALLSCRIP_SIG: [dbo].[ALLSCRIPTS_LATIN_SIG].ALLSCRIPTS_LAT_SIG_CD Foreign Keys FK1_ALLSCRIP_SIG: [dbo].[ALLSCRIPTS_LATIN_SIG].ALLSCRIPTS_LAT_SIG_CD](../../../../Images/fk.png) | ALLSCRIPTS_LAT_SIG_CD | char(15) | 15 | NULL allowed | | Link to ALLSCRIPTS_LATIN_SIG.ALLSCRIPTS_LAT_SIG_CD. |
 | SIGAction | varchar(10) | 10 | NULL allowed | | Indicates how the medication to be consumed. Ex : Inhale, Rub, Sprinkle, Massage, Inject Etc |
 | SIGDoseQty | float | 8 | NULL allowed | | Indicates the number of units of the medication to be consumed per dose. |
 | SIGDoseUnits | varchar(10) | 10 | NULL allowed | | Indicates Dose Units. Ex. Spray, ML , STRIP , Inch, Packet etc |
| ADMIN_ROUTE_DE | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Indicates the Route of Administration. Link to Route_Of_Admin_DE.ID |