The TD_SEASONALNORMALIZE function returns two result sets of data. The primary result set contains the computed seasonal normalized values. A secondary (ARTMETADATA) result set contains the mean and standard deviation for each column in the primary (ARTPRIMARY) layer. The secondary layer (ARTMETADATA) is retrieved using TD_EXTRACT_RESULTS.
RETURNS TABLE Schema for the Primary Result Set
The primary result set has the following columns. The results are retrieved using a SELECT statement on the ART produced by the function.| Name | Data Type | Description |
|---|---|---|
| derived-series-identifier | Varies | The resultant series identifier inherited from the SERIES_ID associated with the input. |
| ROW_I | Varies | Index for the result series. Its data type depends on the OUTPUT_FMT:INDEX_STYLE. |
| CYCLE_NO | BIGINT | The sequence number of the cycle period in CYCLE. Only generated when SEASON_INFO is 2 or 3. |
| SEASON_NO | BIGINT | The season number in each cycle in INTERVAL. Only generated when SEASON_INFO is 1 or 3. |
RETURNS TABLE Schema for Secondary Result Set
The secondary result set associated with the ARTMETADATA layer has the following columns:
| Name | Data Type | Description |
|---|---|---|
| derived-series-identifier | VARCHAR | The resultant series identifier inherited from the SERIES_ID. |
| ROW_I | Varies | Index for the ARTMETADATA result series. Data type and values dependent upon the OUTPUT_FMT(INDEX_STYLE()) declaration. |
| MEAN_payload_name | FLOAT | The mean for the season. The payload_name is the same field name that is passed in as the input-payload-fields parameter. |
| SD_payload_name | FLOAT | The standard deviation for a season. The payload_name is the same field name that is passed in as the input-payload-fields parameter. |