Stage 4 Domain Logging

#FAERS - Domain Level

Simply run stage_4_meta.kjb and it will...

1. Counts the number of records in Legacy LAERS domain tables (ie demo) and also in your comparison database

example log of INDI domain's table having same number of rows as comparison's INDI table:

INDI_LEGACY
7382451 <- DATABASE_NAME
7382451 <- DATABASE_COMPARISON_NAME
INDI_LEGACY PERFECTO!!!

example of your database having extra rows of data in the domain table when compared to the database

DEMO
13440024 <- DATABASE_NAME
12061699 <- DATABASE_COMPARISON_NAME
1378325 EXTRA

...if records missing it will indicate "n MISSING"

2. Counts the number of records in FAERS domain tables (ie demo) and also in your comparison database

example from log of a match of DRUG domain

DRUG
52584088 <- DATABASE_NAME
52584088 <- DATABASE_COMPARISON_NAME
DRUG PERFECTO!!!

3. Compares quarters of domain data

Example results:

RPSR - 14046 - 21 - 1 - identical
RPSR - 13123 - 21 - 2 - identical
^matches
RPS4 - 25933 - 12 - 4 - deleted
RPSR - 25933 - 12 - 4 - new
RPSR - 16855 - 21 - 3 - deleted
RPSR - 4936 - 21 - 4 - deleted
RPSR - 13091 - 22 - 1 - deleted
^differences

Possible flagfields

...generated by the Merge rows (diff) step of the stage_4_**_qtrs.ktr's.

• identical
• changed
• new
• deleted

the "^matches" section in the logged results will only have identical results

the "^differences" section shows "not identical" flagfield results from comparison

(note: a table input with a line break can be merged in to help the visual appearance of the log)

Stage 5 Wiki