RBF_SRVL_GS_VW1(SQL View) |
Index Back |
|---|---|
Search record of FSI SLA search record for the Service Location Component RDF_SITE_2_CI (FIN) 8.9 CI |
| SELECT DISTINCT A.SETID , A.SITE_ID , ss.SERVICE_ID , C.BO_ID , C.BO_NAME , C.BO_NAME_UPPER , C.BO_NAME_AC , A.SITE_TYP_ID , B.FSI_NUMBER , B.FSI_SITE_STATUS , B.NUMBER_ATM , %subrec(RB_AUDIT_SBR, A) FROM PS_RD_SITE A , PS_RDFSITE_VW B , PS_BO_NAME C , PS_RDFSITE_SERVICE ss , PS_BO_ROLECM_PADDR ad WHERE A.SETID = B.SETID AND A.SITE_ID = B.SITE_ID AND B.SETID = ss.SETID (+) AND B.SITE_ID = ss.SITE_ID (+) AND A.BO_ID = C.BO_ID AND B.BO_ID = ad.BO_ID AND ad.ROLE_TYPE_ID = 3 AND A.MARKET = 'FIN' AND B.SERVICE_LOC_SW = 'Y' AND B.FSI_SITE_STATUS IN ('1', '3') AND ad.CM_PURPOSE_TYPE_ID = 5 AND C.PRIMARY_IND = 'Y' AND (ss.SERVICE_ID = ( SELECT MIN(XX.SERVICE_ID) FROM PS_RDFSITE_SERVICE XX WHERE XX.SETID = ss.SETID AND XX.SITE_ID = ss.SITE_ID AND XX.START_DATE <= %CurrentDateIn AND (XX.END_DATE IS NULL OR XX.END_DATE >= %CurrentDateIn)) OR ss.SERVICE_ID IS NULL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 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 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 4 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 5 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | BO_NAME_UPPER | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 7 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 8 | SITE_TYP_ID | Character(5) | VARCHAR2(5) NOT NULL |
Site Type identifier
Prompt Table:
RD_STYPE_GS_VW
|
| 9 | FSI_NUMBER | Character(30) | VARCHAR2(30) NOT NULL | FSI bank ABA number |
| 10 | FSI_SITE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FSI loation status
1=Open 2=Closed 3=Targeted for Closure 4=Pending Open |
| 11 | NUMBER_ATM | Number(2,0) | SMALLINT NOT NULL | Number of ATM machines |
| 12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 13 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 14 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 15 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 16 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 17 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |