TD_ROC Output - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

Output Table Schema

If the OutputTable is given in OUT clause:

Column Data Type Description
Model_id VARCHAR, CHAR, SMALLINT, BIGINT, INTEGER The model identifier or partition for ROC curve associated with observation. The column is not displayed if you do not provide the ModelIdColumn syntax element.
Threshold REAL The threshold at which function classifies an observation as positive.
TPR REAL The TPR for the threshold. Calculated as:

The number of observations correctly predicted as positive based on the threshold divided by the number of positive observations.

FPR REAL The FPR for threshold. Calculated as:

The number of observations incorrectly predicted as positive based on the threshold divided by the number of negative observations.

Output Table Schema

If the GINI or AUC syntax element is set to 'True':

Column Data Type Description
AUC REAL The area under the ROC curve for data in the partition. The column is not displayed if the AUC syntax element is false.
GINI REAL GINI coefficient for ROC curve for data in the partition. The column is not displayed if the GINI syntax element is false.