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 |