EMPLIDPrompt Table: SAL_GRADE_TBL
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Prompt Table: COMPANY_TBL
GPCH_SI_VARI_VW(SQL View) |
Index Back |
|---|---|
Social Insurance ViewSocial Insurance View |
| SELECT A.EMPLID , B.GRADE , A.SEX , B.COMPANY , C.HIRE_DT , B.ANNUAL_RT , B.CURRENCY_CD FROM PS_PRIMARY_JOB_VW E , PS_PERS_DATA_EFFDT A , PS_PER_ORG_ASGN_VW C , PS_JOB B WHERE C.PER_ORG = 'EMP' AND C.EMPLID = E.EMPLID AND C.EMPL_RCD = E.EMPL_RCD AND A.EMPLID = E.EMPLID AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PERS_DATA_EFFDT A2 WHERE A.EMPLID = A2.EMPLID AND A2.EFFDT <= %CurrentDateIn ) AND B.EMPLID = E.EMPLID AND B.EMPL_RCD = E.EMPL_RCD AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB B2 WHERE B2.EMPLID = E.EMPLID AND B2.EMPL_RCD = E.EMPL_RCD AND B2.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB B3 WHERE B3.EMPLID = B.EMPLID AND B3.EMPL_RCD = B.EMPL_RCD AND B3.EFFDT = B.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: SAL_GRADE_TBL |
| 3 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 5 | HIRE_DT | Date(10) | DATE | First Start Date |
| 6 | ANNUAL_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Annual Rate |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |