Product: | IGS - Student System (Obsolete) |
---|---|
Description: | The interface table for the Ancillary attributes for the students. |
Implementation/DBA Data: | Not implemented in this database |
SELECT FA.ROWID ROW_ID
, FA.ANCILLARY_INT_ID
, FA.PERSON_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, FA.PERSON_ID_TYPE
, FA.API_PERSON_ID
, FA.STATUS
, FA.FEE_TYPE
, FA.FEE_CAL_TYPE
, FA.FEE_CI_SEQUENCE_NUMBER
, FA.OVERRIDE_DR_REC_ACCOUNT_CD
, FA.OVERRIDE_DR_REC_CCID
, FA.OVERRIDE_CR_REV_ACCOUNT_CD
, FA.OVERRIDE_CR_REV_CCID
, FA.ANCILLARY_ATTRIBUTE1
, FA.ANCILLARY_ATTRIBUTE2
, FA.ANCILLARY_ATTRIBUTE3
, FA.ANCILLARY_ATTRIBUTE4
, FA.ANCILLARY_ATTRIBUTE5
, FA.ANCILLARY_ATTRIBUTE6
, FA.ANCILLARY_ATTRIBUTE7
, FA.ANCILLARY_ATTRIBUTE8
, FA.ANCILLARY_ATTRIBUTE9
, FA.ANCILLARY_ATTRIBUTE10
, FA.ANCILLARY_ATTRIBUTE11
, FA.ANCILLARY_ATTRIBUTE12
, FA.ANCILLARY_ATTRIBUTE13
, FA.ANCILLARY_ATTRIBUTE14
, FA.ANCILLARY_ATTRIBUTE15
, FA.ATTRIBUTE_CATEGORY
, FA.ATTRIBUTE1
, FA.ATTRIBUTE2
, FA.ATTRIBUTE3
, FA.ATTRIBUTE4
, FA.ATTRIBUTE5
, FA.ATTRIBUTE6
, FA.ATTRIBUTE7
, FA.ATTRIBUTE8
, FA.ATTRIBUTE9
, FA.ATTRIBUTE10
, FA.ATTRIBUTE11
, FA.ATTRIBUTE12
, FA.ATTRIBUTE13
, FA.ATTRIBUTE14
, FA.ATTRIBUTE15
, FA.ATTRIBUTE16
, FA.ATTRIBUTE17
, FA.ATTRIBUTE18
, FA.ATTRIBUTE19
, FA.ATTRIBUTE20
, FA.EFFECTIVE_DT
, FA.TRANSACTION_DT
, FA.ORG_ID
, FA.ERROR_MSG
, FA.VALIDATION_FLAG
, FA.REQUEST_ID
, FA.PROGRAM_ID
, FA.PROGRAM_APPLICATION_ID
, FA.PROGRAM_UPDATE_DATE
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGS_FI_ANC_INT FA
, HZ_PARTIES HZ
WHERE HZ.PARTY_ID (+) = FA.PERSON_ID