RD_WRKR_SRCH_VW(SQL View) |
Index Back |
---|---|
Worker Role Search ViewBO search for a worker role. It is used for BO Search in Worker Creation and Worker Setting Copying. |
SELECT A.BO_ID , %NumToChar(SUM(A.ROLE_TYPE_ID3)) , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_BO_ROLE_VW3 A , PSXLATITEM B WHERE B.FIELDNAME = 'WORKER_SUBROLE_SUM' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn) GROUP BY A.BO_ID, B.XLATLONGNAME, B.XLATSHORTNAME, B.FIELDVALUE HAVING B.FIELDVALUE = %NumToChar(SUM(A.ROLE_TYPE_ID3)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID | |
2 | WORKER_SUBROLE_SUM | Character(3) | VARCHAR2(3) NOT NULL |
Worker Sub-Role for Worker' Job Assignment (summary of all BO roles)
086=Employee 087=Contingent Worker 173=Employee, Contingent 86=Employee 87=Contingent Worker |
3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
4 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |