[Home] [Help]
View: IGS_AS_GPC_PE_ID_GRP_V
Product: | IGS - Student System |
Description: | Holds the grading period information for a person ID group |
Implementation/DBA Data: |
APPS.IGS_AS_GPC_PE_ID_GRP_V
|
View Text
SELECT GPG.ROWID ROW_ID
, GPG.GPC_PE_GRP_ID GPC_PE_GRP_ID
, GPG.GRADING_PERIOD_CD GRADING_PERIOD_CD
, LKUP.MEANING GRADING_PERIOD
, GPG.GROUP_ID GROUP_ID
, PIDG.GROUP_CD GROUP_CD
, PIDG.DESCRIPTION GROUP_DESCRIPTION
, GPG.CREATED_BY CREATED_BY
, GPG.CREATION_DATE CREATION_DATE
, GPG.LAST_UPDATED_BY LAST_UPDATED_BY
, GPG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GPG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_GPC_PE_ID_GRP GPG
, IGS_LOOKUPS_VIEW LKUP
, IGS_PE_PERSID_GROUP_V PIDG
WHERE GPG.GRADING_PERIOD_CD = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'AS_GRADING_PERIOD'
AND GPG.GROUP_ID = PIDG.GROUP_ID
Columns
Name |
ROW_ID |
GPC_PE_GRP_ID |
GRADING_PERIOD_CD |
GRADING_PERIOD |
GROUP_ID |
GROUP_CD |
GROUP_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |