Table Detail Report

MANUAL_RECLASS_GL_LOG



Column Section Top of Page


Table-level Detail

Description: Manual Reclass General Ledger Log
Definition: We need to store a log when client runs the reclass utility tool pft_manual_reclass_gl. The log entries include starting time, ending time, user ID, the number of activity ids, and the input filename.
Table Type: ACTIVITY





Column Detail - MANUAL_RECLASS_GL_LOG


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME N The beginning time of the reclass GL Alias job.
END_DT_TM DATETIME N The ending time of the reclass GL Alias job.
ERROR_MSG_TXT VARCHAR(4000) Y The error message of the finished reclass GL Alias job.
INCOMING_ACTIVITY_IDS_CNT DOUBLE N The total count of activity IDs in the input file.
INPUT_FILE_NAME VARCHAR(300) N The input file name used to reclass GL Alias.
JOB_STATUS_TXT VARCHAR(30) N The status of the finished reclass GL Alias Job.
MANUAL_RECLASS_GL_LOG_ID DOUBLE N Unique generated number that identifies a single row on the MANUAL_RECLASS_GL_LOG table.
RECLASSIFIED_ACTIVITY_IDS_CNT DOUBLE N The count of the reclassified GL Alias of activity Identifiers.
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.


PAYMENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Payment Detail
Definition: This table stores detail about the payment such as check or credit card information, payer name, and currency of payment, etc.
Table Type: ACTIVITY





Column Detail - PAYMENT_DETAIL


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 Unique Identifier and Foreign Key to the Trans Log 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.
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 The Credit Card Authorizatrion Number given during Credit Authorization process.
CC_BEG_EFF_DT_TM DATETIME Y Stores any beginning effective dates for credit cards
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 Stores the credit card expiration date.
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 credit card.
CHANGE_DUE_AMOUNT DOUBLE Y Amount of current currency that is to be returned to payer by payment posting personnel after transaction has posted.
CHECK_DATE DATETIME Y Date written on the check
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
CURRENT_CUR_CD DOUBLE N The currency of the organization accepting the payment.
DEPOSIT_STATUS_CD DOUBLE N Contains the status of that payment in relation to being deposited. Allows you to accept a payment but mark it not to be deposited yet.
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_STATUS_CD DOUBLE N Holds the status of the payment.
ERROR_STATUS_REASON_DESC VARCHAR(250) Y A brief description of the reason for the error.
EXTERNAL_IDENT VARCHAR(250) Y The external identifier is the unique identifier for an EDI transaction for various payment types.
MERCHANT_IDENT VARCHAR(250) Y Tsys Merchant Identifier
ORIG_CUR_CD DOUBLE N The currency the payment was actually in.
PARENT_ENTITY_ID DOUBLE N Id of the entity making the payment.
PARENT_ENTITY_NAME VARCHAR(40) Y Name of the entity making the payment.
PAYMENT_DETAIL_ID DOUBLE N Uniquely identifies a payment detail record.
PAYMENT_METHOD_CD DOUBLE N Identifies the method of payment (personal check, visa, MasterCard, American Express)
PAYMENT_NUM_DESC VARCHAR(250) Y Holds the check or credit card number.
PAYOR_NAME VARCHAR(100) Y Holds the name of the payor, not always the patient.
PAYOR_NAME_KEY VARCHAR(250) Y Key Field for the Payor Name
PENDING_REFUND_AMOUNT DOUBLE N The amount indicating the pending refund amount for the payment detail.
POSTING_METHOD_CD DOUBLE N Posting method for the payment.
POST_DT_TM DATETIME Y The date and time of the posting of the payment to our system.
REFUNDABLE_AMOUNT DOUBLE N Holds the total amount of a payment that is available for refund.
SESSION_ID DOUBLE N Foreign Key to the session that accepted this payment - No longer used
TENDERED_AMOUNT DOUBLE Y Amount of original currency given to payment posting personnel by payer at the time of the transaction.
TOTAL_PAYMENT_AMOUNT DOUBLE N Total Payment Amount
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 - PAYMENT_DETAIL


Child Column in PAYMENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
CC_TRANS_ORG_ID ORGANIZATION ORGANIZATION_ID
CREATED_PRSNL_ID PRSNL PERSON_ID




Parent Column in PAYMENT_DETAIL (PK) Child Table Name Child Column Name
Children: PAYMENT_DETAIL_ID PFT_RECEIPT_ALIAS PAYMENT_DETAIL_ID
TRANS_LOG PAYMENT_DETAIL_ID


PFT_ALIAS



Column Section Top of Page


Table-level Detail

Description: ProFit Alias
Definition: ProFit Alias
Table Type: REFERENCE





Column Detail - PFT_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.
ALIAS VARCHAR(255) N Alias 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.
CODE_VALUE DOUBLE Y The code value associated with this code.
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.
PARENT_ENTITY_ID DOUBLE N Part of compound Primary key
PARENT_ENTITY_NAME VARCHAR(32) N Part of compound Primary key
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_AP_OPTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AP OPTIONS
Definition: Third party options for the accounts payable interface.
Table Type: REFERENCE





Column Detail - PFT_AP_OPTIONS


Column Name Type Null? Definition
AP_TYPE_NAME_CD DOUBLE N Defines the option type.
AP_TYPE_RESULT_NBR DOUBLE Y Numeric result of the option
AP_TYPE_RESULT_STR VARCHAR(100) Y TextuaL result of the option.
BILLING_ENTITY_ID DOUBLE N Foreign Key to the Billing Entity table.
PFT_AP_OPTIONS_ID DOUBLE N Unique identifier.
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_OPTIONS


Child Column in PFT_AP_OPTIONS(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


PFT_AP_REFUND



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT AP REFUND
Definition: Holds Accounts Payable refund information.
Table Type: ACTIVITY





Column Detail - PFT_AP_REFUND


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.
ADDRESS_ID DOUBLE N Address of the entity receiving the refund.
CANCEL_REASON_CD DOUBLE N Identifies the reason the refund was cancelled.
CERTIFICATE_NBR VARCHAR(100) Y Certificate Number
EMPLOYER_ID DOUBLE N Unique identifier of the employer.
EMPLOYER_NAME VARCHAR(255) Y Name of the employer.
EXPEDITED_IND DOUBLE N Refund applied immediately, 0 = False 1 = True
GUAR_ACCT_ID DOUBLE N Unique generated account number for the guarantor(s) associated to the patient which identifies the unique record in the account table.
INS_COMPANY_IDENT VARCHAR(100) Y The insurance company identifier for a specific insurance company associated to the insurance refund
INS_GROUP_NUMBER_TXT VARCHAR(50) Y The group number of the insurance company associated to the insurance refund
PARENT_PFT_AP_REFUND_ID DOUBLE N Uniquely identifies the related row for the amount indicating the pending refund amount for the payment detail.
PATIENT_NAME VARCHAR(255) Y Name of the patient related to the refund.
PFT_AP_REFUND_ID DOUBLE N Unique identifier for the table.
PHONE_ID DOUBLE N Phone ID is the primary unique identification number of the phone table. It is an internal system assigned sequence number.
POSTED_IND DOUBLE Y This indicator shows whether the refund has been posted or not.
RECEIVING_NAME VARCHAR(255) Y Name of the person receiving the refund.
REFERENCE_IDENT VARCHAR(255) Y Unique identifier to link a refund to corresponding information received from payer.
REFUND_AMT DOUBLE Y The amount of the refund.
REFUND_CURR_CD DOUBLE N Currency code of the refund.
REFUND_DT_TM DATETIME Y Date of the refund.
REFUND_METHOD_FLAG DOUBLE N Identifies the method by which the refund will be made. 0 = AP refund; 1 = Credit Card Refund
REFUND_REASON_CD DOUBLE N Identifies the reason that the refund was created.
REFUND_STATUS_CD DOUBLE N Status of the refund.
REFUND_TYPE_FLAG DOUBLE Y The type of the refund.
RESPONSIBLE_PRSNL_ID DOUBLE N The ID of the person who is responsible for this refund. It will normally be the original creator of the refund but could also be someone who modified a previously denied refund.
SPONSOR_ID DOUBLE N Unique identifier of the sponsor.
SPONSOR_NAME VARCHAR(255) Y Name of the sponsor.
TRANS_ALIAS_ID DOUBLE N Transaction alias that is used for posting the refund.
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.
VENDOR_NUMBER VARCHAR(50) Y Client defined reference string for the Vendor sending the refund.



Relationship Detail - PFT_AP_REFUND


Child Column in PFT_AP_REFUND(FK) Parent Table Name Parent Column Name
Parents: GUAR_ACCT_ID ACCOUNT ACCT_ID
ADDRESS_ID ADDRESS ADDRESS_ID
EMPLOYER_ID ORGANIZATION ORGANIZATION_ID
PARENT_PFT_AP_REFUND_ID PFT_AP_REFUND PFT_AP_REFUND_ID
TRANS_ALIAS_ID PFT_TRANS_ALIAS PFT_TRANS_ALIAS_ID
PHONE_ID PHONE PHONE_ID
RESPONSIBLE_PRSNL_ID PRSNL PERSON_ID




Parent Column in PFT_AP_REFUND (PK) Child Table Name Child Column Name
Children: PFT_AP_REFUND_ID PFT_AP_REFUND PARENT_PFT_AP_REFUND_ID
PFT_AP_REFUND_HIST PFT_AP_REFUND_ID
PFT_AP_REFUND_RELTN PFT_AP_REFUND_ID
PFT_AP_REFUND_RETURN_INFO PFT_AP_REFUND_ID