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 |