JCM Table: dbo.AT LastFileNo

From Sherlock Software
Revision as of 03:31, 31 December 2021 by Sherlock (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

TABLE NAME: dbo.AT_LastFileNo

Record the last patient file number used in an institution so that the system can generate the next available file number automatically.

Col ID Name Data Type Description
1 InstitutionID smallint ID of institution
2 CaseTypeID smallint ID of study case type
3 LastFileNo smallint Last patient file number used



Back to JCM Database tables