ACTIVITY_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Activity Log
Definition: This table stores a high level view of all activity as it enters the system. An activity can be either a transaction (payment, write off, adjustment, charge) or correspondence, (bill, claim, letter,fax, email, phone call)
Table Type: ACTIVITY





Column Detail - ACTIVITY_LOG


Column Name Type Null? Definition
ACTION_CODE VARCHAR(40) Y User-defined code used to identify an event.
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 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.
ACTIVITY_DT_TM DATETIME Y The date and time that the activity took place.
ACTIVITY_ID DOUBLE N The primary key and will be used through out the system to track the activity.
ACTIVITY_TYPE_CD DOUBLE N Identifies if the activity was a transaction or correspondence.
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.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created record.
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_CD DOUBLE N System event code value.
PRODUCTIVITY_FLAG DOUBLE Y Flag used to define if the row is used in productivity reporting.
PRODUCTIVITY_WEIGHT DOUBLE Y Assign weight of event used to measure productivity.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - ACTIVITY_LOG


Child Column in ACTIVITY_LOG(FK) Parent Table Name Parent Column Name
Parents: CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in ACTIVITY_LOG (PK) Child Table Name Child Column Name
Children: ACTIVITY_ID BATCH_TRANS_EXT ACTIVITY_ID
CORSP_LOG ACTIVITY_ID
GL_TRANS_LOG_OFFSET ACTIVITY_ID
PAYMENT_DETAIL ACTIVITY_ID
PFT_BILL_ACTIVITY ACTIVITY_ID
PFT_CHARGE ACTIVITY_ID
PFT_PRORATION_RELTN ACTIVITY_ID
PFT_TRANS_RELTN ACTIVITY_ID
TRANS_LOG ACTIVITY_ID


BATCH_DENIAL_FILE_DETAIL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BATCH DENIAL FILE DETAIL RELATION
Definition: Detail for the batch denial file table
Table Type: ACTIVITY





Column Detail - BATCH_DENIAL_FILE_DETAIL_R


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 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.
BATCH_DENIAL_FILE_DETAIL_R_ID DOUBLE N Primary Key
BATCH_DENIAL_FILE_R_ID DOUBLE N Foreign Key to Batch_Denial_File_R table
BEG_EFFECTIVE_DT_TM DATETIME N 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.
END_EFFECTIVE_DT_TM DATETIME N 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.
REMARK_CODE_ATTRIB_CD DOUBLE N Remark Code Attribute
REMARK_CODE_ATTRIB_VALUE VARCHAR(50) Y value for the attribute identified by the remark_code_attrib_cd
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 - BATCH_DENIAL_FILE_DETAIL_R


Child Column in BATCH_DENIAL_FILE_DETAIL_R(FK) Parent Table Name Parent Column Name
Parents: BATCH_DENIAL_FILE_R_ID BATCH_DENIAL_FILE_R BATCH_DENIAL_FILE_R_ID


BATCH_DENIAL_FILE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: BATCH DENIAL FILE RELATION
Definition: Relates the batchs and denila codes.
Table Type: ACTIVITY





Column Detail - BATCH_DENIAL_FILE_R


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 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.
BATCH_DENIAL_FILE_R_ID DOUBLE N Primary key
BATCH_TRANS_FILE_ID DOUBLE N Foreign key reference to the batch_trans_file table.
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.
DENIAL_CD DOUBLE N A claim remark providing additional information on why a claim was adjudicated. Additional information about a payment/adjustment on a claim. Valid codesets for this column are 26398, 26399, and 24730.
DENIAL_CODE_TXT VARCHAR(255) Y This field holds the text that relates to the denial code value
DENIAL_TEXT VARCHAR(255) N The payers alias representing the claim remark.
DENIAL_TYPE_CD DOUBLE N This defines the base type of the denial code i.e. provider, patient, technical, information only.
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.
TRANS_RELTN_REASON_CD DOUBLE N Stores TRANS_TRANS_RELTN tables TRANS_RELN_REASON_CD value in case of Transfer Transaction associated with remarks.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BATCH_DENIAL_FILE_R


Child Column in BATCH_DENIAL_FILE_R(FK) Parent Table Name Parent Column Name
Parents: BATCH_TRANS_FILE_ID BATCH_TRANS_FILE BATCH_TRANS_FILE_ID




Parent Column in BATCH_DENIAL_FILE_R (PK) Child Table Name Child Column Name
Children: BATCH_DENIAL_FILE_R_ID BATCH_DENIAL_FILE_DETAIL_R BATCH_DENIAL_FILE_R_ID


BATCH_TRANS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Batch Transaction
Definition: Contains information about a Batch Transaction
Table Type: ACTIVITY





Column Detail - BATCH_TRANS


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 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.
ADJ_COMPUTED_TOTAL DOUBLE Y Adjustment Computed Total. The total monetary amount of adjustments that have been added to the batch.
ADJ_RESTATED_TOTAL DOUBLE Y Populated in the event the user re-states the adjustment control total after stating it during batch creation.
ADJ_STATED_TOTAL DOUBLE Y The initial adjustment control total as stated by the user.
BATCHJOB_IND DOUBLE Y Obsolete. This column is no longer used. Batch Job Indicator
BATCH_ALIAS VARCHAR(25) Y An optional User-defined batch alias for each transaction entry batch
BATCH_ALIAS_KEY VARCHAR(25) Y Corresponding KEY field in UPPERCASE and with special characters and blanks removed.
BATCH_ALIAS_KEY_A_NLS VARCHAR(100) Y BATCH_ALIAS_KEY_A_NLS column
BATCH_ALIAS_KEY_NLS VARCHAR(52) Y Corresponding Global support field for the associated column KEY column.
BATCH_CONTROL_NBR VARCHAR(20) Y This will assist batch control handling when receiving transactions from an external file
BATCH_STATUS_CD DOUBLE N The current status of the watch, i.e., working posted, etc. Code Set 23372.
BATCH_TRANS_ID DOUBLE N Uniquely identifies a batch transaction.
BATCH_TYPE_FLAG DOUBLE Y Indicates which tool created the batch.
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.
BILLING_ENTITY_ID DOUBLE N Foreign key reference to the billing_entity table.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of person that created the record.
DENIAL_AMT DOUBLE N ** obsolete ** The amount of the denial.
DENIAL_CD DOUBLE N ** obsolete ** The Code representing the denial reason.
DEPOSIT_DT_TM DATETIME Y This indicates on which date the amount got deposited to the bank, for the user to see at the time of batch reconciliation
DEPOSIT_RECORD_ID DOUBLE N Uniquely identifies the deposit record related to this batch transaction.
DR_CR_ADJ_COMPUTED_FLAG DOUBLE Y Debit Credit Flag for the Adjustment Computed.0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
DR_CR_ADJ_RESTATED_FLAG DOUBLE Y Debit Credit Flag for the Adjustment Restated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
DR_CR_ADJ_STATED_FLAG DOUBLE Y Debit Credit Flag for the Adjustment Stated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
DR_CR_FC_COMPUTED_FLAG DOUBLE Y Obsolete. No longer used. Debit Credit Flag for the Finance Charge Computed 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
DR_CR_FC_RESTATED_FLAG DOUBLE Y Obsolete. No longer used. Debit Credit Flag for Finance Charge Restated
DR_CR_FC_STATED_FLAG DOUBLE Y Obsolete. No longer used. Debit Credit Flag for the Finance Charge Stated
DR_CR_PAY_COMPUTED_FLAG DOUBLE Y Debit Credit Flag for Payment Computed 0 - No Balance; 1- Debit Balance; 2 - Credit Balance
DR_CR_PAY_RESTATED_FLAG DOUBLE Y Debit Credit Flag for the Payment Restated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
DR_CR_PAY_STATED_FLAG DOUBLE Y Debit Credit Flag for the Payment Stated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance
ELECTRONIC_FILE_NAME VARCHAR(500) Y Stores the 835 file name in the system.
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.
EXT_BATCH_ID_TXT VARCHAR(100) Y External Batch ID Text. User created Batch Identifier.
EXT_BATCH_ID_TXT_KEY VARCHAR(100) Y External Batch ID Text_key. This field is used for indexing and searching by External Batch ID Text.
EXT_BATCH_ID_TXT_KEY_A_NLS VARCHAR(400) Y EXT_BATCH_ID_TXT_KEY_A_NLS column
EXT_BATCH_ID_TXT_KEY_NLS VARCHAR(100) Y EXT_BATCH_ID_TXT Key field converted to NLS format for internationalization requirements.
FC_COMPUTED_TOTAL DOUBLE Y Obsolete. No longer used. Finance Charge Computed Total
FC_RESTATED_TOTAL DOUBLE Y Obsolete. No longer used. Finance Charge Restated Total
FC_STATED_TOTAL DOUBLE Y Obsolete. Column no longer used. Finance Charge Stated Total
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ONEPAYMENT_IND DOUBLE N One Payment Indicator. If the indicator is 1, then the batch has one form of payment for all payments within the batch.
PAYEE_NPI_ORG_ALIAS VARCHAR(100) N National provider identifier alias for the payee organization.
PAYEE_ORG_ID DOUBLE N National provider identifier for the payee organization.
PAYER_BATCH_IDENT VARCHAR(25) N ** obsolete ** External reference number specified by payer for batch of the claim forms
PAYMENT_METHOD_CD DOUBLE N The mode of payment sent by the payer.
PAYMENT_NUM_DESC VARCHAR(500) N The check number associated with the remittance check.
PAYOR_ORG_ID DOUBLE N Uniquely identifies the payor of the remittance batch.
PAY_COMPUTED_TOTAL DOUBLE Y Payment Computed Total. The total monetary amount of payments that have been added to the batch.
PAY_RESTATED_TOTAL DOUBLE Y Payment Restated Total. Populated in the event the user re-states the payment control total after stating it during batch creation.
PAY_STATED_TOTAL DOUBLE Y Payment Stated Total. The initial payment control total as stated by the user.
PFT_EVENT_OCCUR_LOG_ID DOUBLE N Obsolete. No longer used. ProFit Event Occurrence Log
POSTED_BY_USER_ID DOUBLE N The column will help to identify who posted the batch.
POST_DT_TM DATETIME Y Post date for this batch.
PURGED_IND DOUBLE Y Obsolete. No longer used. Purged Indicator
RAW_BATCH_TRANS_ID DOUBLE Y Uniquely identifies the Raw Batch Transaction record related to this row.
SESSION_ID DOUBLE N Session ID - No longer used
SUBMITTED_DT_TM DATETIME Y If submitted, the date and time of submittal
SUBMITTED_IND DOUBLE Y Indicates whether or not submitted
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BATCH_TRANS


Child Column in BATCH_TRANS(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PAYEE_ORG_ID ORGANIZATION ORGANIZATION_ID
PAYOR_ORG_ID ORGANIZATION ORGANIZATION_ID
CREATED_PRSNL_ID PRSNL PERSON_ID
POSTED_BY_USER_ID PRSNL PERSON_ID
RAW_BATCH_TRANS_ID RAW_BATCH_TRANS RAW_BATCH_TRANS_ID




Parent Column in BATCH_TRANS (PK) Child Table Name Child Column Name
Children: BATCH_TRANS_ID BATCH_TRANS_EXT BATCH_TRANS_ID
BATCH_TRANS_FILE BATCH_TRANS_ID
BATCH_TRANS_RELTN BATCH_TRANS_ID
CLAIM_TRANS_INFO BATCH_TRANS_ID
DEP_REC_BATCH_TRANS_RELTN BATCH_TRANS_ID
PFT_QUEUE_ITEM BATCH_TRANS_ID
PFT_QUEUE_ITEM_HIST BATCH_TRANS_ID


BATCH_TRANS_EXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: BATCH TRANSACTION EXT
Definition: Holds all of the transaction data whether it gets posted or not.
Table Type: ACTIVITY





Column Detail - BATCH_TRANS_EXT


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 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.
ACTIVITY_ID DOUBLE N Foreign key to activity log- only populated if posted
BATCH_TRANS_EXT_ID DOUBLE N Primary key
BATCH_TRANS_ID DOUBLE N Foreign key to the batch_trans table
BEG_EFFECTIVE_DT_TM DATETIME N 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.
EDI_ADJ_AMOUNT DOUBLE N From CAS loop
EDI_ADJ_DR_CR_FLAG DOUBLE N Debit/Credit flag for the EDI adj amount
EDI_ADJ_QUANTITY DOUBLE N From CAS loop
EDI_ADJ_REASON_CD DOUBLE N Adjustment reason
END_EFFECTIVE_DT_TM DATETIME N 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.
ESRD_PAYMENT_AMOUNT DOUBLE N End State Renal Disease (ESRD) payment amount
INPAT_PROF_COMP_AMT DOUBLE N Non-payable professional component amount related to inpatient adjudication
NON_INPAT_PROF_COMP_AMT DOUBLE N Non-payable professional component amount related to Medicare adjudication not related to inpatient
PARENT_ENTITY_ID DOUBLE N Foreign key to the table for which this entry points (Bill, Charge, Transaction)
PARENT_ENTITY_NAME VARCHAR(20) Y CHARGE
POSTED_IND DOUBLE N Indicates whether the transaction was posted or not
SEQUENCE_NBR DOUBLE N Relates to the sequence number on the Batch_Trans_File table through the Batch_Trans_id.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - BATCH_TRANS_EXT


Child Column in BATCH_TRANS_EXT(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
BATCH_TRANS_ID BATCH_TRANS BATCH_TRANS_ID