SETIDBUSINESS_UNITSETID_BU_UTL_VW(SQL View) |
Index Back |
|---|---|
prompting BU within a SETID |
| SELECT A.SETID , %Substring(A.SETCNTRLVALUE, 1, 5) FROM PS_SET_CNTRL_GROUP A , PS_REC_GROUP_REC C WHERE C.RECNAME = 'UTIL_GROUP_INV' AND C.REC_GROUP_ID = A.REC_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |