ATTRIB_CATALOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores information related to the attributes that will be used to create bills |
Definition: | Attrbute Catalog |
Table Type: | REFERENCE |
Column Detail - ATTRIB_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. |
ATTRIB_CATALOG_ID | DOUBLE | N | Primary Key |
ATTRIB_DESC | VARCHAR(250) | Y | Description of the attribute. |
ATTRIB_NAME | VARCHAR(250) | Y | Name of the attribute |
ATTRIB_NAME_KEY | VARCHAR(250) | Y | Name of the attribute. This attribute name is all in capitols without punctuation. This will be used in indexing and searching of attributes by name. |
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. |
COLUMN_NAME | DOUBLE | Y | Identifies a column name on the Millennium table from where to get the data for an attribute. |
CONTROL_GRP_CD | DOUBLE | N | Code value related to the information group (e.g. Patient Info, Encounter Info, Provider Info etc.) to which an attribute belongs. Defines a group of attributes by some common factor. |
CONTROL_NBR | DOUBLE | Y | Unique defined number for internal data processing in ProFit. |
CONTROL_SUB_GRP_CD | DOUBLE | N | Further defines the Attrib Control Group codeset. |
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. |
GET_SCRIPT_NAME | VARCHAR(30) | Y | Name of the get script that retrieves this attribute |
TABLE_NAME | DOUBLE | Y | Identifies name of the Millennium table from where to get the data for the attribute. |
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. |
USER_DEFINED_IND | DOUBLE | Y | User Defined Indicator |
VALUE_INDEX | DOUBLE | N | Index to the value_reply structure in the corresponding get script |
Relationship Detail - ATTRIB_CATALOG
Parent Column in ATTRIB_CATALOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ATTRIB_CATALOG_ID | ATTRIB_FIELD_RELTN | ATTRIB_CATALOG_ID |
ATTRIB_PRIMER_VAL | ATTRIB_CATALOG_ID |
ATTRIB_FIELD_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the relationship between the attributes and the fields they go to on bill |
Definition: | Attribute Field Relation |
Table Type: | REFERENCE |
Column Detail - ATTRIB_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_CATALOG_ID | DOUBLE | N | Foreign key reference to the attrib_catalog table. |
ATTRIB_FIELD_RELTN_ID | DOUBLE | N | Primary Key |
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. |
FIELD_CATALOG_ID | DOUBLE | N | Foreign key reference to the field catalog 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 - ATTRIB_FIELD_RELTN
Child Column in ATTRIB_FIELD_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ATTRIB_CATALOG_ID | ATTRIB_CATALOG | ATTRIB_CATALOG_ID |
FIELD_CATALOG_ID | FIELD_CATALOG | FIELD_CATALOG_ID |
Parent Column in ATTRIB_FIELD_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ATTRIB_FIELD_RELTN_ID | BT_FIELD_RELTN | ATTRIB_FIELD_RELTN_ID |
ATTRIB_PRIMER_VAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Attribute Primer Value |
Definition: | Contains Attribute Primer Value Information. |
Table Type: | REFERENCE |
Column Detail - ATTRIB_PRIMER_VAL
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_CATALOG_ID | DOUBLE | N | Foreign key to the attrib_catalog table. |
ATTRIB_PRIMER_VAL_ID | DOUBLE | N | Primary Key |
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. |
CODE_SET | DOUBLE | Y | Code set to which an attribute related to. |
CODE_VALUE | DOUBLE | Y | Code value associated to the attribute. |
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. |
PRIORITY_SEQ | DOUBLE | Y | Sequence of related rows |
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 - ATTRIB_PRIMER_VAL
Child Column in ATTRIB_PRIMER_VAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ATTRIB_CATALOG_ID | ATTRIB_CATALOG | ATTRIB_CATALOG_ID |
BILL_REC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores the information related to a bill record. |
Definition: | Bill Record |
Table Type: | ACTIVITY |
Column Detail - BILL_REC
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. |
AUTO_SUBMIT_CD | DOUBLE | N | Code value related to the unit of the specified period after which bill will be submitted automatically. e.g. 25 days, "days" will be the auto_submit_cd. |
AUTO_SUBMIT_IND | DOUBLE | Y | Indicate whether the bill should be submitted automatically. |
AUTO_SUBMIT_VALUE | DOUBLE | Y | Numeric value after which a bill will be submitted automatically. For e.g. 25 days, 25 will be the auto submit value. |
BALANCE | DOUBLE | Y | Balance on a bill record |
BALANCE_DR_CR_FLAG | DOUBLE | N | Debit/Credit flag for the balance field |
BALANCE_DUE | DOUBLE | N | Balance that is due for the bill |
BALANCE_DUE_DR_CR_FLAG | DOUBLE | N | Debit/Credit flag for the balance due field |
BALANCE_FWD | DOUBLE | N | Balance carried forward from a previous bill |
BALANCE_FWD_DR_CR_FLAG | DOUBLE | N | Debit/Credit flag for the balance foorward field |
BATCH_EVENT_ID | DOUBLE | N | This field references the SI_BATCH_EVENT table if there is an instance of claim resubmission |
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 | Foreign key reference to the billing_entity table - No longer used |
BILL_CLASS_CD | DOUBLE | N | Identifies the class (e.g. Claim, Letter etc.) to which a bill record belongs. |
BILL_NBR_DISP | VARCHAR(40) | Y | Display value associated to a bill (claim) number. |
BILL_NBR_DISP_KEY | VARCHAR(250) | Y | Display value associated to a bill number. This is dispaly in all capitols with punctuation removed. This field is used for indexing and searching a schedule by dispaly. |
BILL_STATUS_CD | DOUBLE | N | Code value associated to the status of the bill. e.g. pending, ready to bill etc. |
BILL_STATUS_REASON_CD | DOUBLE | N | Code value associated to the reason for a particular state of bill. |
BILL_SUBMIT_SCHED_ID | DOUBLE | N | Obsolete. No longer used. Foreign key reference to the bill_submit_sched table. |
BILL_TEMPL_ID | DOUBLE | N | Foreign key reference to the bill_templ table. |
BILL_TYPE_CD | DOUBLE | N | Bill type code value |
BILL_VRSN_NBR | DOUBLE | N | Version number of a bill record. |
BT_COND_RESULT_ID | DOUBLE | N | Foreign key reference to the bt_cond_result table. |
CLAIM_FILE_CD | DOUBLE | N | Represents how the claim was filed and processed |
CLAIM_SERIAL_NBR | DOUBLE | N | This field holds the value of the claim serial number for a given bill record. |
CLAIM_STATUS_CD | DOUBLE | N | Status of the claim (i.e. denied, suspended, processed, etc.) |
CLAIM_STATUS_CONTROL_DT_TM | DATETIME | Y | When the last claim status was posted or queried |
CM_STATUS_CD | DOUBLE | N | status (i.e. not submitted, pending estimated adjustment, estimated received and posted, estimated received and not posted, actual received with variance, actual received and without variance) |
CORSP_ACTIVITY_ID | DOUBLE | N | Corsp activity ID is the unique id for the table that could comprise of statement, invoice and claim. |
DEMAND_IND | DOUBLE | N | This is an indicator that determines if the bill record was generated on demand |
DUNNING_LEVEL_CD | DOUBLE | N | Code value indicating collections state that a ProFit encounter is in |
DUNNING_LEVEL_CNT | DOUBLE | N | Indicates how many times a bill has been sent at the current dunning level |
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. |
E_SORT_FIELD_1 | VARCHAR(250) | N | Primary sort field for electronic media type. |
E_SORT_FIELD_1_CD | DOUBLE | N | Code value that represents the primary sort field for electronic media type. |
E_SORT_FIELD_2 | VARCHAR(250) | N | Secondary sort field for electronic media type. |
E_SORT_FIELD_2_CD | DOUBLE | N | Code value that represents the secondary sort field for electronic media type. |
E_SORT_FIELD_3 | VARCHAR(250) | N | Tertiary sort field for electronic media type. |
E_SORT_FIELD_3_CD | DOUBLE | N | Code value that represents the tertiary sort field for electronic media type. |
FROM_SERVICE_DT_TM | DATETIME | Y | Starting coverage date/time. |
GEN_DT_TM | DATETIME | Y | The and time the bill record was generated. |
GEN_REASON_CD | DOUBLE | N | Code value associated to the reason for bill generation. e.g. manual or automated - No longer used |
GOVERNMENT_IDENT | VARCHAR(40) | Y | Government Identifier (NFe number or Nota Fiscal in Brazil) that would be placed on claim/statement. |
IMAGE_FLAG | DOUBLE | N | This field is used to determine if an image is stored in the system for the bill record or if processing needs to be done to it. 0=No image 1=Ready to process 2=Processing 3=Image exists |
INTERIM_BILL_FLAG | DOUBLE | N | Represents the type of Interim bill, i.e., Initial, Continuing, Adjusted, Final |
LAST_ADJUSTMENT_DT_TM | DATETIME | Y | The date and time that an adjustment was made on this bill_rec. |
LAST_PAYMENT_DT_TM | DATETIME | Y | The date and time that a payment was made on this bill_rec. |
MAN_REVIEW_IND | DOUBLE | Y | Indicates whether the bill record has been manually edited. |
MEDIA_SUB_TYPE_CD | DOUBLE | N | Code value associated to the sub type of the bill submission media. e.g. continuous feed, 837 (ANS X.12) etc. |
MEDIA_TYPE_CD | DOUBLE | N | The code value associated to the bill submission media. |
NEW_AMOUNT | DOUBLE | N | Amount of new activity for the bill |
NEW_AMOUNT_DR_CR_FLAG | DOUBLE | N | Debit/Credit flag for the new amount field |
PAGE_CNT | DOUBLE | Y | The number of pages for a bill. |
PARENT_BILL_REC_ID | DOUBLE | N | Id of the parent of this bill record. |
PARENT_BILL_VRSN_NBR | DOUBLE | Y | Version number of the parent bill record of the this one. |
PAYOR_CTRL_NBR_TXT | VARCHAR(40) | Y | Payor Control number text |
PAY_ADJ_TO_CM_DT_TM | DATETIME | Y | Pay adjustment date time. Not Used. |
RA_CLAIM_FIELD_CD | DOUBLE | N | Remittance advice claim field code value |
RA_CLAIM_STATUS_CD | DOUBLE | N | Remittance advice claim status code value |
RESPONSIBILITY_CD | DOUBLE | N | Responsible party for Claim |
ROUTE_USER_NAME | VARCHAR(40) | Y | Username of the personnel setting up the submission route |
SORT_FIELD_1 | VARCHAR(250) | Y | Primary sorting field for batch processing. |
SORT_FIELD_1_CD | DOUBLE | N | Code value for primary sort field. |
SORT_FIELD_2 | VARCHAR(250) | Y | Secondary sorting field for batch processing. |
SORT_FIELD_2_CD | DOUBLE | N | Code value for secondary sort field. |
SORT_FIELD_3 | VARCHAR(250) | Y | Tertiary sorting field for the batch processing. |
SORT_FIELD_3_CD | DOUBLE | N | Code value for tertiary sort field. |
STATEMENT_FROM_DT_TM | DATETIME | Y | Exact statement from date for the claim. |
STATEMENT_TO_DT_TM | DATETIME | Y | Exact Statement to Date and Time |
SUBMISSION_ROUTE_CD | DOUBLE | N | The submission routing for this claim |
SUBMIT_DT_TM | DATETIME | Y | The date and time for which the bill record is submitted to a payer. |
SUBSCRIBER_FIRST_NAME | VARCHAR(200) | Y | Subscriber First Name of the insurance policy that exists in the media xml |
SUBSCRIBER_LAST_NAME | VARCHAR(200) | Y | Subscriber Last Name of the insurance policy that exists in the media xml |
SUBSCRIBER_MIDDLE_NAME | VARCHAR(200) | Y | Subscriber Middle Name of the insurance policy that exists in the media xml |
SUBSCRIBER_NBR_IDENT | VARCHAR(100) | Y | Subscriber Member Number, assigned outside of Millennium. |
SUBSCRIBER_SUFFIX_NAME | VARCHAR(200) | Y | Subscriber Suffix Name of the insurance policy that exists in the media xml |
THIRD_PARTY_IDENT | VARCHAR(40) | Y | Third party identifier (RPS number in Brazil) that would be placed on claim/statement. |
TO_SERVICE_DT_TM | DATETIME | Y | Ending coverage date/time. |
TRANSMISSION_DT_TM | DATETIME | Y | A date/time field used to identify the date/time a bill rec was transmitted to an outside payer. |
TYPE_OF_BILL_TXT | VARCHAR(4) | Y | Determines type of bill of a claim. This four-digit alphanumeric code gives three specific pieces of information after a leading zero. The second digit identifies the type of facility. The third classifies the type of care. The fourth indicates the sequence of this bill in this particular episode of care. It is referred to as a ¿frequency¿ code. |
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. |
VARIANCE_AMT | DOUBLE | Y | Differences between estimated and actual reimbursement |
ZIP_CODE_KEY | VARCHAR(40) | Y | Zip code key. Used for searching purposes |
Relationship Detail - BILL_REC
Child Column in BILL_REC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
PARENT_BILL_REC_ID | BILL_REC | CORSP_ACTIVITY_ID | |
PARENT_BILL_VRSN_NBR | BILL_REC | BILL_VRSN_NBR | |
BILL_TEMPL_ID | BILL_TEMPL | BILL_TEMPL_ID | |
BATCH_EVENT_ID | SI_BATCH_EVENT | BATCH_EVENT_ID |
Parent Column in BILL_REC (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CORSP_ACTIVITY_ID | BILL_REC | PARENT_BILL_REC_ID |
BILL_VRSN_NBR | BILL_REC | PARENT_BILL_VRSN_NBR | |
BILL_RELTN | BILL_VRSN_NBR | ||
CORSP_ACTIVITY_ID | BILL_RELTN | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | BILL_STRUCT | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | BILL_STRUCT | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | BR_FIELD_ERRORS | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | BR_FIELD_ERRORS | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | CLAIM_TRANS_INFO | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | CLAIM_TRANS_INFO | CORSP_ACTIVITY_ID | |
CORSP_BR_RELTN | BILL_REC_ID | ||
BILL_VRSN_NBR | CORSP_BR_RELTN | BILL_VRSN_NBR | |
DENIAL | BILL_VRSN_NBR | ||
CORSP_ACTIVITY_ID | DENIAL | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | EXT_REQ_STATUS | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | EXT_REQ_STATUS | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_BALANCE | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_BALANCE | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_BILL | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_BILL | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_BILL_ACTIVITY | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_BILL_ACTIVITY | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_BR_CLAIM_DETAIL | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_BR_CLAIM_DETAIL | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_BR_CLAIM_STATUS_DETAIL | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_BR_CLAIM_STATUS_DETAIL | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_DAILY_BILL_BAL | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_DAILY_BILL_BAL | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_LINE_ITEM | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_LINE_ITEM | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_LINE_ITEM_ACTIVITY | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_LINE_ITEM_ACTIVITY | CORSP_ACTIVITY_ID | |
BILL_VRSN_NBR | PFT_QUEUE_ITEM_HIST | BILL_VRSN_NBR | |
CORSP_ACTIVITY_ID | PFT_QUEUE_ITEM_HIST | CORSP_ACTIVITY_ID |
BILL_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Bill Relation |
Definition: | Contains information about entities related to a given bill. |
Table Type: | ACTIVITY |
Column Detail - BILL_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. |
BILL_RELTN_ID | DOUBLE | N | Primary Key |
BILL_VRSN_NBR | DOUBLE | N | The version number identifying which bill |
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. |
PARENT_ENTITY_ID | DOUBLE | N | FK reference to the bo_bill_reltn, bill_person_reltn, or bill_org_reltn tables |
PARENT_ENTITY_NAME | CHAR(32) | N | Name of the parent entity |
RELTN_TYPE_CD | DOUBLE | N | Relation Type Code |
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_RELTN
Child Column in BILL_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILL_VRSN_NBR | BILL_REC | BILL_VRSN_NBR |
CORSP_ACTIVITY_ID | BILL_REC | CORSP_ACTIVITY_ID |