JCM Table: dbo.AT LastFileNo
From Sherlock Software
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