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 |