Table Detail Report
RC_F_VAR_CLAIM_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Variance Claim Summary |
| Definition: | Contains the detail data associated to variance for reporting purposes. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_VAR_CLAIM_SMRY
| 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. |
| 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 | N | 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. |
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| ADJUSTED_VARIANCE_AMT | DOUBLE | N | Contains the adjusted original variance dollar amount that has been identified for this fact row. |
| ADJUSTED_VARIANCE_DT_NBR | DOUBLE | N | A number representing the adjusted original variance identified date for this fact row. References the key in the omf_date table. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| APPEAL_CNT | DOUBLE | N | Identifies the total number of appeals related to a specific claim. |
| BILLED_AMT | DOUBLE | N | Contains the dollar amount billed on the claim. |
| CLAIM_NBR_IDENT | VARCHAR(40) | Y | The claim number related to this fact row. |
| CURRENT_VARIANCE_AMT | DOUBLE | N | Contains the current variance dollar amount that has been identified for this fact row. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge date. References the key in the omf_date table. |
| EST_CONTRACTUAL_AMT | DOUBLE | N | Contains the estimated contractual dollar amount on the claim. |
| EST_REIMBURSEMENT_AMT | DOUBLE | N | Contains the estimated reimbursement dollar amount on the claim. |
| FIN_NBR_IDENT | VARCHAR(50) | Y | Contains the financial number alias related to the patient encounter. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_APPEAL_DT_NBR | DOUBLE | N | A number representing the appeal action code date for this fact row. References the key in the omf_date table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| LAST_VAR_ACTIVITY_DT_NBR | DOUBLE | N | Stores the equivalent date number for the last date/time that the variance activity occurred. |
| MILL_CORSP_ID | DOUBLE | N | Number that identifies the row in the Bill_Rec Millennium database table from which this row was derived. |
| MILL_PFT_QUEUE_ITEM_ID | DOUBLE | N | Identifies the millennium related queue item for which the history data on the ID was derived. |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of a medical record number. |
| ORIGINAL_VARIANCE_AMT | DOUBLE | N | Contains the first variance dollar amount that has been identified for this fact row. |
| ORIG_VARIANCE_DT_NBR | DOUBLE | N | A number representing the first variance identified date for this fact row. References the key in the omf_date table. |
| PATIENT_RESPONSIBILITY_AMT | DOUBLE | N | Contains the patient responsibility dollar amount on the claim. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies information about the billing property related to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies the denial alias dimension row that is related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class information related to this fact row. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies information about the primary financial class related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan related to this fact row. |
| RC_D_VARIANCE_ACTION_ID | DOUBLE | N | Uniquely identifies information about the variance attributes related to this fact row. |
| RC_D_VARIANCE_ORIGIN_ID | DOUBLE | N | Uniquely identifies the related RC_D_VARIANCE_ORIGIN row. |
| RC_D_VARIANCE_PROPERTY_ID | DOUBLE | N | Uniquely identifies information about the variance attributes related to this fact row. |
| RC_F_VAR_CLAIM_SMRY_ID | DOUBLE | N | Uniquely identifies detail data associated to variance for reporting purposes. |
| RECOVERY_AMT | DOUBLE | N | Contains the recovery dollar amount on the claim. |
| SELF_PAY_BALANCE_AMT | DOUBLE | N | Contains the last self pay balance dollar amount for this fact row. |
| SHR_D_ACTION_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this fact row. |
| SHR_D_PATIENT_ID | DOUBLE | N | Uniquely identifies the patient related to this fact row. |
| SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the location of the patient. |
| SHR_D_QUEUE_PERSON_ID | DOUBLE | N | Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow. |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Contains the total adjustment dollar amount for this claim. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total payment dollar amount for this claim. |
| 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 - RC_F_VAR_CLAIM_SMRY
| Child Column in RC_F_VAR_CLAIM_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| ADJUSTED_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| ADMIT_DT_NBR | OMF_DATE | DT_NBR | |
| DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_APPEAL_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_VAR_ACTIVITY_DT_NBR | OMF_DATE | DT_NBR | |
| ORIG_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_BILL_PROPERTY_ID | RC_D_BILL_PROPERTY | RC_D_BILL_PROPERTY_ID | |
| RC_D_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_DENIAL_ALIAS_ID | RC_D_DENIAL_ALIAS | RC_D_DENIAL_ALIAS_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_FINANCIAL_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_VARIANCE_ACTION_ID | RC_D_VARIANCE_ACTION | RC_D_VARIANCE_ACTION_ID | |
| RC_D_VARIANCE_ORIGIN_ID | RC_D_VARIANCE_ORIGIN | RC_D_VARIANCE_ORIGIN_ID | |
| RC_D_VARIANCE_PROPERTY_ID | RC_D_VARIANCE_PROPERTY | RC_D_VARIANCE_PROPERTY_ID | |
| SHR_D_PATIENT_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ACTION_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PATIENT_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_QUEUE_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_F_VAR_LINE_ITEM_SMRY
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Fact Variance Line Item Summary |
| Definition: | Contains the detail data associated to variance for reporting purposes. |
| Table Type: | ACTIVITY |
Column Detail - RC_F_VAR_LINE_ITEM_SMRY
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DT_NBR | DOUBLE | N | A number representing the activity date. References the key in the OMF_DATE table. |
| ADJUSTED_VARIANCE_AMT | DOUBLE | N | Contains the adjusted original variance dollar amount that has been identified for this fact row. |
| ADJUSTED_VARIANCE_DT_NBR | DOUBLE | N | A number representing the adjusted original variance identified date for this fact row. References the key in the omf_date table. |
| ADMIT_DT_NBR | DOUBLE | N | A number representing the admit date. References the key in the OMF_DATE table. |
| APPEAL_CNT | DOUBLE | N | Identifies the total number of appeals related to a specific claim. |
| CLAIM_BILLED_AMT | DOUBLE | N | Contains the dollar amount billed on the claim. |
| CLAIM_NBR_IDENT | VARCHAR(40) | Y | The claim number related to this fact row. |
| CLAIM_SERVICE_ITEM_IDENT | VARCHAR(50) | N | The claim service item related to this fact row. |
| CURRENT_VARIANCE_AMT | DOUBLE | N | Contains the current variance dollar amount that has been identified for this fact row. |
| DISCHARGE_DT_NBR | DOUBLE | N | A number representing the discharge date. References the key in the omf_date table. |
| EST_CONTRACTUAL_AMT | DOUBLE | N | Contains the estimated contractual dollar amount on the claim. |
| EST_REIMBURSEMENT_AMT | DOUBLE | N | Contains the estimated reimbursement dollar amount on the claim. |
| FIN_NBR_IDENT | VARCHAR(50) | Y | Contains the financial number alias related to the patient encounter. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_APPEAL_DT_NBR | DOUBLE | N | A number representing the appeal action code date for this fact row. References the key in the omf_date table. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| LAST_VAR_ACTIVITY_DT_NBR | DOUBLE | N | Stores the equivalent date number for the last date/time that the variance activity occurred. |
| MILL_CORSP_ID | DOUBLE | N | Identifies the related row in the BILL_REC table in the millennium database from which the data for this table was derived. |
| MILL_PFT_QUEUE_ITEM_ID | DOUBLE | N | Identifies the millennium related queue item for which the history data on the ID was derived. |
| MRN_NBR_IDENT | VARCHAR(50) | Y | Identifier of a medical record number. |
| ORIGINAL_VARIANCE_AMT | DOUBLE | N | Contains the first variance dollar amount that has been identified for this fact row. |
| ORIG_VARIANCE_DT_NBR | DOUBLE | N | A number representing the first variance identified date for this fact row. References the key in the omf_date table. |
| PATIENT_RESPONSIBILITY_AMT | DOUBLE | N | Contains the patient responsibility dollar amount on the claim. |
| RC_D_BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the billing entity related to this fact row. |
| RC_D_BILL_PROPERTY_ID | DOUBLE | N | Uniquely identifies information about the billing property related to this fact row. |
| RC_D_BILL_TYPE_ID | DOUBLE | N | Uniquely identifies the bill type related to this fact row. |
| RC_D_DENIAL_ALIAS_ID | DOUBLE | N | Uniquely identifies the denial alias dimension row that is related to this fact row. |
| RC_D_ENCNTR_TYPE_CLASS_ID | DOUBLE | N | Uniquely identifies the encounter type class information related to this fact row. |
| RC_D_FINANCIAL_CLASS_ID | DOUBLE | N | Uniquely identifies information about the primary financial class related to this fact row. |
| RC_D_HEALTH_PLAN_ID | DOUBLE | N | Uniquely identifies the health plan related to this fact row. |
| RC_D_VARIANCE_ACTION_ID | DOUBLE | N | Uniquely identifies information about the variance attributes related to this fact row. |
| RC_D_VARIANCE_ORIGIN_ID | DOUBLE | N | Uniquely identifies the related RC_D_VARIANCE_ORIGIN row. |
| RC_D_VARIANCE_PROPERTY_ID | DOUBLE | N | Uniquely identifies information about the variance attributes related to this fact row. |
| RC_F_VAR_LINE_ITEM_SMRY_ID | DOUBLE | N | Uniquely identifies detail data associated to variance for reporting purposes. |
| RECOVERY_AMT | DOUBLE | N | Contains the recovery dollar amount on the claim. |
| SELF_PAY_BALANCE_AMT | DOUBLE | N | Contains the last self pay balance dollar amount for this fact row. |
| SHR_D_ACTION_PERSON_ID | DOUBLE | N | Uniquely identifies the person related to this fact row. |
| SHR_D_PATIENT_ID | DOUBLE | N | Uniquely identifies the patient related to this fact row. |
| SHR_D_PATIENT_LOCATION_ID | DOUBLE | N | Uniquely identifies the location of the patient. |
| SHR_D_QUEUE_PERSON_ID | DOUBLE | N | Uniquely identifies the person to whom the responsible financial encounter balance is assigned in a workflow. |
| TOTAL_ADJUSTMENT_AMT | DOUBLE | N | Contains the total adjustment dollar amount for this claim. |
| TOTAL_PAYMENT_AMT | DOUBLE | N | Contains the total payment dollar amount for this claim. |
| 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 - RC_F_VAR_LINE_ITEM_SMRY
| Child Column in RC_F_VAR_LINE_ITEM_SMRY(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | ACTIVITY_DT_NBR | OMF_DATE | DT_NBR |
| ADJUSTED_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| ADMIT_DT_NBR | OMF_DATE | DT_NBR | |
| DISCHARGE_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_APPEAL_DT_NBR | OMF_DATE | DT_NBR | |
| LAST_VAR_ACTIVITY_DT_NBR | OMF_DATE | DT_NBR | |
| ORIG_VARIANCE_DT_NBR | OMF_DATE | DT_NBR | |
| RC_D_BILLING_ENTITY_ID | RC_D_BILLING_ENTITY | RC_D_BILLING_ENTITY_ID | |
| RC_D_BILL_PROPERTY_ID | RC_D_BILL_PROPERTY | RC_D_BILL_PROPERTY_ID | |
| RC_D_BILL_TYPE_ID | RC_D_BILL_TYPE | RC_D_BILL_TYPE_ID | |
| RC_D_DENIAL_ALIAS_ID | RC_D_DENIAL_ALIAS | RC_D_DENIAL_ALIAS_ID | |
| RC_D_ENCNTR_TYPE_CLASS_ID | RC_D_ENCNTR_TYPE_CLASS | RC_D_ENCNTR_TYPE_CLASS_ID | |
| RC_D_FINANCIAL_CLASS_ID | RC_D_FINANCIAL_CLASS | RC_D_FINANCIAL_CLASS_ID | |
| RC_D_HEALTH_PLAN_ID | RC_D_HEALTH_PLAN | RC_D_HEALTH_PLAN_ID | |
| RC_D_VARIANCE_ACTION_ID | RC_D_VARIANCE_ACTION | RC_D_VARIANCE_ACTION_ID | |
| RC_D_VARIANCE_ORIGIN_ID | RC_D_VARIANCE_ORIGIN | RC_D_VARIANCE_ORIGIN_ID | |
| RC_D_VARIANCE_PROPERTY_ID | RC_D_VARIANCE_PROPERTY | RC_D_VARIANCE_PROPERTY_ID | |
| SHR_D_PATIENT_LOCATION_ID | SHR_D_LOCATION | SHR_D_LOCATION_ID | |
| SHR_D_ACTION_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_PATIENT_ID | SHR_D_PERSON | SHR_D_PERSON_ID | |
| SHR_D_QUEUE_PERSON_ID | SHR_D_PERSON | SHR_D_PERSON_ID |
RC_GSR_DIMENSION_TMP
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Gold Standard Reporting Dimension Temporary |
| Definition: | This table is used by the GSR dimension load process to identify the distinct set of rows in each of the dimension tables which must be inserted or updated during the current job execution. This table does not need a unique PK value or associated index. |
| Table Type: | ACTIVITY |
Column Detail - RC_GSR_DIMENSION_TMP
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| BATCH_ID | DOUBLE | N | A sequential batch identifier assigned to a group of rows inserted into this table by the GSR dimension load process for the logical_domain_id in which the process is being executed. |
| DIM_INDEX | DOUBLE | N | This field is an index into the recDWItems structure that is used by the GSR dimension load process to access the parameters needed to process the loading of data for each dimension table |
| INSERT_IND | DOUBLE | N | This field will be set to 0 if the dimension row related to this row already exists and must be updated, or 1 if a new row will need to be inserted. |
| 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. |
| LONG_TEXT_MD5_HASH_TXT | VARCHAR(32) | N | This field is a unique identifier based on the value of the long_text string that is linked to the referenced rc_cln_area row. While rc_cln_area may include large numbers of rows that reference the same dimension row, only one row will be inserted into this table for each distinct dimension row based on the value of this column. |
| RCR_GSR_CONTEXT_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCR_GSR_CONTEXT table. |
| RC_CLN_AREA_ID | DOUBLE | N | This is the primary key of a row on the rc_cln_area staging table. |
| RC_DIMENSION_ID | DOUBLE | N | This field is a numeric identifier that is associated with each GSR dimension table. The specific values assigned to each dimension table are defined in the pft_load_dw.inc include file. |
Relationship Detail - RC_GSR_DIMENSION_TMP
| Child Column in RC_GSR_DIMENSION_TMP(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RCR_GSR_CONTEXT_ID | RCR_GSR_CONTEXT | RCR_GSR_CONTEXT_ID |
RC_GSR_SUM_AGG_TMP
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Revenue Cycle Gold Standard Reporting Summary Aggregate Temporary |
| Definition: | This tables is used in the GSR summarization process to control the distributed summarization of data based on all possible values of an extract-specific dimension. |
| Table Type: | ACTIVITY |
Column Detail - RC_GSR_SUM_AGG_TMP
| Column Name | Type | Null? | Definition |
|---|---|---|---|
| ACTIVITY_DATE | DOUBLE | N | The date for which activity data is to be summarized. |
| AGGREGATE_INFO | VARCHAR(250) | N | This is a delimited string that defines the names of the source activity table, the column in that table containing the dimension id found in the attribute_value and the name of the dimension table for which this value represents the primary key. |
| ATTRIBUTE_VALUE | DOUBLE | N | The value of a specific dimension id by which activity data is to be summarized. This value may be 0.0 to allow summarization to occur for activity data for which there is no related dimension row. See the aggregate_info column for information defining which dimension table is referenced, what it's primary key column name is, and what the name of the activity table being summarized is. |
| LOAD_SCRIPT_NAME | VARCHAR(32) | N | The name of the load script that is responsible for summarizing the data associated with this row. |
| 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 | Uniquely identifies the related GSR Context Identifier |
| TEMP_ID | DOUBLE | N | A sequential identifier for the rows that are inserted by the GSR summary load process for the logical_domain_id in which the process is being executed. |
Relationship Detail - RC_GSR_SUM_AGG_TMP
| Child Column in RC_GSR_SUM_AGG_TMP(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | RCR_GSR_CONTEXT_ID | RCR_GSR_CONTEXT | RCR_GSR_CONTEXT_ID |
SHR_D_LOCATION
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Shared Dimension Location |
| Definition: | This table contains location information such as facility and building name. |
| Table Type: | REFERENCE |
Column Detail - SHR_D_LOCATION
| 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. |
| BED | VARCHAR(40) | N | The bed associate with a location. |
| 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. |
| BUILDING | VARCHAR(40) | N | The building associated with a location. |
| 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 | VARCHAR(40) | N | The facility associated with a location. |
| FIRST_PROCESS_DT_TM | DATETIME | N | The date/time that the first ETL process started that created this record. |
| LAST_PROCESS_DT_TM | DATETIME | N | The date/time that the last ETL process started that updated this record. |
| LOCATION_DESC | VARCHAR(40) | N | The current permanent location of the patient (The location of a patient will be valued with the lowest level location type in the hierarchy of facility, building, room, bed). |
| LOCATION_MD5_HASH_TXT | VARCHAR(32) | N | This column contains an MD5 hash code based upon the combined values of the LOCATION_DESC, FACILITY, BUILDING, ROOM, BED, MILL_LOGICAL_DOMAIN_ID and ACTIVE_IND columns. |
| MILL_LOGICAL_DOMAIN_ID | DOUBLE | N | Uniquely identifies the logical domain to which the row data belongs. |
| ROOM | VARCHAR(40) | N | The room associated with a location. |
| SHR_D_LOCATION_ID | DOUBLE | N | Uniquely identifies location information such as facility and building name. |
| 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 - SHR_D_LOCATION
| Parent Column in SHR_D_LOCATION (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | SHR_D_LOCATION_ID | RC_F_ADJUSTMENT | SHR_D_PATIENT_LOCATION_ID |
| RC_F_BALANCE_AR | SHR_D_LOCATION_ID | ||
| RC_F_CASE_MIX | SHR_D_LOCATION_ID | ||
| RC_F_CASH | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_CLAIM_EVENT | SHR_D_LOCATION_ID | ||
| RC_F_CODING_ACTIVITY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_BAL_AR_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_CDM_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_CENSUS | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_CENSUS_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_CLAIM_EVENT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_ENCNTR_VISIT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DAILY_TRANS_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_DENIAL | SHR_D_LOCATION_ID | ||
| RC_F_DLY_CHRG_ASSOC_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_DLY_CODING_ACT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_INVOICE_AR_BALANCE | SHR_D_LOCATION_ID | ||
| RC_F_MONTHLY_CDM_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_MONTHLY_CENSUS_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_MONTHLY_CLAIM_EVENT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_MONTHLY_ENCNTR_VISIT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_MONTHLY_TRANS_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_MTH_CHRG_ASSOC_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_MTH_CODING_ACT_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_PATIENT_AR_BALANCE | SHR_D_LOCATION_ID | ||
| RC_F_PATIENT_AR_BAL_SMRY | SHR_D_LOCATION_ID | ||
| RC_F_REVENUE | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_REVENUE | SHR_D_PERFORMING_LOCATION_ID | ||
| RC_F_VARIANCE | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_VAR_CLAIM_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
| RC_F_VAR_LINE_ITEM_SMRY | SHR_D_PATIENT_LOCATION_ID | ||
| SHR_F_ENCOUNTER_VISIT | SHR_D_LOCATION_ID |