Data Population and Output Tables

This topic provides information on how data is populated in the tables:

1. During Job 2, the data is bucketed and processed by using the match rule sets.
2. The output is initially written into the dynamic tables. This is referenced by the V_CANDIDATES_OUTPUT_TABLE column in FCC_MR_CANDIDATE_STATUS. The following query can be used to fetch these tables:

   SELECT * FROM FCC_MR_CANDIDATE_STATUS
   
   WHERE N_MASTER_SEQ IN
   
   (SELECT N_MASTER_SEQ FROM FCC_MR_CANDIDATE_MASTER_PREP
   
   WHERE N_RUN_SKEY IN (SELECT MAX(N_RUN_SKEY) AS N_RUN_SKEY FROM FCC_M_PIPELINE_BATCH_RUN)
   
   );

3. The selected candidate data is then moved to the FCC_MR_SELECTED_CANDIDATES and then to the FCC_MR_MATCHED_RESULTS tables
4. After populating the tables (FCC_MR_SELECTED_CANDIDATES and FCC_MR_MATCHED_RESULTS) the same output dynamics table is used to populate the FCC_ER_MATCHING and FCC_ER_MANUAL_MATCH tables based on match rules and scores.
5. All the output and tracking tables are located in the ER schema.