RC_EMPL_SRH_VW(SQL View) |
Index Back |
|---|---|
worker search viewWorker Search View. Used for search all workers from CDM. |
| SELECT p.BO_ID , n.BO_NAME_DISPLAY , p.EMPLID , K.EBS_EMPLID , n.BO_NAME_DISP_UPPER , n.FIRST_NAME , n.FIRST_NAME_SRCH , n.LAST_NAME , n.LAST_NAME_SRCH FROM PS_RB_WORKER w , PS_RD_PERSON p LEFT OUTER JOIN PS_RC_EBS_EMPLRSVW K ON p.PERSON_ID = K.PERSON_ID , PS_RD_PERSON_NAME n WHERE w.PERSON_ID = p.PERSON_ID AND p.PERSON_ID = n.PERSON_ID AND w.EMPL_STATUS = 'A' AND n.PRIMARY_IND = 'Y' |
| # | 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 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EBS_EMPLID | Character(30) | VARCHAR2(30) NOT NULL | EBS Employee Number used in the EBS - HR HelpDesk integration. |
| 5 | BO_NAME_DISP_UPPER | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object in Upper |
| 6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |