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_FI_SUB_ER_RT_V

Product:	IGS - Student System (Obsolete)
Description:	Fetches Sub Element Range Rates records
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SERT.ROWID
, SERT.SUB_ERR_ID
, SERT.SUB_ER_ID
, SERT.FAR_ID
, FAR.RATE_NUMBER
, FAR.CHG_RATE
, FAR.LOCATION_CD
, FAR.ATTENDANCE_TYPE
, FAR.ATTENDANCE_MODE
, FAR.CLASS_STANDING
, FAR.COURSE_CD
, FAR.VERSION_NUMBER
, HP.PARTY_NUMBER
, FAR.RESIDENCY_STATUS_CD
, FAR.UNIT_SET_CD
, FAR.US_VERSION_NUMBER
, SERT.CREATE_DATE
, SERT.LOGICAL_DELETE_DATE
, SERT.CREATED_BY
, SERT.CREATION_DATE
, SERT.LAST_UPDATE_DATE
, SERT.LAST_UPDATED_BY
, SERT.LAST_UPDATE_LOGIN
, FAR.UNIT_CD
, FAR.UNIT_VERSION_NUMBER
, FAR.UNIT_LEVEL
, FAR.UNIT_TYPE_ID
, UTL.LEVEL_CODE
, FAR.UNIT_MODE
, FAR.UNIT_CLASS
FROM IGS_FI_SUB_ER_RT SERT
, IGS_FI_FEE_AS_RATE FAR
, HZ_PARTIES HP
, IGS_PS_UNIT_TYPE_LVL UTL
WHERE SERT.FAR_ID = FAR.FAR_ID
AND FAR.ORG_PARTY_ID = HP.PARTY_ID(+)
AND FAR.UNIT_TYPE_ID = UTL.UNIT_TYPE_ID (+)

Columns

Name
ROW_ID
SUB_ERR_ID
SUB_ER_ID
FAR_ID
RATE_NUMBER
CHG_RATE
LOCATION_CD
ATTENDANCE_TYPE
ATTENDANCE_MODE
CLASS_STANDING
COURSE_CD
VERSION_NUMBER
ORG_UNIT_CD
RESIDENCY_STATUS_CD
UNIT_SET_CD
US_VERSION_NUMBER
CREATE_DATE
LOGICAL_DELETE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
UNIT_CD
UNIT_VERSION_NUMBER
UNIT_LEVEL
UNIT_TYPE_ID
LEVEL_CODE
UNIT_MODE
UNIT_CLASS