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