Table Detail Report
PFT_DAILY_BO_HP_BAL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT DAILY BO HP BAL |
Definition: | Stores a BO_HP's balances on a daily basis. |
Table Type: | ACTIVITY |
Column Detail - PFT_DAILY_BO_HP_BAL
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_DT_TM | DATETIME | N | Date of the activity applied to the BO_HP_RELTN. |
ADJUSTMENT_AMT | DOUBLE | N | Total adjustments made on this bill rec for this day. |
ADJ_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the adjustment amount.1 |
BEG_EST_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the Beginning Estimated Balance. |
BEG_EST_RESP | DOUBLE | N | Beginning Estimated Responsibility |
BILLING_ENTITY_ID | DOUBLE | N | Billing Entity related to the given BO_HP Reltn. |
CALCULATED_END_BAL | DOUBLE | N | Calculated balance of the BO_HP Reltn for this day. |
CALC_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the calculated balance. |
CHARGE_AMOUNT | DOUBLE | N | Total Charges applied on the BO_HP_RELTN for this day. |
CHARGE_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the Charges. |
CO_INSURANCE_AMT | DOUBLE | N | Amount of the co-insurance, if applicable. |
CO_PAYMENT_AMT | DOUBLE | N | Amount of the co-pay, if applicable. |
DEDUCTIBLE_AMT | DOUBLE | N | Amount of the deductible, if applicable. |
DENIAL_AMT | DOUBLE | N | Amount of the denial, if applicable |
END_EST_DR_CR_FLAG | DOUBLE | N | Ending balance of the BO_HP reltn for this day. This relates to the Curr_Amount on the pft_proration table. |
END_EST_RESP | DOUBLE | N | Ending Estimated Responsibility |
MAN_ADJ_AMOUNT | DOUBLE | N | Total Manual Adjustments on the BO_HP_RELTN for this day. |
MAN_ADJ_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the Manual Adjustments. |
NON_COVERED_CHARGE_AMT | DOUBLE | N | Amount of the non-covered charge, if applicable. |
PATIENT_RESP_AMT | DOUBLE | N | Amount of the patient responsibility, if applicable. |
PAYMENT_AMOUNT | DOUBLE | N | Total Payments made on this BO_HP Reltn for this day. |
PAY_DR_CR_FLAG | DOUBLE | N | Debit Credit flag for the Payments. |
PFT_DAILY_BO_HP_BAL_ID | DOUBLE | N | Unique Identifier |
PFT_PRORATION_ID | DOUBLE | N | Bill Record ID related to this daily balance. |
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_DAILY_BO_HP_BAL
Child Column in PFT_DAILY_BO_HP_BAL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
PFT_PRORATION_ID | PFT_PRORATION | PFT_PRORATION_ID |
PFT_DATE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT DATE |
Definition: | Houses ProFit Date formats |
Table Type: | ACTIVITY |
Column Detail - PFT_DATE
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. |
DATE_TYPE_CD | DOUBLE | N | Type of Date stored |
DATE_VALUE_DT_TM | DATETIME | Y | Date Value being stored |
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. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | The Parent entity of the date being stored |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | Name of the parent entity for the stored date |
PFT_DATE_ID | DOUBLE | N | Primary Key |
PFT_EVENT_ID | DOUBLE | Y | Uniquely identifies the related row on the PFT_EVENT table. |
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_DATE
Child Column in PFT_DATE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
PFT_EVENT_ID | PFT_EVENT | PFT_EVENT_ID |
PFT_ENCNTR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit's Encounter Table |
Definition: | pft encounter |
Table Type: | ACTIVITY |
Column Detail - PFT_ENCNTR
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCT_ID | DOUBLE | N | Candidate key reference to an account. |
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. |
ADJUSTMENT_BALANCE | DOUBLE | Y | Total amount of adjustments posted to this pft_encntr. |
ADJ_BAL_DR_CR_FLAG | DOUBLE | Y | Debit/Credit flag for the adjustment balance. |
ALIAS_SEQ | DOUBLE | Y | Current alias sequence according to Patient Accounting |
APPLIED_PAYMENT_BALANCE | DOUBLE | Y | Total amount of payments posted to the ProFit Encounter. |
BAD_DEBT_BALANCE | DOUBLE | N | Balance of bad debt on financial encounter |
BAD_DEBT_BAL_DR_CR_FLAG | DOUBLE | N | debit/credit flag for bad_debt_balance |
BAD_DEBT_DT_TM | DATETIME | Y | Date Encounter entered a state of Bad Debt. |
BALANCE | DOUBLE | Y | Balance related to a ProFit encounter. |
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 | Foreign Key from the billing_entity table |
BILL_COUNTER_TERM | LONGTEXT | Y | Obsolete, No longer used. |
BILL_STATUS_CD | DOUBLE | N | Billing status of an invoice. Examples :Complete, Inprocess, Generated |
CHARGE_BALANCE | DOUBLE | Y | Total amount of charges posted to a ProFit Encounter. |
CHRG_BAL_DR_CR_FLAG | DOUBLE | Y | Debit/Credit flag for the charge balance. |
COLLECTION_STATE_CD | DOUBLE | N | To be removed |
COL_LETTER_IND | DOUBLE | N | Indicator that this financial encounter is excluded from collection letters |
COMBINED_INTO_ID | DOUBLE | N | Candidate key reference to a PFT Encounter. |
CONSOLIDATION_IND | DOUBLE | N | Indicator that this financial encounter is excluded from a consolidation statement |
CONVERSION_IND | DOUBLE | Y | Indicates that this encounter was created because of a conversion. |
COURTESY_STMT_IND | DOUBLE | N | Indicates whether this financial encounter has started sending out courtesy statements. |
CR_START_DT_TM | DATETIME | Y | stores the start of the cardiac rehab treatment |
CR_TOTAL_VISITS | DOUBLE | Y | stores the running total of cardiac rehab treatment visits |
DISCH_DT_TM | DATETIME | Y | Date the person was discharged from the facility |
DR_CR_FLAG | DOUBLE | Y | Flag identifying whether the balance is debit or credit. |
DUNNING_HOLD_IND | DOUBLE | N | Indicates if this financial encounter remains at the same dunning level regardless of other criteria |
DUNNING_IND | DOUBLE | N | Indicator that this financial encounter is excluded from dunning messages |
DUNNING_LEVEL_CD | DOUBLE | N | Code value indicating collections state that a ProFit encounter is in. |
DUNNING_LEVEL_CHANGE_DT_TM | DATETIME | Y | Date the dunning level was changed by the bill record generation process. |
DUNNING_LEVEL_CNT | DOUBLE | Y | Indicates how many times a bill has been sent at the current dunning level code. |
DUNNING_NO_PAY_CNT | DOUBLE | Y | The number of times that no payment has been received at this dunning level |
DUNNING_PAY_CNT | DOUBLE | Y | The number of times that an acceptable payment has been received at this dunning level |
DUNNING_UNACC_PAY_CNT | DOUBLE | Y | The number of times that an unacceptable payment has been received at this dunning level |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
ENCNTR_PLAN_COB_ID | DOUBLE | N | Uniquely identifies the encounter plan coordination of benefits related to this pft_encntr |
ENCNTR_TYPE_CD | DOUBLE | N | Current encounter type according to Patient Accounting |
ENCNTR_TYPE_CLASS_CD | DOUBLE | N | Current encounter type class according to Patient Accounting |
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. |
EST_FINANCIAL_RESP_AMT | DOUBLE | Y | The estimated amount due for the encounter, which is set during registration. |
EXTRACTION_IND | DOUBLE | Y | Indicator displaying the status of the extraction (1=success, 0=fail) |
EXT_BILLING_IND | DOUBLE | Y | Indicates if the ProFit encounter needs to be send to the outside collection agency at the given dunning level. |
FIN_CLASS_CD | DOUBLE | N | Financial class code value |
GOOD_WILL_IND | DOUBLE | Y | Tells if the ProFit encounter is being paid off timely. |
GUAR_EXT_IND | DOUBLE | Y | indicator displaying the status of the guarantor extraction (1=success, 0=fail) |
INPATIENT_ADMIT_DT_TM | DATETIME | Y | Current admit date and time according to Patient Accounting. |
INS_PEND_BAL_FWD | DOUBLE | N | The amount of insurance pending that is being pulled forward at the pft_encntr level to the next month's statement |
INTERIM_IND | DOUBLE | Y | Indicates whether or not an encounter qualifies for interim billing. |
LAST_ADJUSTMENT_DT_TM | DATETIME | Y | Date of the last adjustment made against this encounter |
LAST_CHARGE_DT_TM | DATETIME | Y | Stores the last charge date and time |
LAST_CLAIM_DT_TM | DATETIME | Y | Date of the last claim made against this encounter |
LAST_EXTRACTION_DT_TM | DATETIME | Y | Date and Time when the last extraction was made to the Sorian Financials system. |
LAST_PATIENT_PAY_DT_TM | DATETIME | Y | The latest date/time of a patient payment |
LAST_PAYMENT_DT_TM | DATETIME | Y | Stores the last payment date and time |
LAST_STMT_DT_TM | DATETIME | Y | Date of the last Statement made against this encounter |
LOC_FACILITY_CD | DOUBLE | N | Current facility location according to Patient Accounting |
LOC_NURSE_UNIT_CD | DOUBLE | N | Current nurse unit location according to Patient Accounting |
NBR_OF_STMTS | DOUBLE | Y | Total number of Statements that this Encounter is related to. |
ORIG_BILL_SUBMIT_DT_TM | DATETIME | Y | A date / time stamp that will identify the date/time the bill was originally submitted to a third party. |
ORIG_BILL_TRANSMIT_DT_TM | DATETIME | Y | A date / time stamp that will identify the date/time the bill was originally transmitted to a third party. |
OT_START_DT_TM | DATETIME | Y | stores the start of the occupational therapy treatment |
OT_TOTAL_VISITS | DOUBLE | Y | stores the running total of occupational therapy treatment visits |
PACKAGE_STATUS_CD | DOUBLE | N | The package status code indicating whether this particular financial encounter has been package priced for all the eligible charges tied to it. |
PAT_BAL_FWD | DOUBLE | N | The amount the patient owes at the pft_encntr level that is being pulled forward to the next month's statement. |
PAYMENT_PLAN_FLAG | DOUBLE | Y | The field defines the payment plan. |
PAYMENT_PLAN_STATUS_CD | DOUBLE | N | This field defines the status of the payment plan |
PFT_ENCNTR_ALIAS | VARCHAR(215) | Y | stores the financial encounter's alias which will be used to identify the financial encounter |
PFT_ENCNTR_DATA_MODEL_VRSN_NBR | DOUBLE | N | Identifies this financial encounter's data model version. |
PFT_ENCNTR_ID | DOUBLE | N | Primary Key |
PFT_ENCNTR_STATUS_CD | DOUBLE | N | Status of the encounter. Active / Pending |
PT_START_DT_TM | DATETIME | Y | stores the start of the physical therapy treatment |
PT_TOTAL_VISITS | DOUBLE | Y | stores the running total of physical therapy treatment visits |
QUALIFIER_CD | DOUBLE | N | Allows a user-defined qualifier to be attached to each ProFit financial encounter. |
RC_CONT_PROCESS_GROUP_ID | DOUBLE | Y | Uniquely identifies the related Id representing a group of processes on a specific model instance. |
RECUR_BILL_GEN_IND | DOUBLE | Y | stores whether or not a bill has been generated for the recurring financial encounter |
RECUR_BILL_READY_IND | DOUBLE | Y | stores whether or not a recurring bill is ready to be generated for a financial encounter |
RECUR_CURRENT_MONTH | DOUBLE | Y | Integer field to store the value for the current month for recurring billing. Valid values are limited to 1-12. |
RECUR_CURRENT_YEAR | DOUBLE | N | Integer field to store the value for the current year for recurring billing. |
RECUR_IND | DOUBLE | Y | stores whether or not the financial encounter is related to a recurring clinical encounter |
RECUR_SEQ | DOUBLE | Y | stores the sequence o the recurring financial encounters. Should only be valued if recur_ind = 1. |
RECUR_TYPE_CD | DOUBLE | N | Describes how often the encounter will re-occur. Valid values are Weekly, Monthly, or Daily. |
REG_DT_TM | DATETIME | Y | Current registration date time according to Patient Accounting |
REMAINING_EST_DUE_AMT | DOUBLE | Y | The remaining estimated amount due for the encounter, which is set during registration. This field will change based on payments/adjustments. |
ROUTE_USER_NAME | VARCHAR(40) | Y | This column is not used on this table, it was added by mistake |
SELF_PAY_EDIT_FLAG | DOUBLE | Y | Values: (0) No edits to self-pay plan (1) Self-pay plan added (2) Self-pay plan removed (3) Self-pay plan out of sequence |
SEND_COL_IND | DOUBLE | N | Indicator that this financial encounteris excluded from being sent to collections |
SLT_START_DT_TM | DATETIME | Y | stores the start of the speech language therapy treatment visits |
SLT_TOTAL_VISITS | DOUBLE | Y | stores the running total of speech language therapy treatment visits |
STATEMENT_CYCLE_ID | DOUBLE | N | Foreign key to the statement cycle table |
STMT_BILLING_LEVEL_CD | DOUBLE | Y | This field indicates the level at which statements are billed for the financial encounter. (Ex. Encounter, Balance) |
SUBMISSION_ROUTE_CD | DOUBLE | N | This is the submission routing for this claim |
SVC_BEG_DT_TM | DATETIME | Y | The date and time this service began. |
SVC_END_DT_TM | DATETIME | Y | The date and time this service ended. |
UNAPPLIED_PAYMENT_BALANCE | DOUBLE | Y | Total amount of unapplied payments to the ProFit Encounter. |
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. |
ZERO_BALANCE_DT_TM | DATETIME | Y | This field will store the date that the Encounter and all related charge groups reached a zero balance in regards of actual balance and bad debt balance. |
Relationship Detail - PFT_ENCNTR
Child Column in PFT_ENCNTR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ACCT_ID | ACCOUNT | ACCT_ID |
BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID | |
ENCNTR_PLAN_COB_ID | ENCNTR_PLAN_COB | ENCNTR_PLAN_COB_ID | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
LOC_FACILITY_CD | LOCATION | LOCATION_CD | |
LOC_NURSE_UNIT_CD | LOCATION | LOCATION_CD | |
COMBINED_INTO_ID | PFT_ENCNTR | PFT_ENCNTR_ID | |
RC_CONT_PROCESS_GROUP_ID | RC_CONT_PROCESS_GROUP | RC_CONT_PROCESS_GROUP_ID | |
STATEMENT_CYCLE_ID | STATEMENT_CYCLE | STATEMENT_CYCLE_ID |
Parent Column in PFT_ENCNTR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PFT_ENCNTR_ID | BATCH_TRANS_FILE | PFT_ENCNTR_ID |
BENEFIT_ORDER | PFT_ENCNTR_ID | ||
CBOS_PE_RELTN | PFT_ENCNTR_ID | ||
CORSP_LOG_RELTN | PFT_ENCNTR_ID | ||
DAILY_ENCNTR_BAL | PFT_ENCNTR_ID | ||
EXT_PAY_PLAN_PE_RELTN | PFT_ENCNTR_ID | ||
GL_TRANS_LOG_OFFSET | PFT_ENCNTR_ID | ||
PE_STATUS_REASON | PFT_ENCNTR_ID | ||
PFT_BAD_DEBT_BAL | PFT_ENCNTR_ID | ||
PFT_BALANCE | PFT_ENCNTR_ID | ||
PFT_BENEFIT_ORDER | PFT_ENCNTR_ID | ||
PFT_BILL_SUMMARY | PFT_ENCNTR_ID | ||
PFT_CHARGE | PFT_ENCNTR_ID | ||
PFT_CHRG_GRP_RPRCS | PFT_ENCNTR_ID | ||
PFT_CHRG_GRP_RPRCS_HIST | PFT_ENCNTR_ID | ||
PFT_ENCNTR | COMBINED_INTO_ID | ||
PFT_ENCNTR_ALIAS | PFT_ENCNTR_ID | ||
PFT_ENCNTR_COLLECTION_RELTN | PFT_ENCNTR_ID | ||
PFT_ENCNTR_FACT | PFT_ENCNTR_ID | ||
PFT_PAY_PLAN_PE_RELTN | PFT_ENCNTR_ID | ||
PFT_PENDING_BILL | PFT_ENCNTR_ID | ||
PFT_PRORATION | PFT_ENCNTR_ID | ||
PFT_QUEUE_ITEM | PFT_ENCNTR_ID | ||
PFT_QUEUE_ITEM_HIST | PFT_ENCNTR_ID | ||
RCR_TRANS_DIST | PFT_ENCNTR_ID |
PFT_ENCNTR_ALIAS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PFT ENCNTR ALIAS |
Definition: | Profit's encounter alias table |
Table Type: | ACTIVITY |
Column Detail - PFT_ENCNTR_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(100) | Y | Identifier for the encounter |
ALIAS_POOL_CD | DOUBLE | N | Alias pool code identifies a unique set or list of encounter identifiers and determines the accept/display format for the unique set of identifiers. |
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. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DATA_STATUS_CD | DOUBLE | N | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the data_status_cd to be set or change. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
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. |
PFT_ENCNTR_ALIAS_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter alias table. It is an internal system assigned number |
PFT_ENCNTR_ALIAS_TYPE_CD | DOUBLE | N | Encounter alias type code identifies a kind or type of alias |
PFT_ENCNTR_ID | DOUBLE | N | Foreign key to PFT_Encntr 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_ENCNTR_ALIAS
Child Column in PFT_ENCNTR_ALIAS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PFT_ENCNTR_ID | PFT_ENCNTR | PFT_ENCNTR_ID |
PFT_ENCNTR_CENSUS_SUMMARY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | ProFit Encounter Census Summary |
Definition: | Summary of Encounter Level census information |
Table Type: | ACTIVITY |
Column Detail - PFT_ENCNTR_CENSUS_SUMMARY
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCOMMODATION_CD | DOUBLE | N | Current type of accommodations in which the patient (encounter) has been placed. (e.g. Private, Semi Private, etc.) |
ADMIT_CNT | DOUBLE | Y | The number of patient admits for the time period |
BILLING_ENTITY_ID | DOUBLE | N | Identifies the related Billing Entity for an encounter census summary |
DISCHARGE_CNT | DOUBLE | Y | The number of patient discharges for the time period |
ENCNTR_TYPE_CLASS_CD | DOUBLE | N | Used to categorize patients into more general groups than encounter type. (i.e., inpatient, outpatient, emergency, recurring outpatient). Code values have Cerner defined meanings. |
FIN_CLASS_CD | DOUBLE | N | Financial classification used for a given encounter. Examples may include Worker's Comp, Self Pay, etc. |
LOC_BUILDING_CD | DOUBLE | N | Current patient location with a location type of building |
LOC_FACILITY_CD | DOUBLE | N | Current patient location with a location type of facility |
LOC_NURSE_UNIT_CD | DOUBLE | N | Current patient location with a location type of Nurse Unit |
MED_SERVICE_CD | DOUBLE | N | Type or Category of medical service that patient receives in relation to the encounter. The category may be of treatment type, surgery, general resources, or others. |
PATIENT_DAYS_CNT | DOUBLE | Y | Number of inpatient patient care days for the time period |
PFT_ENCNTR_CENSUS_SUMMARY_ID | DOUBLE | N | Identifies a Summary of encounter census-level Information |
PFT_FISCAL_PERIOD_ID | DOUBLE | N | This identifies which fiscal period the transaction was posted against. This column is constrained by the PFT_FISCAL_PERIOD 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. |
VISIT_DAYS_CNT | DOUBLE | Y | The number of outpatient visits for the time period. |
Relationship Detail - PFT_ENCNTR_CENSUS_SUMMARY
Child Column in PFT_ENCNTR_CENSUS_SUMMARY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
LOC_BUILDING_CD | LOCATION | LOCATION_CD | |
LOC_FACILITY_CD | LOCATION | LOCATION_CD | |
LOC_NURSE_UNIT_CD | LOCATION | LOCATION_CD | |
PFT_FISCAL_PERIOD_ID | PFT_FISCAL_PERIOD | PFT_FISCAL_PERIOD_ID |