S laptops table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "The '''s_laptops table''' in CCMDB.accdb contains identifiers of the laptops used to collect data. This is not the name of the physical device (workstation name) but the n..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The '''s_laptops table''' in [[CCMDB.accdb]] contains identifiers of the laptops used to collect data. This is not the name of the physical device (workstation name) but the name by which we designate the laptop internally. | {{DISPLAYTITLE:s_laptops table}}The '''s_laptops table''' in [[CCMDB.accdb]] contains identifiers of the laptops used to collect data. Equivalent to the data backup locations. This is '''not the name of the physical device''' (workstation name) but the name by which we designate the laptop internally; for list of physical hardware, see [[Workstations.mdb]]. | ||
== Data Structure == | == Data Structure == | ||
| Line 11: | Line 11: | ||
|- | |- | ||
|| '''Laptop''' || Text (15) || Human readable name of laptop | || '''Laptop''' || Text (15) || Human readable name of laptop | ||
|- | |||
|| '''hosp''' || Text (3) || hospital designator | |||
|- | |- | ||
|| '''StartDtTm''' || date || start of use of that laptop | || '''StartDtTm''' || date || start of use of that laptop | ||
Latest revision as of 15:17, 2023 June 28
The s_laptops table in CCMDB.accdb contains identifiers of the laptops used to collect data. Equivalent to the data backup locations. This is not the name of the physical device (workstation name) but the name by which we designate the laptop internally; for list of physical hardware, see Workstations.mdb.
Data Structure
| field | type | description |
|---|---|---|
| Laptop_ID | Long Integer | Automatically generated random |
| Laptop | Text (15) | Human readable name of laptop |
| hosp | Text (3) | hospital designator |
| StartDtTm | date | start of use of that laptop |
| EndDtTm | date | end of use of that laptop |
Related articles
| Related articles: |