[Home] [Help]
View: IGS_HE_UT_PRT_AWARD_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Holds the parent child Award relationships for a Calculation Type |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT HUTPA.ROWID
, HUTPA.TARIFF_CALC_TYPE_CD
, HUTPA.AWARD_CD
, PA1.AWARD_TITLE
, HUTPA.PARENT_AWARD_CD
, PA2.AWARD_TITLE
, HUTPA.CREATED_BY
, HUTPA.CREATION_DATE
, HUTPA.LAST_UPDATED_BY
, HUTPA.LAST_UPDATE_DATE
, HUTPA.LAST_UPDATE_LOGIN
FROM IGS_HE_UT_PRT_AWARD HUTPA
, IGS_PS_AWD PA1
, IGS_PS_AWD PA2
WHERE HUTPA.AWARD_CD = PA1.AWARD_CD
AND HUTPA.PARENT_AWARD_CD = PA2.AWARD_CD
Columns
| Name |
| ROW_ID |
| TARIFF_CALC_TYPE_CD |
| AWARD_CD |
| AWARD_DESC |
| PARENT_AWARD_CD |
| PARENT_AWARD_DESC |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |