Table Detail Report

PFT_SUB_TYPE_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT SUB TYPE SECURITY
Definition: Security exclusions for Sub Type security in regards to transaction posting
Table Type: REFERENCE





Column Detail - PFT_SUB_TYPE_SECURITY


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.
AMOUNT DOUBLE Y The numeric value that the user is excluded from posting the transaction
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.
PFT_SUB_TYPE_SECURITY_ID DOUBLE N Primary key
PRSNL_ID DOUBLE N Foreign key to the personnel table
SELECTED_TASK_ID DOUBLE N Foreign key to the selected task table
TRANS_SUB_TYPE_CD DOUBLE N Transaction sub type
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 - PFT_SUB_TYPE_SECURITY


Child Column in PFT_SUB_TYPE_SECURITY(FK) Parent Table Name Parent Column Name
Parents: SELECTED_TASK_ID SELECTED_TASK SELECTED_TASK_ID


PFT_TRANS_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Transaction Alias
Definition: Defines aliases that correspond to a transation type, subtype and reason.
Table Type: REFERENCE





Column Detail - PFT_TRANS_ALIAS


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.
DR_CR_FLAG DOUBLE Y Flag identifying whether the balance is debit or credit.
EDI_IND DOUBLE Y Indicates if this trans alias should be used only for edi transactions
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.
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.
PFT_TRANS_ALIAS VARCHAR(20) Y Contains the transaction alias text.
PFT_TRANS_ALIAS_CD DOUBLE N transaction alias code
PFT_TRANS_ALIAS_ID DOUBLE N Uniquely identifies a transaction alias.
TRANS_REASON_CD DOUBLE N Code value identifying the transaction reason.
TRANS_SUB_TYPE_CD DOUBLE N Further identifies the type and purpose of the transaction (for example, Bad Debt Adjustment)
TRANS_TYPE_CD DOUBLE N Transaction type code value
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 - PFT_TRANS_ALIAS


Child Column in PFT_TRANS_ALIAS(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PFT_TRANS_ALIAS (PK) Child Table Name Child Column Name
Children: PFT_TRANS_ALIAS_ID BATCH_TRANS_FILE TRANS_ALIAS_ID
PFT_AP_REFUND TRANS_ALIAS_ID
PFT_CM_EVENT_LOG TRANS_ALIAS_ID
TRANS_LOG TRANS_ALIAS_ID


PFT_TRANS_DIST_CONFIG



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Transaction Distribution Configuration
Definition: Stores distribution methods related to billing entity and account type (Client/Selfpay)
Table Type: REFERENCE





Column Detail - PFT_TRANS_DIST_CONFIG


Column Name Type Null? Definition
ACCOUNT_TYPE_FLAG DOUBLE N Account type to which this transaction distribution applies. (Selfpay/Client)
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.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related row on the BILLING_ENTITY table.
CREATE_DT_TM DATETIME Y Date and Time the row was created.
CREATE_PRSNL_ID DOUBLE Y the person_id of the person from the personnel table (prsnl) that created the row in the table.
DISTRIBUTION_METHOD_CD DOUBLE N Transaction distirbution method from codeset 4064000.
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.
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.
PFT_TRANS_DIST_CONFIG_ID DOUBLE N System generated number to uniquely identify a row on the PFT_TRANS_DIST_CONFIG table.
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 - PFT_TRANS_DIST_CONFIG


Child Column in PFT_TRANS_DIST_CONFIG(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
CREATE_PRSNL_ID PRSNL PERSON_ID


PFT_TRANS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Transaction Relation
Definition: Contains all ProFit transactions, including charges, payments and adjustments.
Table Type: ACTIVITY





Column Detail - PFT_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 FK to the activity_log table
AMOUNT DOUBLE N Amount value
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.
BENEFIT_ORDER_ID DOUBLE N FK to the bo_hp_reltn table. Identifies to which balance this transaction is associated.
BILL_VRSN_NBR DOUBLE Y The version number identifying which bill
CREATED_DT_TM DATETIME N Date and time this record was created.
CREATED_PRSNL_ID DOUBLE N FK to the person table
DR_CR_FLAG DOUBLE N Flag identifying whether the balance is debit or credit.
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.
FINANCE_CHRG_ID DOUBLE N FK to the finance_chrg_cat
GL_TRANS_LOG_ID DOUBLE N FK to the gl_trans_log table
PARENT_ENTITY_ID DOUBLE N FK to account, pft_encntr or bill_rec tables.
PARENT_ENTITY_NAME CHAR(32) N Name of the parent entity
PFT_TRANS_RELTN_ID DOUBLE N Uniquely identifies all ProFit transactions, including charges, payments and adjustments.
POST_CLAIM_DEFAULT_IND DOUBLE N Indicates that the transaction was posted to claim because the charge could not be identified
REASSOC_DT_TM DATETIME Y Date that the transaction was reassociated from one entity to another.
REVENUE_SUMMARY_ID DOUBLE N Identifies the corresponding revenue summary, which this transaction participated.
TRANS_TYPE_CD DOUBLE N Transaction type code value
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 - PFT_TRANS_RELTN


Child Column in PFT_TRANS_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
BATCH_TRANS_FILE_ID BATCH_TRANS_FILE BATCH_TRANS_FILE_ID
FINANCE_CHRG_ID FINANCE_CHRG_CAT FINANCE_CHRG_ID
GL_TRANS_LOG_ID GL_TRANS_LOG GL_TRANS_LOG_ID
REVENUE_SUMMARY_ID PFT_REVENUE_SUMMARY PFT_REVENUE_SUMMARY_ID
CREATED_PRSNL_ID PRSNL PERSON_ID


RAW_BATCH_TRANS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Raw Batch Transactions
Definition: Contains pre-translated x12 835 batch level data.
Table Type: ACTIVITY





Column Detail - RAW_BATCH_TRANS


Column Name Type Null? Definition
BATCH_DT_TM DATETIME N BPR16 - Date the originating company intends for the transaction to be settled.
CONTROL_NUMBER_IDENT VARCHAR(30) N Uniquely identifies the Transaction Set. Combination of ISA13, GS06, and ST02.
INTERFACEID DOUBLE N Used to match the INTERFACEID column on the OEN_PROCINFO table.
PAYER_IDENT_CD_TXT VARCHAR(10) N TRN03 - Federal tax id of the payer.
PAYMENT_AMT DOUBLE N BPR02 - Total Payment Amount for the Batch.
PAYMENT_NUMBER_IDENT VARCHAR(50) N TRN02 - Check or EFT Number.
PAYMENT_TYPE_TXT VARCHAR(3) N BPR04 - Type of Payment, Check or ACH.
RAW_BATCH_TRANS_ID DOUBLE N Uniquely identifies a row of pre-translated X12 835 Batch Level data.
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 - RAW_BATCH_TRANS




Parent Column in RAW_BATCH_TRANS (PK) Child Table Name Child Column Name
Children: RAW_BATCH_TRANS_ID BATCH_TRANS RAW_BATCH_TRANS_ID
RAW_BATCH_TRANS_FILE RAW_BATCH_TRANS_ID