ACTIVITY_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Activity Log |
Definition: | This table stores a high level view of all activity as it enters the system. An activity can be either a transaction (payment, write off, adjustment, charge) or correspondence, (bill, claim, letter,fax, email, phone call) |
Table Type: | ACTIVITY |
Column Detail - ACTIVITY_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTION_CODE | VARCHAR(40) | Y | User-defined code used to identify an event. |
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. |
ACTIVITY_DT_TM | DATETIME | Y | The date and time that the activity took place. |
ACTIVITY_ID | DOUBLE | N | The primary key and will be used through out the system to track the activity. |
ACTIVITY_TYPE_CD | DOUBLE | N | Identifies if the activity was a transaction or correspondence. |
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. |
CREATED_DT_TM | DATETIME | Y | Date and time the record was created. |
CREATED_PRSNL_ID | DOUBLE | N | Unique identifier of the person that created record. |
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. |
EVENT_CD | DOUBLE | N | System event code value. |
PRODUCTIVITY_FLAG | DOUBLE | Y | Flag used to define if the row is used in productivity reporting. |
PRODUCTIVITY_WEIGHT | DOUBLE | Y | Assign weight of event used to measure productivity. |
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 - ACTIVITY_LOG
Child Column in ACTIVITY_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CREATED_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in ACTIVITY_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ACTIVITY_ID | BATCH_TRANS_EXT | ACTIVITY_ID |
CORSP_LOG | ACTIVITY_ID | ||
GL_TRANS_LOG_OFFSET | ACTIVITY_ID | ||
PAYMENT_DETAIL | ACTIVITY_ID | ||
PFT_BILL_ACTIVITY | ACTIVITY_ID | ||
PFT_CHARGE | ACTIVITY_ID | ||
PFT_PRORATION_RELTN | ACTIVITY_ID | ||
PFT_TRANS_RELTN | ACTIVITY_ID | ||
TRANS_LOG | ACTIVITY_ID |
BATCH_DENIAL_FILE_DETAIL_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BATCH DENIAL FILE DETAIL RELATION |
Definition: | Detail for the batch denial file table |
Table Type: | ACTIVITY |
Column Detail - BATCH_DENIAL_FILE_DETAIL_R
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. |
BATCH_DENIAL_FILE_DETAIL_R_ID | DOUBLE | N | Primary Key |
BATCH_DENIAL_FILE_R_ID | DOUBLE | N | Foreign Key to Batch_Denial_File_R table |
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. |
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. |
REMARK_CODE_ATTRIB_CD | DOUBLE | N | Remark Code Attribute |
REMARK_CODE_ATTRIB_VALUE | VARCHAR(50) | Y | value for the attribute identified by the remark_code_attrib_cd |
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 - BATCH_DENIAL_FILE_DETAIL_R
Child Column in BATCH_DENIAL_FILE_DETAIL_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BATCH_DENIAL_FILE_R_ID | BATCH_DENIAL_FILE_R | BATCH_DENIAL_FILE_R_ID |
BATCH_DENIAL_FILE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BATCH DENIAL FILE RELATION |
Definition: | Relates the batchs and denila codes. |
Table Type: | ACTIVITY |
Column Detail - BATCH_DENIAL_FILE_R
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. |
BATCH_DENIAL_FILE_R_ID | DOUBLE | N | Primary key |
BATCH_TRANS_FILE_ID | DOUBLE | N | Foreign key reference to the batch_trans_file table. |
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. |
DENIAL_CD | DOUBLE | N | A claim remark providing additional information on why a claim was adjudicated. Additional information about a payment/adjustment on a claim. Valid codesets for this column are 26398, 26399, and 24730. |
DENIAL_CODE_TXT | VARCHAR(255) | Y | This field holds the text that relates to the denial code value |
DENIAL_TEXT | VARCHAR(255) | N | The payers alias representing the claim remark. |
DENIAL_TYPE_CD | DOUBLE | N | This defines the base type of the denial code i.e. provider, patient, technical, information only. |
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. |
TRANS_RELTN_REASON_CD | DOUBLE | N | Stores TRANS_TRANS_RELTN tables TRANS_RELN_REASON_CD value in case of Transfer Transaction associated with remarks. |
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 - BATCH_DENIAL_FILE_R
Child Column in BATCH_DENIAL_FILE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BATCH_TRANS_FILE_ID | BATCH_TRANS_FILE | BATCH_TRANS_FILE_ID |
Parent Column in BATCH_DENIAL_FILE_R (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BATCH_DENIAL_FILE_R_ID | BATCH_DENIAL_FILE_DETAIL_R | BATCH_DENIAL_FILE_R_ID |
BATCH_TRANS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Batch Transaction |
Definition: | Contains information about a Batch Transaction |
Table Type: | ACTIVITY |
Column Detail - BATCH_TRANS
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. |
ADJ_COMPUTED_TOTAL | DOUBLE | Y | Adjustment Computed Total. The total monetary amount of adjustments that have been added to the batch. |
ADJ_RESTATED_TOTAL | DOUBLE | Y | Populated in the event the user re-states the adjustment control total after stating it during batch creation. |
ADJ_STATED_TOTAL | DOUBLE | Y | The initial adjustment control total as stated by the user. |
BATCHJOB_IND | DOUBLE | Y | Obsolete. This column is no longer used. Batch Job Indicator |
BATCH_ALIAS | VARCHAR(25) | Y | An optional User-defined batch alias for each transaction entry batch |
BATCH_ALIAS_KEY | VARCHAR(25) | Y | Corresponding KEY field in UPPERCASE and with special characters and blanks removed. |
BATCH_ALIAS_KEY_A_NLS | VARCHAR(100) | Y | BATCH_ALIAS_KEY_A_NLS column |
BATCH_ALIAS_KEY_NLS | VARCHAR(52) | Y | Corresponding Global support field for the associated column KEY column. |
BATCH_CONTROL_NBR | VARCHAR(20) | Y | This will assist batch control handling when receiving transactions from an external file |
BATCH_STATUS_CD | DOUBLE | N | The current status of the watch, i.e., working posted, etc. Code Set 23372. |
BATCH_TRANS_ID | DOUBLE | N | Uniquely identifies a batch transaction. |
BATCH_TYPE_FLAG | DOUBLE | Y | Indicates which tool created the batch. |
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. |
CREATED_DT_TM | DATETIME | Y | Date and time the record was created. |
CREATED_PRSNL_ID | DOUBLE | N | Unique identifier of person that created the record. |
DENIAL_AMT | DOUBLE | N | ** obsolete ** The amount of the denial. |
DENIAL_CD | DOUBLE | N | ** obsolete ** The Code representing the denial reason. |
DEPOSIT_DT_TM | DATETIME | Y | This indicates on which date the amount got deposited to the bank, for the user to see at the time of batch reconciliation |
DEPOSIT_RECORD_ID | DOUBLE | N | Uniquely identifies the deposit record related to this batch transaction. |
DR_CR_ADJ_COMPUTED_FLAG | DOUBLE | Y | Debit Credit Flag for the Adjustment Computed.0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
DR_CR_ADJ_RESTATED_FLAG | DOUBLE | Y | Debit Credit Flag for the Adjustment Restated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
DR_CR_ADJ_STATED_FLAG | DOUBLE | Y | Debit Credit Flag for the Adjustment Stated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
DR_CR_FC_COMPUTED_FLAG | DOUBLE | Y | Obsolete. No longer used. Debit Credit Flag for the Finance Charge Computed 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
DR_CR_FC_RESTATED_FLAG | DOUBLE | Y | Obsolete. No longer used. Debit Credit Flag for Finance Charge Restated |
DR_CR_FC_STATED_FLAG | DOUBLE | Y | Obsolete. No longer used. Debit Credit Flag for the Finance Charge Stated |
DR_CR_PAY_COMPUTED_FLAG | DOUBLE | Y | Debit Credit Flag for Payment Computed 0 - No Balance; 1- Debit Balance; 2 - Credit Balance |
DR_CR_PAY_RESTATED_FLAG | DOUBLE | Y | Debit Credit Flag for the Payment Restated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
DR_CR_PAY_STATED_FLAG | DOUBLE | Y | Debit Credit Flag for the Payment Stated 0 - No Balance; 1 - Debit Balance; 2 - Credit Balance |
ELECTRONIC_FILE_NAME | VARCHAR(500) | Y | Stores the 835 file name in the system. |
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. |
EXT_BATCH_ID_TXT | VARCHAR(100) | Y | External Batch ID Text. User created Batch Identifier. |
EXT_BATCH_ID_TXT_KEY | VARCHAR(100) | Y | External Batch ID Text_key. This field is used for indexing and searching by External Batch ID Text. |
EXT_BATCH_ID_TXT_KEY_A_NLS | VARCHAR(400) | Y | EXT_BATCH_ID_TXT_KEY_A_NLS column |
EXT_BATCH_ID_TXT_KEY_NLS | VARCHAR(100) | Y | EXT_BATCH_ID_TXT Key field converted to NLS format for internationalization requirements. |
FC_COMPUTED_TOTAL | DOUBLE | Y | Obsolete. No longer used. Finance Charge Computed Total |
FC_RESTATED_TOTAL | DOUBLE | Y | Obsolete. No longer used. Finance Charge Restated Total |
FC_STATED_TOTAL | DOUBLE | Y | Obsolete. Column no longer used. Finance Charge Stated Total |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
ONEPAYMENT_IND | DOUBLE | N | One Payment Indicator. If the indicator is 1, then the batch has one form of payment for all payments within the batch. |
PAYEE_NPI_ORG_ALIAS | VARCHAR(100) | N | National provider identifier alias for the payee organization. |
PAYEE_ORG_ID | DOUBLE | N | National provider identifier for the payee organization. |
PAYER_BATCH_IDENT | VARCHAR(25) | N | ** obsolete ** External reference number specified by payer for batch of the claim forms |
PAYMENT_METHOD_CD | DOUBLE | N | The mode of payment sent by the payer. |
PAYMENT_NUM_DESC | VARCHAR(500) | N | The check number associated with the remittance check. |
PAYOR_ORG_ID | DOUBLE | N | Uniquely identifies the payor of the remittance batch. |
PAY_COMPUTED_TOTAL | DOUBLE | Y | Payment Computed Total. The total monetary amount of payments that have been added to the batch. |
PAY_RESTATED_TOTAL | DOUBLE | Y | Payment Restated Total. Populated in the event the user re-states the payment control total after stating it during batch creation. |
PAY_STATED_TOTAL | DOUBLE | Y | Payment Stated Total. The initial payment control total as stated by the user. |
PFT_EVENT_OCCUR_LOG_ID | DOUBLE | N | Obsolete. No longer used. ProFit Event Occurrence Log |
POSTED_BY_USER_ID | DOUBLE | N | The column will help to identify who posted the batch. |
POST_DT_TM | DATETIME | Y | Post date for this batch. |
PURGED_IND | DOUBLE | Y | Obsolete. No longer used. Purged Indicator |
RAW_BATCH_TRANS_ID | DOUBLE | Y | Uniquely identifies the Raw Batch Transaction record related to this row. |
SESSION_ID | DOUBLE | N | Session ID - No longer used |
SUBMITTED_DT_TM | DATETIME | Y | If submitted, the date and time of submittal |
SUBMITTED_IND | DOUBLE | Y | Indicates whether or not submitted |
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 - BATCH_TRANS
Child Column in BATCH_TRANS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
PAYEE_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
PAYOR_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
CREATED_PRSNL_ID | PRSNL | PERSON_ID | |
POSTED_BY_USER_ID | PRSNL | PERSON_ID | |
RAW_BATCH_TRANS_ID | RAW_BATCH_TRANS | RAW_BATCH_TRANS_ID |
Parent Column in BATCH_TRANS (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BATCH_TRANS_ID | BATCH_TRANS_EXT | BATCH_TRANS_ID |
BATCH_TRANS_FILE | BATCH_TRANS_ID | ||
BATCH_TRANS_RELTN | BATCH_TRANS_ID | ||
CLAIM_TRANS_INFO | BATCH_TRANS_ID | ||
DEP_REC_BATCH_TRANS_RELTN | BATCH_TRANS_ID | ||
PFT_QUEUE_ITEM | BATCH_TRANS_ID | ||
PFT_QUEUE_ITEM_HIST | BATCH_TRANS_ID |
BATCH_TRANS_EXT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BATCH TRANSACTION EXT |
Definition: | Holds all of the transaction data whether it gets posted or not. |
Table Type: | ACTIVITY |
Column Detail - BATCH_TRANS_EXT
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. |
ACTIVITY_ID | DOUBLE | N | Foreign key to activity log- only populated if posted |
BATCH_TRANS_EXT_ID | DOUBLE | N | Primary key |
BATCH_TRANS_ID | DOUBLE | N | Foreign key to the batch_trans table |
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. |
EDI_ADJ_AMOUNT | DOUBLE | N | From CAS loop |
EDI_ADJ_DR_CR_FLAG | DOUBLE | N | Debit/Credit flag for the EDI adj amount |
EDI_ADJ_QUANTITY | DOUBLE | N | From CAS loop |
EDI_ADJ_REASON_CD | DOUBLE | N | Adjustment reason |
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. |
ESRD_PAYMENT_AMOUNT | DOUBLE | N | End State Renal Disease (ESRD) payment amount |
INPAT_PROF_COMP_AMT | DOUBLE | N | Non-payable professional component amount related to inpatient adjudication |
NON_INPAT_PROF_COMP_AMT | DOUBLE | N | Non-payable professional component amount related to Medicare adjudication not related to inpatient |
PARENT_ENTITY_ID | DOUBLE | N | Foreign key to the table for which this entry points (Bill, Charge, Transaction) |
PARENT_ENTITY_NAME | VARCHAR(20) | Y | CHARGE |
POSTED_IND | DOUBLE | N | Indicates whether the transaction was posted or not |
SEQUENCE_NBR | DOUBLE | N | Relates to the sequence number on the Batch_Trans_File table through the Batch_Trans_id. |
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 - BATCH_TRANS_EXT
Child Column in BATCH_TRANS_EXT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACTIVITY_ID | ACTIVITY_LOG | ACTIVITY_ID |
BATCH_TRANS_ID | BATCH_TRANS | BATCH_TRANS_ID |