Table Detail Report

BATCH_TRANS_FILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Batch Transaction File
Definition: Contains information about a Batch Transaction File
Table Type: ACTIVITY





Column Detail - BATCH_TRANS_FILE


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.
AR_ACCOUNT_ID DOUBLE N Uniquely identifies a row on the Account table. Identifies the Patient Account, General AR Account, or client Account the Payment or Adjustment is for.
BATCH_TRANS_FILE_ID DOUBLE N Foreign key reference to the batch_trans_file table.
BATCH_TRANS_ID DOUBLE N Batch Transaction ID value
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 Foreign key to the bo_ho_reltn table
BILL_NBR_DISP VARCHAR(50) Y Textual representation of the selected bill.
BILL_VRSN_NBR DOUBLE Y Version number of the selected bill record. Part of candidate key reference to the bill_rec table.
CC_AID_TXT VARCHAR(255) Y Contains the application identifier for the credit card.
CC_APP_LABEL VARCHAR(255) Y Contains the application label of the credit card.
CC_APP_NAME VARCHAR(255) Y Contains the application name (i.e. Visa, MasterCard, etc.) used to process the EMV transaction.
CC_ARC_TXT VARCHAR(255) Y Contains the application response code of the credit card.
CC_AUTH_NBR VARCHAR(50) Y Authorization Number for the Credit Card
CC_BEG_EFF_DT_TM DATETIME Y The Beginning Effective Date and Time for the credit card.
CC_CARD_ENTRY_MODE_TXT VARCHAR(255) Y Contains the card entry mode (i.e. C = Chip Card)
CC_CVM_TXT VARCHAR(255) Y Contains the Cardholder Verification Method (CVM) (i.e. PIN VERIFIED)
CC_END_EFF_DT_TM DATETIME Y The Ending Effective Date Time for the Credit Card
CC_IAD_TXT VARCHAR(255) Y Contains the Issuer Application Data for the credit card.
CC_LOCATION_CD DOUBLE Y Holds credit card location for charging.
CC_TOKEN_TXT VARCHAR(250) Y Holds token for charging a credit card.
CC_TRANS_ORG_ID DOUBLE N Stores the organization id that was used to get the submitter id which was used to make a credit card payment.
CC_TSI_TXT VARCHAR(255) Y Contains the Transaction Status Indicator for the credit card.
CC_TVR_TXT VARCHAR(255) Y Contains the Terminal Verification Results
CC_TYPE_CD DOUBLE N Identifies the type of the credit card.
CHANGE_DUE_AMT DOUBLE N Amount of local currency that exceeded payment amount and was returned to the payer.
CHECK_DATE DATETIME Y Date written on the check
CHRG_ACTIVITY_ID DOUBLE N Foreign key to the trans_log table
CHRG_AUTO_FIFO_FLAG DOUBLE N Stores the automatic fifo flag for service item at Account, Encounter and Statement level.
CHRG_WRITEOFF_IND DOUBLE N Indicates whether the write-off adjustment was applied on the charge or not
CLAIM_FILE_CD DOUBLE N Claim filing indicator code. Code Set 26380
CLAIM_STATUS_CD DOUBLE N claim status code. Determines how the claim is being paid by the insurance. Codeset 26381.
CORSP_ACTIVITY_ID DOUBLE N Part of candidate key reference to the bill_rec 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.
CROSSOVER_TYPE_FLAG DOUBLE N Flag used to determine add-on-th-fly preferences for crossover scenarios
CURRENT_CUR_CD DOUBLE N Current Currency Code. Identifies the currency for this current transaction.
DISTRIBUTION_IND DOUBLE Y A flag used to determine whether the excess amount has to be distributed at the charge level or not.
DRG_CODE VARCHAR(255) Y Contains the DRG Code retrieved from CLP11 field of the 835.
DRG_NOMENCLATURE_ID DOUBLE Y Uniquely identifies the related DRG on the Nomenclature table.
DR_CR_AR_FLAG DOUBLE Y Debit Credit Accounts Receivable Flag - No longer used
DR_CR_FLAG DOUBLE Y Debit Credit Accounts Receivable Flag
EDI_ADJ_GROUP_CD DOUBLE N Claims adjustment group code
EDI_ADJ_QUANTITY DOUBLE N Adjustment quantity
EDI_ADJ_REASON_CD DOUBLE N Holds X12 Claim Adjustment Reason Code also can hold claim or PLBCodesets 26398 or 26377.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
ERROR_IND DOUBLE Y Indicates if any error occurred.
ERROR_STATUS_CD DOUBLE N Code value indicating the status of the error.
ERROR_STATUS_REASON_DESC VARCHAR(250) Y A brief description of the reason for the error.
ESRD_PAYMENT_AMOUNT DOUBLE N Obsolete. No longer used. End State Renal Disease (ESRD) payment amount
EXTERNAL_IDENT VARCHAR(250) Y The external identifier is the unique identifier for an EDI transaction for various payment types.
FINANCE_CHRG_ID DOUBLE N Obsolete. No longer used. Finance Charge ID
FIN_TRANS_GROUP_ID DOUBLE Y Uniquely identifies the related row on the FIN_TRANS_GROUP table.
FROM_BATCH_TRANS_FILE_ID DOUBLE Y Stores the batch_trans_file_id of the original row that this transaction was created on in order to walk back through the transaction history for combines/uncombines.
GUARANTOR_PERSON_ID DOUBLE N The person_id for the guarantor of the transaction.
GUAR_ACCT_ID DOUBLE Y Unique generated account number for the guarantor(s) associated to the patient which identifies the unique record in the account table.
HEALTH_PLAN_ALIAS VARCHAR(255) N Health plan alias received from 835.
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the health plan as stated on the remittance advice
INPAT_PROF_COMP_AMT DOUBLE N Non-payable professional component amount related to inpatient adjudication
INTERCHANGE_TRANSACTION_IDENT VARCHAR(50) Y Identifier created in the front end using the Julian Date that we send to EDI when performing a synchronous credit card charge.
LONG_TEXT_ID DOUBLE N Foreign key to the long_text table.
MERCHANT_IDENT VARCHAR(250) Y Tsys Merchant Identifier
NONTRANS_FLAG DOUBLE Y Identifies whether a transaction will affect an AR Account. 0 - Will Affect AR1 - Remark40 - Batch header41 - Charge level batch header
NON_INPAT_PROF_COMP_AMT DOUBLE N Non-payable professional component amount related to Medicare adjudication not related to inpatient
ORIG_CUR_CD DOUBLE N The original currency type submitted by a patient prior to it being converted the currency type of the system.
PARENT_ENTITY_ID DOUBLE N Foreign key reference to other tables as defined by the parent_entity name
PARENT_ENTITY_NAME VARCHAR(255) Y Designates the location of parent entity.
PATIENT_RESPONSIBILITY DOUBLE Y This defines the patient responsibility.
PAYMENT_METHOD_CD DOUBLE N The payment method type of the payer. Code Set 20589.
PAYMENT_NUM_DESC VARCHAR(250) Y The Payment Number. In the instance of a check this would be the check number.
PAYOR_CNTRL_NBR_TXT VARCHAR(255) Y Control number to designate the payor.
PAYOR_NAME VARCHAR(255) Y Name of the person that paid.
PAYOR_ORG_ID DOUBLE N Stores BO_HP_RELTN table's PAYOR_ORG_ID for claim level payment\Adjustment, -99.99 for self pay(Patient Account, Encounter and Statement) and 0.0 Unidentified payor
PFT_ENCNTR_ID DOUBLE N Foreign key to the pft_encntr table.
PFT_LINE_ITEM_ID DOUBLE N Identifies the Claim line item related to the batch transaction
PFT_PAYMENT_LOCATION_ID DOUBLE N Uniquely identifies the payment location for this record.
PFT_PAYMENT_PLAN_ID DOUBLE N Payment Plan Identifier. FK value from the PFT_PAYMENT_PLAN table.
POSTING_CATEGORY_TYPE_FLAG DOUBLE N Captures the posting level of each transaction.
POSTING_METHOD_CD DOUBLE N Posting method for the payment.
POST_CLAIM_DEFAULT_IND DOUBLE N Indicates that the transaction was posted to claim because the charge could not be identified.
POST_DT_TM DATETIME Y The user identified post date.
PURGED_IND DOUBLE Y Obsolete. No longer used. Purged Indicator
RAW_BATCH_TRANS_FILE_ID DOUBLE Y Uniquely identifies the raw data row related to this transaction batch file row.
RELATED_SEQ_NBR DOUBLE Y Sequence number to which this payment relates.
ROLL_BO_IND DOUBLE Y This is the manual piece to mark the current benefit order as complete and roll onto the next Benefit Order.
SEQUENCE_NBR DOUBLE Y The sequence number to determine the record order.
SOURCE_FLAG DOUBLE N The source of the transaction. 0 for manually calculated, 1 for automatically calculated.
SURCHRG_PRTCPTN_STATUS_CD DOUBLE N Codeset which contains participation types to which we are associating surcharge percentages.
TENDERED_AMOUNT DOUBLE Y Amount of original currency given to payment posting personnel by payer at the time of the transaction.
TRANS_ALIAS_ID DOUBLE N Foreign key to the pft_trans_alias table.
TRANS_GROUP_NBR DOUBLE N EOB number to which this transaction is related.
TRANS_REASON_CD DOUBLE N Code value identifying the transaction reason.
TRANS_SUBTYPE_CD DOUBLE N Transaction Subtype Code. This further categorizes the transaction type. Ex: Type is Payment, the Sub Type is the Patient Payment. Code Set 20549.
TRANS_TOTAL_AMOUNT DOUBLE Y The total transaction amount of the current payment or adjustment.
TRANS_TYPE_CD DOUBLE N Transaction type code value. Code Set 18649.
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_FILE


Child Column in BATCH_TRANS_FILE(FK) Parent Table Name Parent Column Name
Parents: GUAR_ACCT_ID ACCOUNT ACCT_ID
BATCH_TRANS_ID BATCH_TRANS BATCH_TRANS_ID
FROM_BATCH_TRANS_FILE_ID BATCH_TRANS_FILE BATCH_TRANS_FILE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
FIN_TRANS_GROUP_ID FIN_TRANS_GROUP FIN_TRANS_GROUP_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
DRG_NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
CC_TRANS_ORG_ID ORGANIZATION ORGANIZATION_ID
PAYOR_ORG_ID ORGANIZATION ORGANIZATION_ID
GUARANTOR_PERSON_ID PERSON PERSON_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
PFT_LINE_ITEM_ID PFT_LINE_ITEM PFT_LINE_ITEM_ID
PFT_PAYMENT_LOCATION_ID PFT_PAYMENT_LOCATION PFT_PAYMENT_LOCATION_ID
PFT_PAYMENT_PLAN_ID PFT_PAYMENT_PLAN PFT_PAYMENT_PLAN_ID
TRANS_ALIAS_ID PFT_TRANS_ALIAS PFT_TRANS_ALIAS_ID
CREATED_PRSNL_ID PRSNL PERSON_ID
RAW_BATCH_TRANS_FILE_ID RAW_BATCH_TRANS_FILE RAW_BATCH_TRANS_FILE_ID
CHRG_ACTIVITY_ID TRANS_LOG ACTIVITY_ID




Parent Column in BATCH_TRANS_FILE (PK) Child Table Name Child Column Name
Children: BATCH_TRANS_FILE_ID BATCH_DENIAL_FILE_R BATCH_TRANS_FILE_ID
BATCH_TRANS_FILE FROM_BATCH_TRANS_FILE_ID
DENIAL BATCH_TRANS_FILE_ID
PFT_TRANS_RELTN BATCH_TRANS_FILE_ID


BATCH_TRANS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: BATCH TRANSACTION RELATION
Definition: Holds the relationship between a batch and a transaction
Table Type: ACTIVITY





Column Detail - BATCH_TRANS_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.
ACTIVITY_ID DOUBLE N The Activity_ID from the Trans_Log table.
BATCH_TRANS_ID DOUBLE N Foreign Key to the Batch table.
BATCH_TRANS_RELTN_ID DOUBLE N Batch Transaction Relation
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 Billing entity id
DISABLED_IND DOUBLE Y Disabled Indicator - No longer used
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.
SEQUENCE_NBR DOUBLE Y The sequence number to determine the record order.
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_TRANS_RELTN


Child Column in BATCH_TRANS_RELTN(FK) Parent Table Name Parent Column Name
Parents: BATCH_TRANS_ID BATCH_TRANS BATCH_TRANS_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
ACTIVITY_ID TRANS_LOG ACTIVITY_ID


FIN_TRANS_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Financial Transaction Group
Definition: Schema to store and track the events associated to a financial transaction group.
Table Type: ACTIVITY





Column Detail - FIN_TRANS_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 N 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.
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.
EXTERNAL_IDENT VARCHAR(30) N The unique identifier sent from an external entity for a Remit.
EXTERNAL_NAME VARCHAR(30) N The name that is used to identify from where the EXTERNAL_IDENT was sent. ("CCM: or "HDX")
FIN_TRANS_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the FIN_TRANS_GROUP table.
ORIG_FIN_TRANS_GROUP_ID DOUBLE N Used to track versions of the financial transaction group rows. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PARENT_ENTITY_ID DOUBLE N The entity identifier that the functional transaction group is posted to.
PARENT_ENTITY_NAME VARCHAR(30) N The table name that the PARENT_ENTITY_ID is associated to. ("BILL_REC" or "ENCOUTNER" or "ACCOUNT")
STATUS_CD DOUBLE N Defines the status of a functional transaction group.
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.
VERSION_SEQ DOUBLE N The version sequence for the financial transaction group.



Relationship Detail - FIN_TRANS_GROUP


Child Column in FIN_TRANS_GROUP(FK) Parent Table Name Parent Column Name
Parents: ORIG_FIN_TRANS_GROUP_ID FIN_TRANS_GROUP FIN_TRANS_GROUP_ID




Parent Column in FIN_TRANS_GROUP (PK) Child Table Name Child Column Name
Children: FIN_TRANS_GROUP_ID BATCH_TRANS_FILE FIN_TRANS_GROUP_ID
DENIAL FIN_TRANS_GROUP_ID
FIN_TRANS_GROUP ORIG_FIN_TRANS_GROUP_ID
FIN_TRANS_GROUP_DETAIL FIN_TRANS_GROUP_ID
TRANS_LOG FIN_TRANS_GROUP_ID


FIN_TRANS_GROUP_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Financial Transaction Group Detail
Definition: Defines the event details of each financial transaction service
Table Type: ACTIVITY





Column Detail - FIN_TRANS_GROUP_DETAIL


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 N 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.
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.
FIN_TRANS_GROUP_DETAIL_ID DOUBLE N Unique generataed number that identifies a single row on the PFT_TRANS_GROUP_DETAIL table.
FIN_TRANS_GROUP_ID DOUBLE N Uniquely identifies the related row on the fin_trans_group table.
HTTP_URL VARCHAR(512) Y The URL used to make the HTTP call
SERVICE_CORRELATION_IDENT VARCHAR(50) N The unique identifier that is related to the service. This can be used to retrive the service logs.
SERVICE_HTTP_STATUS_CODE VARCHAR(50) N The HTTP status code that the service returned.
SERVICE_NAME VARCHAR(50) N The name of the service that is being executed ("Payment" or "Adjustment" or "Remark")
SERVICE_STATUS_CD DOUBLE N The status of the service
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.
VERSION_SEQ DOUBLE N The version sequence for the financial transaction group.



Relationship Detail - FIN_TRANS_GROUP_DETAIL


Child Column in FIN_TRANS_GROUP_DETAIL(FK) Parent Table Name Parent Column Name
Parents: FIN_TRANS_GROUP_ID FIN_TRANS_GROUP FIN_TRANS_GROUP_ID




Parent Column in FIN_TRANS_GROUP_DETAIL (PK) Child Table Name Child Column Name
Children: FIN_TRANS_GROUP_DETAIL_ID FIN_TRANS_LONG_TEXT FIN_TRANS_GROUP_DETAIL_ID


FIN_TRANS_LONG_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Financial Transaction Long Text
Definition: Schema to store financial transaction service request and reply.
Table Type: ACTIVITY





Column Detail - FIN_TRANS_LONG_TEXT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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 N 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.
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.
FIN_TRANS_GROUP_DETAIL_ID DOUBLE N Unique generataed number that identifies a single row on the PFT_TRANS_GROUP_DETAIL table.
FIN_TRANS_LONG_TEXT_ID DOUBLE N Unique generated number that identifies a single row on the FIN_TRANS_LONG_TEXT table.
LONG_TEXT LONGTEXT Y Stores the service payload.
PAYLOAD_TYPE_NAME VARCHAR(30) N The service payload type. ("REQUEST" or "REPLY")
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 - FIN_TRANS_LONG_TEXT


Child Column in FIN_TRANS_LONG_TEXT(FK) Parent Table Name Parent Column Name
Parents: FIN_TRANS_GROUP_DETAIL_ID FIN_TRANS_GROUP_DETAIL FIN_TRANS_GROUP_DETAIL_ID