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 |