Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View for update financial information for Exchange Visitor in the XML file being sent to SEVIS. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PERS.BATCH_ID BATCH_ID
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID PERSON_ID
, FINC.RECVD_US_GVT_FUNDS RECEIVED_US_GOV_FUNDS
, FINC.PROGRAM_SPONSOR CURRENT_PROGRAM_SPONSOR
, FINC.GOVT_ORG1_CODE GOVT_ORG1
, FINC.GOVT_ORG1 GOVT_ORG1_AMOUNT
, FINC.GOVT_ORG2_CODE GOVT_ORG2
, FINC.GOVT_ORG2 GOVT_ORG2_AMOUNT
, FINC.INTL_ORG1_CODE INTERNAT_ORG1
, FINC.INTL_ORG1 INTERNAT_ORG1_AMOUNT
, FINC.INTL_ORG2_CODE INTERNAT_ORG2
, FINC.INTL_ORG2 INTERNAT_ORG2_AMOUNT
, FINC.EV_GOVT EV_GOVT
, FINC.BI_NATNL_COM BINATIONAL_COMMISSION
, FINC.OTHER_ORG OTHER_ORG
, FINC.PERSONAL_FUNDS PERSONAL_FUNDS
, FINC.REMARKS FINANCIAL_REMARKS
, FINC.GOVT_ORG1_OTHR_NAME
, FINC.GOVT_ORG2_OTHR_NAME
, FINC.INTL_ORG1_OTHR_NAME
, FINC.INTL_ORG2_OTHR_NAME
, FINC.OTHER_GOVT_NAME
, PERS.PRINT_FORM PRINT_FORM
, PERS.SEVIS_USER_ID SEVIS_USER_ID
, PERS.RECORD_NUMBER RECORD_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) PERSON_NUMBER
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, PERS.REPRINT_RSN_CODE REPRINT_REASON
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, NULL
, PERS.REPRINT_REMARKS) REPRINT_REMARKS
, DECODE(PERS.REPRINT_RSN_CODE
, '05'
, PERS.REPRINT_REMARKS
, NULL) OTHER_REMARKS
FROM IGS_SV_PERSONS PERS
, IGS_SV_FINANCE_INFO FINC
, IGS_SV_BTCH_SUMMARY FINSUMM
WHERE PERS.RECORD_STATUS = 'C'
AND FINC.BATCH_ID = PERS.BATCH_ID
AND FINC.PERSON_ID = PERS.PERSON_ID
AND FINC.PERSON_ID = FINSUMM.PERSON_ID
AND FINC.BATCH_ID = FINSUMM.BATCH_ID
AND FINSUMM.TAG_CODE = 'SV_FINANCIAL'
AND FINSUMM.ADM_ACTION_CODE = 'SEND'