[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View for obtaining information for the XML block describing the creation of the student information. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PERS.BATCH_ID BATCH_ID
, PERS.PERSON_ID
, PERS.PRINT_FORM
, NULL STDNT_LAST_NAME
, NULL STDNT_FIRST_NAME
, NULL STDNT_MIDDLE_NAME
, NULL STDNT_SUFFIX
, NULL STDNT_BIRTH_DATE
, NULL STDNT_GENDER
, NULL STDNT_BIRTH_CNTRY_CODE
, NULL STDNT_CITIZEN_CNTRY_CODE
, NULL STDNT_COMMUTER
, NULL STDNT_VISA_TYPE
, NULL DMISSION_NUMBER
, NULL DRIVERS_LICENSE
, NULL DRIVERS_LICENSE_STATE
, NULL SSN
, NULL TAX_ID
, NULL FN_ADDRESS_LINE1
, NULL FN_ADDRESS_LINE2
, NULL FN_CITY
, NULL FN_PROVINCE
, NULL FN_COUNTRY_CODE
, NULL FN_POSTAL_CODE
, NULL US_ADDRESS_LINE1
, NULL US_ADDRESS_LINE2
, NULL US_CITY
, NULL US_STATE
, NULL US_POSTAL_CODE
, NULL US_POSTAL_ROUTING_CODE
, NULL EDUCATION_LEVEL
, NULL EDUC_LVL_REMARKS
, NULL PRIMARY_MAJOR
, NULL SECOND_MAJOR
, NULL MINOR
, NULL LENGTH_OF_STUDY
, NULL PRG_START_DATE
, NULL PRG_END_DATE
, NULL ENGL_REQUIRED
, NULL ENGL_REQUIREMENTS_MET
, NULL ENGL_NOT_REQD_REASON
, NULL ACADEMIC_TERM
, NULL TUITION
, NULL LIVING_EXPENSE
, NULL DEPENDENT_EXPENSE
, NULL OTHER_EXPENSE
, NULL OTHER_EXPENSE_DESC
, NULL PERSONAL_FUNDS
, NULL SCHOOL_FUNDS
, NULL SCHOOL_FUNDS_DESC
, NULL OTHER_FUNDS
, NULL OTHER_FUNDS_DESC
, NULL EMPLOYMENT_FUNDS
, NULL FUNDING_REMARKS
, PERS.RECORD_NUMBER
, PERS.PDSO_SEVIS_ID PDSO_SEVIS_ID
, PERS.PERSON_ID STDNT_PERSON_ID
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 10)
, '0000000000')) STDNT_PERSON_NUMBER
, NULL PROG_REMARKS
, LTRIM(TO_CHAR(SUBSTR(PERS.PERSON_ID
, 1
, 14)
, '00000000000000')) PERSON_ID_LONG
, PERS.REMARKS
, PERS.ISSUING_REASON ISSUE_REASON
FROM IGS_SV_PERSONS PERS
, IGS_SV_BTCH_SUMMARY BIOSUMM
, IGS_SV_BTCH_SUMMARY FADDSUMM
, IGS_SV_BTCH_SUMMARY PRGMSUMM
, IGS_SV_BTCH_SUMMARY FINSUMM
WHERE PERS.RECORD_STATUS = 'N'
AND PERS.PERSON_ID = BIOSUMM.PERSON_ID
AND PERS.BATCH_ID = BIOSUMM.BATCH_ID
AND BIOSUMM.TAG_CODE = 'SV_BIO'
AND BIOSUMM.ADM_ACTION_CODE = 'SEND'
AND PERS.PERSON_ID = FADDSUMM.PERSON_ID
AND PERS.BATCH_ID = FADDSUMM.BATCH_ID
AND FADDSUMM.TAG_CODE = 'SV_F_ADDR'
AND FADDSUMM.ADM_ACTION_CODE = 'SEND'
AND PERS.PERSON_ID = PRGMSUMM.PERSON_ID
AND PERS.BATCH_ID = PRGMSUMM.BATCH_ID
AND PRGMSUMM.TAG_CODE = 'SV_PRGMS'
AND PRGMSUMM.ADM_ACTION_CODE = 'SEND'
AND PERS.PERSON_ID = FINSUMM.PERSON_ID
AND PERS.BATCH_ID = FINSUMM.BATCH_ID
AND FINSUMM.TAG_CODE = 'SV_FINANCIAL'
AND FINSUMM.ADM_ACTION_CODE = 'SEND'