Table Detail Report

HANDHELD_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Handheld Session
Definition: This table will be used to track information for each session from a handheld collection device. This table is used for reporting purposes only.
Table Type: ACTIVITY





Column Detail - HANDHELD_SESSION


Column Name Type Null? Definition
DEVICE_TXT VARCHAR(100) Y The name of the device used for the handheld collections.
HANDHELD_SESSION_ID DOUBLE N A unique identifier for each occurrence of a Handheld session.
LOGON_DT_TM DATETIME N The date and time the user logged onto the device.
POSITIVE_PATIENT_IDENT_FLAG DOUBLE N The preference value that indicates the level at which positive patient identification will be used.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - HANDHELD_SESSION




Parent Column in HANDHELD_SESSION (PK) Child Table Name Child Column Name
Children: HANDHELD_SESSION_ID HANDHELD_UPLOAD HANDHELD_SESSION_ID


HANDHELD_UPLOAD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Handheld Upload
Definition: This table will be used to track information for each upload of data from a handheld collection device. This table is used for reporting purposes only.
Table Type: ACTIVITY





Column Detail - HANDHELD_UPLOAD


Column Name Type Null? Definition
DEVICE_DT_TM DATETIME Y If a significant date/time difference is detected on the upload, but the user chooses to continue with the upload, the date and time on the device will be stored here. If no discrepancy was found, this will be set to NULL.
HANDHELD_SESSION_ID DOUBLE N A unique identifier for each occurrence of a Handheld session.
HANDHELD_UPLOAD_ID DOUBLE N Unique identifier for each occurrence of an upload of data.
LOGIN_LOCATION_CD DOUBLE N Login location where the specimens where received.
ORGANIZATION_ID DOUBLE N Organization the user is performing the handheld collections for.
REPORT_NBR DOUBLE N A number assigned to each upload event that will be reset to 1 at the beginning of each day.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
UPLOAD_DT_TM DATETIME Y The date and time the upload was performed.



Relationship Detail - HANDHELD_UPLOAD


Child Column in HANDHELD_UPLOAD(FK) Parent Table Name Parent Column Name
Parents: HANDHELD_SESSION_ID HANDHELD_SESSION HANDHELD_SESSION_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in HANDHELD_UPLOAD (PK) Child Table Name Child Column Name
Children: HANDHELD_UPLOAD_ID HANDHELD_DETAIL HANDHELD_UPLOAD_ID


LOGIN_TEMPLATE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Login Template
Definition: Stores all of the login templates. Login Templates control the behavior of the PathNet Collections: Specimen Login application.
Table Type: REFERENCE





Column Detail - LOGIN_TEMPLATE


Column Name Type Null? Definition
DEFAULT_IND DOUBLE Y This field determines which login template will be used as the default template for users to whom another template is not assigned. Only one row on this table should have this field set to 1 (default). All other rows should have this field set to 0.
TEMPLATE_CD DOUBLE N Code value associated with the login template described by this row.
TEMPLATE_NAME VARCHAR(50) N Textual name of the login template defined by this row.
TEMPLATE_TYPE_FLAG DOUBLE N Determines the type of login template.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - LOGIN_TEMPLATE




Parent Column in LOGIN_TEMPLATE (PK) Child Table Name Child Column Name
Children: TEMPLATE_CD LOGIN_TEMPLATE_PREFERENCE TEMPLATE_CD


LOGIN_TEMPLATE_ASSIGNMENT



Column Section Top of Page


Table-level Detail

Description: Login Template Assignment
Definition: Stores the assignment of users to login templates. Login Templates control the behavior of the PathNet Collections: Specimen Login application
Table Type: REFERENCE





Column Detail - LOGIN_TEMPLATE_ASSIGNMENT


Column Name Type Null? Definition
ASSIGNED_ID DOUBLE N Either a person id or a login location cd.
TEMPLATE_CD DOUBLE N This field identifies the login template that is assigned to the person identified in the person_id field.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


LOGIN_TEMPLATE_PREFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Login Template Preference
Definition: Stores the detail preferences of each login template. Login Templates control the behavior of the PathNet Collections: Specimen Login application
Table Type: REFERENCE





Column Detail - LOGIN_TEMPLATE_PREFERENCE


Column Name Type Null? Definition
PREFERENCE DOUBLE N This field defines a particular preference for a login type (see template_type field) on a login template (see template_cd field). Preferences include which spreadsheet columns are visible; sort order for spreadsheet column headings; default values for collected and received date, time, and id; etc.
TEMPLATE_CD DOUBLE N The code value identifying a particular login template.
TEMPLATE_TYPE DOUBLE N This field identifies with which type of log-in this row's preference is associated. Possible values include 0 (general -- more general options such as which log-in types are enabled on this template), 1 (log-in by user), 2 (log-in by location), 3 (log-in by list), 4 (log-in by patient), 5 (log-in by accession). All 5 log-in types are defined for each template. This field is used to further subclass them so they can be pulled back individually.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VALUE DOUBLE Y This field defines the actual value for a log-in template preference. In other words, it is this field that defines what options are turned on and off on a given log-in template.



Relationship Detail - LOGIN_TEMPLATE_PREFERENCE


Child Column in LOGIN_TEMPLATE_PREFERENCE(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_CD LOGIN_TEMPLATE TEMPLATE_CD