Table Detail Report

PFT_PRORATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the Prorated amounts for each Benefit_Order, if Proration is to be calced
Definition: This table stores the Prorated amounts for each Benefit_Order, if Proration is to be calculated.
Table Type: ACTIVITY





Column Detail - PFT_PRORATION


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 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.
BO_HP_RELTN_ID DOUBLE N Unique Identifier
CURR_AMOUNT_DR_CR_FLAG DOUBLE N Flag showing DR_CR Status of Curr_Amount_Due
CURR_AMT_DUE DOUBLE N The Current Amount Due for this realationship
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.
HEALTH_PLAN_ID DOUBLE N Unique identifier of a health plan for the health_plan table
HIGH_AMOUNT_DR_CR_FLAG DOUBLE N Flag showing DR_CR Status of High_Amount_Due
HIGH_AMT DOUBLE N The Highest Amount calculated for this relationship
NON_COVERED_AMT DOUBLE N The Amount that is not covered by the deductible - primarily for Pat Res
NON_COVERED_AMT_DR_CR_FLAG DOUBLE N Flag showing DR_CR Status of Non_Covered_Amount
ORIG_AMOUNT_DR_CR_FLAG DOUBLE N Flag showing DR_CR Status of Orig_Amount_Due
ORIG_AMT_DUE DOUBLE N Original Amount calculated for this relationship
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
PFT_ENCNTR_ID DOUBLE N The PFT_Encntr related to this data - Foreign Key-PFT_ENCNTR
PFT_PRORATION_ID DOUBLE N Primary Key : Built from pft_activity_seq
PRIORITY_SEQ DOUBLE Y If the Proration_Type_CD = PAYEROTHER then this field will store the level of the payer - 2, 3, so forth
PRORATION_TYPE_CD DOUBLE N The type of relationship to this record
TOTAL_ADJ DOUBLE N Total Adjustments made on this relationship
TOTAL_ADJ_DR_CR_FLAG DOUBLE N Flag showing DR_CR Status of Total_Adjustment
TOTAL_PAY_AMT DOUBLE N Total payments made on this relationship.
TOTAL_PAY_AMT_DR_CR_FLAG DOUBLE N Flag showing debit/credit status of total pay.
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_PRORATION


Child Column in PFT_PRORATION(FK) Parent Table Name Parent Column Name
Parents: BO_HP_RELTN_ID BO_HP_RELTN BO_HP_RELTN_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PERSON_ID PERSON PERSON_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID




Parent Column in PFT_PRORATION (PK) Child Table Name Child Column Name
Children: PFT_PRORATION_ID PFT_DAILY_BO_HP_BAL PFT_PRORATION_ID
PFT_PRORATION_RELTN PFT_PRORATION_ID


PFT_PRORATION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores information on all modifications made to the Proration tables
Definition: This table stores information on all modifications made to the Proration tables.
Table Type: ACTIVITY





Column Detail - PFT_PRORATION_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.
ACTIVITY_ID DOUBLE N Related activity that caused the difference.
AMOUNT_CHANGED_CD DOUBLE N This is the type of value modified. (Current, Original, Deductible, Original Deductible) - See New Code Set - Amount_Changed_CD
AMOUNT_DIFFERENCE DOUBLE N Difference between New and Old Amount from the perspective of the Old Amount
AMOUNT_DIFFERENCE_DR_CR_FLAG DOUBLE N Debit/Credit flag associated with the Amount_Difference.
MODIFICATION_FLAG DOUBLE Y This flag states whether the modification was manual (1) or automatic (0)
MODIFICATION_REASON_CD DOUBLE N Reason for the modification - See New Code Set - Modification_Reason_CD
NEW_AMOUNT DOUBLE N New Amount after modification
NEW_AMOUNT_DR_CR_FLAG DOUBLE N Debit/Credit flag associated with the New Amount.
OLD_AMOUNT DOUBLE N Old Amount before modification
OLD_AMOUNT_DR_CR_FLAG DOUBLE N Debit/Credit flag associated with the Old Amount.
PFT_PRORATE_DEDUCT_ID DOUBLE N Pft Proration Deduct Identifier
PFT_PRORATION_ID DOUBLE N PFT Proration Identifier
PFT_PRORATION_RELTN_ID DOUBLE N Primary Key: Built from pft_charge_seq
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_PRORATION_RELTN


Child Column in PFT_PRORATION_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
PFT_PRORATION_ID PFT_PRORATION PFT_PRORATION_ID


PFT_PRSNL_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table defines personnel groups within the context of the ProFit application
Definition: ProFit Personnel Group
Table Type: REFERENCE





Column Detail - PFT_PRSNL_GROUP


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.
GROUP_NAME VARCHAR(250) Y This field defines the name of the personnel group
PFT_PRSNL_GROUP_ID DOUBLE N Unique row identifier on the PFT_PRSNL_GROUP 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_PRSNL_GROUP




Parent Column in PFT_PRSNL_GROUP (PK) Child Table Name Child Column Name
Children: PFT_PRSNL_GROUP_ID ACCT_PRSNL_GROUP_R PFT_PRSNL_GROUP_ID
BE_PRSNL_GROUP_R PFT_PRSNL_GROUP_ID
PFT_PRSNL_GROUP_R PFT_PRSNL_GROUP_ID


PFT_PRSNL_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Personnel Group Relation
Definition: ProFit Personnel Group Relation
Table Type: REFERENCE





Column Detail - PFT_PRSNL_GROUP_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 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.
PFT_PRSNL_GROUP_ID DOUBLE N ProFit Personnel Group ID
PFT_PRSNL_GROUP_R_ID DOUBLE N ProFit Personnel Group Relation ID
PRSNL_ID DOUBLE N Personnel ID
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_PRSNL_GROUP_R


Child Column in PFT_PRSNL_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: PFT_PRSNL_GROUP_ID PFT_PRSNL_GROUP PFT_PRSNL_GROUP_ID
PRSNL_ID PRSNL PERSON_ID


PFT_REG_MOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: ProFit Account Management
Definition: Tracks modifications by type. (i.e. Encounter Type Change, Primary Health Plan Change, Nurse Unit Location Change and Admit Date Time Change.
Table Type: ACTIVITY





Column Detail - PFT_REG_MOD


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.
CREATE_DT_TM DATETIME Y The date and time that the row was created.
CREATE_PRSNL_ID DOUBLE N This is the person responsible for creating a row in the PFT_REG_MOD table.
DISCH_DT_TM DATETIME Y The actual date/time that the patient was discharged from the facility. For most outpatients, this column may be null unless the user process requires capturing this data, for example, day surgery. Auto discharge will populate this column. This also may or may not be a system assigned date and time depending on the discharge process used.
ENCNTR_ID DOUBLE N Uniquely identifies the related Encounter. This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type. Examples may include inpatient, outpatient, etc.
ENCNTR_TYPE_CLASS_CD DOUBLE N Encounter type class is used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). The values in this codeset all have Cerner defined meanings.
GUARANTOR_ID DOUBLE N The person guarantor for patient
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the related health plan. This is the value of the unique primary identifier of the health plan table. It is an internal system assigned number.
INPATIENT_ADMIT_DT_TM DATETIME Y Stores the date and time of the inpatient admit.
LOC_FACILITY_CD DOUBLE N Contains the current patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N This field is the current patient location with a location type of nurse unit.
PFT_REG_MOD_ID DOUBLE N Uniquely identifies a modification in the registration. Contains a unique generated number that identifies a single row on the PFT_REG_MOD table.
PRIORITY_SEQ DOUBLE N This is a numeric number used to represent the order in which to consider this health plan for reimbursement, if the person is a member of more than one health plan. This number may change from the original number depending on the encounter.
REG_DT_TM DATETIME Y Inidcates the date/time that the registration or admission process was performed
TRANSACTION_TYPE VARCHAR(4) Y The type of transaction that occurred. Example: UPDT, ATDS, etc.
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_REG_MOD


Child Column in PFT_REG_MOD(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_TYPE_CD CODE_VALUE CODE_VALUE
ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
LOC_FACILITY_CD LOCATION LOCATION_CD
GUARANTOR_ID PERSON PERSON_ID