The Reporting has the following two changes at the database level:
- For BRWdocument table in Reporting database:
- A new column "ADDITIONALTABLEENGINE" has been added. This contains the engine name which is a predetermined value i.e. "CTE" in case CTE is enabled in Chain Table Extraction Settings in SCM while processing the document. Using this option all the documents can be identified which have used CTE as table engine for coursework table.
- For BRWdistillerFields in Reporting database:
- A new column "ADDITIONALTTECANDIDATE" has been added which contains the old data before merging CTE and TTE data. Therefore, this column will display only TTE records.
- For the existing columns in BRWdistillerFields:
-
-
CONTENTRTS: This column contains the values before CTE-TTE merging. This is the value determined by the TTE engine.
-
CONTENTV: This column contains the values after the verification process is complete and before export. For example, if a verifier corrects a value then the new value will be displayed in CONTENTV.
-
DETAIL: In case CTE is enabled the description will be appended with CTECol, CTEHS or CTEHSNoSem based on the table that got used by CTE while extraction. For manual descriptions, no suffix will be added.
-
| "Description" field values | When |
|---|---|
| "Automatic CTECol" / "Semi-Automatic CTECol" | For college transcripts. |
| "Automatic CTEHS" / "Semi-Automatic CTEHS" | For High School documents when CTEHSCoursework table got used to extract data by CTE engine. |
| "Automatic CTEHSNoSem" / "Semi-Automatic CTEHSNoSem" | For High School documents when CTEHSNoSemCoursework table got used to extract data by CTE engine. |