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 |