Tables [dbo].[ALLSCRIP_SIG]
structured informative group  / Full textual description  indicating all instructions which can be prescribed to a patient.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_ALLSCRIP_SIG: ALLSCRIP_SIG_CDIndexes TWstat_ALLSCRIP_SIG_ALLSCRIPTS_LAT_SIG_CD_ALLSCRIP_SIG_CD, TWstat_ALLSCRIP_SIG_DAILY_METRIC_QTY_ALLSCRIP_SIG_CD, TWstat_ALLSCRIP_SIG_DOSE_FREQ_ALLSCRIP_SIG_CD, TWstat_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ALLSCRIP_SIG_CD, TWstat_ALLSCRIP_SIG_SIG_DESC_SPANISH_ALLSCRIP_SIG_CD, TWstat_ALLSCRIP_SIG_TRAN_CD_ALLSCRIP_SIG_CD(6)ALLSCRIP_SIG_CDchar(15)15NOT NULLKey to the ALLSCRIP_SIG table
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumns, TWstat_ALLSCRIP_SIG_DAILY_METRIC_QTY_ALLSCRIP_SIG_CD(2)DAILY_METRIC_QTYfloat8NOT NULLIndicates the number of units of the medication to be consumed per day.
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumns, TWstat_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ALLSCRIP_SIG_CD(2)SIG_DESC_ENGLISHvarchar(1000)1000NULL allowedSIG Description in English
Indexes TWstat_ALLSCRIP_SIG_SIG_DESC_SPANISH_ALLSCRIP_SIG_CDSIG_DESC_SPANISHvarchar(1000)1000NULL allowedSIG Description in Spanish
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumns, TWstat_ALLSCRIP_SIG_DOSE_FREQ_ALLSCRIP_SIG_CD(2)DOSE_FREQint4NULL allowedNumber of times per day to take the medication.
Indexes TWstat_ALLSCRIP_SIG_TRAN_CD_ALLSCRIP_SIG_CDTRAN_CDchar(1)1NOT NULLIndicates Status of SIG. A for Appended, D for Deleted
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumnsCheck Constraints CK_ALLSCRIP_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.
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumns, TWstat_ALLSCRIP_SIG_ALLSCRIPTS_LAT_SIG_CD_ALLSCRIP_SIG_CD(2)Foreign Keys FK1_ALLSCRIP_SIG: [dbo].[ALLSCRIPTS_LATIN_SIG].ALLSCRIPTS_LAT_SIG_CDALLSCRIPTS_LAT_SIG_CDchar(15)15NULL allowedLink to ALLSCRIPTS_LATIN_SIG.ALLSCRIPTS_LAT_SIG_CD.
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumnsSIGActionvarchar(10)10NULL allowedIndicates how the medication to be consumed. Ex : Inhale, Rub, Sprinkle, Massage, Inject Etc
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumnsSIGDoseQtyfloat8NULL allowedIndicates the number of units of the medication to be consumed per dose.
Indexes NIX_ALLSCRIP_SIG_SIG_DESC_ENGLISH_ACTV_IND_WithIncludeColumnsSIGDoseUnitsvarchar(10)10NULL allowedIndicates Dose Units. Ex. Spray, ML , STRIP , Inch, Packet etc
ADMIN_ROUTE_DE[dbo].[uniqueid]9NOT NULL((0))Indicates the Route of Administration. Link to Route_Of_Admin_DE.ID