EMPLIDPrompt Table: ACA_SF_HRBR_PVW
ACA_SF_HRBR_PVW(SQL View) |
Index Back |
|---|---|
Safe Harbor prompt viewSafe Harbor prompt view |
| SELECT DISTINCT B.EMPLID , NM.NAME_DISPLAY FROM PS_ACA_CMPY_TBL A , PS_PER_ORG_ASGN B , PS_JOB C , PS_PER_ORG_INST PI , PS_REG_REGION_TBL R , PS_NAMES NM WHERE A.COMPANY = C.COMPANY AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACA_CMPY_TBL A1 WHERE A.COMPANY = A1.COMPANY AND A.EFFDT <= A1.EFFDT) AND PI.EMPLID = B.EMPLID AND PI.ORG_INSTANCE_ERN = B.ORG_INSTANCE_ERN AND C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND NM.EMPLID = B.EMPLID AND NM.NAME_TYPE = 'PRI' AND NM.EFF_STATUS = 'A' AND C.REG_REGION=R.REG_REGION AND R.COUNTRY='USA' AND C.EFFDT = ( SELECT MAX(H.EFFDT) FROM PS_JOB H WHERE H.EMPLID = C.EMPLID AND H.EMPL_RCD = C.EMPL_RCD AND C.EFFDT <= H.EFFDT) AND C.EFFSEQ = ( SELECT MAX(I.EFFSEQ) FROM PS_JOB I WHERE I.EMPLID = C.EMPLID AND I.EMPL_RCD = C.EMPL_RCD AND I.EFFDT = C.EFFDT) AND NM.EFFDT = ( SELECT MAX(NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM.EMPLID = NM1.EMPLID AND NM.NAME_TYPE = NM1.NAME_TYPE AND NM.EFFDT <= NM1.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: ACA_SF_HRBR_PVW |
| 2 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |