Tables [dbo].[ALLSCRIPTS_LATIN_SIG]
Master table which holds the Dosage Frequency units which is used for prescription
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_ALLSCRIPTS_LATIN_SIG: ALLSCRIPTS_LAT_SIG_CDIndexes TWstat_ALLSCRIPTS_LATIN_SIG_ACTV_IND_ALLSCRIPTS_LAT_SIG_CD, TWstat_ALLSCRIPTS_LATIN_SIG_ALLSCRIPTS_LAT_SIG_DESC_ALLSCRIPTS_LAT_SIG_CD, TWstat_ALLSCRIPTS_LATIN_SIG_TRAN_CD_ALLSCRIPTS_LAT_SIG_CD(3)ALLSCRIPTS_LAT_SIG_CDchar(15)15NOT NULLKey to the ALLSCRIPTS_LATIN_SIG table
Indexes TWstat_ALLSCRIPTS_LATIN_SIG_ALLSCRIPTS_LAT_SIG_DESC_ALLSCRIPTS_LAT_SIG_CDALLSCRIPTS_LAT_SIG_DESCvarchar(1000)1000NULL allowedDescription of Dosage Frequency Units used for prescription. Ex : TWICE DAILY,BEDTIME,ONCE
Indexes TWstat_ALLSCRIPTS_LATIN_SIG_TRAN_CD_ALLSCRIPTS_LAT_SIG_CDTRAN_CDchar(1)1NOT NULLIndicates Status of SIG. A for Appended, D for Deleted
Indexes TWstat_ALLSCRIPTS_LATIN_SIG_ACTV_IND_ALLSCRIPTS_LAT_SIG_CDCheck Constraints CK_ALLSCRIPTS_LATIN_SIG_ACTV_IND : ([ACTV_IND]='N' OR [ACTV_IND]='Y')ACTV_INDchar(1)1NOT NULL('Y')Indicates Active or Non Active record. Ex: Y for Active , N for Non Active
USER_ID_REC_CREATEchar(20)20NOT NULL('SYSTEM')Record Created by.
DATETIME_REC_CREATEdatetime8NOT NULL(getdate())Record created date time.
USER_ID_LAST_MODchar(20)20NOT NULL('SYSTEM')Record last modified by
DATETIME_LAST_MODdatetime8NULL allowed(getdate())Date and Time of record last modified.