CPT
The CPT dimension table contains all of the CPT Codes that have been billed within the organization and is used for monthly reporting and provider-level budgeting.
The following table lists all of the options available in this dimension table:
| Column | Description |
|---|---|
| CPT | The CPT code used in Axiom Budgeting and Performance Reporting. This must be an alpha code, so a C is prefixed during the import process. |
| Description | Identifies the CPT description to use for budgeting and reporting. |
| KHABgtCode | The code to equal the preferred budget level. Examples include LAB, RAD, SURG, and so on. All values in this column must be in the CPT column. |
| KHAInt |
Used during the budget creation process. Valid entries include the following:
|
| GLRevAcct | The GL Revenue Account to transfer Provider Revenue to the Stat_Rev sheet. This can also be defined by FinClass. If FinClass is used, the default should be 0 (zero). Do not leave blanks. |
| GLEncAcct | The GL Statistic Account to transfer Encounters to the Stat_Rev sheet. For non-Encounter codes, he default should be 0 (zero). Do not leave blanks. |
| GLVisAcct | The GL Statistic Account to transfer Visits to the Stat_Rev sheet. For non-Visit codes, he default should be 0 (zero). Do not leave blanks. |
| GLWRVUAcct | The GL Statistic Account to transfer Provider WRVUs to the Stat_Rev sheet. For codes without a WRVU, he default should be 0 (zero). Do not leave blanks. |
| Group1 | A hierarchical grouping column to group CPTs (variable column) |
| ReportDescription | Concatenation of the CPT column and Description column. |
| GLRVUAcct | The GL Statistic Account to transfer Provider RVUs to the Stat_Rev sheet. For codes without an RVU, he default should be 0 (zero). Do not leave blanks. |
| Group2 | A hierarchical grouping column to group CPTs (variable column) |
| GLProAcct | The GL Statistic Account to transfer Provider Procedures to the Stat_Rev sheet. For codes without a procedure, he default should be 0 (zero). Do not leave blanks. |
| Group3 | A hierarchical grouping column to group CPTs (variable column) |
| Group4 | A hierarchical grouping column to group CPTs (variable column) |
| KeyStat |
Used via utility to summarize CPT volume and post to the financial data tables. Valid options are Yes or No. To summarize all of the Yes codes as monthly key stats, use the Summarize Provider Statistics to Financial utility. This utility is available in Axiom Budgeting and Performance Reporting in the Bud Admin task pane in Budget Reporting > Budget Utilities > Provider Utilities > Statistics. |
| Group5 | A hierarchical grouping column to group CPTs (variable column) |
| RVU | Used via utility to adjust volume during summarization prior to posting to the financial tables. This utility is available in Axiom Budgeting and Performance Reporting in the Bud Admin task pane, in Budget Reporting > Budget Utilities > Provider Utilities > Statistics. |
| Type | Used during the import process to summarize CPT codes for Visits Counts. Can also be used for reporting on types such as Visits, Lab, Radiology, Surgery, and so on. If summarizing CPT codes for Visit counts, the type must be Visit. The default value is NA. |
| RFCPT | Used to identify the CPT codes for Axiom Rolling Forecast. |
| KHABgtCodeSum |
Used to configure the CPT codes for the Provider Summary option. While any existing CPT Code can be used, the intent is to combine all CPT codes to one value such as AllCodes. The value selected will be the value used to build and process the Provider tab in a plan file. NOTE: Use only one value in this column since all CPT codes will summarize to one row in the plan file. |
| DKHABgtCode | Used to identify the DKHA budget codes. |
| ServiceLine | The name of the service line |
| SubServiceLine | The name of line of service (level above ServiceLine) |
| ServiceLineGroup | The name of line of service (level above ServiceLine) |
