eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AS_SERVIC_PLAN_V

Product:	IGS - Student System (Obsolete)
Description:	Contains one row for each Transcript Service Plan offered by the institution. It is also used to support allowance of several "free" transcripts per career or academic year. If an institution does not desire a seeded service, use of the clo
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASP.ROWID
, ASP.PLAN_ID
, ASP.PLAN_TYPE
, ASP.UNLIMITED_IND
, ASP.QUANTITY_LIMIT
, ASP.PERIOD_OF_PLAN
, LKUP.MEANING
, ASP.TOTAL_PERIODS_COVERED
, ASP.FEE_AMOUNT
, ASP.CLOSED_IND
, ASP.CREATED_BY
, ASP.CREATION_DATE
, ASP.LAST_UPDATED_BY
, ASP.LAST_UPDATE_DATE
, ASP.LAST_UPDATE_LOGIN
FROM IGS_AS_SERVIC_PLAN ASP
, IGS_LOOKUPS_VIEW LKUP
WHERE ASP.PERIOD_OF_PLAN = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'PERIOD_OF_PLAN'

Columns

Name
ROW_ID
PLAN_ID
PLAN_TYPE
UNLIMITED_IND
QUANTITY_LIMIT
PERIOD_OF_PLAN
PERIOD_OF_PLAN_MEANING
TOTAL_PERIODS_COVERED
FEE_AMOUNT
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN