Table Detail Report

SN_PROC_CPT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN PROC CPT R
Definition: Procedure / CPT code associations
Table Type: REFERENCE





Column Detail - SN_PROC_CPT_R


Column Name Type Null? Definition
CPT_SEQ DOUBLE N Identifies the priority and sequence in which the CPT was selected
NOMENCLATURE_ID DOUBLE N Unique identifier for a CPT 4 code
PRINCIPLE_TYPE_CD DOUBLE N The principle type cd from principle type code set
PROCEDURE_CD DOUBLE N Unique identifier for a Surgical procedure
PROC_CPT_ASSOC_ID DOUBLE N Procedure CPT code association identifier
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 - SN_PROC_CPT_R


Child Column in SN_PROC_CPT_R(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PROCEDURE_CD ORDER_CATALOG CATALOG_CD


SN_PROC_SEG_ASSOCIATION



Column Section Top of Page


Table-level Detail

Description: PROCEDURE_SEGMENT
Definition: All associated segments of procedures are stored in this table. A new row will be inserted into this table when user checks a segment under the procedure in SNDBProcMgr. A new row will be deleted when user unchecks a segment under the procedure in SNDBProcMgr.
Table Type: ACTIVITY





Column Detail - SN_PROC_SEG_ASSOCIATION


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Catalog code of a procedure that identifies a single row on the surgical_procedures table
DOC_TYPE_CD DOUBLE N The document type associated with this documentation segment, i.e. OR Nursing Record, Preop Nursing Assessment
SEG_CD DOUBLE N The segment associated with the procedure
SN_PROC_SEG_ASSOCIATION_ID DOUBLE N Unique generated number that identifies a single row on the SN_PROC_SEG_ASSOCIATION table.
SURG_AREA_CD DOUBLE N The surgical area associated with this documentation segment. Identified by a CDF Meaning of ""SURGAREA"" on the Service Resource codeset.
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.


SN_REPORT_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: SN REPORT TEMPLATE
Definition: This is the table that will be used for dynamically generate customized reports.
Table Type: REFERENCE





Column Detail - SN_REPORT_TEMPLATE


Column Name Type Null? Definition
CREATE_APPLCTX DOUBLE Y The application context responsible for inserting this row on the table.
CREATE_DT_TM DATETIME Y The date and time this row was inserted on the table
CREATE_PRSNL_ID DOUBLE N The person responsible for inserting this row on the table
CREATE_TASK DOUBLE Y The task responsible for inserting this row on the table
DISPLAY VARCHAR(50) Y Display of the template.
DISPLAY_KEY VARCHAR(50) Y Key to associate the template to the Operations.This column is not populated by mainline Surginet applications and has been deemed OBSOLETE for that solution. It is possible, however, that other applications may use the field.
REPORT_TEMPLATE_ID DOUBLE N Primary key of the table
SURG_AREA_CD DOUBLE N Area for which the cases will be retrived from.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.


SN_RPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains all SurgiNet client built reports.
Definition: Contains all SurgiNet client built reports. This stores various information about paper size, orientation, margins, surgical area, and the name of the report.
Table Type: REFERENCE





Column Detail - SN_RPT


Column Name Type Null? Definition
BUTTON_SEQ DOUBLE Y identifies the report as having a shortcut button and in which sequence to display the up to five definable buttons.
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was first inserted.
CREATE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the row to be created in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DISPLAY VARCHAR(60) N The display name of the report.
FORMAT_FLAG DOUBLE N FUTURE:: Will indicate the type of file format that is generated for this report.
LANDSCAPE_IND DOUBLE N Determines if the report prints in landscape mode or not.
NUM_COLS DOUBLE N The number of printable columns that are on the report's paper.
NUM_ROWS DOUBLE N The number of printable rows that are on the report's paper.
ORGANIZATION_ID DOUBLE N Organization id refers to the ID of the organization to which the report belongs to
OWNER_ID DOUBLE N The person_id of the person from the personnel table (prsnl) assigned to own the report.
PAPER_SOURCE VARCHAR(20) N The display value of the paper source used to default the number of rows and columns for this report.
PRINT_BARCODE_IND DOUBLE N ** NOT USED - Logically Obsolete ** Indicates whether the barcode should be printed to case picklist report or not
RPT_ID DOUBLE N Primary KeyColumn
RPT_KEY VARCHAR(32) N The unique area key for this report. Used primarily for operations jobs to determine which report to run.
RPT_TYPE_CD DOUBLE N Indicates the type of report this is.
START_COL DOUBLE N The column number on the page to start printing on.
START_ROW DOUBLE N The row number on the page to start printing on.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SN_RPT


Child Column in SN_RPT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
OWNER_ID PRSNL PERSON_ID


SN_RPT_DEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds the printer information for each of SurgiNet's reports.
Definition: This table holds the printer queue and number of copies that should be printed of each report.
Table Type: REFERENCE





Column Detail - SN_RPT_DEST


Column Name Type Null? Definition
CREATE_APPLCTX DOUBLE Y The application context number from the record info block.
CREATE_DT_TM DATETIME Y The date and time the row was first inserted.
CREATE_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the row to be created in the table.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that inserted the row.
DISPLAY VARCHAR(60) N The display name of the print queue.
NUM_COPIES DOUBLE N The number of copies that is to printed to this print queue for this report.
OUTPUT_DEST_ID DOUBLE N This is a foreign key into the OUTPUT_DEST table to indicate which printer queue this row belongs to.
RPT_DEST_ID DOUBLE N Primary Key
RPT_FILTER_GRP_ID DOUBLE N This is a foreign key into the SN_RPT_FILTER_GRP table.
TYPE_FLAG DOUBLE N Determines the type of output destination this is.
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 - SN_RPT_DEST


Child Column in SN_RPT_DEST(FK) Parent Table Name Parent Column Name
Parents: OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD
RPT_FILTER_GRP_ID SN_RPT_FILTER_GRP RPT_FILTER_GRP_ID