Table Detail Report

CREDIT_CARD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Credit Card Relationship
Definition: Relates credit card information to person and/or formal payment plan rows.
Table Type: ACTIVITY





Column Detail - CREDIT_CARD_RELTN


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.
CREDIT_CARD_RELTN_ID DOUBLE N Uniquely identifies a relationship between credit card information, a person, and/or a formal payment plan.
CREDIT_CARD_TYPE_CD DOUBLE N Identifies the type of credit card.
DISPLAY_TXT VARCHAR(250) Y The dispalyable masked credit card number.
EXPIRATION_DT_TM DATETIME Y The date and time the credit card will expire.
MERCHANT_IDENT VARCHAR(250) Y Identifier for the credit card vendor.
PERSON_ID DOUBLE N Uniquely associates the credit card to one or more persons (card on file).
PFT_PAYMENT_PLAN_ID DOUBLE N Associates the credit card to one or more payment plans.
TOKEN_TXT VARCHAR(250) Y A reference value used for charging a credit card.
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 - CREDIT_CARD_RELTN


Child Column in CREDIT_CARD_RELTN(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
PFT_PAYMENT_PLAN_ID PFT_PAYMENT_PLAN PFT_PAYMENT_PLAN_ID


ENCNTR_CLASS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Class Group
Definition: Encounter Class Group
Table Type: REFERENCE





Column Detail - ENCNTR_CLASS_GROUP


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.
BE_DOMAIN_ID DOUBLE N Billing Entity Domain ID
ENCNTR_CLASS_GROUP_ID DOUBLE N Encounter Class Group ID
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter Type Class Code
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.
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 - ENCNTR_CLASS_GROUP


Child Column in ENCNTR_CLASS_GROUP(FK) Parent Table Name Parent Column Name
Parents: BE_DOMAIN_ID BE_DOMAIN BE_DOMAIN_ID


FIELD_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores all field information pertaining to the Bill Template.
Definition: Field_Catalog
Table Type: REFERENCE





Column Detail - FIELD_CATALOG


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.
BILL_TYPE_CD DOUBLE N Codeset holding information about the different bill types
CONTROL_NBR DOUBLE Y Unique number used for internal processing
ELEMENT_NAME VARCHAR(40) Y Name of the corresponding element in the bill structure
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.
FIELD_CATALOG_ID DOUBLE N Unique Id
FIELD_DESC VARCHAR(250) Y Defines what the field is used for
FIELD_LOC_STRING VARCHAR(20) Y Stores the field locator on the form (1500,1450)
FIELD_NAME VARCHAR(250) Y The name of the field
FIELD_NAME_KEY VARCHAR(250) Y The name of the field in Upper Case. This is used to search on.
FIELD_TYPE_FLAG DOUBLE Y Stores the default field type for that field
LIST_INDEX DOUBLE N Index to the corresponding list in the bill structrue
LIST_NAME VARCHAR(40) Y Name of the corresponding list in the bill structure
MAX_FIELD_LENGTH DOUBLE Y The maximumlength the field is able to handle
MIN_FIELD_LENGTH DOUBLE Y The minimumlength the field requires
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 - FIELD_CATALOG




Parent Column in FIELD_CATALOG (PK) Child Table Name Child Column Name
Children: FIELD_CATALOG_ID ATTRIB_FIELD_RELTN FIELD_CATALOG_ID
BR_FIELD_ERRORS FIELD_CATALOG_ID
CLAIM_FLD_POSITION FIELD_CATALOG_ID


INV_CONFIG



Column Section Top of Page


Table-level Detail

Description: INV CONFIG
Definition: Used for Custom Client Invoice
Table Type: REFERENCE





Column Detail - INV_CONFIG


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.
ADDTL_SORT2_CD DOUBLE N The purpose of this field is to store the second additional sort field when defining the format of a client invoice. This field acts similar to the addtl_sort_cd field
ADDTL_SORT_CD DOUBLE N From Inv_Sort code set
ALIAS_OPTION_CD DOUBLE N From Inv_Alias code set
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.
DEFAULT_IND DOUBLE N If a row cannot be found using the primary search criteria, the system will look for the row marked with a default_ind of 1.
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.
GROUP_SORT_CD DOUBLE N From Inv_Sort code set
INV_CONFIG_ID DOUBLE N Unique identifier
PATIENT_MASK_IND DOUBLE N The purpose of this field is to store the value used to determine if the patient identifier is being masked from the client invoice.
PRIMARY_SORT_FLAG DOUBLE N The purpose of this field is to store the value used to determine what action should take place after a primary sort value changes.
ROLL_CHARGES_TO_PARENT_IND DOUBLE Y Defines whether or not client invoices will roll up child charges into their parent charges.
SUMMARY_OPTION_CD DOUBLE N From Inv_Summary 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.


MMR_UMDAP_AMT_REF



Column Section Top of Page


Table-level Detail

Description: MMR UMDAP Amount Ref
Definition: mmr_umdap_amt_ref
Table Type: REFERENCE





Column Detail - MMR_UMDAP_AMT_REF


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.
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.
MAX_MTH_AGI DOUBLE Y Maximum monthly adjusted gross income for the umdap range.
MIN_MTH_AGI DOUBLE Y The minimum monthly adjusted gross income for the umdap amount.
NBR_DEPENDENTS DOUBLE Y The total number of dependents for the guarantor.
UMDAP_AMT DOUBLE Y The umdap amount.
UMDAP_AMT_REF_ID DOUBLE N The unique identifier for the mmr_umdap_amt_ref 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.