[Home] [Help]
View: IGSBV_STUDENT_PROGRAM_TERMS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view lists program attempt attributes based on Term Calendar. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SPAT.TERM_RECORD_ID
, SPAT.PERSON_ID
, SPAT.PROGRAM_CD
, SPAT.PROGRAM_VERSION
, SPAT.ACAD_CAL_TYPE
, SPAT.TERM_CAL_TYPE
, SPAT.TERM_SEQUENCE_NUMBER
, SPAT.KEY_PROGRAM_FLAG
, '_LA:KEY_PROGRAM_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SPAT.LOCATION_CD
, SPAT.ATTENDANCE_MODE
, SPAT.ATTENDANCE_TYPE
, SPAT.FEE_CAT
, SPAT.COO_ID
, SPAT.CLASS_STANDING_ID
, SPAT.CREATED_BY
, SPAT.CREATION_DATE
, SPAT.LAST_UPDATED_BY
, SPAT.LAST_UPDATE_DATE
FROM IGS_EN_SPA_TERMS SPAT WITH READ ONLY
Columns
| Name |
| TERM_RECORD_ID |
| PERSON_IDENTIFIER |
| PROGRAM_CODE |
| PROGRAM_VERSION |
| ACADEMIC_CALENDAR_TYPE |
| TERM_CALENDAR_TYPE |
| TERM_CAL_SEQUENCE_NUMBER |
| KEY_PROGRAM_FLAG |
| "_LA:KEY_PROGRAM_FLAG_DESC" |
| LOCATION_CODE |
| ATTENDANCE_MODE |
| ATTENDANCE_TYPE |
| FEE_CATEGORY |
| COO_ID |
| CLASS_STANDING_IDENTIFIER |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |