Table Detail Report

GL_TRANS_LOG_OFFSET



Column Section Relationship Section Top of Page


Table-level Detail

Description: GL_TRANS_LOG_OFFSET
Definition: Stores the adjustment information for backdated charges
Table Type: ACTIVITY





Column Detail - GL_TRANS_LOG_OFFSET


Column Name Type Null? Definition
ACCOUNT_ID DOUBLE Y Uniquely identifies the account related to this row.
ACTIVITY_DT_TM DATETIME N The date on which the charge was aliased.
ACTIVITY_ID DOUBLE Y Uniquely identifies the related activity log record.
GL_TRANS_LOG_OFFSET_ID DOUBLE N Unique generated number that identifies a single row on the GL_TRANS_LOG_OFFSET table.
OFFSET_AMT DOUBLE N Stores the amount is to be adjusted.
PFT_ENCNTR_ID DOUBLE N The pft_encntr_Id related to backdated charges.
SERVICE_DT_TM DATETIME N The date on which the charge was queued to be aliased.
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 - GL_TRANS_LOG_OFFSET


Child Column in GL_TRANS_LOG_OFFSET(FK) Parent Table Name Parent Column Name
Parents: ACCOUNT_ID ACCOUNT ACCT_ID
ACTIVITY_ID ACTIVITY_LOG ACTIVITY_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID


GL_TRANS_QUALIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Transaction Qualifier
Definition: Stores all possible qualifier data as defined at the time a transaction was assigned a GL alias.
Table Type: ACTIVITY





Column Detail - GL_TRANS_QUALIFIER


Column Name Type Null? Definition
ACCOUNT_SUB_TYPE_CD DOUBLE N Contains a sub type of the Acct_Type_Cd to further define the account.
ACTIVITY_SUB_TYPE_CD DOUBLE N Contains a sub type of the activity_type_cd to further define the activity
ACTIVITY_TYPE_CD DOUBLE N A code value that uniquely identifies to which "net" (PathNet, RadNet) and/or what department (General Lab, Microbiology) an order belongs.
ATTENDING_PHYS_ID DOUBLE Y Uniquely identifies the attending physician
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related Billing Entity.
BILL_ITEM_ID DOUBLE N Uniquely identifies the related Bill Item.
BILL_TYPE_CD DOUBLE N Identifies the type of bill.
CLIENT_ACCOUNT_ID DOUBLE N Uniquely identifies the related account.
CLIENT_ORG_ID DOUBLE N Uniquely identifies the related client organization.
CURRENT_FIN_CLASS_CD DOUBLE N The financial classification used for the current balance.
CURRENT_INS_ORG_ID DOUBLE N Uniquely identifies the related organization for the current balance.
DEPARTMENT_CD DOUBLE N Service resource code associated to the department.
ENCNTR_TYPE_CD DOUBLE N Categorizes the encounter into a logical group or type.
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).
FINANCIAL_CLASS_CD DOUBLE N The financial classification used for the encounter.
GL_TRANS_LOG_ID DOUBLE N Uniquely identifies the related general ledger transaction log record.
GL_TRANS_QUALIFIER_ID DOUBLE N Unique generated number that identifies a single row on the gl_trans_qualifiers_table.
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the related Health Plan.
INSTITUTION_CD DOUBLE N Service resource code associated to the institution.
INS_ORG_ID DOUBLE N Uniquely identifies the related insurance organization.
LEVEL5_CD DOUBLE N Service resource code associated to the level 5 (exam room, bench, instrument, etc.)
LOC_BED_CD DOUBLE N The current patient location with a location type of bed
LOC_BUILDING_CD DOUBLE N The current patient location with a location type of building.
LOC_FACILITY_CD DOUBLE N The current patient location with a location type of facility.
LOC_NURSE_UNIT_CD DOUBLE N The current patient location with a location type of nurse unit.
LOC_ROOM_CD DOUBLE N The current patient location with a location type of room
MED_SERVICE_CD DOUBLE N Represents the category of treatment, surgery, or general resources.
ORDERING_LOCATION_CD DOUBLE N Represents the location where the order was placed.
ORDERING_PHYS_GROUP_ID DOUBLE Y Uniquely identifies the ordering physician group.
ORDERING_PHYS_ID DOUBLE N Uniquely identifies the ordering physician.
PATIENT_LOCATION_CD DOUBLE N Identifies the location of the patient.
PERFORMING_LOCATION_CD DOUBLE N Represents the location at which the services were provided.
PERFORMING_PHYS_ID DOUBLE N Uniquely identifies the performing physician.
PFT_PAYMENT_LOCATION_ID DOUBLE N Uniquely identifies the related payment location.
PRIMARY_HEALTH_PLAN_ID DOUBLE N The primary health plan ID associated to an activity.
RENDERING_PHYS_GROUP_ID DOUBLE Y Uniquely identifies the rendering physician group.
SECTION_CD DOUBLE N Service resource code associated to the section.
SUBSECTION_CD DOUBLE N Service resource code associated to the subsection.
SUPERVISING_PHYS_ID DOUBLE Y Uniquely identifies the supervising physician.
TIER_GROUP_CD DOUBLE N Tier that was responsible for creating the charge.
TRANS_REASON_CD DOUBLE N Stores information about why a transaction took place.
TRANS_SUB_TYPE_CD DOUBLE N Further identifies the type and purpose of the transaction.
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.
VERIFY_PHYS_ID DOUBLE N Uniquely identifies the physician who verified the result.



Relationship Detail - GL_TRANS_QUALIFIER


Child Column in GL_TRANS_QUALIFIER(FK) Parent Table Name Parent Column Name
Parents: CLIENT_ACCOUNT_ID ACCOUNT ACCT_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
GL_TRANS_LOG_ID GL_TRANS_LOG GL_TRANS_LOG_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PRIMARY_HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
LOC_BED_CD LOCATION LOCATION_CD
LOC_BUILDING_CD LOCATION LOCATION_CD
LOC_FACILITY_CD LOCATION LOCATION_CD
LOC_NURSE_UNIT_CD LOCATION LOCATION_CD
LOC_ROOM_CD LOCATION LOCATION_CD
CLIENT_ORG_ID ORGANIZATION ORGANIZATION_ID
CURRENT_INS_ORG_ID ORGANIZATION ORGANIZATION_ID
INS_ORG_ID ORGANIZATION ORGANIZATION_ID
PFT_PAYMENT_LOCATION_ID PFT_PAYMENT_LOCATION PFT_PAYMENT_LOCATION_ID
ATTENDING_PHYS_ID PRSNL PERSON_ID
ORDERING_PHYS_ID PRSNL PERSON_ID
PERFORMING_PHYS_ID PRSNL PERSON_ID
SUPERVISING_PHYS_ID PRSNL PERSON_ID
VERIFY_PHYS_ID PRSNL PERSON_ID
ORDERING_PHYS_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
RENDERING_PHYS_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in GL_TRANS_QUALIFIER (PK) Child Table Name Child Column Name
Children: GL_TRANS_QUALIFIER_ID GL_TRANS_QUALIFIER_DETAIL GL_TRANS_QUALIFIER_ID


GL_TRANS_QUALIFIER_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: General Ledger Transaction Qualifier Detail
Definition: Stores qualifiers where there can be more than one possible data point.
Table Type: ACTIVITY





Column Detail - GL_TRANS_QUALIFIER_DETAIL


Column Name Type Null? Definition
GL_TRANS_QUALIFIER_DETAIL_ID DOUBLE N Unique generated number that identifies a single row on the gl_trans_qualifier_detail table.
GL_TRANS_QUALIFIER_ID DOUBLE N Uniquely identifies the related gl_trans_qualifier row.
PARENT_ENTITY_ID DOUBLE N This column represents the name of the qualifier being stored.
PARENT_ENTITY_NAME VARCHAR(30) N This column contains the name of the qualifier being stored.
QUALIFIER_TYPE_TXT VARCHAR(100) N Describes what type of qualifier is being stored.
QUALIFIER_VALUE VARCHAR(200) N The qualifier value entered by the user for the corresponding qualifier type text.
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 - GL_TRANS_QUALIFIER_DETAIL


Child Column in GL_TRANS_QUALIFIER_DETAIL(FK) Parent Table Name Parent Column Name
Parents: GL_TRANS_QUALIFIER_ID GL_TRANS_QUALIFIER GL_TRANS_QUALIFIER_ID


INTERFACE_TRANSACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: interface transaction table
Definition: This table will hold all the transactions that needs to be interfaced via FSI.
Table Type: ACTIVITY





Column Detail - INTERFACE_TRANSACTION


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME Y the date and time that the activity took place.
BATCH_ID DOUBLE N id for grouping all the payments/adjustments from the same batch together. Value is obtained from sequence PFT_BRE_SEQ, but is not a FK value.
CC_AUTH_NBR_TXT VARCHAR(50) Y The credit card authorization number
CC_END_EFF_DT_TM DATETIME Y the ending effective date time for the credit card
CHANGE_DUE_AMOUNT DOUBLE Y amount of local currency that exceeded payment amount and was returned to the payer.
CHECK_DT_TM DATETIME Y date written on the check
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
CURRENT_CUR_CD DOUBLE N Current Currency Code. Identifies the currency for this current transaction.
DR_CR_FLAG DOUBLE Y debit credit accounts receivable flag
EDI_EXTERNAL_IDENT VARCHAR(250) Y This external identifier is the unique identifier for an EDI transaction for various payment types.
ENCNTR_ID DOUBLE N this is the value of the unique primary identifier of the encounter table.
INTERCHANGE_TRANSACTION_IDENT VARCHAR(50) Y Identifier created in the front end using the Julian Date that we send to EDI when a performing a synchronous credit card charge.
INTERFACE_BATCH_ID DOUBLE N identifies which outbound batch the transaction was included on. This field will be used as a high-level grouper. Value comes from the pft_bre_seq oracle sequence. It is not a foreign key value.
INTERFACE_DT_TM DATETIME Y the date and time this transaction was interfaced to external system
INTERFACE_STATUS_CD DOUBLE N code value to tell what state this transactions is in, in relationship to the external interface. the states include pending, error, or submitted
INTERFACE_TRANSACTION_ID DOUBLE N PRIMARY KEY
MERCHANT_IDENT VARCHAR(250) Y Contains the Tsys Merchant Identifier.
ORIG_CUR_CD DOUBLE N The original currency type submitted by a patient prior to it being converted the currency type of the system.
PAYMENT_METHOD_CD DOUBLE N identifies the method of payment (personal check, credit card, money order, cash, etc.)
PAYMENT_NUM_DESC VARCHAR(250) Y the payment number. in the instance of a check this would be the check number.
PAYOR_NAME VARCHAR(60) Y name of the person that paid
PFT_PAYMENT_LOCATION_ID DOUBLE N uniquely identifies the payment location for this record.
TENDERED_AMOUNT DOUBLE Y amount of original currency given to payment posting personnel by payer at the time of the transaction.
TRANSACTION_AMOUNT DOUBLE Y AMOUNT OF PAYMENT FOR THIS TRANSACTION
TRANS_TYPE_CD DOUBLE N code value identifying the transaction type.
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 - INTERFACE_TRANSACTION


Child Column in INTERFACE_TRANSACTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PFT_PAYMENT_LOCATION_ID PFT_PAYMENT_LOCATION PFT_PAYMENT_LOCATION_ID
CREATED_PRSNL_ID PRSNL PERSON_ID


KPI_DAILY_TOTAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Key Performance Indicator Daily Totals
Definition: Each row represents the value of a distinct attribute associated with a report-specific set of summariazed totals or the value of a distinct attribute of a detail item included in such totals.
Table Type: ACTIVITY





Column Detail - KPI_DAILY_TOTAL


Column Name Type Null? Definition
ACTIVITY_DT_NBR DOUBLE N The specific date associated with the summary or detail attributes captured by the KPI report.
DETAIL_ROW_GRP_NBR DOUBLE N Used to group sets of summary and/or detail fields captured by individual KPI reports. For summary fields, this field will contain zero. For detail fields, all fields related to a specific detail item will share a single non-zero value.
FIELD_DT_TM DATETIME Y For rows with a field type of 3, this column will contain the specific date value assigned to it during the KPI report's execution.
FIELD_INT_NBR DOUBLE Y For rows with a field type of 1, this column will contain the specific integer value assigned to it during the KPI report's execution.
FIELD_NAME VARCHAR(255) N Identifies the nature of the value represented by the row. Examples of common field names would include TENANT, FACILITY, TOTAL and COUNT.
FIELD_REAL_NBR DOUBLE Y For rows with a field type of 2, this column will contain the specific real value assigned to it during the KPI report's execution.
FIELD_TXT VARCHAR(255) Y For rows with a field type of 4, this column will contain the specific string value assigned to it during the KPI report's execution. For rows with a field type of 2 that represent components of the flex key string, this column will contain the description of that specific component of the flex key.
FIELD_TYPE_FLAG DOUBLE N Indicates the type of data associated with the field (1= integer value, 2= real value, 3 = date value, 4 = string value)
FLEX_KEY_TXT VARCHAR(255) N Identifies distinct combinations of attribute values that are shared by a set of report-specific fields that the KPI report captures.
KPI_DAILY_TOTAL_ID DOUBLE N Uniquely represents the value of a distinct attribute associated with a report-specific set of summarized totals, or the value of a distinct attribute of a detail item included in such totals.
KPI_VERSION_NBR DOUBLE N Identifies the version number of the KPI report. For any given report, rows related to previous KPI versions will be purged by the reporting process.
PFT_REPORT_ID DOUBLE N Uniquely identifies the related KPI Report
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 - KPI_DAILY_TOTAL


Child Column in KPI_DAILY_TOTAL(FK) Parent Table Name Parent Column Name
Parents: PFT_REPORT_ID PFT_REPORT PFT_REPORT_ID