QS_API_SG_SRCH (SQL Table)	Index Back
Subgroup lookback search rec Message agent API - search record for retreiving 'N' historical subgroups for analysis, specify a stream, starting subgroup #, and ending subgroup #. The dummy_nk field is on the panel to satisfy the requirement of a non-key field to kick off peoplecode. Scrollselects in peoplecode on the stream_id field do the historical subgroup selection.

QS_API_SG_SRCH

(SQL Table)

Subgroup lookback search rec

Message agent API - search record for retreiving 'N' historical subgroups for analysis, specify a stream, starting subgroup #, and ending subgroup #. The dummy_nk field is on the panel to satisfy the requirement of a non-key field to kick off peoplecode. Scrollselects in peoplecode on the stream_id field do the historical subgroup selection.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STREAM_ID Number(8,0) INTEGER NOT NULL Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).

2 QS_API_STARTING_SG Number(6,0) INTEGER NOT NULL Starting Sgrp Seq #

3 QS_API_ENDING_SG Number(6,0) INTEGER NOT NULL Ending Sgrp Seq #

4 QS_API_DUMMY_NK Character(1) VARCHAR2(1) NOT NULL Non-key field for dummy search records - used to nudge buffer processing via including a non-key field on the panel when using the dummy search records

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STREAM_ID	Number(8,0)	INTEGER NOT NULL	Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
2	QS_API_STARTING_SG	Number(6,0)	INTEGER NOT NULL	Starting Sgrp Seq #
3	QS_API_ENDING_SG	Number(6,0)	INTEGER NOT NULL	Ending Sgrp Seq #
4	QS_API_DUMMY_NK	Character(1)	VARCHAR2(1) NOT NULL	Non-key field for dummy search records - used to nudge buffer processing via including a non-key field on the panel when using the dummy search records