[Home] [Help]
View: IGS_PE_ALL_PERSID_GROUP_V
Product: | IGS - Student System (Obsolete) |
Description: | New View which is the union of the existing Static Person ID table and New proposed Dynamic Person ID table |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PPG.ROW_ID
, PPG.GROUP_ID
, PPG.GROUP_TYPE
, 0
, NULL
, PPG.GROUP_CD
, PPG.CREATOR_PERSON_ID
, PPG.DESCRIPTION
, PPG.CLOSED_IND
, PPG.COMMENTS
, PPG.CREATED_BY
, PPG.CREATION_DATE
, PPG.LAST_UPDATED_BY
, PPG.LAST_UPDATE_DATE
, PPG.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSID_GROUP_V PPG
Columns
Name |
ROW_ID |
GROUP_ID |
GROUP_TYPE |
SEGMENT_SEQUENCE |
SQL_SEGMENT |
GROUP_CD |
CREATOR_PERSON_ID |
DESCRIPTION |
CLOSED_IND |
COMMENTS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |