Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes a unit granted as advanced standing. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ASU.AS_COURSE_CD
, ASU.AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE
, ASU.UNIT_CD
, ASU.VERSION_NUMBER
, ASU.EXEMPTION_INSTITUTION_CD
, ASU.CAL_TYPE
, ASU.CI_SEQUENCE_NUMBER
, NULL
, /* ASU.CREDIT_PERCENTAGE
, */ ASU.ACHIEVABLE_CREDIT_POINTS
, ASU.GRADING_SCHEMA_CD
, ASU.GRD_SCH_VERSION_NUMBER
, ASU.GRADE
, '_LA:ASU.S_ADV_STND_RECOGNITION_TYPE:IGS_LOOKUP_VALUES:ADV_STND_RECOGNITION_TYPE:MEANING'
, '_LA:ASU.S_ADV_STND_GRANTING_STATUS:IGS_LOOKUP_VALUES:ADV_STND_GRANTING_STATUS:MEANING'
, ASU.APPROVED_DT
, ASU.GRANTED_DT
, ASU.EXPIRY_DT
, ASU.CANCELLED_DT
, ASU.REVOKED_DT
, ASU.COMMENTS
, ASU.CRS_GROUP_IND
, ASU.AV_STND_UNIT_ID
, ASU.PERSON_ID
, ASU.UNIT_DETAILS_ID
, ASU.TST_RSLT_DTLS_ID
, ASU.DEG_AUD_DETAIL_ID
, ASU.AUTHORISING_PERSON_ID
, ASU.CREATED_BY
, ASU.CREATION_DATE
, ASU.LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE
FROM IGS_AV_STND_UNIT_ALL ASU WITH READ ONLY