TL_GROUP_D_VW(SQL View) |
Index Back |
---|---|
T&L Dynamic Group ViewT&L Dynamic Group View |
SELECT A.GROUP_ID , A.DESCR FROM PS_TL_GROUP_TBL A WHERE A.GROUP_TYPE_IND = 'D' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GROUP_ID | Character(5) | VARCHAR2(5) NOT NULL | Group ID |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |