Table Detail Report

PFT_RPT_BLOB_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the relationship between a report instance and long blob record
Definition: Stores the relationship between a report instance and the corresponding long blob record
Table Type: ACTIVITY





Column Detail - PFT_RPT_BLOB_RELTN


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 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.
COMPRESS_SIZE DOUBLE N Compressed size of report
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.
LONG_BLOB_ID DOUBLE N Foreign key to the Long_Blob table
ORIG_SIZE DOUBLE N Original size of report
PFT_REPORT_INSTANCE_ID DOUBLE N Foreign key to Pft_Report_Instance table
PFT_RPT_BLOB_RELTN_ID DOUBLE N Unique identifier of this table
SEQUENCE DOUBLE N Sequence value for consecutive 32K blobs
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_RPT_BLOB_RELTN


Child Column in PFT_RPT_BLOB_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_REPORT_INSTANCE_ID PFT_REPORT_INSTANCE PFT_REPORT_INSTANCE_ID


PFT_RVU_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Profit Relative Value Unit Content
Definition: Stores information from the CMS National Physician Fee Schedule Relative Value Filegeographical location of practice to determine how much providers can charge for Medicare-reimbursed services.
Table Type: REFERENCE





Column Detail - PFT_RVU_CONTENT


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.
ASSISTANT_AT_SURGERY_CD DOUBLE N Indicates services where an assistant at surgery is never paid for per Medicare claims manual.
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.
BILATERAL_SURGERY_CD DOUBLE N Indicates services subject to payment adjustment.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related billing entity
CDM_VALUE_TXT VARCHAR(50) Y Contains the text value of the charge master description.
CDM_VALUE_TXT_KEY VARCHAR(50) Y Contains the text value of the charge master description in all capitals and with no special characters.
CONVERSION_FACTOR_NBR DOUBLE Y Multiplier that transforms relative values into payment amounts.
COSURGEONS_CD DOUBLE N Indicates services for which two surgeons, each in a different specialty, may be paid.
ENDOSCOPIC_BASE_CODE_TXT VARCHAR(5) Y Code which identifies an endoscopic base code for each code with a multiple surgery indicator of 3
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.
FACILITY_NA_IND DOUBLE Y Indicates whether or not the procedure is rarely or never performed in the facility setting
FACILITY_PRACTICE_EXP_RVU_NBR DOUBLE Y RVU for fully-implemented resource based practice expense for the facility setting
GLOBAL_SURGERY_CD DOUBLE N Provides time frames that apply to each surgical procedure.
INTRAOPERATIVE_PCT DOUBLE Y Percentage for intraoperative portion of global package, including postoperative work in the hospital
MALPRACTICE_RVU_NBR DOUBLE Y RVU for the malpractice expense for the service
MEDICARE_PYMT_PURPOSE_IND DOUBLE Y Indicates whether or not RVU are used for Medicare payment purposes
MOD_NOMEN_ID DOUBLE N Identifies nomenclature for HCPCS or CPT4 modifier code
MOD_TXT VARCHAR(200) Y Contains the Identifier of the Modifiers for CPT and HCPCS. When new nomenclature content is loaded in the middle of the year, nomenclature ids don¿t match for the same source identifiers, so instead of qualifying on nomenclature ids in Revenue GSR we want to qualify on Source Identifier itself.
MULTIPLE_PROCEDURE_CD DOUBLE N Provides applicable payment adjustment rule for multiple procedures.
NON_FAC_NA_IND DOUBLE Y Indicates whether or not the procedure is rarely or never performed in the non-facility setting
NON_FAC_PRACTICE_EXP_RVU_NBR DOUBLE Y RVU for fully-implemented resource based practice expense for the non-facility setting
PFT_RVU_CONTENT_ID DOUBLE N Unique Identifier for content developed to determine the standard Medicare Fee Schedule.
PHYS_SUPERVISION_DIAG_PROC_CD DOUBLE N Used in post payment review.
POSTOPERATIVE_PCT DOUBLE Y Percentage for postoperative portion of global package that is provided in the office after discharge from the hospital
PREOPERATIVE_PCT DOUBLE Y Percentage for preoperative portion of global package
PROCEDURE_STATUS_CD DOUBLE N Indicates whether code is in fee schedule and whether it is separately payable if service is covered.
PROC_NOMEN_ID DOUBLE N Identifies HCPCS or CPT4 procedure code.
PROF_TECH_COMP_INDICATOR_CD DOUBLE N Medicare Prof/Tech Component Indicator
RVU_FLAG DOUBLE N Indicates whether or not the Relative Value Unit is for CDM or CPT0 - CPT1 - CDM
SOURCE_TXT VARCHAR(200) Y Contains the Identifier of the Charge Master Description(CDM), Current Procedural Terminology (CPT) and HCPCS. When new nomenclature content is loaded in the middle of the year, nomenclature ids don¿t match for the same source identifiers, so instead of qualifying on nomenclature ids in Revenue GSR we want to qualify on Source Identifier itself.
TEAM_SURGERY_CD DOUBLE N Indicates services for which team surgeons may be paid.
TOTAL_FACILITY_RVU_NBR DOUBLE Y Sum of work, fully implemented facility practice expense, and malpractice expense RVUs
TOTAL_NON_FAC_RVU_NBR DOUBLE Y Sum of work, fully implemented non-facility practice expense, and malpractice expense RVUs
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.
WORK_RVU_NBR DOUBLE Y RVU for physician work



Relationship Detail - PFT_RVU_CONTENT


Child Column in PFT_RVU_CONTENT(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
MOD_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID
PROC_NOMEN_ID NOMENCLATURE NOMENCLATURE_ID


RCR_GSR_CONTEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Reporting - Gold Standard Reporting Context
Definition: Holds a GSR context with reference to logical domain and time zone.
Table Type: ACTIVITY





Column Detail - RCR_GSR_CONTEXT


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.
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.
RCR_GSR_CONTEXT_ID DOUBLE N Unique generated number that identifies a single row on the RCR_GSR_CONTEXT table.
TIME_ZONE_INDEX DOUBLE N Stores the time zone in which the GSR job is running.
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 - RCR_GSR_CONTEXT


Child Column in RCR_GSR_CONTEXT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in RCR_GSR_CONTEXT (PK) Child Table Name Child Column Name
Children: RCR_GSR_CONTEXT_ID RCR_GSR_CONTEXT_RELTN RCR_GSR_CONTEXT_ID
RCR_GSR_LOCK_INFO RCR_GSR_CONTEXT_ID
RC_CLN_AREA RCR_GSR_CONTEXT_ID
RC_GSR_DIMENSION_TMP RCR_GSR_CONTEXT_ID
RC_GSR_SUM_AGG_TMP RCR_GSR_CONTEXT_ID


RCR_GSR_CONTEXT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Reporting - Gold Standard Reporting Context Relationship
Definition: Contains a relationship between the GSR context with its entities.
Table Type: ACTIVITY





Column Detail - RCR_GSR_CONTEXT_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.
GSR_ENTITY_NAME VARCHAR(20) N Contains the name of the GSR Extract, refer to the DEM_XTRCT table.
RCR_GSR_CONTEXT_ID DOUBLE N Uniquely identifies the related Gold Standard Reporting Context.
RCR_GSR_CONTEXT_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RCR_GSR_CONTEXT_RELTN 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 - RCR_GSR_CONTEXT_RELTN


Child Column in RCR_GSR_CONTEXT_RELTN(FK) Parent Table Name Parent Column Name
Parents: RCR_GSR_CONTEXT_ID RCR_GSR_CONTEXT RCR_GSR_CONTEXT_ID


RCR_GSR_LOCK_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Reporting - Gold Standard Reporting Lock Information
Definition: This table provides a locking mechanism for the Gold Standard ETL job.
Table Type: ACTIVITY





Column Detail - RCR_GSR_LOCK_INFO


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.
DIMENSION_INDEX DOUBLE N This is an index for an internal structure that tracks the available dimensions.
LOCK_DT_TM DATETIME Y Used to Store the Lock date and time, when the lock was acquired.
LOCK_IND DOUBLE N Indicator to determine if the lock is active. 1 indicates that the lock is active.
LOCK_NAME VARCHAR(255) N Used to store the name of the lock on the process.
RCR_GSR_CONTEXT_ID DOUBLE N Unique generated number that identifies a single row on the RCR_GSR_CONTEXT table.
RCR_GSR_LOCK_INFO_ID DOUBLE N Unique generated number that identifies a single rown on the RCR_GSR_LOCK_INFO 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 - RCR_GSR_LOCK_INFO


Child Column in RCR_GSR_LOCK_INFO(FK) Parent Table Name Parent Column Name
Parents: RCR_GSR_CONTEXT_ID RCR_GSR_CONTEXT RCR_GSR_CONTEXT_ID