





Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
"How many SSIS packages can populate a single table in Caboodle. A. A single SSIS package B. Multiple SSIS packages all from Clarity C. Multiple SSIS packages from multiple sources - CORRECT ANSWER=> A, B, and C" "True or False: The ER Diagram contains information that cannot be found anywhere else in the Cogito Dictionary? - CORRECT ANSWER=> False. The ER Diagram is a visual representation of information that can be found in the dictionary" "Identify the Caboodle table and column for the following data point: Encounter's Epic CSN - CORRECT ANSWER=> EncounterFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point: Type - CORRECT ANSWER=> EncounterFact.Type" "Identify the Caboodle table and column for the following data point: Patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's age in years - CORRECT ANSWER=> DurationDim.YearsDisplayString"
Typology: Quizzes
1 / 9
This page cannot be seen from the preview
Don't miss anything!
"How many SSIS packages can populate a single table in Caboodle. A. A single SSIS package B. Multiple SSIS packages all from Clarity C. Multiple SSIS packages from multiple sources - CORRECT ANSWER=> A, B, and C" "True or False: The ER Diagram contains information that cannot be found anywhere else in the Cogito Dictionary? - CORRECT ANSWER=> False. The ER Diagram is a visual representation of information that can be found in the dictionary" "Identify the Caboodle table and column for the following data point: Encounter's Epic CSN - CORRECT ANSWER=> EncounterFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point: Type - CORRECT ANSWER=> EncounterFact.Type" "Identify the Caboodle table and column for the following data point: Patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's age in years
"Identify the Caboodle table and column for the following data point: The department's name (DEP .2) - CORRECT ANSWER=> DepartmentDim.Name" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The date of the Encounter
"Identify the Caboodle table and column for the following data point: Column in the -Fact table to remove deleted data - CORRECT ANSWER=> MedicationOrderFact._IsDeleted = 0" "Identify the Caboodle table and column for the following data point: The Patient's Epic ID - CORRECT ANSWER=> PatientDim.PatientEpicId" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's zip code - CORRECT ANSWER=> PatientDim.PostalCode" "Identify the Caboodle table and column for the following data point: The patient's phone number - CORRECT ANSWER=> PatientDim.HomePhoneNumber" "Identify the Caboodle table and column for the following data point: The patient's MyChart Status - CORRECT ANSWER=> PatientDim.MyChartStatus" "Identify the Caboodle table and column for the following data point: Column to identify deleted primary care providers - CORRECT ANSWER=> ProviderDim._IsDeleted = 1" "Suppose you're creating a report using EncounterFact and ProviderDim that displays the name of each provider for each encounter. If an encounter's data loads into EncounterFact, but that provider's data hasn't been extracted to ProviderDim, what value would appear in ProviderDim.Name for this encounter? - CORRECT ANSWER=> There would be an inferred row in ProviderDim, therefore ProviderDim.Name would show "*Unknown" for the encounter." "A lookup column in Caboodle contains the value -3. What could this mean? - CORRECT ANSWER=> There are two possibilities: Either the data that once populated this row in Caboodle has been deleted from the source or this is the row with -3 as its primary key, for which all lookup columns are also -3. To know which is true, check the primary key value for the given row: a non-negative value indicates that this row represents deleted data in the source." "If a lookup column is null in Clarity, what will appear in the corresponding column in Caboodle?
"Log into Hyperspace as the Cogito Tools Administrator, open the Patients data model in SlicerDicer, and click Troubleshoot. What is the purpose of the WHERE clause in this data model? - CORRECT ANSWER=> The WHERE clause (WHERE subq.DurableKey > 0) filters out the rows with negative durable key values from PatientDim. Since these rows do not represent actual patients, they should not be included in the total count of patients in the Patients data model." "A row in a Caboodle table has a primary key value of -2. What value will be stored in columns with a data type of "Date" for this row that are not lookup columns? A. - B. NULL C. 12/31/ D. Not Applicable - CORRECT ANSWER=> b. NULL, For the row with a primary key of -2, lookup columns will store a value of -2, string columns will store 'Not Applicable', and all other data type columns will store NULL." "True or False: All inferred rows in Caboodle have a primary key of -1. - CORRECT ANSWER=> False. Inferred rows in Caboodle have non-negative primary key values because they represent an entity that Caboodle has inferred the existence of. The lookup columns for such rows will be set to -1 until the Caboodle ETL process updates the data." "Identify the Caboodle table and column for the following data point: The date the patient arrived at the ED - CORRECT ANSWER=> " "Identify the Caboodle table and column for the following data point: The chief complaints Epic ID - CORRECT ANSWER=> ChiefComplaintBridge.ChiefComplaintEpicId" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The Encounter's Epic CSN
"Identify the Caboodle table and column for the following data point: Days as attending - CORRECT ANSWER=> HospitalAdmissionAttributedProviderDataMart.NumberOfDistinctDaysAsInpatientAttending" "Identify the Caboodle table and column for the following data point: Number of Encounters - CORRECT ANSWER=> HospitalAdmissionAttributedProviderDataMart.HospitalAdmissionKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Administration Date, I LPL 4010 - CORRECT ANSWER=> ImmunizationEventFact.AdministrationDateKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Immunization Name, I LIM .2 - CORRECT ANSWER=> ImmunizationDim.Name" "Identify the Caboodle table and column for the following data point, INI, and Item #: Patient's Age, none - CORRECT ANSWER=> ImmunizationEventFact.AgeKey" "Identify the Caboodle table and column for the following data point, INI, and Item #: Encounter CSN, I EPT 8 - CORRECT ANSWER=> EncounterFact.EncounterEpicCsn" "Identify the Caboodle table and column for the following data point, INI, and Item #: The immunizations in the VCG grouper, I VCG .1 - CORRECT ANSWER=> ImmunizationSetDim.ValueSetEpicId = '1137225'" "Identify the Caboodle table and column for the following data point: The patient's name - CORRECT ANSWER=> PatientDim.Name" "Identify the Caboodle table and column for the following data point: The patient's Epic ID - CORRECT ANSWER=> PatientDim.PatientEpicId" "Identify the Caboodle table and column for the following data point: The attribute's name (HLX .2) - CORRECT ANSWER=> AttributeDim.Name" "Identify the Caboodle table and column for the following data point: The value for the current diet type - CORRECT ANSWER=> PatientAttributeValueDim.Value"
"What two columns do all bridge tables have? - CORRECT ANSWER=> Every bridge table has a ComboKey to which other tables join and a lookup column used to join to its associated dimension table." "Use the Cogito Dictionary to list 3 examples of