Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Base View to hold basic institution/organization related information |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.ROWID ROW_ID
, P.PARTY_ID PARTY_ID
, P.PARTY_NUMBER TCA_PARTY_NUMBER
, PP.OSS_ORG_UNIT_CD PARTY_NUMBER
, P.PARTY_NAME PARTY_NAME
, PP.OU_START_DT START_DATE
, PP.OU_END_DT END_DATE
, PP.INST_ORG_IND INST_ORG_IND
, PP.OI_INSTITUTION_STATUS INSTITUTION_STATUS
, PP.OU_ORG_STATUS ORG_STATUS
, PP.INSTITUTION_CD OU_INSTITUTION_CD
, PP.OI_LOCAL_INSTITUTION_IND
, PP.OI_GOVT_INSTITUTION_CD
, PP.OI_INST_CONTROL_TYPE
, PP.OI_INSTITUTION_TYPE
, PP.OU_MEMBER_TYPE
, PP.OU_ORG_TYPE
FROM HZ_PARTIES P
, IGS_PE_HZ_PARTIES PP
WHERE P.PARTY_ID = PP.PARTY_ID
AND P.STATUS = 'A'
AND PP.INST_ORG_IND IS NOT NULL