Difference between revisions of "JCM Table: dbo.AT LastFileNo"
From Sherlock Software
(Created page with "===TABLE NAME: dbo.AT_LastFileNo=== Record last patient file number used in an institution so that the system can generate next available file number automatically. {| class="...") |
|||
| Line 1: | Line 1: | ||
===TABLE NAME: dbo.AT_LastFileNo=== | ===TABLE NAME: dbo.AT_LastFileNo=== | ||
Record last patient file number used in an institution so that the system can generate next available file number automatically. | Record the last patient file number used in an institution so that the system can generate the next available file number automatically. | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Latest revision as of 03:31, 31 December 2021
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
