[Home] [Help]
View: IGS_EN_TIMESLOT_RSLT_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | To capture the Timeslot assignment results. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT TSR.ROWID ROW_ID
, TSR.IGS_EN_TIMESLOT_RSLT_ID
, TSR.IGS_EN_TIMESLOT_PARA_ID
, TSR.PERSON_ID
, PPV.PERSON_NUMBER
, PPV.FULL_NAME
, TSR.START_DT_TIME
, TSR.END_DT_TIME
, TSR.CREATED_BY
, TSR.CREATION_DATE
, TSR.LAST_UPDATED_BY
, TSR.LAST_UPDATE_DATE
, TSR.LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_RSLT TSR
, IGS_PE_PERSON_BASE_V PPV
WHERE TSR.PERSON_ID = PPV.PERSON_ID
Columns
| Name |
| ROW_ID |
| IGS_EN_TIMESLOT_RSLT_ID |
| IGS_EN_TIMESLOT_PARA_ID |
| PERSON_ID |
| PERSON_NUMBER |
| FULL_NAME |
| START_DT_TIME |
| END_DT_TIME |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |