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 |