SETIDEIP_CTL_IDIN_ITMEXPCTL_VW(SQL View) |
Index Back |
|---|---|
Item Excp EIP Ctl Id View |
| SELECT DISTINCT a.setid , a.eip_ctl_id FROM ps_eo_eip_ctl a , PS_MASTER_ITEM_EC b WHERE a.eip_program = 'ITEM' AND a.eip_dta_status IN ('0','1','4','6','7') AND a.setid = b.setid AND a.eip_ctl_id = b.eip_ctl_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |