BO_IDF=Female
M=Male
U=Unknown
RBD_SALESPER_VW(SQL View) |
Index Back |
|---|---|
Dashboard PersonThis is the record for the Dashboard Person temporary table. |
| SELECT A.BO_ID , A.PERSON_ID , B.BO_NAME_DISPLAY , A.SEX , A.EMPLID FROM %Table(RD_PERSON) A , %Table(BO_NAME) B , %Table(RSF_SUSER) C WHERE A.BO_ID = B.BO_ID AND A.PERSON_ID = C.PERSON_ID AND B.PRIMARY_IND = 'Y' AND NOT EXISTS ( SELECT 'X' FROM %Table(BO_ROLE) D WHERE A.BO_ID = D.BO_ID AND D.ROLE_TYPE_ID IN (4, 88, 17)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 4 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |