TASK_GRP_IDLANGUAGE_CDRB_TGRP_TSK_LVW(SQL View) |
Index Back |
|---|---|
Task Group Tasks ViewRelated language View all Tasks that are in a Task Group |
| SELECT TG.TASK_GRP_ID , T.LANGUAGE_CD , T.DESCR60 FROM PS_RB_TGRP_TSK TG , PS_RB_TSK_LANG T , PS_RB_TSK_ASGN TA WHERE TG.TASK_ID = T.TASK_ID AND T.TASK_ID = TA.TASK_ID (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_GRP_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Task Group ID. Key for Task Group. Used by Task Management. |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |