RG_TSK_TYPE_VW(SQL View) |
Index Back |
---|---|
VIEW Task TypesView Task Types available to Change Management use |
SELECT T.TASK_TYPE , T.DESCR FROM PS_RB_TSK_TYPE T WHERE T.APPLICATION_USAGE IN ('ALL', 'CHMG') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Copied from Resouce Management (8.1). Added new label id for "Task Type" |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |