PERSON_IDA=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
RB_TSKDLG_PER_V(SQL View) |
Index Back |
|---|---|
Person Name ViewTask Delegation view to fecth Person Name |
| SELECT A.PERSON_ID ,B.BO_NAME_DISPLAY , B.BO_NAME_AC , B.FIRST_NAME , B.LAST_NAME ,E.EMPL_STATUS FROM PS_RD_PERSON A ,PS_BO_NAME_PRIM_VW B ,PSXLATITEM D , PS_RB_WORKER E WHERE A.BO_ID=B.BO_ID AND A.PERSON_ID = E.PERSON_ID AND E.EMPL_STATUS='A' AND D.FIELDVALUE = E.EMPL_STATUS AND D.FIELDNAME = 'EMPL_STATUS' AND D.EFFDT = ( SELECT MAX(F.EFFDT) FROM PSXLATITEM F WHERE F.FIELDNAME = D.FIELDNAME AND F.FIELDVALUE = D.FIELDVALUE AND F.EFF_STATUS = 'A' AND F.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 3 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name (Alternate Character) |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 6 | 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 |