L TISS Form table: Difference between revisions

Newer edit →

@@ Line 4: / Line 4: @@
 == Data Structure ==
-* '''TISS_FORM_ID''' - autonumber(long int) - unique identifier
-* '''D_ID''' - text(18) - [[D_ID]] in [[L_Log table]]
+ +-----------------+----------+---------------------------------------+
-* '''BATCH_NO''' - long int - batch number
+ | Field           | Type     | Meaning                               |
-* '''BATCH_NO_TEXT''' - text (10) - batch number in text
+ +-----------------+----------+---------------------------------------+
-* '''BATCH_R_DATE''' - date - ???
+ | TISS_FORM_ID    | longint  | unique identifier                     |
-* '''OUTPUT_FILENAME''' - file name of form image
+ | PATIENT_ID      | longint  | [[D_ID]] in [[L_Log table]]           |
-* '''FIRST_DATE''' - date - first date on form?
+ | BATCH_NO        | longint  | batch number                          |
-* '''ITEM_DATE_GRP''' - text(14) - ???
+ | BATCH_NO_TEXT   | text(10) | batch number in text                  |
+ | BATCH_R_DATE    | datetime | ???                                   |
+ | OUTPUT_FILENAME | text(255)| file name of scanned form image       |
+ | FIRST_DATE      | datetime | date - first date on form?            |
+ | ITEM_DATE_GRP   | text(14) | ???                                   |
+ +-----------------+----------+---------------------------------------+