TISS28 Data.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
 
(21 intermediate revisions by 2 users not shown)
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.mdb]].
|successor=[[CCMDB.accdb]] / [[CFE]] / [[Centralized data.mdb]]
|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:  
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 ==
== Dependencies ==
TISS28 Data.mdb feeds into [[Centralized data.mdb]].
TISS28 Data.mdb uses D_ID and [[Service/Location field]] in [[Centralized data.mdb]].
 
Most processing on the data is done via [[TISS28.accdb]].


== Location ==
== Location ==
X:\TISS28\Database\TISS28_Data.mdb
X:\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==
==Password==
Line 23: Line 35:


==See: [[TISS MDB Crash]]==
==See: [[TISS MDB Crash]]==
==Start Date==
January 1, 2013


== Legacy ==
== 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]]
}}

Latest revision as of 21:49, 2022 February 17

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

TISS28_Data.mdb is a Microsoft Access database for storing 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:

The TISS28.accdb Change Log reflects the ongoing evolution of the database in response to emerging requirements from the 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.

Data structure

Dependencies

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

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

Location

X:\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

See: TISS MDB Crash

Start Date

January 1, 2013

Legacy

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