RA_CN_TK_GRP_VW(SQL View) |
Index Back |
---|---|
Content Task Group ViewContent Task Group View of task groups relating to contents only |
SELECT B.RA_TASK_GRP_ID , B.DESCR50 FROM PS_RA_TASK_GRP_DFN B WHERE B.RA_TASK_SHELL_TYPE = 'CONT' AND B.STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RA_TASK_GRP_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Task Group ID
Task Library (new definition)
Default Value: 9999999999 |
2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |