Column Name | Data Type | Is Key | Short description |
TableProcessKey | int | | Surrogate primary key |
PkgExecKey | int | | Foreign key to AuditPkgExecution |
TableName | varchar | | Table name |
ExtractRowCnt | int | | Count of rows extracted from the source |
ExtractCheckValue1 | float | | Check value of ETL designer's choice, eg Sum(SalesAmt), upon extract |
ExtractCheckValue2 | float | | Check value of ETL designer's choice, eg Max(SalesAmt), upon extract |
InsertStdRowCnt | int | | Count of rows inserted into target using standard processing |
InsertStdCheckValue1 | float | | Check value of ETL designer's choice, eg Sum(SalesAmt), upon standard insert |
InsertStdCheckValue2 | float | | Check value of ETL designer's choice, eg Max(SalesAmt), upon standard insert |
InsertNonstdRowCnt | int | | Count of rows inserted into target using a non-standard branch of the ETL system |
InsertNonstdCheckValue1 | float | | Check value of ETL designer's choice, eg Sum(SalesAmt), upon non-standard insert |
InsertNonstdCheckValue2 | float | | Check value of ETL designer's choice, eg Max(SalesAmt), upon non-standard insert |
UpdateRowCnt | int | | Count of rows updated in target table |
ErrorRowCnt | int | | Count of error rows not inserted into table |
TableInitialRowCnt | int | | Initial row count of target table, pre-processing |
TableFinalRowCnt | int | | Final row count of target table, post processing |
SuccessfulProcessingInd | char | | Did this table finish processing successfully? |