EMPLIDPrompt Table: PERSON
SSF_PYCNV_DR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.EMPLID FROM PS_DIR_DEP_DISTRIB A , PS_DIRECT_DEPOSIT B , PS_JOB C WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND C.POI_TYPE = '00006' AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A' AND A.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_DIR_DEP_DISTRIB B1 WHERE B1.EMPLID = A.EMPLID AND B1.ACCOUNT_TYPE = A.ACCOUNT_TYPE AND B1.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_JOB C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT) AND C.HR_STATUS = 'A' AND A.EMPLID NOT IN ( SELECT COMMON_ID FROM PS_SSF_BANK_ACCT WHERE SA_ID_TYPE = 'P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |