[Home] [Help]
View: IGS_PE_ID_GROUP_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT GM.ROWID ROW_ID
, GM.PERSON_ID
, GM.GROUP_ID
, PG.GROUP_CD
, PG.DESCRIPTION
, PG.FULL_NAME
, PG.CREATE_DT
, PG.CLOSED_IND
, GM.START_DATE
, GM.END_DATE
, GM.CREATED_BY
, GM.CREATION_DATE
, GM.LAST_UPDATED_BY
, GM.LAST_UPDATE_DATE
, GM.LAST_UPDATE_LOGIN
FROM IGS_PE_PRSID_GRP_MEM GM
, IGS_PE_PERSID_GROUP_V PG
WHERE GM.GROUP_ID = PG.GROUP_ID
Columns
| Name |
| ROW_ID |
| PERSON_ID |
| GROUP_ID |
| GROUP_CD |
| DESCRIPTION |
| FULL_NAME |
| CREATE_DT |
| CLOSED_IND |
| START_DATE |
| END_DATE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |