[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PUV.ROWID ROW_ID
, PUV.UNIT_SEC_CREDIT_POINTS_ID
, PUV.UOO_ID
, PUV.MINIMUM_CREDIT_POINTS
, PUV.MAXIMUM_CREDIT_POINTS
, PUV.VARIABLE_INCREMENT
, PUV.LECTURE_CREDIT_POINTS
, PUV.LAB_CREDIT_POINTS
, PUV.OTHER_CREDIT_POINTS
, PUV.CLOCK_HOURS
, PUV.BILLING_CREDIT_POINTS
, PUV.WORK_LOAD_CP_LECTURE
, PUV.WORK_LOAD_CP_LAB
, PUV.CONTINUING_EDUCATION_UNITS
, PUV.ACHIEVABLE_CREDIT_POINTS
, PUV.ENROLLED_CREDIT_POINTS
, PUV.WORK_LOAD_OTHER
, PUV.CONTACT_HRS_LECTURE
, PUV.CONTACT_HRS_LAB
, PUV.CONTACT_HRS_OTHER
, (PUV. CONTACT_HRS_LECTURE + PUV.CONTACT_HRS_LAB + PUV.CONTACT_HRS_OTHER ) DSP_CONTACT_HRS_TOTAL
, PUV.BILLING_HRS
, PUV.NON_SCHD_REQUIRED_HRS
, PUV.FIN_AID_CP
, PUV.FIN_AID_HRS
, PUV.EXCLUDE_FROM_MAX_CP_LIMIT
, PUV.CLAIMABLE_HOURS
, PUV.CREATED_BY
, PUV.CREATION_DATE
, PUV.LAST_UPDATED_BY
, PUV.LAST_UPDATE_DATE
, PUV.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_CPS PUV
, IGS_PS_UNIT_VER UNT
, IGS_PS_UNIT_OFR_OPT UOO
WHERE PUV.UOO_ID = UOO.UOO_ID
AND UOO.UNIT_CD = UNT.UNIT_CD
AND UOO.VERSION_NUMBER = UNT.VERSION_NUMBER