EMPLIDEMPL_RCDEFFDTA=Assignee
C=Consultant
E=Expatriate
G=Agency/Temp
I=Intern
P=Apprentice
R=Contractor
T=Trainee
GM_BUD_JOB_VW(SQL View) |
Index Back |
|---|---|
Proposal Job Details - ViewShows job-related information for pre-award budgeting. Used as a prompt table to select the appropriate EMPL_RCD# for a proposal professional. |
| select EMPLID, EMPL_RCD, EFFDT, EFFSEQ, JOBCODE, EMPL_CLASS, STD_HOURS from PS_JOB A where EMPL_STATUS in ('A', 'B') and EFFDT in (select EFFDT from PS_JOB where EMPLID = A.EMPLID and EMPL_RCD = A.EMPL_RCD) and EFFSEQ in (select EFFSEQ from PS_JOB where EMPLID = A.EMPLID and EMPL_RCD = A.EMPL_RCD and EFFDT = A.EFFDT) |
| # | 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 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | EMPL_CLASS | Character(3) | VARCHAR2(3) NOT NULL |
Employee Classification
A=Assignee C=Consultant E=Expatriate G=Agency/Temp I=Intern P=Apprentice R=Contractor T=Trainee |
| 7 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |