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. |