View: IGS_PE_EV_FORM_V

View Text

SELECT PV.ROWID ROW_ID
, PV.EV_FORM_ID
, PV.PERSON_ID
, PV.PRINT_FORM
, PV.FORM_EFFECTIVE_DATE
, PV.FORM_STATUS
, L1.MEANING FORM_STATUS_DESC
, PV.CREATE_REASON
, PV.IS_VALID
, PV.PRGM_SPONSOR_AMT
, PV.GOVT_ORG1_AMT
, PV.GOVT_ORG1_CODE
, L2.MEANING GOVT_ORG1_DESC
, PV.GOVT_ORG2_AMT
, PV.GOVT_ORG2_CODE
, L3.MEANING GOVT_ORG2_DESC
, PV.INTL_ORG1_AMT
, PV.INTL_ORG1_CODE
, L4.MEANING INTL_ORG1_DESC
, PV.INTL_ORG2_AMT
, PV.INTL_ORG2_CODE
, L5.MEANING INTL_ORG2_DESC
, PV.EV_GOVT_AMT
, PV.BI_NATNL_COM_AMT
, PV.OTHER_GOVT_AMT
, PV.PERSONAL_FUNDS_AMT
, PV.EV_FORM_NUMBER
, PV.PRGM_START_DATE
, PV.PRGM_END_DATE
, PV.LAST_REPRINT_DATE
, PV.REPRINT_REASON
, L6.MEANING REPRINT_REASON_DESC
, PV.REPRINT_REMARKS
, PV.POSITION_CODE
, L7.MEANING POSITION_DESC
, PV.POSITION_REMARKS
, PV.SUBJECT_FIELD_CODE
, L8.MEANING SUBJECT_FIELD_DESC
, PV.SUBJECT_FIELD_REMARKS
, PV.MATRICULATION
, L9.MEANING MATRICULATION_DESC
, PV.REMARKS
, PV.CREATION_DATE
, PV.CREATED_BY
, PV.LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN
, PV.INIT_PRGM_START_DATE
, PV.CATEGORY_CODE
, L10.MEANING CATEGORY_CODE_DESC
, PV.NO_SHOW_FLAG
, PV.GOVT_ORG1_OTHR_NAME
, PV.GOVT_ORG2_OTHR_NAME
, PV.INTL_ORG1_OTHR_NAME
, PV.INTL_ORG2_OTHR_NAME
, PV.OTHER_GOVT_NAME
, PV.SEVIS_SCHOOL_IDENTIFIER
, HP.PARTY_NAME SEVIS_SCHOOL
FROM IGS_PE_EV_FORM PV
, IGS_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES L2
, IGS_LOOKUP_VALUES L3
, IGS_LOOKUP_VALUES L4
, IGS_LOOKUP_VALUES L5
, IGS_LOOKUP_VALUES L6
, IGS_LOOKUP_VALUES L7
, IGS_LOOKUP_VALUES L8
, IGS_LOOKUP_VALUES L9
, IGS_LOOKUP_VALUES L10
, HZ_PARTIES HP
WHERE PV.FORM_STATUS = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_SV_FM_STAT_TYPE'
AND PV.GOVT_ORG1_CODE = L2.LOOKUP_CODE(+)
AND L2.LOOKUP_TYPE (+) = 'PE_US_GVT_AGENCY'
AND PV.GOVT_ORG2_CODE = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'PE_US_GVT_AGENCY'
AND PV.INTL_ORG1_CODE = L4.LOOKUP_CODE(+)
AND L4.LOOKUP_TYPE (+) = 'PE_SV_INTL_ORG'
AND PV.INTL_ORG2_CODE = L5.LOOKUP_CODE(+)
AND L5.LOOKUP_TYPE(+) = 'PE_SV_INTL_ORG'
AND PV.REPRINT_REASON = L6.LOOKUP_CODE(+)
AND L6.LOOKUP_TYPE (+) = 'PE_SV_REPRINT_REASON'
AND PV.POSITION_CODE = L7.LOOKUP_CODE
AND L7.LOOKUP_TYPE = 'PE_SV_EV_POSITION'
AND PV.SUBJECT_FIELD_CODE = L8.LOOKUP_CODE
AND L8.LOOKUP_TYPE = 'PE_US_COURSE_SUBJECT'
AND PV.MATRICULATION = L9.LOOKUP_CODE(+)
AND L9.LOOKUP_TYPE (+) = 'PE_SV_EV_MATR_CODE'
AND PV.CATEGORY_CODE = L10.LOOKUP_CODE (+)
AND L10.LOOKUP_TYPE (+) = 'PE_SV_EV_PRG_CATEGORY'
AND HP.PARTY_TYPE(+) = 'ORGANIZATION'
AND PV.SEVIS_SCHOOL_IDENTIFIER = HP.PARTY_ID(+)

Columns