L TmpV2 table: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 1:

{{DISPLAYTITLE:L_TmpV2 table}}L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.~~mdb~~]] contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at [[Projects]].

{{DISPLAYTITLE:L_TmpV2 table}}L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.accdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at [[Projects]].

=== Entity–attribute–value model ===

Line 12:

{| class="wikitable sortable"

|-

! Field Name !! position !! type !! description

|-

| ~~Serial~~ ||1 || ~~Number~~ || unique identifier of ~~patient~~

| Tmp_ID ||1 || AutoNumber (Long integer)|| unique identifier of tmp entry

|-

| ~~Site~~ ||2 || ~~dropdown-limited text~~ || ~~Hospital where the patient was admitted~~

| Pat_ID/[[D_ID]] ||2 || ||

|-

| ~~Location~~ ||3 || ~~dropdown-limited~~ text || ~~Ward~~ the ~~patient was admitted~~ to

| Project ||3 || text () || name of the [[Projects|Project]], corresponds to [[s_tmp]].Study

|-

| ~~collected~~ ||4 || ~~Date/Time~~ || ~~date the variable was collected~~

| Item ||4 || text () || value in project, or [[Dropdown-like user experience for tmp projects |dropdown]], corresponds to [[s_tmp]].value

|-

| ~~Project~~ ||5 || ~~dropdown-limited text~~ || ~~ ~~

| obsdate ||5 || Date/Time || automatically entered date of collection, see [[Separation of date and time fields]]

|-

| ~~Item~~ ||6 || ~~Text~~ || ~~Project-Item identifier~~

| obstime ||6 || Date/Time || automatically entered time of collection, see [[Separation of date and time fields]]

|-

| ~~DtTm_var~~ ||7 || Date/Time || date~~/time variable~~ collected, ~~if needed~~

| date_var ||7 || Date/Time || date, if collected, specified in [[s_tmp]].date_var_label, see [[Separation of date and time fields]]

|-

| int_var ||8 || number || integer variable, if collected

| time_var ||8 || Date/Time || time, if collected, specified in [[s_tmp]].time_var_label, see [[Separation of date and time fields]]

|-

| int_var ||9 || number (long integer) || integer variable, if collected, specified in [[s_tmp]].int_var_label

|-

| float_var ||9 || number || float/real variable, if collected

| float_var ||9 || number (double) || float/real variable, if collected, specified in [[s_tmp]].float_var_label

|-

| bool_var ||10 || Yes/No || boolean variable, if collected

| bool_var ||10 || Yes/No || boolean variable, if collected, specified in [[s_tmp]].bool_var_label

|-

| comment_var ||11 || Text || comment variable, if collected

| comment_var ||11 || Text || comment variable, if collected, not specified in [[s_tmp]] since generally permitted as free text comment

|-

~~| Instruction ||12 || dropdown-limited text || Instruction as given~~ in ~~the dropdown~~ [[s_tmp ~~table~~]]

|-

~~| data_sent ||13 || Date/Time || Date/Time the patient was sent~~

|}

== why separate? ==

See [[separation of date and time fields]]

== Related articles ==

Line 48:

Line 49:

[[Category:Data structure]]

[[Category:L_TmpV2 Data | *]]

[[Category:~~TmpV2~~ | *]]

[[Category:Tmp Project Infrastructure | *]]

[[Category:L TmpV2 table | *]]

[[Category:L Table]]

</noinclude>

@@ Line 1: / Line 1: @@
-{{DISPLAYTITLE:L_TmpV2 table}}L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at [[Projects]].
+{{DISPLAYTITLE:L_TmpV2 table}}L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.accdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at [[Projects]].
 === Entity–attribute–value model ===
@@ Line 12: / Line 12: @@
 {| class="wikitable sortable"
 |-
-! Field Name !! position !! type !! description
+! Field Name 		!! position !! type !! description
 |-
-| Serial 	||1 || Number 			|| unique identifier of patient
+| Tmp_ID 			||1 || AutoNumber (Long integer)|| unique identifier of tmp entry
 |-
-| Site 		||2 || dropdown-limited text	|| Hospital where the patient was admitted
+| Pat_ID/[[D_ID]] 	||2 || 							||
 |-
-| Location 	||3 || dropdown-limited text	|| Ward the patient was admitted to
+| Project 			||3 || text ()					|| name of the [[Projects|Project]], corresponds to [[s_tmp]].Study
 |-
-| collected 	||4 || Date/Time 		|| date the variable was collected
+| Item 				||4 || text ()					|| value in project, or [[Dropdown-like user experience for tmp projects |dropdown]], corresponds to [[s_tmp]].value
 |-
-| Project 	||5 || dropdown-limited text	|| &nbsp;
+| obsdate 			||5 || Date/Time				|| automatically entered date of collection, see [[Separation of date and time fields]]
 |-
-| Item  	||6 || Text 			|| Project-Item identifier
+| obstime 			||6 || Date/Time				|| automatically entered time of collection, see [[Separation of date and time fields]]
 |-
-| DtTm_var 	||7 || Date/Time 		|| date/time variable collected, if needed
+| date_var 			||7 || Date/Time				|| date, if collected, specified in [[s_tmp]].date_var_label, see [[Separation of date and time fields]]
 |-
-| int_var 	||8 || number 			|| integer variable, if collected
+| time_var 			||8 || Date/Time				|| time, if collected, specified in [[s_tmp]].time_var_label, see [[Separation of date and time fields]]
+|-
+| int_var 			||9 || number (long integer)	|| integer variable, if collected, specified in [[s_tmp]].int_var_label
 |-
-| float_var 	||9 || number 			|| float/real variable, if collected
+| float_var 		||9 || number (double)			|| float/real variable, if collected, specified in [[s_tmp]].float_var_label
 |-
-| bool_var 	||10 || Yes/No 			|| boolean variable, if collected
+| bool_var 			||10 || Yes/No 					|| boolean variable, if collected, specified in [[s_tmp]].bool_var_label
 |-
-| comment_var 	||11 || Text 			|| comment variable, if collected
+| comment_var 		||11 || Text 					|| comment variable, if collected, not specified in [[s_tmp]] since generally permitted as free text comment
-|-
-| Instruction 	||12 || dropdown-limited text	|| Instruction as given in the dropdown [[s_tmp table]]
-|-
-| data_sent 	||13 || Date/Time 		|| Date/Time the patient was sent
 |}
+== why separate? ==
+See [[separation of date and time fields]]
 == Related articles ==
@@ Line 48: / Line 49: @@
 [[Category:Data structure]]
 [[Category:L_TmpV2 Data | *]]
-[[Category:TmpV2 | *]]
+[[Category:Tmp Project Infrastructure | *]]
 [[Category:L TmpV2 table | *]]
 [[Category:L Table]]
 </noinclude>