Table Detail Report

SN_RPT_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN RPT FILTER
Definition: This table holds all of the filters for a given filter group.
Table Type: REFERENCE





Column Detail - SN_RPT_FILTER


Column Name Type Null? Definition
CONTROL_EVENT_CD DOUBLE N The event code associated with the task_assay_cd
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.
FILTER_STRING VARCHAR(255) Y This holds non-foreign key filter values.
FORM_EVENT_CD DOUBLE N The event code associated with the input_form_cd
INPUT_FORM_CD DOUBLE N For a clinical event filter, this will contain the code value of the form to which the filter value applies.
PARENT_ENTITY_ID DOUBLE N If this filter 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) Y Name of the table that this filter has a foreign key to.
RPT_FILTER_GRP_ID DOUBLE N Foreign key into the SN_RPT_FILTER_GRP table to indicate which filter group this filter belongs to.
RPT_FILTER_ID DOUBLE N Primary Key
RPT_FILTER_REF_ID DOUBLE N Foreign key into the SN_RPT_FILTER_REF table to indicate what reference filter this filter was created from.
TASK_ASSAY_CD DOUBLE N For a clinical event filter, this will contain the code value of the control to which the filter value applies.
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_FILTER


Child Column in SN_RPT_FILTER(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
RPT_FILTER_GRP_ID SN_RPT_FILTER_GRP RPT_FILTER_GRP_ID


SN_RPT_FILTER_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds the filter groups for a report.
Definition: This table holds the filter groups for a report. Each filter group will hold: printing file properties, filters, output destinations, and privileges.
Table Type: REFERENCE





Column Detail - SN_RPT_FILTER_GRP


Column Name Type Null? Definition
APPEND_IND DOUBLE N Indicates if appending existing print file is desired (0 - False, 1 - True).
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.
DIR_NAME VARCHAR(100) Y Specifies the name of the logical or the full directory path where the print file will be generated.
DISPLAY VARCHAR(60) N The display value for this filter group.
FILE_FORMAT DOUBLE N Specifies the format of the print file (0 - Postscript, 1 - ASCII, 2 - CSV).
FILE_NAME VARCHAR(50) Y Specifies the name of the print file.
OWNER_ID DOUBLE N The person_id of the person from the personnel table (prsnl) assigned to own the filter group.
PAGE_BREAK_IND DOUBLE N Indicates if page break is desired in the print file (0 - False, 1 - True).
RPT_FILTER_GRP_ID DOUBLE N Primary Key
RPT_ID DOUBLE N This is a foreign key into the SN_RPT table to indicate which report this filter group belongs.
TYPE_FLAG DOUBLE N Indicates what type of applications this filter group 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.



Relationship Detail - SN_RPT_FILTER_GRP


Child Column in SN_RPT_FILTER_GRP(FK) Parent Table Name Parent Column Name
Parents: CREATE_PRSNL_ID PRSNL PERSON_ID
OWNER_ID PRSNL PERSON_ID




Parent Column in SN_RPT_FILTER_GRP (PK) Child Table Name Child Column Name
Children: RPT_FILTER_GRP_ID SN_RPT_DEST RPT_FILTER_GRP_ID
SN_RPT_FILTER RPT_FILTER_GRP_ID
SN_RPT_PREFS RPT_FILTER_GRP_ID


SN_RPT_FILTER_REF



Column Section Top of Page


Table-level Detail

Description: SN RPT FILTER REF
Definition: This table contains all of the filters associated with a given report type.
Table Type: REFERENCE





Column Detail - SN_RPT_FILTER_REF


Column Name Type Null? Definition
DISPLAY VARCHAR(100) N The display value for the filter.
DISPLAY_TYPE_FLAG DOUBLE N The type of control that will be used to collect information for this filter. For example: a provider control, list box, text box, etc.
FILTER_DATA VARCHAR(255) Y Contains miscellaneous information about the filter. For example it could contain information about which code set the filter values come from, or if the provider selection control should be limited to just physicians, or the actual values for this filter.
FILTER_KEY VARCHAR(20) N The unique key for this filter. This is a SurgiNet defined key that is used within the report scripts to identify this filter.
FILTER_TYPE_FLAG DOUBLE N Determines the type of filter that this is.
REQUIRED_IND DOUBLE N Determines if this filter is required to run the given report type.
RPT_FILTER_REF_ID DOUBLE N Primary Key
RPT_TYPE_CD DOUBLE N Determines which report type these filters apply 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_GRP



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN RPT GRP
Definition: This table groups SurgiNet reports into logical report sets.
Table Type: REFERENCE





Column Detail - SN_RPT_GRP


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 for this report group.
ORDER_SEQ DOUBLE N The order that this report group displays.
RPT_GRP_ID DOUBLE N Primary Key
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_GRP




Parent Column in SN_RPT_GRP (PK) Child Table Name Child Column Name
Children: RPT_GRP_ID SN_RPT_GRP_R RPT_GRP_ID


SN_RPT_GRP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: SN RPT GRP R
Definition: This is a relationship table for the reports and the report groups in SurgiNet.
Table Type: REFERENCE





Column Detail - SN_RPT_GRP_R


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.
ORDER_SEQ DOUBLE N The sequence of the report in the group.
RPT_GRP_ID DOUBLE N Foreign key into the SN_RPT_GRP table to determine the group that this relationship goes with.
RPT_GRP_R_ID DOUBLE N Primary Key
RPT_ID DOUBLE N Foreign key into the SN_RPT table to determine which report this relationship goes with.
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_GRP_R


Child Column in SN_RPT_GRP_R(FK) Parent Table Name Parent Column Name
Parents: RPT_GRP_ID SN_RPT_GRP RPT_GRP_ID