TASK_PRFL_TMPLT_IDTASK_PROFILE_IDLANGUAGE_CDEFFDTDefault Value: %date
TL_TSKPRF_V_LNG(SQL View) |
Index Back |
|---|---|
Task Profile & Template ViewThis view is used to control the Task Profiles displayed in the list box as the Task Profile Template ID for the Profile must equal that of the Task Profile Template ID selected for the Taskgroup. |
| SELECT R.TASK_PRFL_TMPLT_ID ,L.TASK_PROFILE_ID ,L.LANGUAGE_CD , L.EFFDT , L.DESCR FROM PS_TL_TSKPRF_LNG L ,PS_TL_TSKPRF R WHERE R.TASK_PROFILE_ID =L.TASK_PROFILE_ID AND R.EFFDT=L.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_PRFL_TMPLT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Task Template ID |
| 2 | TASK_PROFILE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |