EMPLIDEMPL_RCDACTION_DT_SSTRANS_EFFSEQOPRIDFE_ADDR_APPR_VW(SQL View) |
Index Back |
|---|---|
Approver Search ViewApprover Search View to display pending name change requests. OPRID is one of the keys for this view. So, the join with the current sign-on operator id happens at the run time. |
| SELECT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.TRANS_EFFSEQ , O.OPRID , B.EMPLID_CURR_APPR , B.STEP , B.CURRENT_STEP FROM PS_FE_ADDRESS_DAT A , PS_FE_ADDRESS_STA B , PSOPRDEFN O WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.TRANS_EFFSEQ = B.TRANS_EFFSEQ AND B.STEP > 0 AND B.FE_APPRSTEP_ACTION = 'P' AND (B.EMPLID_CURR_APPR = O.EMPLID OR (O.OPRID IN ( SELECT C.ROLEUSER FROM PSROLEUSER C WHERE C. ROLENAME = B.ROLENAME_CURR_APPR))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | ACTION_DT_SS |
Date(10) | DATE | *Effective Date |
| 4 | TRANS_EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | EMPLID_CURR_APPR | Character(11) | VARCHAR2(11) NOT NULL | Stores the Employee ID of the Current Approver in Federal Self-Service Transactions. |
| 7 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 8 | CURRENT_STEP | Number(3,0) | SMALLINT NOT NULL | Current Step Number |