Table Detail Report

PFT_AP_REFUND_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AP REFUND HIST
Definition: This table store modifications made to the AP_refund table.
Table Type: ACTIVITY





Column Detail - PFT_AP_REFUND_HIST


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.
CHANGED_FIELD_CD DOUBLE N The code value of the field modified on the given ap_refund record related to the ap_field_cd.
CURRENT_VALUE VARCHAR(255) Y The current value of the modified field.
PFT_AP_REFUND_HIST_ID DOUBLE N Unique identifier for this table.
PFT_AP_REFUND_ID DOUBLE N Foreign key from the pft_ap_refund table.
PREV_VALUE VARCHAR(255) Y The previous value of the modified field.
PRSNL_ID DOUBLE N Foreign Key to the Prsnl 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_AP_REFUND_HIST


Child Column in PFT_AP_REFUND_HIST(FK) Parent Table Name Parent Column Name
Parents: PFT_AP_REFUND_ID PFT_AP_REFUND PFT_AP_REFUND_ID
PRSNL_ID PRSNL PERSON_ID


PFT_AP_REFUND_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AP REFUND RELTN
Definition: Compiles the entities that can relate to a given refund invoice.
Table Type: ACTIVITY





Column Detail - PFT_AP_REFUND_RELTN


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.
PARENT_ENTITY_ID DOUBLE N Used to store the identifier for the parent
PARENT_ENTITY_NAME VARCHAR(30) N The name related to the type of entity related to this entry.
PFT_AP_REFUND_ID DOUBLE N Foreign key from the pft_ap_refund table.
PFT_AP_REFUND_RELTN_ID DOUBLE N Unique identifier.
REFUND_AMT DOUBLE N The amount indicating the pending refund amount for the payment detail.
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_AP_REFUND_RELTN


Child Column in PFT_AP_REFUND_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_AP_REFUND_ID PFT_AP_REFUND PFT_AP_REFUND_ID


PFT_AP_REFUND_RETURN_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AP REFUND RETURN INFO
Definition: This table is populated with the return information for refunds.
Table Type: ACTIVITY





Column Detail - PFT_AP_REFUND_RETURN_INFO


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.
CHECK_AMT DOUBLE Y The amount of the refund check The check could contain more than the related refund.
CHECK_CASHED_DT_TM DATETIME Y The date and time the CHECK CASHED status was received from the AP system.
CHECK_CUT_DT_TM DATETIME Y Date the check was cut for the refund.
CHECK_NBR VARCHAR(100) Y The check number of the refund.
INVOICE_NBR VARCHAR(100) Y The number of the invoice.
MAILED_DT_TM DATETIME Y Date the refund was mailed.
PAYEE_NAME VARCHAR(100) Y Name of the payee.
PFT_AP_REFUND_ID DOUBLE N Foreign key from the pft_ap_refund table.
PFT_AP_REFUND_RETURN_INFO_ID DOUBLE N UNIQUE IDENTIFIER.
RECEIVED_DT_TM DATETIME Y Date the refund was received.
REFUND_TYPE_CD DOUBLE N Refund type code.
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.
VOID_DT_TM DATETIME Y The date and time the VOID status was received from the AP system.



Relationship Detail - PFT_AP_REFUND_RETURN_INFO


Child Column in PFT_AP_REFUND_RETURN_INFO(FK) Parent Table Name Parent Column Name
Parents: PFT_AP_REFUND_ID PFT_AP_REFUND PFT_AP_REFUND_ID


PFT_ARWB_DATA_EXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit AR Workbench Data Extraction
Definition: The table is used to store the clinical encounter ids for profit AR workbench data extraction job.
Table Type: ACTIVITY





Column Detail - PFT_ARWB_DATA_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 Y 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 Y The person who caused the active_status_cd to be set or change.
CREATE_DT_TM DATETIME Y Contains the date and time the row was created.
ELAPSED_TIME_M_SECS DOUBLE Y Elapsed time in milliseconds for a single clinical encounter.
ENCNTR_ID DOUBLE Y This field is going to hold ENCNTR_ID from ENCOUNTER table and will refer all the active financial encounters from the PFT_ENCNTR table so that it can be processed further.
LOGICAL_DOMAIN_ID DOUBLE Y 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_ARWB_DATA_EXT_ID DOUBLE N Unique generated number that identifies a single row on the PFT_ARWB_DATA_EXT table.
STATUS_MESSAGE_TXT VARCHAR(255) Y This field will store the status message for the encounter.
STATUS_MNEMONIC_TXT VARCHAR(15) Y This field tell the status of the data whether it has been processed or not.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_ARWB_DATA_EXT


Child Column in PFT_ARWB_DATA_EXT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


PFT_AR_CONV_CODES



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AR CONV CODES
Definition: This table holds converted Occurence, Span, Value, and Condition Codes
Table Type: ACTIVITY





Column Detail - PFT_AR_CONV_CODES


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.
CODE_TYPE_FLAG DOUBLE N The type of code associated with this record.
CODE_VALUE DOUBLE N The code value associated with this code.
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_DT_TM DATETIME Y The Ending date time of this code.
PFT_AR_CONV_CODES_ID DOUBLE N Unique Identifier for this record.
START_DT_TM DATETIME Y The starting date time for this code.
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.
VALUE DOUBLE Y The user defined value for this code.



Relationship Detail - PFT_AR_CONV_CODES


Child Column in PFT_AR_CONV_CODES(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID