Table Detail Report

BILL_STRUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Structure
Definition: Contains information about the Bill Structure
Table Type: ACTIVITY





Column Detail - BILL_STRUCT


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_STRUCT_ID DOUBLE N Primary Key
BILL_VRSN_NBR DOUBLE N The version number identifying which bill
BR_SEQ DOUBLE Y Bill Record Sequence
BR_SIZE DOUBLE Y Bill Record Size
BR_STRING LONGBLOB Y Bill Record String
CORSP_ACTIVITY_ID DOUBLE N Correspondence Activity ID value
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.
ORIG_SIZE DOUBLE Y Original size of the bill record
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 - BILL_STRUCT


Child Column in BILL_STRUCT(FK) Parent Table Name Parent Column Name
Parents: BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID


BILL_TEMPL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the information related to a bill template.
Definition: Bill Template
Table Type: REFERENCE





Column Detail - BILL_TEMPL


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.
BASE_TEMPL_ID DOUBLE N Bill Template Id of the base template from which a particular bill template was created. This is a circular reference to itself.
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_TEMPL_DESC VARCHAR(250) Y Description of the bill template.
BILL_TEMPL_ID DOUBLE N Primary Key
BILL_TEMPL_NAME VARCHAR(250) Y Name of the bill template
BILL_TEMPL_NAME_KEY VARCHAR(250) Y The name of the bill template. This the bill template name in all capitols without punctuation. This will be used for indexing and searching the bill templates by name.
BILL_TYPE_CD DOUBLE N Code value associated to the type of bill.
DETAIL_LINE_ITEM_NBR DOUBLE Y Number of detail line item fields available on bill template.
DISP_OFFSET_IND DOUBLE Y Indicates if the offset transactions (because of adjustments, payments etc.) should be displayed on the bill.
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.
FORMAT_BILL_TYPE_CD DOUBLE N Stores a code value for the secondary formatting bill type of the template object. The bill_templ has a bill_type and so does the fields. They may be different values. This table will store the default.
MEDIA_SUB_TYPE_CD DOUBLE N Code value associated to the bill submission media subtype.
MEDIA_TYPE_CD DOUBLE N Code value associated to the bill submission media.
OBJECT_NAME VARCHAR(30) Y Name of the template generated object in the object library that corresponds to this bill template
PRINT_OBJECT_NAME VARCHAR(30) Y Name of the template generated print object in the object library that corresponds to this bill template
TOTAL_UNITS_IND DOUBLE N Indicates whether the client has chosen to display total units on the total line of the UB 1450.
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 - BILL_TEMPL


Child Column in BILL_TEMPL(FK) Parent Table Name Parent Column Name
Parents: BASE_TEMPL_ID BILL_TEMPL BILL_TEMPL_ID




Parent Column in BILL_TEMPL (PK) Child Table Name Child Column Name
Children: BILL_TEMPL_ID BILL_REC BILL_TEMPL_ID
BILL_TEMPL BASE_TEMPL_ID
BT_FIELD_RELTN BILL_TEMPL_ID
BT_SELECTION BILL_TEMPL_ID
PFT_CHARGE_BO_RELTN BILL_TEMPL_ID


BR_FIELD_ERRORS



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL RECORD FIELD ERRORS
Definition: This table stores field errors found by the bill record validation process
Table Type: ACTIVITY





Column Detail - BR_FIELD_ERRORS


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 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.
BILL_VRSN_NBR DOUBLE N Along with corsp_activity_id, uniquely identifies a bill record
BR_FIELD_ERRORS_ID DOUBLE N Primary Key
CORSP_ACTIVITY_ID DOUBLE N Along with bill_vrsn_nbr, uniquely identifies a bill record
ELEMENT_NAME VARCHAR(40) Y The element name of the field catalog entry
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.
ERROR_CD DOUBLE N The code value that describes the error for the field
FIELD_CATALOG_ID DOUBLE N The unique identifier of a field catalog entry
LIST_INDEX DOUBLE N The list index of the field catalog entry
LIST_NAME VARCHAR(40) Y The list name of the field catalog entry
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 - BR_FIELD_ERRORS


Child Column in BR_FIELD_ERRORS(FK) Parent Table Name Parent Column Name
Parents: BILL_VRSN_NBR BILL_REC BILL_VRSN_NBR
CORSP_ACTIVITY_ID BILL_REC CORSP_ACTIVITY_ID
FIELD_CATALOG_ID FIELD_CATALOG FIELD_CATALOG_ID


BR_GEN_EVENT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL RECORD GEN EVENT LOG
Definition: Event log for bill record generation
Table Type: ACTIVITY





Column Detail - BR_GEN_EVENT_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.
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.
BENEFIT_ORDER_ID DOUBLE N Benefit order for this bill
BILL_REC_ID DOUBLE N bill record ID for the bill being generated
BR_GEN_EVENT_ID DOUBLE N generated event 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.
LOG_LEVEL_CD DOUBLE N level to log detail
LOG_MESSAGE VARCHAR(250) Y text message on the generation process
PFT_EVENT_OCCUR_LOG_ID DOUBLE N Foreign key to the pft_event_occur_log 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.



Relationship Detail - BR_GEN_EVENT_LOG


Child Column in BR_GEN_EVENT_LOG(FK) Parent Table Name Parent Column Name
Parents: PFT_EVENT_OCCUR_LOG_ID PFT_EVENT_OCCUR_LOG PFT_EVENT_OCCUR_LOG_ID


BR_LONG_BLOB_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL RECORD LONG BLOB RELTN
Definition: Relates the bill_record to the long_blob
Table Type: ACTIVITY





Column Detail - BR_LONG_BLOB_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 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.
BILL_SIZE DOUBLE Y Size of compressed bill record long blob
BILL_VRSN_NBR DOUBLE Y Foreign key to bill record
BR_LONG_BLOB_RELTN_ID DOUBLE N Unique identifier of table
CORSP_ACTIVITY_ID DOUBLE N Foreign key to bill record
DATA_TYPE_FLAG DOUBLE N Identifies the type of data stored in the corresponding long_blob row. 0 - Serialized and Compressed Srv_instance (legacy generation) 1- Claim Data XML 2 - Translated Claim XML 3 - Claim Metadata XML 4 - Claim Data Lite XML 5 - Cached Postscript 6 - Validation XML
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.
LONG_BLOB_ID DOUBLE N Foreign key to Long Blob record
ORIG_SIZE DOUBLE Y Original size of bill record before compression
SEQUENCE DOUBLE Y Sequence number of long blob record
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 - BR_LONG_BLOB_RELTN


Child Column in BR_LONG_BLOB_RELTN(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID