[Home] [Help]
View: IGSBV_HOUSING_STATUSES
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains information about the housing statuses of a person. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PTP.CAL_TYPE
, PTP.SEQUENCE_NUMBER
, TO_DATE(NULL) START_DATE
, TO_DATE(NULL) END_DATE
, '_LA:PTP.TEACH_PERIOD_RESID_STAT_CD:IGS_LOOKUP_VALUES:PE_TEA_PER_RES:MEANING'
, PTP.TEACHING_PERIOD_ID
, PTP.PERSON_ID
, PTP.CREATION_DATE
, PTP.CREATED_BY
, PTP.LAST_UPDATED_BY
, PTP.LAST_UPDATE_DATE
FROM IGS_PE_TEACH_PERIODS_ALL PTP WITH READ ONLY
Columns
Name |
CALENDER_TYPE |
SEQUENCE_NUMBER |
START_DATE |
END_DATE |
"_LA:TEACH_PERIOD_RES_STATUS" |
TEACHING_PERIOD_ID |
PERSON_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |