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 |