Table Detail Report
PFT_REPORT_PROMPT_RELTN
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | PFT REPORT PROMPT RELTN |
| Definition: | This is the ProFit report/prompt reltn table. |
| Table Type: | REFERENCE |
Column Detail - PFT_REPORT_PROMPT_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 | 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. |
| CUSTOM_PROMPT_TEXT | VARCHAR(50) | Y | custom prompt text |
| 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. |
| PFT_REPORT_ID | DOUBLE | N | This is a foreign key to the pft_report table and this is the unique identifier for the report. |
| PFT_REPORT_PROMPT_ID | DOUBLE | N | This is a foreign key to the report prompt table and is the unique identifier to the prompt |
| PFT_REPORT_PROMPT_RELTN_ID | DOUBLE | N | Primary key. |
| PRIORITY_SEQ | DOUBLE | Y | The sequence of the priority for this row |
| 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_REPORT_PROMPT_RELTN
| Child Column in PFT_REPORT_PROMPT_RELTN(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | PFT_REPORT_ID | PFT_REPORT | PFT_REPORT_ID |
| PFT_REPORT_PROMPT_ID | PFT_REPORT_PROMPT | PFT_REPORT_PROMPT_ID |
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_CENSUS_EXCLSN_CNFG
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | RCR_GSR_CENSUS_EXCLSN_CNFG |
| Definition: | This table is used to store the Code values of the Encounter type Codes and Encounter Class type codes which needs to excluded from the GSR Daily Census Extract |
| Table Type: | REFERENCE |
Column Detail - RCR_GSR_CENSUS_EXCLSN_CNFG
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| CODE_SET | DOUBLE | Y | Code Set from Code_Value table ; |
| CODE_VALUE | DOUBLE | Y | Field to Store the Code_Value from Code_Value table |
| CREATED_DT_TM | DATETIME | Y | Date and time the record was created |
| ENTITY_CDF_MEANING | VARCHAR(12) | Y | Field to Store the CFD Meaning from Code_Value table; |
| ENTITY_CKI | VARCHAR(255) | Y | Field to Store the CKI from Code_Value table |
| ENTITY_NAME | VARCHAR(40) | Y | Field to Store the Display field from Code_Value table |
| ENTITY_TYPE_TXT | VARCHAR(100) | Y | Field Indicating the Type of Code; Example - possible values are ENCOUNTER_CODE_TYPE or ENCOUNTER_CLASS_TYPE |
| EXCLUDE_IND | DOUBLE | Y | Field to Indicate if the code Value needs to be Excluded from the Extract, Value 1 indicates its excluded |
| LOGICAL_DOMAIN_ID | DOUBLE | Y | 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_CENSUS_EXCLSN_CNFG_ID | DOUBLE | N | PRIMARY KEY |
| UPDT_APPLCTX | DOUBLE | Y | 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 | Y | 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 | Y | 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 | Y | 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 | Y | 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 - RCR_GSR_CENSUS_EXCLSN_CNFG
| Child Column in RCR_GSR_CENSUS_EXCLSN_CNFG(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | CODE_VALUE | CODE_VALUE | CODE_VALUE |
| LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_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 |