RSF_L_TGRPT_VW(SQL View) |
Index Back |
---|---|
Lead Task Group Template viewView of Task Group Templates for Lead |
SELECT TASK_GRP_TPL_ID , DESCR FROM PS_RB_TGRP_TPL WHERE APPLICATION_USAGE = 'LEAD' AND ACTIVE_FLG = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_GRP_TPL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Task Group Template ID primary key
Prompt Table: RB_TGRP_TPL |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |