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 |