Table Detail Report

SN_RPT_EVENT



Column Section Top of Page


Table-level Detail

Description: SN RPT EVENT
Definition: This table holds all of the events that were selected to be active for a report.
Table Type: REFERENCE





Column Detail - SN_RPT_EVENT


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 initially inserted.
CREATE_PRSNL_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that created the row.
RPT_EVENT_ID DOUBLE N Primary Key
RPT_EVENT_REF_ID DOUBLE N This is a foreign key into the SN_RPT_EVENT_REF table to indicate which reference event this came from.
RPT_ID DOUBLE N This is a foreign key into the SN_RPT table to indicate which report this event belongs to.
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_RPT_EVENT_REF



Column Section Top of Page


Table-level Detail

Description: SN RPT EVENT REF
Definition: Contains all events that are available for a given report type.
Table Type: REFERENCE





Column Detail - SN_RPT_EVENT_REF


Column Name Type Null? Definition
DESCRIPTION VARCHAR(255) N The description of the event.
DISPLAY VARCHAR(60) N The display representation of the event.
EVENT_KEY VARCHAR(20) N The unique SurgiNet defined key for the event.
RPT_EVENT_REF_ID DOUBLE N Primary Key
RPT_TYPE_CD DOUBLE N The type of report that the event applies to.
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_RPT_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains the field information for each report.
Definition: This table contains the size, stacking info, sort sequence, and various other font information about each field in a report.
Table Type: REFERENCE





Column Detail - SN_RPT_FIELD


Column Name Type Null? Definition
BACK_COLOR_PCT DOUBLE N Determines the back color for this field.
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(255) N Contains the display value of the field.
DISPLAY_COL DOUBLE N Determines which column this field displays in on the front-end application.
DISPLAY_ROW DOUBLE N Determines which row this field displays in on the front-end application.
FIELD_SIZE DOUBLE N Determines the number of columns that prints for this field.
FONT_NUM DOUBLE N Determines which font prints for this field.
FONT_SIZE DOUBLE N Determines the size of the font that prints for this field.
FONT_UNDERLINE_IND DOUBLE N Determines if this field is underlined or not.
LINE_FLAG DOUBLE N Determines the type of line that surrounds this field.
LINE_IND DOUBLE N Determines if a '____' can be used as the value for this field.
REPEAT_IND DOUBLE N Determines if this field repeats within the report. This field must be sorted if the repeat_ind is equal to zero.
RPT_FIELD_ID DOUBLE N Primary Key
RPT_FIELD_REF_ID DOUBLE N Foreign key into the SN_RPT_FIELD_REF table to line to the reference information for this field.
RPT_SECT_ID DOUBLE N Foreign key into the SN_RPT_SECT table to indicate which section this field is in.
SORT_SEQ DOUBLE N Determines the sequence that this field is sorted in for the entire report. This is only applicable to section types of 4 (Body).
START_COL DOUBLE N The column that printing starts in for this 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.
WRAP_IND DOUBLE N Determines if this field has text wrap turned on or not.



Relationship Detail - SN_RPT_FIELD


Child Column in SN_RPT_FIELD(FK) Parent Table Name Parent Column Name
Parents: RPT_SECT_ID SN_RPT_SECT RPT_SECT_ID




Parent Column in SN_RPT_FIELD (PK) Child Table Name Child Column Name
Children: RPT_FIELD_ID SN_RPT_FIELD_SETTING RPT_FIELD_ID


SN_RPT_FIELD_REF



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN_RPT_FIELD_REF
Definition: Contains the reference information for each field in a report section. This information includes the key, default display, and various other indicators.
Table Type: REFERENCE





Column Detail - SN_RPT_FIELD_REF


Column Name Type Null? Definition
DISPLAY VARCHAR(60) N The default display value for this field.
FIELD_KEY VARCHAR(20) N The unique field key for this field. These keys are set by the SurgiNet engineering team and are used in various scripts to determine what data to retrieve for this field.
FIELD_SIZE DOUBLE N The default number of columns that this field uses.
LINE_IND DOUBLE N Determines if a '____' can be used as the value for this field.
MULTI_SETTING_FLAG DOUBLE N Determines the type of setting selection that can be made for this field.
RPT_FIELD_GRP_CD DOUBLE N Determines what field group this field belongs in.
RPT_FIELD_REF_ID DOUBLE N Primary Key
RPT_SECT_REF_ID DOUBLE N A foreign key into the SN_RPT_SECT_REF table to determine what section this field belongs in.
SCRIPT_NAME VARCHAR(32) N Determines which script the values for this field are derived from.
SETTING_IND DOUBLE N Determines if this field contains additional field settings.
SIZABLE_IND DOUBLE N Determines if the size of this field is adjustable by the user.
SORTABLE_IND DOUBLE N Determines if the user can sort on this field or not.
STACKABLE_IND DOUBLE N Determines if this field can be stacked on top of another 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.



Relationship Detail - SN_RPT_FIELD_REF


Child Column in SN_RPT_FIELD_REF(FK) Parent Table Name Parent Column Name
Parents: RPT_SECT_REF_ID SN_RPT_SECT_REF RPT_SECT_REF_ID


SN_RPT_FIELD_SETTING



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN RPT FIELD SETTING
Definition: Contains additional information for a field in the SN_RPT_FIELD table.
Table Type: REFERENCE





Column Detail - SN_RPT_FIELD_SETTING


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 initially inserted.
CREATE_PRSNL_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.
CREATE_TASK DOUBLE Y The registered (assigned) task number for the process that created the row.
PRIMARY_ENTITY_ID DOUBLE N The _id that corresponds to this settings primary id. This is commonly used for fields that require additional information to get the actual value for the report. For example: segment comments would require a primary_entity_id equal to the seg_cd which corresponds to the segment that we are wanting to get the comments for.
PRIMARY_ENTITY_NAME VARCHAR(32) N The name of the table that the primary_entity_id corresponds to.
RPT_FIELD_ID DOUBLE N The field that these settings belong to.
RPT_FIELD_SETTING_ID DOUBLE N Primary Key
SECONDARY_ENTITY_ID DOUBLE N The _id that corresponds to this settings secondary id. This is commonly used for fields that require additional information beyond a single id to get the actual value for the report. For example: A DTA off of a form would require two event_cd's to retrieve the value out of the clinical events; a form level event_cd and a control level event_cd.
SECONDARY_ENTITY_NAME VARCHAR(32) Y The name of the table that the secondary_entity_id corresponds to.
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_FIELD_SETTING


Child Column in SN_RPT_FIELD_SETTING(FK) Parent Table Name Parent Column Name
Parents: RPT_FIELD_ID SN_RPT_FIELD RPT_FIELD_ID