Table Detail Report

SN_CHARGE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Charge Item
Definition: SurgiNet Charge Item Table
Table Type: ACTIVITY





Column Detail - SN_CHARGE_ITEM


Column Name Type Null? Definition
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 Y 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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CHARGE_ITEM_ID DOUBLE N The Unique Identifier on the Table
CHARGE_TYPE_FLAG DOUBLE Y Charge Type Flag
CREATE_APPLCTX DOUBLE N The Application Context creating the row
CREATE_DT_TM DATETIME Y The Date and Time the Row was createdColumn
CREATE_PRSNL_ID DOUBLE N The Personnel respnosible for creating this row.
CREATE_TASK DOUBLE N The task that was used in creating the row
DOC_TYPE_CD DOUBLE N The document Type Code for which this charge is being sent
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EVENT_ID DOUBLE N The Id that references to the Event Id on the AFC request
EVENT_NAME VARCHAR(30) Y The Table name that contains the Event ID can be Item_Master, Order_Catalog or Surgical_Case
IN_PROCESS_IND DOUBLE Y Indicates if the charge is in the process of being sent.
QUANTITY DOUBLE N This is the quantity which has been charged
REFERENCE_ID DOUBLE N Reference_Id in the AFC Request
REFERENCE_NAME VARCHAR(30) Y The Table name that contains the Reference ID can be Surg_Case_Procedure, Case_Cart_Pick_List, Code_Value
SURG_CASE_ID DOUBLE N The Surgical Case Id this charge item is for.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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_CHARGE_ITEM


Child Column in SN_CHARGE_ITEM(FK) Parent Table Name Parent Column Name
Parents: SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_CHARGE_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Charge Queue
Definition: SurgiNet Charge Queue Table
Table Type: ACTIVITY





Column Detail - SN_CHARGE_QUEUE


Column Name Type Null? Definition
AREA_CD DOUBLE N The surgical area associated with the transaction.
BLOCKED_DT_TM DATETIME Y The date and time the transaction was last blocked.
BLOCKED_IND DOUBLE N Indicates block status (0 = False, 1 = True).
BLOCKED_REASON_FLAG DOUBLE N Identifies the reason of why the pending charge is being blocked (0 = unknown, 1 = incomplete data, 2 = user, 3 = sync constraint, 4 = other)
DELAY_REASON VARCHAR(250) Y The reason why the transaction was last delayed.
DOC_TYPE_CD DOUBLE N The document type associated with the transaction. This is the second field of the unique identifier on the Table.
FAILURE_CNT DOUBLE N Set to 0 on insert. Incremented by 1 when the transaction fails.
FAILURE_DT_TM DATETIME Y The date and time the transaction last failed.
HOLD_BY_ID DOUBLE N The personnel ID who requested to hold the transaction.
HOLD_DT_TM DATETIME Y The date and time the transaction was held.
HOLD_REASON VARCHAR(250) Y The reason why the transaction is being held.
PROCESS_IND DOUBLE N Indicates whether this transaction type is being processed
RECHARGES_IND DOUBLE N Indicates if the transaction was requested to be recharged (0 = False, 1 = True)
RELEASE_BY_ID DOUBLE N Identifies the personnel ID of the personnel releasing the blocked pending charge.
RELEASE_DT_TM DATETIME Y Identifies the date and time of when the blocked pending charge was released.
RELEASE_REASON VARCHAR(250) Y Identifies the reason of releasing the blocked pending charge.
SUBMITTED_BY_ID DOUBLE N The personnel ID who submitted the transaction.
SUBMITTED_DT_TM DATETIME Y The date and time the transaction was last submitted.
SURG_CASE_ID DOUBLE N The surgical case associated with the transaction. This is the first field of the unique identifier on the Table.
TRANS_TYPE_MEAN VARCHAR(12) N The type of transaction. This is the third field of the unique identifier on the Table.
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_CHARGE_QUEUE


Child Column in SN_CHARGE_QUEUE(FK) Parent Table Name Parent Column Name
Parents: SURG_CASE_ID SURGICAL_CASE SURG_CASE_ID


SN_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Comments
Definition: SurgiNet Comments Table
Table Type: REFERENCE





Column Detail - SN_COMMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMMENT_TYPE_CD DOUBLE N Comment Type CodeColumn
CREATE_APPLCTX DOUBLE Y Create Application ContextColumn
CREATE_DT_TM DATETIME Y Create Date and TimeColumn
CREATE_PRSNL_ID DOUBLE Y Create Personnel IDColumn
CREATE_TASK DOUBLE Y Create TaskColumn
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
LONG_TEXT_ID DOUBLE N Long Text IdColumn
PARENT_ENTITY_ID DOUBLE N Parent Entity IdColumn
PARENT_ENTITY_NAME VARCHAR(32) N Parent Enity NameColumn
SN_COMMENT_ID DOUBLE N Sn Comment IDColumn
SURG_AREA_CD DOUBLE Y Surgical AreaColumn
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_COMMENT


Child Column in SN_COMMENT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


SN_COMMENT_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SurgiNet Comment Text
Definition: SurgiNet Comment Text Table
Table Type: REFERENCE





Column Detail - SN_COMMENT_TEXT


Column Name Type Null? Definition
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.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMMENT_TYPE_CD DOUBLE N The type of comment that this is.
CREATE_APPLCTX DOUBLE Y The application context responsible for creating the row
CREATE_DT_TM DATETIME Y The Create Date and Time for the row
CREATE_PRSNL_ID DOUBLE N The ID of the Personnel responsible for creating the row
CREATE_TASK DOUBLE Y The task creating the row
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
HEADER VARCHAR(150) N Header for the Comment
LONG_BLOB_ID DOUBLE N The ID from the LONG_BLOB table for the blob data
LONG_TEXT_ID DOUBLE N The ID from the LONG_TEXT table for the text data
REFERENCE_IND DOUBLE N Specifies if this is a reference Comment
ROOT_ID DOUBLE N The ID from the table specified in ROOT_NAME for which this comment is being stored for
ROOT_NAME VARCHAR(30) N The table for which the comment is being stored for
SEG_CD DOUBLE N The segment for which the comment is being store for
SEQ_NUM DOUBLE N Sequence number of the comment text
SN_COMMENT_ID DOUBLE N The Unique ID for the table
SURG_AREA_CD DOUBLE N The Surgical Area for which the comment is stored for
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_COMMENT_TEXT


Child Column in SN_COMMENT_TEXT(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


SN_COST_REF



Column Section Top of Page


Table-level Detail

Description: SN COST REF
Definition: This table holds the reference information for costing of roles and prsnl.
Table Type: REFERENCE





Column Detail - SN_COST_REF


Column Name Type Null? Definition
AREA_CD DOUBLE N The surgical area for the cost.
COST_PER_MIN DOUBLE Y The cost per minute of time.
COST_REF_ID DOUBLE N Primary KeyColumn
COST_TYPE_MEAN VARCHAR(12) N The cost type meaningColumn
PARENT_ENTITY_ID DOUBLE N Parent foreign key for this cost
PARENT_ENTITY_NAME VARCHAR(32) N Parent table for this cost
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.