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_OR_UNIT_FUNDSRC_V

Product:	IGS - Student System (Obsolete)
Description:	View of all organization units joined to all funding source to use in ADMF2M44
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT HZ.PARTY_NUMBER TCA_PARTY_NUMBER
, PEP.OSS_ORG_UNIT_CD ORG_UNIT_CD
, PEP.OU_START_DT
, PEP.OU_END_DT
, HZ.PARTY_NAME OU_DESCRIPTION
, PEP.OU_ORG_STATUS
, PEP.OU_ORG_TYPE
, PEP.OU_MEMBER_TYPE
, PEP.INSTITUTION_CD
, FS.FUNDING_SOURCE
, FS.DESCRIPTION FS_DESCRIPTION
, FS.GOVT_FUNDING_SOURCE
, FS.CLOSED_IND
, HZ.CREATED_BY
, HZ.CREATION_DATE
, HZ.LAST_UPDATED_BY
, HZ.LAST_UPDATE_DATE
, HZ.LAST_UPDATE_LOGIN
FROM HZ_PARTIES HZ
, IGS_PE_HZ_PARTIES PEP
, IGS_FI_FUND_SRC FS
WHERE HZ.PARTY_ID = PEP.PARTY_ID
AND PEP.INST_ORG_IND = 'O'

Columns

Name
TCA_PARTY_NUMBER
ORG_UNIT_CD
START_DT
END_DT
OU_DESCRIPTION
ORG_STATUS
ORG_TYPE
MEMBER_TYPE
INSTITUTION_CD
FUNDING_SOURCE
FS_DESCRIPTION
GOVT_FUNDING_SOURCE
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN