SETID_WRKSITE_IDRF_BOSITEGBL_VW(SQL View) |
Index Back |
|---|---|
Copy of BO_SITE_GBL_VWThis copy of BO_SITE_GBL_VW is used on the Provider Group and Worker criteria pages in order to display all sites (when not customer is specified.) However, the first key on BO_SITE_GBL_VW is SETID and the prompt table on the criteria page needs to be SETID_WRK. |
| SELECT A.SETID , A.SITE_ID , C.BO_NAME , C.BO_NAME_AC , D.BO_NAME , E.ADDRESS1 , E.CITY , E.STATE , B.CUST_ID FROM PS_RD_SITE A , PS_BO_NAME D , PS_BC B , PS_BO_NAME C , PS_BO_SRCH_ADD E WHERE A.BO_ID_PARENT = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y' AND A.MARKET = 'GBL' AND A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y' AND A.BO_ID = E.BO_ID AND E.BO_CM_USE_TYPE = 'R' AND E.ROLE_TYPE_ID = 3 AND E.PRIMARY_IND = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_WRK |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SITE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 4 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_PARENT | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 7 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 8 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 9 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |