Table Detail Report
PFT_SEL_TASK_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Profit Selected Task Relation |
Definition: | Identifies the related entity type and id to a specific selected task that was created in the navagation tool. |
Table Type: | REFERENCE |
Column Detail - PFT_SEL_TASK_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. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | Related Entity ID (from prsnl or billing_entity table) |
PARENT_ENTITY_NAME | VARCHAR(32) | N | Related Entity (prsnl, be, prsnlgroup) |
PFT_SEL_TASK_R_ID | DOUBLE | N | Unique identifier of the table |
SELECTED_TASK_ID | DOUBLE | N | Foreign key to the selected_task table |
TASK_OWNER_AUTH_FLAG | DOUBLE | Y | Defines if the current personnel can change the owner of this task- this is only used when working with Push |
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_SEL_TASK_R
Child Column in PFT_SEL_TASK_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SELECTED_TASK_ID | SELECTED_TASK | SELECTED_TASK_ID |
PFT_SURCHARGE_ENABLED
Column Section | Top of Page |
Table-level Detail
Description: | ProFit Surcharge Enabled |
Definition: | Contains information about entities related to a surcharge |
Table Type: | REFERENCE |
Column Detail - PFT_SURCHARGE_ENABLED
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. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | Contains the reference to the ID of the parent entity name |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Name of the parent entity. |
PFT_SURCHARGE_ENABLED_ID | DOUBLE | N | Unique generated number that identifies a single row on the pfr_surcharge_enabled. |
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. |
PFT_SYSTEM_ACTIVITY_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Accounting System Activity Log |
Definition: | Stores general logging information for patient accounting processes. |
Table Type: | ACTIVITY |
Column Detail - PFT_SYSTEM_ACTIVITY_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
COMPLETION_MSG | VARCHAR(250) | N | The message returned from the reply block of the task. |
CURRENT_NODE_NAME | VARCHAR(100) | N | The name of the node of the executed task. |
CURRENT_PROCESS_NAME | VARCHAR(100) | N | Contains the name of the process which is executing the task. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related Encounter record. |
END_DT_TM | DATETIME | Y | The end time of the executed task. |
ENTITY_ID | DOUBLE | N | Uniquely identifies a row on the related entity name. |
ENTITY_NAME | VARCHAR(30) | N | Identifies the related entity. |
EXECUTION_DURATION_SECS | DOUBLE | N | The time it took for the script to execute. |
FINAL_STATUS_CD | DOUBLE | N | The final status code that is givien back from the reply block of the task. |
LOC_FACILITY_CD | DOUBLE | N | Code value of the facility location. |
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. |
ORGANIZATION_ID | DOUBLE | N | Uniquely identifies the related organization. |
PERSON_ID | DOUBLE | N | Uniquely identifies the related Person record. |
PFT_EVENT_OCCUR_LOG_ID | DOUBLE | N | Uniquely identifies the related pft_event_occur_log record. |
PFT_SYSTEM_ACTIVITY_LOG_ID | DOUBLE | N | Unique generated number that identifies a single row on the PFT_SYSTEM_ACTIVITY_LOG table. |
SERVER_NAME | VARCHAR(100) | N | Name of the server of the executed task. |
START_DT_TM | DATETIME | Y | The start time of the executed task. |
TASK_NAME | VARCHAR(30) | N | The task that workflow task process performed. |
TIMER_IDENT | VARCHAR(100) | N | Used to persist the timer information. |
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_SYSTEM_ACTIVITY_LOG
Child Column in PFT_SYSTEM_ACTIVITY_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID | |
PFT_EVENT_OCCUR_LOG_ID | PFT_EVENT_OCCUR_LOG | PFT_EVENT_OCCUR_LOG_ID |
PFT_TOOLS
Column Section | Top of Page |
Table-level Detail
Description: | PFT TOOLS |
Definition: | Stores the information related to the ProFit tools. |
Table Type: | REFERENCE |
Column Detail - PFT_TOOLS
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. |
DISPLAY_NAME | VARCHAR(250) | Y | The tool name to be displayed. |
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. |
ENTRY_POINT | VARCHAR(250) | Y | Entry Point |
ICON_KEY | VARCHAR(250) | Y | Icon key |
PFT_TOOLS_ID | DOUBLE | N | Primary key |
TOOL_TIP_TEXT | VARCHAR(250) | Y | Tool tip text |
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. |
PFT_TRANSACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT TRANSACTION |
Definition: | Profit transaction table for OMF reporting |
Table Type: | ACTIVITY |
Column Detail - PFT_TRANSACTION
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 | References entry to activity table |
BATCH_DESC | VARCHAR(100) | Y | If it was in a batch, a description of what batch |
BATCH_TRANS_ID | DOUBLE | N | If it was in a batch, the id of 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. |
BENEFIT_ORDER_ID | DOUBLE | N | References an entry on the benefit order table |
BILLED_IND | DOUBLE | Y | Indicates whether or not it has been put on a bill |
BILLING_ENTITY_ID | DOUBLE | N | References an entry on the billing entity table |
BILLING_ENTITY_NAME | VARCHAR(100) | Y | The name of the billing entity |
BILLING_ENTITY_ORG_ID | DOUBLE | N | References an entry on the billing entity organization table |
BILLING_ENTITY_ORG_NAME | VARCHAR(100) | Y | The billing entity organization name |
BILL_ALIAS | VARCHAR(100) | Y | The bill alias |
BILL_VRSN_NBR | DOUBLE | Y | The version number identifying which bill |
CC_AUTH_NBR | VARCHAR(100) | Y | Credit card authorization number |
CC_BEG_EFF_DT_TM | DATETIME | Y | Credit card beginning effective date |
CC_END_EFF_DT_TM | DATETIME | Y | Credit card ending effective date |
CHARGE_ITEM_ID | DOUBLE | N | References an entry on the charge table |
CHECK_DATE | DATETIME | Y | The date of the check if paid by check |
CORSP_ACTIVITY_ID | DOUBLE | N | References the id of the bill |
CR_ACCT_ID | DOUBLE | N | References credit account id |
CURRENT_CUR_CD | DOUBLE | N | Current currency type |
DR_ACCT_ID | DOUBLE | N | References the debit account ID |
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_CR_ACCT_ID_TXT | VARCHAR(40) | Y | Alias for the credit account id |
EXT_DR_ACCT_ID_TXT | VARCHAR(40) | Y | Alias for the debit account id |
GEN_LEDG_POSTED_IND | DOUBLE | Y | Indicates whether or not it has been posted to the general ledger |
ORIGINAL_CUR_CD | DOUBLE | N | Original currency type |
PAYMENT_METH_CD | DOUBLE | N | payment method |
PAYMENT_NUM_DESC | VARCHAR(255) | Y | Payment number description (ex. the check number if paid by chec, the credit card number if paid by a credit card) |
PAYOR_NAME | VARCHAR(100) | Y | The name of the payor |
PAYOR_ORG_ID | DOUBLE | N | The payor ID if it is an organization |
PAYOR_ORG_NAME | VARCHAR(100) | Y | The payor name if it is an organization |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PERSON_NAME_FULL | VARCHAR(100) | Y | Person name if paid by a person |
PFT_CHARGE_ID | DOUBLE | N | References the pft_charge table |
PFT_ENCNTR_ALIAS | VARCHAR(100) | Y | Financial encounter alias |
PFT_ENCNTR_ID | DOUBLE | N | References an entry on the pft encntr table |
PFT_TRANSACTION_ID | DOUBLE | N | Unique identifier for this table |
POSTED_DT_TM | DATETIME | Y | Date and time posted to the system |
POSTING_METH_CD | DOUBLE | N | Posted method (ex: LIFO, FIFO, or Distributed) |
SUPPRESSION_FLAG | DOUBLE | Y | Indicates whether to suppress for printing and or viewing on claim, statement, power account or all |
TOTAL_TRANS_AMOUNT | DOUBLE | N | Total amount of transaction |
TPM_ID | DOUBLE | N | References an entry for a transaction posting matrix rule for this transaction |
TRANS_ALIAS_ID | DOUBLE | N | Alias for combination of trans_type_cd, trans_sub_type_cd and trans_reason_cd |
TRANS_REASON_CD | DOUBLE | N | Code value identifying the transaction reason. |
TRANS_SUB_TYPE_CD | DOUBLE | N | Transaction sub type code value |
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. |
USERNAME | VARCHAR(50) | Y | The username of the person who posted the transaction. |
Relationship Detail - PFT_TRANSACTION
Child Column in PFT_TRANSACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |