EMPLIDGM_JOBCODE_VW(SQL View) |
Index Back |
|---|---|
PI's JobCodes view for GrantsJob codes associated with Principle Investigators |
| Select EMPLID, EMPL_RCD,EFFDT, EFFSEQ,BUSINESS_UNIT,JOBCODE from PS_JOB a Where EFFDT=(Select max(d.EFFDT) From PS_JOB d Where a.EMPLID=d.EMPLID and a.EMPL_RCD=d.EMPL_RCD and a.EFFDT<=d.EFFDT and a.EFFSEQ<=d.EFFSEQ) and EFFSEQ=(Select max(c.EFFSEQ) From PS_JOB c Where a.EMPLID=c.EMPLID and a.EMPL_RCD=c.EMPL_RCD and a.EFFDT=c.EFFDT and a.EFFSEQ<=c.EFFSEQ) |
| # | 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 Rcd Nbr |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |