[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ASU.ROWID ROW_ID
, ASU.PERSON_ID PERSON_ID
, ASU.AS_COURSE_CD AS_COURSE_CD
, ASU.AS_VERSION_NUMBER AS_VERSION_NUMBER
, ASU.S_ADV_STND_TYPE S_ADV_STND_TYPE
, ASU.UNIT_CD UNIT_CD
, ASU.VERSION_NUMBER VERSION_NUMBER
, ASU.S_ADV_STND_GRANTING_STATUS S_ADV_STND_GRANTING_STATUS
, ASU.APPROVED_DT APPROVED_DT
, ASU.AUTHORISING_PERSON_ID AUTHORISING_PERSON_ID
, PPV.PERSON_NUMBER AUTHORISING_PERSON_NUMBER
, PPV.FULL_NAME PREFERRED_NAME
, ASU.CRS_GROUP_IND CRS_GROUP_IND
, ASU.EXEMPTION_INSTITUTION_CD EXEMPTION_INSTITUTION_CD
, ASU.GRANTED_DT GRANTED_DT
, ASU.EXPIRY_DT EXPIRY_DT
, ASU.CANCELLED_DT CANCELLED_DT
, ASU.REVOKED_DT REVOKED_DT
, ASU.COMMENTS COMMENTS
, NULL
, /* ASU.CREDIT_PERCENTAGE CREDIT_PERCENTAGE
, */ ASU.S_ADV_STND_RECOGNITION_TYPE S_ADV_STND_RECOGNITION_TYPE
, ASU.CREATED_BY CREATED_BY
, ASU.CREATION_DATE CREATION_DATE
, ASU.LAST_UPDATED_BY LAST_UPDATED_BY
, ASU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASU.REQUEST_ID REQUEST_ID
, ASU.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ASU.PROGRAM_ID PROGRAM_ID
, ASU.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ASU.AV_STND_UNIT_ID
, ASU.CAL_TYPE
, ASU.CI_SEQUENCE_NUMBER
, ASU.INSTITUTION_CD
, ASU.UNIT_DETAILS_ID
, ASU.TST_RSLT_DTLS_ID
, ASU.GRADING_SCHEMA_CD
, ASU.GRD_SCH_VERSION_NUMBER
, ASU.GRADE
, ASU.ACHIEVABLE_CREDIT_POINTS
, ASU.DEG_AUD_DETAIL_ID
FROM IGS_AV_STND_UNIT ASU
, IGS_PE_PERSON_BASE_V PPV
WHERE ASU.AUTHORISING_PERSON_ID = PPV.PERSON_ID