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 |