Table Detail Report

BT_CRITERIA_LIMIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Criteria Limit
Definition: Bill Template Criteria Limit
Table Type: REFERENCE





Column Detail - BT_CRITERIA_LIMIT


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 Bill Template Condition Criteria Relation ID
BT_CRITERIA_LIMIT_ID DOUBLE N Bill Template Criteria Limit 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.
LIMIT_TYPE_CD DOUBLE N Limit Type Code
LIMIT_VAL_TYPE_CD DOUBLE N Limit Value Type Code
LWR_LIMIT_VAL DOUBLE Y Lower Limit Value
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.
UPR_LIMIT_VAL DOUBLE Y Upper Limit Value



Relationship Detail - BT_CRITERIA_LIMIT


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


BT_FIELD_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Field Relation
Definition: Bill Template Field Relation
Table Type: REFERENCE





Column Detail - BT_FIELD_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.
ATTRIB_FIELD_RELTN_ID DOUBLE N Attribute Field Relation ID
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_ID DOUBLE N This column relates this record to a specific Bill Template.
BT_FIELD_RELTN_ID DOUBLE N Bill Template Field Relation ID
BT_FIELD_VRSN_NBR DOUBLE N Bill Template Field Version Number
CUSTOM_IND DOUBLE Y Custom Indicator
DATA_TYPE_CD DOUBLE N Data Type Code 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.
FLD_JUSTIFICATION_CD DOUBLE N Field Justification Code
MAX_FIELD_LENGTH DOUBLE Y Maximum Field Length
MIN_FIELD_LENGTH DOUBLE Y Minimum Field Length
PATTERN_CHK_IND DOUBLE Y Pattern Check Indicator
REQUIRED_IND DOUBLE Y Required Indicator
UDV_ID DOUBLE N User-Defined Value ID - Not Used
UDV_TEXT VARCHAR(250) Y User Defined Value 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.
USER_DEFINED_IND DOUBLE Y User-Defined Indicator - Not Used



Relationship Detail - BT_FIELD_RELTN


Child Column in BT_FIELD_RELTN(FK) Parent Table Name Parent Column Name
Parents: ATTRIB_FIELD_RELTN_ID ATTRIB_FIELD_RELTN ATTRIB_FIELD_RELTN_ID
BILL_TEMPL_ID BILL_TEMPL BILL_TEMPL_ID
UDV_ID USER_DEFINED_VALUE UDV_ID


BT_HP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL TEMPLATE HEALTH PLAN RELTN
Definition: This table stores bill template/health plan relationship information
Table Type: REFERENCE





Column Detail - BT_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 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_TEMPL_ID DOUBLE N Unique identifier of a bill template from bill_templ table
BILL_TYPE_CD DOUBLE N The bill type of the bill template
BT_HP_RELTN_ID DOUBLE N Primary key
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.
HEALTH_PLAN_ID DOUBLE N Unique identifier of a health plan for the health_plan table
MAN_REVIEW_IND DOUBLE N Indicates whether or not the group of charges identified by this condition should be manually reviewed before being sent out on a bill
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 - BT_HP_RELTN


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


BT_PRSNL_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Personnel Group Relation
Definition: Bill Template Personnel Group Relation
Table Type: REFERENCE





Column Detail - BT_PRSNL_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 Bill Template Condition Criteria Relation ID
BT_PRSNL_GRP_RELTN_ID DOUBLE N Bill Template Personnel Group Relation ID
CODE_VALUE DOUBLE Y This is the code value for certain code sets that allow for multiple selects.
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.
PRSNL_ID DOUBLE N Personnel ID
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 - BT_PRSNL_GRP_RELTN


Child Column in BT_PRSNL_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID
PRSNL_ID PRSNL PERSON_ID


BT_SELECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: BILL TEMPLATE SELECTION
Definition: This table stores bill template selection information
Table Type: REFERENCE





Column Detail - BT_SELECTION


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_TEMPL_ID DOUBLE N Foreign key to bill_templ table
BT_SELECTION_ID DOUBLE N Unique identifier of this table
CONDITION_NAME VARCHAR(30) Y Name of bill template selection condition
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.
PARENT_BT_SELECTION_ID DOUBLE N Provides parent/child relationships for records
PRIORITY_SEQ DOUBLE N Priority sequence of selection 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 - BT_SELECTION


Child Column in BT_SELECTION(FK) Parent Table Name Parent Column Name
Parents: BILL_TEMPL_ID BILL_TEMPL BILL_TEMPL_ID
PARENT_BT_SELECTION_ID BT_SELECTION BT_SELECTION_ID




Parent Column in BT_SELECTION (PK) Child Table Name Child Column Name
Children: BT_SELECTION_ID BT_SELECTION PARENT_BT_SELECTION_ID
BT_SELECTION_CRIT BT_SELECTION_ID