FO_Common_Tests
Each record represents a single TestCode in a list that can be assigned to a specific common list. The collection of all rows for a single CommonTestListCode represents the list of codes presented to the user with that code assigned in FO_Users.
| Field | Type | Notes |
|---|---|---|
|
ClientOrdTests_ID |
int |
ID field, a counter. Unique |
|
CommonTestListCode |
varchar(50) |
Enter a valid common test list code. |
|
TestCode |
varchar(50) |
Enter a valid test code. |
|
Sequence |
varchar(50) |
Order, or sequence, in which to display this test code. Enter an integer for numeric order, typical, or enter alpha characters, such as A, B, or CC, DD, for alphabetical order. |
|
Active |
bit |
Bit flag to determine if this test code is active for the list. Enter 0 or 1 0 = inactive 1 = active |
|
CreateDate |
datetime |
System timestamp when record is created. Informational |
|
CreateUserName |
varchar(50) |
Name of user who created record. Informational |
|
EditDate |
datetime |
System timestamp when record is edited. Informational |
|
EditUserName |
varchar(50) |
Name of user who last edited record. Informational |