Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ALLSCRIPTS_LATIN_SIG
Touchworks 25.2
[dbo].[ALLSCRIPTS_LATIN_SIG]
MS_Description
Master table which holds the Dosage Frequency units which is used for prescription
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
(3)
ALLSCRIPTS_LAT_SIG_CD
char(15)
15
NOT NULL
Key to the ALLSCRIPTS_LATIN_SIG table
ALLSCRIPTS_LAT_SIG_DESC
varchar(1000)
1000
NULL allowed
Description of Dosage Frequency Units used for prescription. Ex : TWICE DAILY,BEDTIME,ONCE
TRAN_CD
char(1)
1
NOT NULL
Indicates Status of SIG. A for Appended, D for Deleted
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.