ORG_PLAN_JPNPrompt Table: IDO_ORGPLAN_JPN
EMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: BUS_UNIT_TBL_HR
Prompt Table: DEPT_TBL
IDO_NO_SYNC_JPN(SQL View) |
Index Back |
|---|---|
List of employees not synchronThe record IDO_FUT_UPD_JPN tracks the previous department and business unit for employees. Since it is possible to make changes to Job, it is possible for the previous data to get out of data. This view lists the employees whose Job previous dept/BU does not match the IDO_FUT_UPD_JPN previous dept/BU. |
| SELECT B.ORG_PLAN_JPN , A.EMPLID , A.EMPL_RCD , A.BUSINESS_UNIT , A.DEPTID FROM PS_JOB A , PS_IDO_FUT_UPD_JPN B , PS_IDO_ORGPLAN_JPN C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.ORG_PLAN_JPN = C.ORG_PLAN_JPN AND B.SEQUENCE_JPN = 1 AND (B.PREV_DEPTID_JPN <> A.DEPTID OR B.PREV_BUS_UNIT_JPN <> A.BUSINESS_UNIT) AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT <= C.ORG_DATE_JPN) AND A.EFFSEQ = ( SELECT MAX(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 | ORG_PLAN_JPN |
Character(3) | VARCHAR2(3) NOT NULL |
Tracks one possible view of the employees in a company.
Prompt Table: IDO_ORGPLAN_JPN |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 5 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |