PERSON_IDDefault Value: NEXT
RBW_WORKER_VW(SQL View) |
Index Back |
|---|---|
Worker view.This view is returns the BOID and the name of the worker based on person. |
| SELECT A.PERSON_ID ,C.BO_NAME_DISPLAY ,C.BO_NAME_AC ,A.BO_ID ,A.EMPLID FROM PS_RD_PERSON A ,PS_RB_WORKER B ,PS_BO_NAME_PRIM_VW C WHERE A.PERSON_ID = B.PERSON_ID AND A.BO_ID = C.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: NEXT |
| 2 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 3 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 4 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |