[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PG.ROWID ROW_ID
, PG.GROUP_ID
, PG.GROUP_CD
, DECODE(PG.FILE_NAME
, NULL
, 'STATIC'
, 'DYNAMIC') GROUP_TYPE
, PG.CREATOR_PERSON_ID
, PG.DESCRIPTION
, PG.CLOSED_IND
, PG.COMMENTS
, PE.FULL_NAME
, PE.PERSON_NUMBER CREATOR_PERSON_NUMBER
, PG.FILE_NAME
, PG.CREATE_DT
, PG.CREATED_BY
, PG.CREATION_DATE
, PG.LAST_UPDATED_BY
, PG.LAST_UPDATE_DATE
, PG.LAST_UPDATE_LOGIN
, PG.ATTRIBUTE_CATEGORY
, PG.ATTRIBUTE1
, PG.ATTRIBUTE2
, PG.ATTRIBUTE3
, PG.ATTRIBUTE4
, PG.ATTRIBUTE5
, PG.ATTRIBUTE6
, PG.ATTRIBUTE7
, PG.ATTRIBUTE8
, PG.ATTRIBUTE9
, PG.ATTRIBUTE10
, PG.ATTRIBUTE11
, PG.ATTRIBUTE12
, PG.ATTRIBUTE13
, PG.ATTRIBUTE14
, PG.ATTRIBUTE15
, PG.ATTRIBUTE16
, PG.ATTRIBUTE17
, PG.ATTRIBUTE18
, PG.ATTRIBUTE19
, PG.ATTRIBUTE20 FROM IGS_PE_PERSID_GROUP_ALL PG
, IGS_PE_PERSON_BASE_V PE
WHERE PE.PERSON_ID = PG.CREATOR_PERSON_ID