Table Detail Report

SN_RPT_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds Report Preferences
Definition: This table holds report preferences (sort order, block utilization parameters, etc.)
Table Type: ACTIVITY





Column Detail - SN_RPT_PREFS


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N If this preference has a value that is a foreign key to another table, this will be the foreign key value with the table in the parent_entity_name column.
PARENT_ENTITY_NAME VARCHAR(32) N Name of the table that this preference has a foreign key to.
PREFS_STRING VARCHAR(255) Y This holds non-foreign key report preference values.
RPT_FILTER_GRP_ID DOUBLE N Foreign key into the SN_RPT_FILTER_GRP table to indicate which filter group this report preference belongs to.
RPT_PREFS_ID DOUBLE N Report Preferences ID. Primary Key
RPT_PREFS_REF_ID DOUBLE N Foreign key into the SN_RPT_PREFS_REF table to indicate what reference this report preference was created from.
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_PREFS


Child Column in SN_RPT_PREFS(FK) Parent Table Name Parent Column Name
Parents: RPT_FILTER_GRP_ID SN_RPT_FILTER_GRP RPT_FILTER_GRP_ID
RPT_PREFS_REF_ID SN_RPT_PREFS_REF RPT_PREFS_REF_ID


SN_RPT_PREFS_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds Report Preference Reference information
Definition: This table contains all of the report preferences associated with a given report type.
Table Type: REFERENCE





Column Detail - SN_RPT_PREFS_REF


Column Name Type Null? Definition
DISPLAY VARCHAR(200) N The display value for the report preference.
DISPLAY_TYPE_FLAG DOUBLE N The type of control that will be used to collect information for this report preference. For example: a provider control, list box, text box, etc.
PREFS_DATA VARCHAR(255) Y Contains miscellaneous information about the report preferences. For example, it could contain information about which code set the preference values come from, or the actual values for this preference.
PREFS_KEY VARCHAR(20) N The unique key for this report preference. This is a SurgiNet defined key that is used within the report scripts to identify this preference.
PREFS_KEY_A_NLS VARCHAR(80) Y PREFS_KEY_A_NLS column
PREFS_KEY_NLS VARCHAR(42) N The unique key for this report preference. This is a SurgiNet defined key that is used within the report scripts to identify this preference. (NLS)
PREFS_TYPE_FLAG DOUBLE N Determines the type of report preference that this is.
REQUIRED_IND DOUBLE N (Future functionality.) Whether this preference is required.
RPT_PREFS_REF_ID DOUBLE N Report Preferences Reference ID Primary Key
RPT_TYPE_CD DOUBLE N Determines which report type these preferences apply to. Code Set 25069
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_PREFS_REF




Parent Column in SN_RPT_PREFS_REF (PK) Child Table Name Child Column Name
Children: RPT_PREFS_REF_ID SN_RPT_PREFS RPT_PREFS_REF_ID


SN_RPT_SECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN RPT SECT
Definition: Contains the descriptions, types, order, and sizes of sections in a report.
Table Type: REFERENCE





Column Detail - SN_RPT_SECT


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_COLS DOUBLE N The number of columns that are displayed in the section.
DISPLAY_ROWS DOUBLE N The number of rows that are displayed in the section.
LINE_FLAG DOUBLE N Determines what type of line is surrounding this section.
ORDER_SEQ DOUBLE N Contains the section sequence for this report and section type.
RPT_ID DOUBLE N Foreign key into the SN_RPT table to indicate which report this section belongs in.
RPT_SECT_ID DOUBLE N Primary Key
RPT_SECT_REF_ID DOUBLE N Foreign key into the SN_RPT_SECT_REF table to link to the reference section for this section.
TYPE_FLAG DOUBLE N Determines the type of section.
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_SECT




Parent Column in SN_RPT_SECT (PK) Child Table Name Child Column Name
Children: RPT_SECT_ID SN_RPT_FIELD RPT_SECT_ID


SN_RPT_SECT_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN_RPT_SECT_REF
Definition: Contains the section information for a report. This includes the section type, sequence, and default display.
Table Type: REFERENCE





Column Detail - SN_RPT_SECT_REF


Column Name Type Null? Definition
DISPLAY VARCHAR(60) N The default display of this report section.
ORDER_SEQ DOUBLE N Contains the section sequence for this report and section type.
RPT_SECT_REF_ID DOUBLE N Primary Key
RPT_TYPE_CD DOUBLE N The type of report that this section belongs to.
TYPE_FLAG DOUBLE N Determines the type of section.
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_SECT_REF




Parent Column in SN_RPT_SECT_REF (PK) Child Table Name Child Column Name
Children: RPT_SECT_REF_ID SN_RPT_FIELD_REF RPT_SECT_REF_ID


SN_SIGNATURE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Electronic Signature History
Definition: Stores the history of electronic signature of SurgiNet documents, segments, and field results.
Table Type: ACTIVITY





Column Detail - SN_SIGNATURE


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N The date and time of a signature or an override of a required signature.
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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
COMMENT_TXT VARCHAR(255) Y Stores the comment of a signature, or a reason for overriding a required signature.
OVERRIDE_IND DOUBLE N 0 indicates that this is a signature. 1 indicates that this is an override of a required signature.
PARENT_ENTITY_ID DOUBLE N The primary key ID of the table in PARENT_ENTITY_NAME that identifies the signed entity.
PARENT_ENTITY_NAME VARCHAR(32) Y Identifies the signed entity, i.e.: PERIOPERATIVE_DOCUMENT, INPUT_FORM_DEFINITION, etc.
PERIOP_DOC_ID DOUBLE N Identifies the document. Foreign Key from PERIOPERATIVE_DOCUMENT
PERSONNEL_ID DOUBLE N The person_id of the personnel that signed a document, a segment, or a field result, or overrode a required signature.
SIGNATURE_ID DOUBLE N The primary key ID that uniquely identifies an electronic signature, or an override of a required signature.
TEMPORARY_IND DOUBLE N 0 indicates that this is not a temporary signature. 1 indicates that this is a temporary signature that has not been stored in the clinical repository.
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_SIGNATURE


Child Column in SN_SIGNATURE(FK) Parent Table Name Parent Column Name
Parents: PERIOP_DOC_ID PERIOPERATIVE_DOCUMENT PERIOP_DOC_ID
PERSONNEL_ID PRSNL PERSON_ID