[Home] [Help]
View: IGSFV_DYN_PERSON_GROUP_SQLS
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains information about the SQLs of a dynamic person group. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PDS.FILE_NAME
, PDS.SEG_SEQUENCE_NUM
, PDS.SQL_SEGMENT
, PGA.GROUP_CD
, PGA.DESCRIPTION
, PDS.SQLSEGS_ID
, PDS.CREATION_DATE
, PDS.CREATED_BY
, PDS.LAST_UPDATED_BY
, PDS.LAST_UPDATE_DATE
FROM IGS_PE_DYN_SQLSEGS PDS
, IGS_PE_PERSID_GROUP_ALL PGA
WHERE PDS.FILE_NAME=PGA.FILE_NAME WITH READ ONLY
Columns
Name |
FILE_NAME |
SEG_SEQUENCE_NUM |
SQL_SEGMENT |
GROUP_CODE |
GROUP_DESCRIPTION |
SQLSEGS_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |