RB_WORKER_SRCH(SQL View) |
Index Back |
|---|---|
RB_WORKER_SRCHRB_WORKER_SRCH. This is the search record for Worker Search. |
| SELECT A.PERSON_ID ,A.MARKET ,C.NAME ,C.BO_NAME ,C.BO_NAME_DISPLAY , C.FIRST_NAME_SRCH ,C.LAST_NAME_SRCH ,B.SETID_DEPT ,B.DEPTID ,C.NAME_AC ,B.EMPL_STATUS ,A.EMPLID ,A.BO_ID ,C.SYNCID ,C.SYNCDTTM FROM PS_RD_PERSON A ,PS_RB_WORKER B ,PS_BO_NAME C WHERE A.PERSON_ID = B.PERSON_ID AND A.BO_ID = C.BO_ID AND C.PRIMARY_IND = 'Y' AND B.HR_STATUS = 'A' |
| # | 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 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 6 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table: SP_SETID_NONVW |
| 9 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL |
Department
Prompt Table: RB_WORK_DEPT_VW |
| 10 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 11 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employment Status. e.g., Active, Leave of Absence, Terminated, Retired, etc.
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | BO_ID | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 14 | 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. |
| 15 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |