OPRIDEMPLIDPY_IC_DD_SRH_VW(SQL View) |
Index Back |
|---|---|
WEB - Payroll -DDP Search ViewSearch view to support WEB-enabled Direct Deposit Update. This search view retreives the user's (logged-in employee's) current direct deposit data. If the user has multiple jobs, a search list will come up allowing the user to select the job for which he wishes to review his direct deposit data. |
| SELECT C.OPRID , A.EMPLID , A.COMPANY , A.PAYGROUP , B.DESCR , A.EMPL_RCD FROM PS_JOB A , PS_JOBCODE_TBL B , PSOPRDEFN C WHERE A.EMPLID = C.EMPLID AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD=A.EMPL_RCD AND A1.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT ) AND A.SETID_JOBCODE = B.SETID AND A.JOBCODE = B.JOBCODE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_JOBCODE_TBL B1 WHERE B1.JOBCODE = B.JOBCODE AND B1.SETID = B.SETID AND B1.EFFDT <= A.EFFDT AND B.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 5 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 6 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |