HR_OWS_SYNC_VW(SQL View) |
Index Back |
|---|---|
OWS Sync Message HeaderPersons currently or formerly enrolled in Oracle Workforce Scheduling. |
| SELECT DISTINCT A.EMPLID FROM PS_PER_ORG_ASG_INT A , PS_JOB B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFSEQ = ( SELECT MAX (EFFSEQ) FROM PS_JOB B2 WHERE B2.EMPLID = B.EMPLID AND B2.EMPL_RCD = B.EMPL_RCD AND B2.EFFDT = B.EFFDT) AND A.INT_APP_TYPE = 'SCH' AND A.INTEGR_PROD_CD = 'OWS' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |