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 |