TASK_PROFILE_IDTL_TSKGRPPRF_VW(SQL View) |
Index Back |
|---|---|
Task Group Profile ViewUsed by Rule Templates. |
| SELECT DISTINCT A.TASK_PROFILE_ID FROM PS_TL_TASKGRP_PRFL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TL_TASKGRP_PRFL B WHERE B.TASKGROUP = A.TASKGROUP AND B.TASK_PROFILE_ID = A.TASK_PROFILE_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |