[Home] [Help]
View: IGS_PS_FAC_ASG_TASK_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view stores assigned task for the faculty. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT FAT.ROWID ROW_ID
, FAT.FAC_WL_ID
, FAT.FACULTY_TASK_TYPE
, FTT.DESCRIPTION
, FAT.DEPT_BUDGET_CD
, FAT.CONFIRMED_IND
, FAT.DEFAULT_WL
, FAT.NUM_ROLLOVER_PERIOD
, FAT.ROLLOVER_FLAG
, FAT.CREATED_BY
, FAT.CREATION_DATE
, FAT.LAST_UPDATED_BY
, FAT.LAST_UPDATE_DATE
, FAT.LAST_UPDATE_LOGIN
FROM IGS_PS_FAC_ASG_TASK FAT
, IGS_PS_FAC_TASK_TYP FTT
WHERE FTT.FACULTY_TASK_TYPE = FAT.FACULTY_TASK_TYPE
Columns
| Name |
| ROW_ID |
| FAC_WL_ID |
| FACULTY_TASK_TYPE |
| TASK_DESCRIPTION |
| DEPT_BUDGET_CD |
| CONFIRMED_IND |
| DEFAULT_WL |
| NUM_ROLLOVER_PERIOD |
| ROLLOVER_FLAG |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |