Table Detail Report

RAW_BATCH_TRANS_FILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Raw Batch Transaction File
Definition: Contins pre-translated X12 835 Transaction Level data..
Table Type: ACTIVITY





Column Detail - RAW_BATCH_TRANS_FILE


Column Name Type Null? Definition
BILL_NUMBER_IDENT VARCHAR(38) N CLP01- Bill Number sent in for CLP, CAS, SVC and SVC-CAS transactions.
CLAIM_STATUS_CD_TXT VARCHAR(4) N CLP02 - Code identifying the status of an entire claim as assigned by the payor, claim review organization, or repricing organization. i.e. - Processed as Primary, Secondary, Tertiary, etc.
PAYER_BILL_CODE VARCHAR(20) N Code used by payer to adjudicate the bill.
PAYER_BILL_TYPE_CODE VARCHAR(10) N Code type used by payer to adjudicate the bill.
PAYER_COVERED_CHARGE_AMT DOUBLE Y The charge amount covered by payer.
PAYER_COVERED_DAYS DOUBLE Y The number of days covered by payer.
PROCEDURE_CD_TXT VARCHAR(48) N SVC01-2. Identifying number for a product or service.
PROCEDURE_MODIFIER_CD_TXT VARCHAR(15) N Will hold any modifiers that were sent. Identifies special circumstances related to the performance of the service. Combination of SVC01-3 to SVC01-6. Will be separated with "|".
PROD_SRVC_QUAL_CD_TXT VARCHAR(2) N SVC01-1. Code identifying the type/source of the descriptive number used in Product/Service ID. i.e. - HC for HCPCS codes or NU for UB92 codes.
RAW_BATCH_TRANS_FILE_ID DOUBLE N Uniquely identifies a pre-translated X12 835 transaction level data row.
RAW_BATCH_TRANS_ID DOUBLE N Uniquely identifies the raw batch trans record related to this row.
REF_IDENT_CD_TXT VARCHAR(50) N REF02. Reference information as defined for a particular Transaction Set or as specified by the Reference Identification Qualifier.
REF_IDENT_QUAL_CD_TXT VARCHAR(3) N REF01. Code that qualifies the reference identification. I.e. - Provider control number or Authorization Number.
SRVC_DT_TM DATETIME Y DTM02. Date and time service was performed.
TOTAL_CHARGE_AMT DOUBLE N CLP03, SVC02. Total Charge Amount.
TRANS_AMT DOUBLE N CLP04, CAS03, SVC03, SVC-CAS03. Amount of transaction.
TRANS_GROUP_CD_TXT VARCHAR(2) N CAS01 - Identifies category of claim adjustment. Translates to codeset 26379.CO - Contractual ObligationCR - Correction and ReversalsOA - Other AdjustmentsPI - Payor initiated reductionsPR - Patient Responsibility
TRANS_REASON_CD_TXT VARCHAR(5) N CAS02, SVC-CAS02. Identifies reason the adjustment was made. Translates to codeset 26398.
TRANS_SEGMENT_IDENT VARCHAR(10) N CLP, CAS, SVC, SVC-CAS, SVC-REF. Identifies the segment from which the transaction came.
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 - RAW_BATCH_TRANS_FILE


Child Column in RAW_BATCH_TRANS_FILE(FK) Parent Table Name Parent Column Name
Parents: RAW_BATCH_TRANS_ID RAW_BATCH_TRANS RAW_BATCH_TRANS_ID




Parent Column in RAW_BATCH_TRANS_FILE (PK) Child Table Name Child Column Name
Children: RAW_BATCH_TRANS_FILE_ID BATCH_TRANS_FILE RAW_BATCH_TRANS_FILE_ID


RC_EDI_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle EDI Transaction
Definition: Stores all the EDI transaction details related to pricing.
Table Type: ACTIVITY





Column Detail - RC_EDI_TRANSACTION


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.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active.
CALL_BACK_HANDLER_IDENT DOUBLE Y To persist the call back handler identifier corresponding to each transaction request, for handling response.
CREATE_DT_TM DATETIME N The date and time the record was created.
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.
EXT_BATCH_IDENT VARCHAR(250) Y External batch identifier used to identify a group of related transactions.
EXT_GROUP_IDENT VARCHAR(250) Y The Ticket number (EDI number) provided by the cloud service.
EXT_PARTNER_IDENT VARCHAR(250) Y The 3rd party identification number provided by cloud service.
HTTP_STATUS_CODE DOUBLE N Contains the HTTP status code for a given request.
HTTP_STATUS_DESC VARCHAR(250) Y Contains the corresponding HTTP status description.
MAX_RETRY_CNT DOUBLE N The maximum number of retries allowed for this corresponding transaction.
ORIG_RC_EDI_TRANSACTION_ID DOUBLE N FK from the original RC_EDI_TRANSACTION_ID value. Used for versioning.
PARENT_ENTITY_ID DOUBLE N The primary data source corresponding to this EDI transaction.
PARENT_ENTITY_NAME VARCHAR(32) N The entity name (ex: PFT_ENCNTR, CHARGE, BILLING_ENTITY) describing the primary source entity data corresponding to that EDI transaction.
RC_EDI_TRANSACTION_ID DOUBLE N Unique generated number that identifies a single row on the PFT_EDI_TRANSACTION table.
REPLY_LONG_TEXT_ID DOUBLE N Reply Long Text ID
REQUEST_LONG_TEXT_ID DOUBLE N Request Long Text ID
RESOURCE_URL VARCHAR(3200) N Contains the endpoint resource URL.
RETRIEVE_DT_TM DATETIME Y The EDI Transaction reply(response) received date and time(timestamp).
RETRY_CNT DOUBLE N The count indicating the number of retry on edi transmission performed for that particular ticket id.
SERVICE_CD DOUBLE N The service code indicating the service using this EDI transaction record.
STATUS_CD DOUBLE N The status code representing the current status of this EDI transaction.
TRANSMIT_DT_TM DATETIME N The EDI Transaction request transmit date and time(timestamp).
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 - RC_EDI_TRANSACTION


Child Column in RC_EDI_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: REPLY_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
REQUEST_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORIG_RC_EDI_TRANSACTION_ID RC_EDI_TRANSACTION RC_EDI_TRANSACTION_ID




Parent Column in RC_EDI_TRANSACTION (PK) Child Table Name Child Column Name
Children: RC_EDI_TRANSACTION_ID RC_EDI_TRANSACTION ORIG_RC_EDI_TRANSACTION_ID


TRANS_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Log
Definition: Is used to identify what type of transaction we are dealing with along with high level information about the transaction before it is broken down to the account or charge level.
Table Type: ACTIVITY





Column Detail - TRANS_LOG


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 Primary Key and Foreign Key to the Activity Log 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.
BILL_IND DOUBLE Y Indicates that the bill has been sent out for the transaction.
BUNDLE_ID DOUBLE N Will be removed
BUNDLE_IND DOUBLE Y Bundle Indicator - no longer being used.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
CREDIT_BALANCE_ID DOUBLE N Balance this transaction impacted (credit)
DEBIT_BALANCE_ID DOUBLE N Balance this transaction impacted (debit).
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.
FIN_TRANS_GROUP_ID DOUBLE N Uniquely identifies the related row on the FIN_TRANS_GROUP table.
GL_POSTED_IND DOUBLE Y General Ledger Indicator
PAYMENT_DETAIL_ID DOUBLE N Uniquely identifies the related payment detail record.
PFT_PAYMENT_LOCATION_ID DOUBLE Y Uniquely identifies the payment location for this record.
POST_DT_TM DATETIME Y The date and time the transaction was posted.
SOURCE_FLAG DOUBLE N ** Obsolete - No longer used ** SOURCE FLAG - 1 = Automatically calculated - 0 = Manually calculated ** Obsolete**
SUPPRESS_FLAG DOUBLE Y Suppression flag to indicate levels of suppression - Needs to be a long.
TOTAL_TRANS_AMOUNT DOUBLE Y The total amount of the transaction. (In the case of a payment, the full amount before being applied to multiple accounts).
TPM_ID DOUBLE N Transaction Posting Matrix
TRANS_ALIAS_ID DOUBLE N Foreign key to the pft_trans_alias table.
TRANS_REASON_CD DOUBLE N Stores information about why a transaction (adjustment, write off) took place.
TRANS_STATUS_CD DOUBLE N The current status of the transaction. (hold, review)
TRANS_STATUS_REASON_CD DOUBLE N Contains the reason code for this transaction log entry.
TRANS_SUB_TYPE_CD DOUBLE N Transaction Sub Type
TRANS_TYPE_CD DOUBLE N Identifies whether we are dealing with a charge, payment, adjustment...
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 - TRANS_LOG


Child Column in TRANS_LOG(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
FIN_TRANS_GROUP_ID FIN_TRANS_GROUP FIN_TRANS_GROUP_ID
PAYMENT_DETAIL_ID PAYMENT_DETAIL PAYMENT_DETAIL_ID
CREDIT_BALANCE_ID PFT_BALANCE PFT_BALANCE_ID
DEBIT_BALANCE_ID PFT_BALANCE PFT_BALANCE_ID
PFT_PAYMENT_LOCATION_ID PFT_PAYMENT_LOCATION PFT_PAYMENT_LOCATION_ID
TRANS_ALIAS_ID PFT_TRANS_ALIAS PFT_TRANS_ALIAS_ID
CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in TRANS_LOG (PK) Child Table Name Child Column Name
Children: ACTIVITY_ID BATCH_TRANS_FILE CHRG_ACTIVITY_ID
BATCH_TRANS_RELTN ACTIVITY_ID
GL_TRANS_LOG ACTIVITY_ID
PFT_QUEUE_ITEM ACTIVITY_ID
PFT_QUEUE_ITEM_HIST ACTIVITY_ID
RCR_TRANS_DIST ACTIVITY_ID
TRANS_TRANS_RELTN CHILD_ACTIVITY_ID
TRANS_TRANS_RELTN PARENT_ACTIVITY_ID


TRANS_TRANS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transaction Transaction Relation
Definition: Allows us to relate one transaction with another. (Identify what charge a payment was for, or whatcharge a write-off was for)
Table Type: ACTIVITY





Column Detail - TRANS_TRANS_RELTN


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.
AMOUNT DOUBLE Y Amount of the transaction that applies to this relationship.
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.
CHILD_ACTIVITY_ID DOUBLE N When more than one transaction are related, generally the transaction that occurred at a later time becomes the child transaction in the relationship.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the 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.
PARENT_ACTIVITY_ID DOUBLE N When more than one transaction are related, generally, the original transaction becomes the parent.
TRANS_RELTN_REASON_CD DOUBLE N Code value indicating the reason the two or more transactions are related.
TRANS_RELTN_SUB_REASON_CD DOUBLE N Contains more detailed information about why the trans_reltn_reason_cd is in it's current state.
TRANS_TRANS_RELTN_ID DOUBLE N Trans_Trans_Reltn Sequence ID
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 - TRANS_TRANS_RELTN


Child Column in TRANS_TRANS_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_ACTIVITY_ID TRANS_LOG ACTIVITY_ID
PARENT_ACTIVITY_ID TRANS_LOG ACTIVITY_ID