TISS28 Data.mdb: Difference between revisions

(25 intermediate revisions by 2 users not shown)

Line 1:

~~'''~~[[~~TISS28_Data~~.~~mdb~~]]~~''' is a Microsoft Access database for storing~~ [[~~TISS28 items & points~~ | ~~TISS28 form data~~]] ~~after scanning by~~ [[~~Teleform~~]].

{{LegacyContent

|explanation=TISS is now collected as part of CCI, so collected in [[CCMDB.accdb]] and stored in [[CFE]] / [[Centralized_data.accdb]].

|successor=[[CCMDB.accdb]] / [[CFE]] / [[Centralized_data.accdb]]

|content=

The TISS28 database consists of two Access files: '''[[TISS28.~~mdb~~]]''' and '''TISS28_Data.mdb''', representing the user interface and data components, respectively.

'''[[TISS28_Data.mdb]]''' is a Microsoft Access database for storing [[TISS Item List | TISS28 form data]] after scanning by [[Teleform]].

The TISS28 database consists of two Access files: '''[[TISS28.accdb]]''' and '''TISS28_Data.mdb''', representing the user interface and data components, respectively.

For details, see:

*[[TISS28 ~~data specifications]] (incl~~. ~~location information)~~

*[[TISS28.accdb Change Log]]

*[[TISS28.mdb Change Log]]

*[[Requested TISS changes for the next version]]

The [[TISS28.~~mdb~~ Change Log]] reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communicated via email.

The [[TISS28.accdb Change Log]] reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communicated via email.

==~~Start Date~~==

== Data structure ==

~~January 1, 2013~~

* [[Tmp TISS Export table]]

* [[L TISS Form table]]

* [[L TISS Item table]]

== Dependencies ==

TISS28 Data.mdb uses D_ID and [[Service/Location field]] in [[~~Centralized data~~.~~mdb~~]].

TISS28 Data.mdb uses D_ID and [[Service/Location field]] in [[Centralized_data.accdb]].

Most processing on the data is done via [[TISS28.~~mdb~~]].

Most processing on the data is done via [[TISS28.accdb]].

== Location ==

X:\TISS28\Database\TISS28_Data.mdb

{{S:\MED\MED_CCMED}}TISS28\Database\TISS28_Data.mdb

If the file is not there, see [[Pull down centralized data.vbs]].

== Availability ==

TISS28_Data.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST. See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.

==Password==

Located: M:~~\Passwords_mainoffice~~

Located: {{M:$1}}

==See: [[TISS MDB Crash]]==

==Start Date==

January 1, 2013

== Legacy ==

Before January 1, 2013 we used [[:Category:TISS76]].

Before January 1, 2013 we used [[:Category:TISS76 Legacy]].

[[Category: TISS28]]

[[Category:TISS28]]

[[Category: Data Repository]]

[[Category:Data Repository]]

}}

@@ Line 1: / Line 1: @@
-'''[[TISS28_Data.mdb]]''' is a Microsoft Access database for storing [[TISS28 items & points | TISS28 form data]] after scanning by [[Teleform]].
+{{LegacyContent
+|explanation=TISS is now collected as part of CCI, so collected in [[CCMDB.accdb]] and stored in [[CFE]] / [[Centralized_data.accdb]].
+|successor=[[CCMDB.accdb]] / [[CFE]] / [[Centralized_data.accdb]]
+|content=
-The TISS28 database consists of two Access files: '''[[TISS28.mdb]]''' and '''TISS28_Data.mdb''', representing the user interface and data components, respectively.
+'''[[TISS28_Data.mdb]]''' is a Microsoft Access database for storing [[TISS Item List | TISS28 form data]] after scanning by [[Teleform]].
+The TISS28 database consists of two Access files: '''[[TISS28.accdb]]''' and '''TISS28_Data.mdb''', representing the user interface and data components, respectively.
 For details, see:
-*[[TISS28 data specifications]] (incl. location information)
+*[[TISS28.accdb Change Log]]
-*[[TISS28.mdb Change Log]]
-*[[Requested TISS changes for the next version]]
-The [[TISS28.mdb Change Log]] reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communicated via email.
+The [[TISS28.accdb Change Log]] reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communicated via email.
-==Start Date==
+== Data structure ==
-January 1, 2013
+* [[Tmp TISS Export table]]
+* [[L TISS Form table]]
+* [[L TISS Item table]]
 == Dependencies ==
-TISS28 Data.mdb uses D_ID and [[Service/Location field]] in [[Centralized data.mdb]].
+TISS28 Data.mdb uses D_ID and [[Service/Location field]] in [[Centralized_data.accdb]].
-Most processing on the data is done via [[TISS28.mdb]].
+Most processing on the data is done via [[TISS28.accdb]].
 == Location ==
-X:\TISS28\Database\TISS28_Data.mdb
+{{S:\MED\MED_CCMED}}TISS28\Database\TISS28_Data.mdb
+If the file is not there, see [[Pull down centralized data.vbs]].
+== Availability ==
+TISS28_Data.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST.  See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.
 ==Password==
-Located:   M:\Passwords_mainoffice
+Located:   {{M:$1}}
 ==See: [[TISS MDB Crash]]==
+==Start Date==
+January 1, 2013
 == Legacy ==
-Before January 1, 2013 we used [[:Category:TISS76]].
+Before January 1, 2013 we used [[:Category:TISS76 Legacy]].
-[[Category: TISS28]]
+[[Category:TISS28]]
-[[Category: Data Repository]]
+[[Category:Data Repository]]
+}}