[Home] [Help]
View: IGS_AV_ADV_STANDING_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT AAS.ROWID
, AAS.PERSON_ID
, PPV.PERSON_NUMBER
, PPV.ENCUMBERED_IND
, PPV.CONTEXT_BLOCK_NAME
, PPV.SEX
, PPV.BIRTH_DT
, PPV.DECEASED_IND
, AAS.COURSE_CD
, AAS.VERSION_NUMBER
, AAS.TOTAL_EXMPTN_APPROVED
, AAS.TOTAL_EXMPTN_GRANTED
, AAS.TOTAL_EXMPTN_PERC_GRNTD
, AAS.EXEMPTION_INSTITUTION_CD
, AAS.CREATED_BY
, AAS.CREATION_DATE
, AAS.LAST_UPDATED_BY
, AAS.LAST_UPDATE_DATE
, AAS.LAST_UPDATE_LOGIN
FROM IGS_AV_ADV_STANDING AAS
, IGS_PE_PERSON_V PPV
WHERE AAS.PERSON_ID = PPV.PERSON_ID
Columns
| Name |
| ROW_ID |
| PERSON_ID |
| PERSON_NUMBER |
| ENCUMBERED_IND |
| CONTEXT_BLOCK_NAME |
| SEX |
| BIRTH_DT |
| DECEASED_IND |
| COURSE_CD |
| VERSION_NUMBER |
| TOTAL_EXMPTN_APPROVED |
| TOTAL_EXMPTN_GRANTED |
| TOTAL_EXMPTN_PERC_GRNTD |
| EXEMPTION_INSTITUTION_CD |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |