What database does the data dictionary connect to?
100
A dependent table must always have the same primary columns as the parent.
What is the requirement for an identifying relationship?
100
14
How many steps are in the electronic adjudication process?
100
Batch - 0
All batches should end successfully with which return code?
100
These batch print tables are not truncated.
Why is the prefix for the batch print tables CMC?
200
Regions directory
Where are all the regions specified on the system housed?
200
CMC, CDS, CER
What are the 3 most common table prefixes?
200
Facets only security on the password
The administrative user for the Job Manager is required to have:
200
Procedure file/book
Which file does the runbook/file call during the batch process?
200
CMC_NWST_NET_SET
What table links a provider to a plan?
300
Indicates values in the field are user-defined
What does MCTR in an attribute name indicate?
300
XXX_LOCK_TOKEN and ATXR_SOURCE_ID
What 2 table columns are the most common?
300
ErCmcRunElig
What batch job is run to update members' eligibility?
300
CMC_MCTR_CD_TRANS
On what table are user-defined values stored?
300
ErCmcRunClmu - 01
When a claim goes through adjudication and passes all steps without errors the last step changes the CLST to what status code?
400
Data type of the most common field is DATETIME.
What is the data type of ATXR_SOURCE_ID?
400
Facets doesn’t like blank dates in the database?
9999-12-31 00:00:00.000?
2199-12-13 00:00:00.000
1753-01-01 00:00:00.000
1920-01-01 00:00:00.000
How does Facets handle dates?
400
Customer Exchange
Where can you learn about batch processing?
400
Batch
CLAIMS tables - during ErCmcRunXc00
The Facets XC database contains tables only relevant to which data models?
400
ErCmcRunCkmm - CMC_CLOV_OVERPAY
When a claim is adjusted for an overpayment, which table is updated with data showing the overpaid amount?
500
Facets designed internal identifier for a unique record used when a table has multiple columns as the primary key and is linked to multiple other tables.
What is the purpose of the contrived key?
500
ErWin version 7.2.8
What diagramming tool does TriZetto use?
500
preprocessing, multi-engine, cleanup
Which of the following describes the correct order for multi-engine batch processing?