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