View: IGFFV_STUDENT_AUTHORIZATIONS

Product:	IGF - Financial Aid
Description:	Full View for the Entity that holds Student Work Authorizations
Implementation/DBA Data:	APPS.IGFFV_STUDENT_AUTHORIZATIONS

View Text

SELECT SEAUT.FLAG
, SEAUT.FIRST_NAME
, SEAUT.LAST_NAME
, SEAUT.ADDRESS1
, SEAUT.ADDRESS2
, SEAUT.ADDRESS3
, SEAUT.ADDRESS4
, SEAUT.CITY
, SEAUT.STATE
, SEAUT.PROVINCE
, SEAUT.COUNTY
, SEAUT.COUNTRY
, SEAUT.SEX
, SEAUT.BIRTH_DT
, SEAUT.SSN_NO
, SEAUT.MARITAL_STATUS
, SEAUT.VISA_TYPE
, SEAUT.VISA_CATEGORY
, SEAUT.VISA_NUMBER
, SEAUT.VISA_EXPIRY_DT
, SEAUT.ENTRY_DATE
, NULL
, NULL
, SEAUT.THRESHOLD_PERCT
, SEAUT.THRESHOLD_VALUE
, NULL
, NULL
, SEAUT.ACCEPTED_AMNT
, SEAUT.AW_CAL_TYPE
, SEAUT.AW_SEQUENCE_NUMBER
, SEAUT.LD_CAL_TYPE
, SEAUT.LD_SEQUENCE_NUMBER
, AWARD_CI.ALTERNATE_CODE
, LOAD_CI.ALTERNATE_CODE
, HZ.PARTY_NUMBER
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, SEAUT.AUTH_ID
, SEAUT.PERSON_ID
, SEAUT.FUND_ID
, SEAUT.SEQUENCE_NO
, SEAUT.CREATED_BY
, SEAUT.CREATION_DATE
, SEAUT.LAST_UPDATED_BY
, SEAUT.LAST_UPDATE_DATE
, SEAUT.AWARD_ID
, SEAUT.AUTHORIZATION_DATE
, SEAUT.NOTIFICATION_DATE
FROM IGF_SE_AUTH SEAUT
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWARD_CI
, IGS_CA_INST_ALL LOAD_CI
, HZ_PARTIES HZ
WHERE SEAUT.FUND_ID = FMAST.FUND_ID
AND SEAUT.LD_CAL_TYPE = LOAD_CI.CAL_TYPE
AND SEAUT.LD_SEQUENCE_NUMBER = LOAD_CI.SEQUENCE_NUMBER
AND FMAST.CI_CAL_TYPE = AWARD_CI.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWARD_CI.SEQUENCE_NUMBER
AND HZ.PARTY_ID = SEAUT.PERSON_ID WITH READ ONLY

Columns