Data Table
CDSDD501.mdb
What database does the data dictionary connect to?
This database contains mostly claims tables.
What is the XC database?
14
How many steps are in the electronic adjudication process?
Batch - 0
All batches should end successfully with which return code?
These batch print tables are not truncated.
Why is the prefix for the batch print tables CMC?
A dependent table must have the same primary columns of the parent table.
What is the requirement for an identifying relationship?
CMC, CDS, CER
What are the 3 most common table prefixes?
Facets only security on the password
What is the administrative user for the Job Manager is required to have?
Queue
What is the subset of the total of unprocessed data for an engine to process?
The go to resource for all questions about Facets.
What is the Customer Exchange?
Table where user-defined field values exist
What is the CMC_MCTR_CD_TRANS table?
preprocessing, multi-engine, cleanup
What describes the correct order for multi-engine batch processing?
Regions Directory
Where are all the regions specified on the system housed?
ErCmcRunClmu - 01
When a claim goes through adjudication and passes all steps without errors the last step changes the CLST to what status code?
Data type of this most common field is DATETIME.
What is the data/attribute type of the field/column ATXR_SOURCE_ID?
12/31/9999 00:00:00.000 12/31/2199 00:00:00.000 01/01/1753 00:00:00.000 01/01/1920 00:00:00.000
What are the default dates and time for Facets?
Step 4100
For ErCmcRunCkmm, if an error occurs in step 5500, in which step must it be restarted?
2 of these exist in this check processing batch job to make it perform as robustly as possible while processing claims and producing checks
How many multi-engine steps are there in ErCmcRunCkmm?
CMC_CLOV_OVERPAY
When a claim is adjusted for an overpayment, which table is updated with data showing the overpaid amount?
Internal identifier for a unique record.
What is the purpose of the contrived key?
CMC_NWST_NET_SET
What table links a provider to a plan?
Steps 2250 and 5450 need to be bypassed
Which steps need to be bypassed in ErCmcRunClmu if Workflow is not being used/enabled for claims?
CMC_PDDS_PROD_DESC - in the PDDS_PREM_IND column
On what table is billing first configured?
interactive clients, database servers, application servers
What elements are required for the Facets core environment?