[Home] [Help]
| Product: | IGF - Financial Aid (Obsolete) |
|---|---|
| Description: | View used for reporting the Student tag in the outbound XML for Direct Loan |
| Implementation/DBA Data: | Not implemented in this database |
SELECT BASE_ID
, S_SSN
, TRIM(S_LAST_NAME) S_LAST_NAME
, TRIM(S_FIRST_NAME) S_FIRST_NAME
, SUBSTR(TRIM(S_MIDDLE_NAME)
, 1
, 1) S_MIDDLE_INITIAL
, TRIM(S_PERMT_ADDR1) S_PERMT_ADDR1
, TRIM(S_PERMT_ADDR2) S_PERMT_ADDR2
, TRIM(S_PERMT_CITY) S_PERMT_CITY
, TRIM(S_PERMT_STATE) S_PERMT_STATE
, TRIM(S_PERMT_ZIP) S_PERMT_ZIP
, TRIM(S_PERMT_PHONE) S_PERMT_PHONE
, TRIM(S_EMAIL_ADDR) S_EMAIL_ADDR
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_DATE_OF_BIRTH
, TO_CHAR( S_CHG_BIRTH_DATE
, 'YYYY-MM-DD') S_CHG_BIRTH_DATE
, S_CHG_SSN
, TRIM(S_PERMT_COUNTY) S_PERMT_COUNTY
, TRIM(S_PERMT_COUNTRY) S_PERMT_COUNTRY
, TRIM (S_CHG_LAST_NAME) S_CHG_LAST_NAME
, TRIM(S_LICENSE_NUM) S_LICENSE_NUM
, TRIM(S_LICENSE_STATE) S_LICENSE_STATE
, TRIM(S_DEPNCY_STATUS) S_DEPNCY_STATUS
, TRIM(S_CITIZENSHIP_STATUS) S_CITIZENSHIP_STATUS
, TRIM(S_FOREIGN_POSTAL_CODE) S_FOREIGN_POSTAL_CODE
, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT
, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT
, TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT
FROM IGF_SL_LOR_LOC_ALL GROUP BY BASE_ID
, S_SSN
, TRIM(S_LAST_NAME)
, TRIM(S_FIRST_NAME)
, SUBSTR(TRIM(S_MIDDLE_NAME)
, 1
, 1)
, TRIM(S_PERMT_ADDR1)
, TRIM(S_PERMT_ADDR2)
, TRIM(S_PERMT_CITY)
, TRIM(S_PERMT_STATE)
, TRIM(S_PERMT_ZIP)
, TRIM(S_PERMT_PHONE)
, TRIM(S_EMAIL_ADDR)
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, TO_CHAR( S_CHG_BIRTH_DATE
, 'YYYY-MM-DD')
, S_CHG_SSN
, TRIM(S_PERMT_COUNTY)
, TRIM(S_PERMT_COUNTRY)
, TRIM (S_CHG_LAST_NAME)
, TRIM(S_LICENSE_NUM)
, TRIM(S_LICENSE_STATE)
, TRIM(S_DEPNCY_STATUS)
, TRIM(S_CITIZENSHIP_STATUS)
, TRIM(S_FOREIGN_POSTAL_CODE)
, TRIM(ATD_ENTITY_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(DOCUMENT_ID_TXT)