[Home] [Help]
View: IGF_SL_CL_SETUP_ORG_V
| Product: | IGF - Financial Aid (Obsolete) |
|---|
| Description: | FFELP Organization Unit |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DISTINCT AWDYR.CI_CAL_TYPE
, AWDYR.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, CLSET.PARTY_ID
, ORGV.PARTY_NUMBER
, ORGV.PARTY_NAME
FROM IGF_AP_BATCH_AW_MAP AWDYR
, IGF_SL_CL_SETUP CLSET
, IGS_OR_INST_ORG_BASE_V ORGV
, IGS_CA_INST CA
WHERE AWDYR.CI_CAL_TYPE = CA.CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND ORGV.PARTY_ID = CLSET.PARTY_ID
Columns
| Name |
| CAL_TYPE |
| SEQUENCE_NUMBER |
| ALTERNATE_CODE |
| START_DATE |
| END_DATE |
| PARTY_ID |
| ORG_UNIT_CD |
| ORG_UNIT_CD_DESC |