TPL_APPL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Third party Launch Application
Definition: Stores the name of the Millennium applications that have access to LaunchApp.
Table Type: REFERENCE





Column Detail - TPL_APPL


Column Name Type Null? Definition
APPLICATION_NUMBER DOUBLE N This is the unique number that identifies a component (application). All HNAM applications have an application number that uniquely identifies them to the system. This is used to launch the application by the launching tools.
APPL_ID DOUBLE N Unique ID for an application.
SOLU_ID DOUBLE N Foreign key to the TPL_SOLU table.
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 - TPL_APPL


Child Column in TPL_APPL(FK) Parent Table Name Parent Column Name
Parents: SOLU_ID TPL_SOLU SOLU_ID




Parent Column in TPL_APPL (PK) Child Table Name Child Column Name
Children: APPL_ID TPL_APPL_CTX_PARAM APPL_ID
TPL_APPL_TASK_RELTN APPL_ID


TPL_APPL_CTX_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Third Party Launch Application Context Parameter
Definition: Stores the context parameters for the applications launched from the build and launch tool.
Table Type: REFERENCE





Column Detail - TPL_APPL_CTX_PARAM


Column Name Type Null? Definition
APPL_CTX_PARAM_ID DOUBLE N Generated unique ID for the table
APPL_ID DOUBLE N Foreign key to the TPL_APPL table.
CTX_CD DOUBLE N Code value for the new code set used to maintain the context params.
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 - TPL_APPL_CTX_PARAM


Child Column in TPL_APPL_CTX_PARAM(FK) Parent Table Name Parent Column Name
Parents: APPL_ID TPL_APPL APPL_ID


TPL_APPL_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Third Party Launch Application Detail
Definition: Stores the name of the application - like Stat-DX, Vital Images, etc. that use the build and launch application tool as well as the data necessary to launch them.
Table Type: REFERENCE





Column Detail - TPL_APPL_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
APPL_DETAIL_ID DOUBLE N Unique generated ID for this table.
APPL_TASK_RELTN_ID DOUBLE N Corresponds to a row on the TPL_APPL_TASK_RELTN table.
APPL_TYPE_FLAG DOUBLE N Value determining whether application is a web address, an executable, or neither.
CMD_PATH_TXT VARCHAR(512) Y The path leading to the executable to be launched. In the event of a URL, points to the browser.
CTX_PARAM_TXT VARCHAR(2048) Y The context parameters that need to be passed in via command line or URL in the case of a web address.
FILE_PATH_TXT VARCHAR(512) Y The path to which a file will be created.
FILE_TMPLT_LONG_TEXT_ID DOUBLE N maps to the long text table.
HTTP_POST_IND DOUBLE N If this value is 1 and appl_type_flag is also 1, parameters will be hidden from user view via HTTP post protocol.
RAD_SEND_LINKED_ACCN_IND DOUBLE N Indicates if multiple multiple orders will share the same report data. 1 - send all accessions in the linked exam. 0 - Send only the selected accession in the linked exam.
REUSE_PRCS_IND DOUBLE N For a browser implementation this will (if allowed) try to reuse the active browser window. For an executable, it would set focus to the executable as opposed to launching another instance.0 - Start new process each time1 - Reuse the process if still active
TEST_MODE_IND DOUBLE N 0 - Inactive (default)1 - Active
TITLE_TXT VARCHAR(255) N The title that will appear in the front end application.
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 - TPL_APPL_DETAIL


Child Column in TPL_APPL_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FILE_TMPLT_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
APPL_TASK_RELTN_ID TPL_APPL_TASK_RELTN APPL_TASK_RELTN_ID


TPL_APPL_TASK_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Third Party Launch Application Task Relation
Definition: Stores the tasks associated to the applications used in the build and launch application tool.
Table Type: REFERENCE





Column Detail - TPL_APPL_TASK_RELTN


Column Name Type Null? Definition
APPL_ID DOUBLE N Foreign key to the TPL_APPL table.
APPL_TASK_RELTN_ID DOUBLE N Unique generated key for this table.
TASK_NUMBER DOUBLE N Task number from APPLICATION_TASK.
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 - TPL_APPL_TASK_RELTN


Child Column in TPL_APPL_TASK_RELTN(FK) Parent Table Name Parent Column Name
Parents: APPL_ID TPL_APPL APPL_ID




Parent Column in TPL_APPL_TASK_RELTN (PK) Child Table Name Child Column Name
Children: APPL_TASK_RELTN_ID TPL_APPL_DETAIL APPL_TASK_RELTN_ID


TPL_SOLU



Column Section Relationship Section Top of Page


Table-level Detail

Description: Third Party Launch Solution
Definition: Stores the name of the solution, like Radiology, Laboratory, etc., that use the build and launch application tool.
Table Type: REFERENCE





Column Detail - TPL_SOLU


Column Name Type Null? Definition
SOLU_ID DOUBLE N Unique generated key for the table.
SOLU_NAME_TXT VARCHAR(255) N Name of the solution, such as Radiology.
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 - TPL_SOLU




Parent Column in TPL_SOLU (PK) Child Table Name Child Column Name
Children: SOLU_ID TPL_APPL SOLU_ID