Table Detail Report

CODE_VAL_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Code Value Group Reltn
Definition: This table holds the relationship between the bt_cond_crit_r table and the code_value table.
Table Type: REFERENCE





Column Detail - CODE_VAL_GRP_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.
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.
BT_COND_CRIT_R_ID DOUBLE N Uniquely identifies the related row on the bt_cond_crit_r table.
CODE_VALUE DOUBLE Y This is the code value for certain code sets that allow for multiple selects.
CODE_VAL_GRP_R_ID DOUBLE N Code Value Group Relation ID
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 - CODE_VAL_GRP_RELTN


Child Column in CODE_VAL_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID


COLLECTION_LETTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the text that will be printed on the collection letter.
Definition: Store the text to be printed on the collection letter.
Table Type: REFERENCE





Column Detail - COLLECTION_LETTER


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_ID DOUBLE N FK to the billing_entity table
COLLECTION_GEN_DT_TM DATETIME Y The date collection letter generation script was run.
COLLECTION_LETTER_ID DOUBLE N Primary Key
DUNNING_LEVEL_CD DOUBLE N Code value indicating the collection state.
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.
LETTER_LINE1 VARCHAR(80) Y First line of text.
LETTER_LINE10 VARCHAR(80) Y Tenth line of text.
LETTER_LINE11 VARCHAR(80) Y Eleventh line of text
LETTER_LINE12 VARCHAR(80) Y Twelveth line of text
LETTER_LINE13 VARCHAR(80) Y Thirteenth line of text.
LETTER_LINE14 VARCHAR(80) Y Fourteenth line of text.
LETTER_LINE15 VARCHAR(80) Y Fifteenth line of text.
LETTER_LINE2 VARCHAR(80) Y Second line of text.
LETTER_LINE3 VARCHAR(80) Y Third line of text
LETTER_LINE4 VARCHAR(80) Y Fourth line of text.
LETTER_LINE5 VARCHAR(80) Y Fifth line of text.
LETTER_LINE6 VARCHAR(80) Y Sixth line of text.
LETTER_LINE7 VARCHAR(80) Y Seventh line of text.
LETTER_LINE8 VARCHAR(80) Y Eighth line of text.
LETTER_LINE9 VARCHAR(80) Y Nineth line of text.
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 - COLLECTION_LETTER


Child Column in COLLECTION_LETTER(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


CONTACT_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Store dynamic contact text for a billing entity.
Definition: The text stored in this table will be printed on statements printed for the related billing entity.
Table Type: REFERENCE





Column Detail - CONTACT_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.
BILLING_ENTITY_ID DOUBLE N The identifier of the related billing entity. This is a primary key of the billing_entity table.
CONTACT_TEXT VARCHAR(250) N Text that will be printed on the billing entity system.
CONTACT_TEXT_ID DOUBLE N This is the value of the unique primary identifier of the contact text table. It is an internal system assigned number.
CONTACT_TYPE_CD DOUBLE N A group of people classified together on the basis of common history, nationality, or geographical distribution.
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 - CONTACT_TEXT


Child Column in CONTACT_TEXT(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


COOP_HP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Cooperative Health Plan Relationship
Definition: This table is used to define a product/plan that, when billed, will handle the secondary billing for another product/plan.
Table Type: REFERENCE





Column Detail - COOP_HP_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.
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.
COOP_HP_RELTN_ID DOUBLE N Cooperative Health Plan Relation 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.
HEALTH_PLAN_ID DOUBLE N The HEALTH_PLAN_ID identifies a health plan that will perform the secondary billing for the provider (billing organization).
SEC_HEALTH_PLAN_ID DOUBLE N The SEC_HEALTH_PLAN_ID identifies the product/plan that can be billed for by the product/plan identified in the HEALTH_PLAN_ID column.
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 - COOP_HP_RELTN


Child Column in COOP_HP_RELTN(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
SEC_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


CORSP_LOG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: CORRESPONDENCE LOG RELTN
Definition: This table is used to store all the correspondence relationships.
Table Type: ACTIVITY





Column Detail - CORSP_LOG_RELTN


Column Name Type Null? Definition
ACCT_ID DOUBLE N Foreign key to the account table.
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 Part of Primary key. Foreign key 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_VRSN_NBR DOUBLE Y Version number of the bill record
CORSP_LOG_RELTN_ID DOUBLE N Primary Key on Corsp_Log_Reltn table
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 Text related to the keyword.
LONG_TEXT_ID DOUBLE N Foreign key to the long_text table.
PARENT_ENTITY_ID DOUBLE N Part of Primary key.
PARENT_ENTITY_NAME VARCHAR(32) N Part of Primary key
PFT_ENCNTR_ID DOUBLE N Foreign key to the pft_encntr table.
RECIPIENT_TYPE_CD DOUBLE N For correspondence, represents the type of recipient (e.g. Patient, Guarantor, Subscriber, etc.)
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_LOG_RELTN


Child Column in CORSP_LOG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
ACTIVITY_ID CORSP_LOG ACTIVITY_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID