Table Detail Report

PFT_GENERIC_LOG



Column Section Top of Page


Table-level Detail

Description: PFT GENERIC LOG
Definition: This is a generic log table that will be used by multiple process w/in ProFit.
Table Type: ACTIVITY





Column Detail - PFT_GENERIC_LOG


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.
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.
LOG_LEVEL_CD DOUBLE N Identifies the log level of the record
LOG_MESSAGE VARCHAR(100) Y This is a string field that will allow a user to enter a message that corresponds to the record.
LOG_VALUE VARCHAR(100) Y This is a string value that allows extra necessary information to be logged independently of the log_message. This could hold billing entity information, for example.
PARENT_ENTITY_ID DOUBLE N This field holds the value corresponding to the entry defined in the parent_entity_name column.
PARENT_ENTITY_NAME VARCHAR(32) N This field defines the parent entity for the record.
PFT_GENERIC_LOG_ID DOUBLE N This is the unique identifier to the record on the table.
PROCESS_TYPE_CD DOUBLE N The field defines the process type for the record.
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_GPCI_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Geographic Practice Cost Index Content
Definition: Stores information from the CMS Geographic Practice Cost Index Fileliability insurance (PLI). Three distinct GPCIs are used to calculate the payment schedule amount for a service in a Medicare locality.
Table Type: REFERENCE





Column Detail - PFT_GPCI_CONTENT


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.
LOCALITY_CODE_TXT VARCHAR(2) Y Locality code assigned by CMS
LOCALITY_NAME_TXT VARCHAR(50) Y Name of locality assigned by CMS
MALPRACTICE_GPCI_NBR DOUBLE Y Malpractice related geographic practice cost index component
ORGANIZATION_ID DOUBLE N Identifies the insurance organization that corresponds to the given carrier number organization alias
PFT_GPCI_CONTENT_ID DOUBLE N Unique identifier for GPCI Content record
PRACTICE_GPCI_NBR DOUBLE Y Practice related geographic practice cost index component
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.
WORK_GPCI_NBR DOUBLE Y Work related geographic practice cost index component



Relationship Detail - PFT_GPCI_CONTENT


Child Column in PFT_GPCI_CONTENT(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PFT_HOLD



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Hold
Definition: ProFit Hold
Table Type: REFERENCE





Column Detail - PFT_HOLD


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.
BILLING_ENTITY_ID DOUBLE N Billing Entity for which the hold is defined
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.
HOLD_CD DOUBLE N Code value indicating the type of hold.
HOLD_CRITERIA_IND DOUBLE Y Hold Criteria Indicator
HOLD_FLAG DOUBLE Y Hold Flag (The value and description of that value vary depending on the hold_reason_cd value).
HOLD_NAME VARCHAR(40) Y A user-defined name given to the hold rule.
HOLD_REASON_CD DOUBLE N Code value indicating the reason for hold.
PARENT_ENTITY_ID DOUBLE N Parent Entity ID
PARENT_ENTITY_NAME VARCHAR(32) Y Parent Entity Name
PFT_HOLD_ID DOUBLE N Primary key
PROCESS_PRIORITY_NBR DOUBLE Y A value that indicates the order in which the statement cycles should be processed. The highest priority item gets a process_priority_nbr of 1.
STND_DELAY DOUBLE Y Standard Delay
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_HOLD


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




Parent Column in PFT_HOLD (PK) Child Table Name Child Column Name
Children: PFT_HOLD_ID PE_STATUS_REASON PFT_HOLD_ID
PFT_HOLD_CRITERIA PFT_HOLD_ID


PFT_HOLD_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Hold Criteria
Definition: This table is used to store the hold criteria related information for a hold
Table Type: REFERENCE





Column Detail - PFT_HOLD_CRITERIA


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.
CHILD_CRITERIA_IND DOUBLE Y Indicates whether a particular hold criteria has any children
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.
HOLD_CRITERIA VARCHAR(100) N Hold Criteria
HOLD_CRITERIA_CD DOUBLE N Hold Criteria Code
PFT_HOLD_CRITERIA_ID DOUBLE N Primary Key
PFT_HOLD_ID DOUBLE N FK to the pft_hold table
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_HOLD_CRITERIA


Child Column in PFT_HOLD_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: PFT_HOLD_ID PFT_HOLD PFT_HOLD_ID




Parent Column in PFT_HOLD_CRITERIA (PK) Child Table Name Child Column Name
Children: PFT_HOLD_CRITERIA_ID PFT_CHILD_CRITERIA PFT_HOLD_CRITERIA_ID


PFT_PAYMENT_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Paymnet Location
Definition: This table will store client defined location where payments are collected.
Table Type: REFERENCE





Column Detail - PFT_PAYMENT_LOCATION


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.
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.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
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 organization related to this payment location.
PAYMENT_LOCATION_DESCRIPTION VARCHAR(255) Y ** Obsolete ** Contains a textual description of the payment location. ** This column is no longer being used **
PAYMENT_LOCATION_NAME VARCHAR(255) N ** Obsolete ** Free text value for the name of the location or drawer. ** This column is no longer being used **
PAYMENT_LOCATION_NAME_KEY VARCHAR(255) N ** Obsolete ** Contains the payment location name in upper case with all spaces and symbols removed. ** This column is no longer being used **
PFT_PAYMENT_LOCATION_DEF_ID DOUBLE N Unique generated number that identifies a single row on the PFT_PAYMENT_LOCATION_DEF table.
PFT_PAYMENT_LOCATION_ID DOUBLE N Uniquely identifies a payment location.
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_PAYMENT_LOCATION


Child Column in PFT_PAYMENT_LOCATION(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PFT_PAYMENT_LOCATION_DEF_ID PFT_PAYMENT_LOCATION_DEF PFT_PAYMENT_LOCATION_DEF_ID




Parent Column in PFT_PAYMENT_LOCATION (PK) Child Table Name Child Column Name
Children: PFT_PAYMENT_LOCATION_ID BATCH_TRANS_FILE PFT_PAYMENT_LOCATION_ID
GL_TRANS_QUALIFIER PFT_PAYMENT_LOCATION_ID
INTERFACE_TRANSACTION PFT_PAYMENT_LOCATION_ID
TRANS_LOG PFT_PAYMENT_LOCATION_ID