WM_PCR_SETID_BU(SQL View) |
Index Back |
|---|---|
PCR SetID Business Unit ViewPCR SetID Business Unit View -- retrieves business unit values for PCR setids. |
| SELECT B.BUSINESS_UNIT , S.SETID FROM PS_BUS_UNIT_TBL_WM B , PS_SET_CNTRL_REC S WHERE S.RECNAME = 'WM_PCR_GROUP' AND S.SETCNTRLVALUE = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |