QS_PURGE_SG_VW (SQL View)	Index Back
QSPURGE Subgroup view Purge expired session processing - view to merge subgroups w/session header & quality function (app_def) to determine the subgroup's life

QS_PURGE_SG_VW

(SQL View)

QSPURGE Subgroup view

Purge expired session processing - view to merge subgroups w/session header & quality function (app_def) to determine the subgroup's life

SELECT PS_QS_SUBGROUP.SESSN_ID , PS_QS_SESSN_HDR8.STREAM_ROOT_ID , PS_QS_SUBGROUP.STREAM_ID , PS_QS_SUBGROUP.SESSN_STRM_STS , PS_QS_SESSN_HDR8.SESSN_CRE_DTTM , PS_QS_APP_DEF.SCNTL_SESSN_LIFE , PS_QS_SUBGROUP.QS_PURGE_FLAG FROM PS_QS_SESSN_HDR8 , PS_QS_SUBGROUP , PS_QS_STREAM8 , PS_QS_APP_DEF WHERE PS_QS_SESSN_HDR8.SESSN_ID = PS_QS_SUBGROUP.SESSN_ID AND PS_QS_SUBGROUP.STREAM_ID = PS_QS_STREAM8.STREAM_ID AND PS_QS_STREAM8.STREAM_ROOT_ID = PS_QS_SESSN_HDR8.STREAM_ROOT_ID AND PS_QS_STREAM8.QS_APP_CONTEXT = PS_QS_APP_DEF.QS_APP_CONTEXT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SESSN_ID Character(30) VARCHAR2(30) NOT NULL Session ID

2 STREAM_ROOT_ID Number(8,0) INTEGER NOT NULL Stream Root ID - hierarchal structure

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

4 SESSN_STRM_STS Character(4) VARCHAR2(4) NOT NULL Session Stream Status

5 SESSN_CRE_DTTM DateTime(26) TIMESTAMP Date Created

6 SCNTL_SESSN_LIFE Number(3,0) SMALLINT NOT NULL Session Data Life Days

7 QS_PURGE_FLAG Character(1) VARCHAR2(1) NOT NULL Used in QSPURGE processing - temp marker to show if this subgroup has been examined yet by QS_PURGE AE program for purgeworthiness. DOES NOT indicate if it should be purged or not.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SESSN_ID	Character(30)	VARCHAR2(30) NOT NULL	Session ID
2	STREAM_ROOT_ID	Number(8,0)	INTEGER NOT NULL	Stream Root ID - hierarchal structure
3	STREAM_ID	Number(8,0)	INTEGER NOT NULL	Stream ID- hierarchial structure plus characteristic. (or Stream Root ID plus characteristic).
4	SESSN_STRM_STS	Character(4)	VARCHAR2(4) NOT NULL	Session Stream Status
5	SESSN_CRE_DTTM	DateTime(26)	TIMESTAMP	Date Created
6	SCNTL_SESSN_LIFE	Number(3,0)	SMALLINT NOT NULL	Session Data Life Days
7	QS_PURGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used in QSPURGE processing - temp marker to show if this subgroup has been examined yet by QS_PURGE AE program for purgeworthiness. DOES NOT indicate if it should be purged or not.