PERSON_IDBO_IDROLE_TYPE_IDCOMPANYIDRD_CONST_SRCH_V(SQL View) |
Index Back |
|---|---|
Person SESPerson SES-Used for person SES search |
| SELECT A.PERSON_ID ,A.BO_ID ,B.ROLE_TYPE_ID ,C.COMPANYID ,C.COMPANY_NAME , C.STATUS_DESCR FROM PS_RD_PERSON A , PS_BO_ROLE B ,PS_RB_BUS_CNT_VW C WHERE A.BO_ID= B.BO_ID AND B.ROLE_START_DT <= %CurrentDateIn AND B.ROLE_END_DT >=%CurrentDateIn AND A.BO_ID= C.BO_ID AND B.ROLE_TYPE_ID=C.ROLE_TYPE_ID UNION SELECT A.PERSON_ID ,A.BO_ID ,B.ROLE_TYPE_ID ,'NoValue' ,'' ,'' FROM PS_RD_PERSON A , PS_BO_ROLE B WHERE A.BO_ID= B.BO_ID AND B.ROLE_START_DT <= %CurrentDateIn AND B.ROLE_END_DT >=%CurrentDateIn AND A.BO_ID NOT IN ( SELECT F.BO_ID FROM PS_RB_BUS_CNT_VW F WHERE F.ROLE_TYPE_ID=B.ROLE_TYPE_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 3 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 4 | COMPANYID |
Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 5 | COMPANY_NAME | Character(70) | VARCHAR2(70) NOT NULL | Company Name |
| 6 | STATUS_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Field used to show the status description. Field used as edit box. |