Table Detail Report

CLAIM_TRANS_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Claims Transaction Information
Definition: The claim_trans_info table holds claim transaction information for a given batch.
Table Type: ACTIVITY





Column Detail - CLAIM_TRANS_INFO


Column Name Type Null? Definition
BATCH_TRANS_ID DOUBLE Y Uniquely identifies the related remittance batch_id on the BATCH_TRANS table.
BILL_VRSN_NBR DOUBLE Y Contains the related bill_vrsn_nbr from the BILL_REC table.
CAPITAL_EXCEPTION_AMT DOUBLE Y MIA24 is the capital exception amount.
CAPITAL_OUTLIER_AMT DOUBLE Y MIA17 is the Prospective Payment System (PPS) Capital Outlier amount
CLAIM_PAY_REMARK_CD_MIA05_TXT VARCHAR(250) Y MIA05 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MIA20_TXT VARCHAR(250) Y MIA20 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MIA21_TXT VARCHAR(250) Y MIA21 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MIA22_TXT VARCHAR(250) Y MIA22 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MIA23_TXT VARCHAR(250) Y MIA23 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MOA03_TXT VARCHAR(250) Y MOA03 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MOA04_TXT VARCHAR(250) Y MOA04 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MOA05_TXT VARCHAR(250) Y MOA05 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MOA06_TXT VARCHAR(250) Y MOA06 is the Claim Payment Remark Code
CLAIM_PAY_REMARK_CD_MOA07_TXT VARCHAR(250) Y MOA07 is the Claim Payment Remark Code
CLAIM_TRANS_INFO_ID DOUBLE N A system generated number that uniquely identifies a row on the CLAIM_TRANS_INFO table.
CORSP_ACTIVITY_ID DOUBLE Y In conjunction with the bill_vrsn_nbr, uniquely identifies the related claim row on the BILL_REC table.
COST_REPORT_DAYS_CNT DOUBLE Y MIA15 is the cost report days
COVERED_DAYS_CNT DOUBLE Y MIA01 is the covered days
CREATED_DT_TM DATETIME Y Date and time the record was created.
DISPROPORTION_AMT DOUBLE Y MIA06 is the disproportionate share amount
DRG_AMT DOUBLE Y MIA04 is the Diagnosis Related Group (DRG) amount
DSH_CAPITAL_AMT DOUBLE Y MIA11 is the Prospective Payment System (PPS) capital, disproportionate share, hospital Diagnosis Related Group (DRG) amount
ESRD_PAY_AMT DOUBLE Y MOA08 is the End Stage Renal Disease (ESRD) payment amount
FEDERAL_DRG_AMT DOUBLE Y MIA16 is the federal specific Diagnosis Related Group (DRG) amount
FSP_CAPITAL_AMT DOUBLE Y MIA09 is the Prospective Payment System (PPS) capital, federal specific portion, Diagnosis Related Group (DRG) amount
HOSPITAL_DRG_AMT DOUBLE Y MIA14 is hospital specific Diagnosis Related Group (DRG) Amount
HSP_CAPITAL_AMT DOUBLE Y MIA10 is the Prospective Payment System (PPS) capital, hospital specific portion, Diagnosis Related Group (DRG), amount
IME_CAPITAL_AMT DOUBLE Y MIA13 is the Prospective Payment System (PPS) capital indirect medical education claim amount
MIA_NON_PAYABLE_AMT DOUBLE Y MIA19 is the professional component amount billed but not payable
MOA_NON_PAYABLE_AMT DOUBLE Y MOA09 is the professional component amount billed but not payable
OLD_CAPITAL_AMT DOUBLE Y MIA12 is the old capital amount
OPERATING_OUTLIER_AMT DOUBLE Y MIA02 is the Prospective Payment System (PPS) Operating Outlier amount
PASS_THROUGH_AMT DOUBLE Y MIA07 is the Medicare Secondary Payer (MSP) pass-through amount
PAYABLE_AMT DOUBLE Y MOA02 is the claim HCPCS payable amount
PPS_CAPITAL_AMT DOUBLE Y MIA08 is the total Prospective Payment System (PPS) capital amount
PSYCH_DAYS_CNT DOUBLE Y MIA03 is the lifetime psychiatric days
REIMBURSEMENT_RATE_PCT DOUBLE Y MOA01 is the reimbursement rate. Percentage expressed as a decimal 0.0 thru 1.0
TEACHING_AMT DOUBLE Y MIA18 is the indirect teaching amount
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - CLAIM_TRANS_INFO


Child Column in CLAIM_TRANS_INFO(FK) Parent Table Name Parent Column Name
Parents: BATCH_TRANS_ID BATCH_TRANS BATCH_TRANS_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID


CONS_BO_SCHED



Column Section Relationship Section Top of Page


Table-level Detail

Description: CONS BO SCHED
Definition: Stores guarantor and next billing date info for statement and invoice billing.
Table Type: ACTIVITY





Column Detail - CONS_BO_SCHED


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.
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_GROUP_ID DOUBLE N Relates the record to the billing entity group.
BILLING_ENTITY_ID DOUBLE N Candidate key reference to the billing_entity table.
CONSOLIDATION_CD DOUBLE Y Determines whether an CONS_BO_SCHED_ID based on this template will be consolidated.
CONS_BO_SCHED_ID DOUBLE N Primary Key
CYCLE_DAY DOUBLE N Day of the month on which statement will be generated.
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.
GUARANTOR_ACCESS_CODE VARCHAR(250) Y Guarantor's access code to be entered when using on line bill payment - quick payment option.
LAST_BILL_DT_TM DATETIME Y Date of the last bill
NEXT_BILL_DT_TM DATETIME Y Date on which the next bill will be send.
ORGANIZATION_ID DOUBLE N Candidate key reference to the organization table.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PROC_IND DOUBLE Y Indicator that is turned on when the nightly batch has processed the cons_bo_sched. Turned off by statement generation process
RC_CONT_PROCESS_ID DOUBLE N Stores continous workflow process id if the statement generated through continous workflow instead of legacy statement cycle.
RESTART_STMT_CYCLE_IND DOUBLE N Indicates whether the restart is monthly or FPP on monthly.
STATEMENT_CYCLE_ID DOUBLE N Foreign key to the statment cycle - this is the current cycle
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 - CONS_BO_SCHED


Child Column in CONS_BO_SCHED(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_GROUP_ID BILLING_ENTITY_GROUP BILLING_ENTITY_GROUP_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
RC_CONT_PROCESS_ID RC_CONT_PROCESS RC_CONT_PROCESS_ID




Parent Column in CONS_BO_SCHED (PK) Child Table Name Child Column Name
Children: CONS_BO_SCHED_ID BENEFIT_ORDER CONS_BO_SCHED_ID
CBOS_PERSON_RELTN CONS_BO_SCHED_ID
CBOS_PE_RELTN CONS_BO_SCHED_ID


CORSP_BR_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CORRESPONDENCE BILL RECORD RELATION
Definition: Relation table with corsp_log and bill_rec
Table Type: ACTIVITY





Column Detail - CORSP_BR_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.
ACTIVITY_ID DOUBLE N Foreign key reference to the corsp_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_REC_ID DOUBLE N Part of foreign key reference to the bill_rec table
BILL_VRSN_NBR DOUBLE N Part of foreign key reference to the bill_rec table
CORSP_BR_RELTN_ID DOUBLE N Primary Key
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.
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 - CORSP_BR_RELTN


Child Column in CORSP_BR_RELTN(FK) Parent Table Name Parent Column Name
Parents: BILL_REC_ID BILL_REC CORSP_ACTIVITY_ID
BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
ACTIVITY_ID CORSP_LOG ACTIVITY_ID


CORSP_KEYWORD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CORRESPONDENCE KEYWORD RELTN
Definition: Corspespondence Keyword Relation
Table Type: ACTIVITY





Column Detail - CORSP_KEYWORD_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.
ACTIVITY_ID DOUBLE N The foreign key to the correspondence that this keyword is related to.
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.
CORSP_KEYWORD_ID DOUBLE N This is the unique identifier
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.
KEYWORD_TXT VARCHAR(50) Y A text field to store additional keywords that may not common enough to include in the code set.
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 - CORSP_KEYWORD_RELTN


Child Column in CORSP_KEYWORD_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID CORSP_LOG ACTIVITY_ID


CORSP_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Correspondence Log
Definition: The corsp_log table stores information about both incoming and outgoing coorespondece. It holds the storage location of the correspondence and identifies any relationships with various other tables in the system.
Table Type: ACTIVITY





Column Detail - CORSP_LOG


Column Name Type Null? Definition
ACCT_IND DOUBLE Y Indicates whether this Correspondence is related to an account - No longer used
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 Unique Identifier and Foreign Key to the Activity Log table
ACTIVITY_IND DOUBLE Y Tells us to look on the Act_Act_Reltn table if 1 - No longer used
ADDRESS_UPDATE_TYPE_CD DOUBLE N Stores the update types for the returned mail.
BAD_ADDRESS_CD DOUBLE N Stores the bad address type for the returned mail.
BATCH_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
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_IND DOUBLE Y Tells us to look on the Corsp_BE_Reltn table if 1 - No longer used
BILL_REC_IND DOUBLE Y Indicates that a comment is related to a bill record - No longer used
CORSP_DESC VARCHAR(250) Y A memo field that summarizes the contents of the correspondence.
CORSP_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
CORSP_STATUS_CD DOUBLE N The status documents where the correspondence is in the process of being delivered to the recipient.
CORSP_SUBJECT VARCHAR(100) Y Free Text Subject field
CORSP_SUBJECT_KEY VARCHAR(250) Y Key Field for the Corsp_subect_key. This field can be indexed.
CORSP_SUB_TYPE_CD DOUBLE N Defines the exact type of correspondence as a sub type of the Corsp_Type_CD
CORSP_TYPE_CD DOUBLE N Identifies the type of correspondence (Incoming, Outgoing, Comment)
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.
DELIVERED_DT_TM DATETIME Y The date this correspondence was submitted to the external system responsible for delivery.
DPV_CD DOUBLE N Stores the delivery point validation status for the mail.
ENCNTR_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
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.
EXTERNAL_IDENT VARCHAR(250) Y The external identifier is used primarily in the case of correspondence, which is transmitted to the Transaction Services hub.
HEALTH_PLAN_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
IMPORTANCE_FLAG DOUBLE Y Indicates the priority of a comment (i.e. Low, Medium, High)
LONG_TEXT_ID DOUBLE N Foreign key to the long_text table.
MOVE_TYPE_CD DOUBLE N Stores the move type for the returned mail.
ORGANIZATION_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
PERSON_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
PRSNL_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
REASON_CD DOUBLE N Identifies the reason why the correspondence was posted.
SESSION_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
STORAGE_LOC VARCHAR(100) Y List the location of the stored correspondence (network path, filling system id's)
STORAGE_TYPE_CD DOUBLE N Describes how the correspondence is stored (network drive, filling cabinet, archived).
SUBMITTED_DT_TM DATETIME Y The date this correspondence was delivered.
TRANS_IND DOUBLE Y Identifies whether a relationships exists. It cuts down the number of joins we have to perform by telling us whether we have a relationship to begin with - No longer used
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.
WORKFLOW_CATEGORY_CD DOUBLE Y Feild that holds the value of workflow model type.



Relationship Detail - CORSP_LOG


Child Column in CORSP_LOG(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in CORSP_LOG (PK) Child Table Name Child Column Name
Children: ACTIVITY_ID CORSP_BR_RELTN ACTIVITY_ID
CORSP_KEYWORD_RELTN ACTIVITY_ID
CORSP_LOG_RELTN ACTIVITY_ID
DEPOSIT_RECORD ACTIVITY_ID