IDO_NEW_ORG_JPN(SQL Table) |
Index Back |
|---|---|
Proposed Reorg SnapshotSnapshot of the employees in the company after a reorganization has been processed. This table is used in reporting to allow users to model the reorganization before the data is actually inserted into the Job record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  JOBINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: ACTIVE_WRKR_VW |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: EE_RCD_JPN_VW |
| 4 | APPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
0=Core Appointment 1=Japan Kenmu Appointment 2=French Public Sector Appt 3=Staffing |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUSUNIT_HR_VW |
| 6 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 7 | SUPV_LVL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL |
| 8 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 10 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 11 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: SAL_PLAN_TBL |
| 12 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: SAL_GRADE_TBL |
| 13 | STEP | Number(2,0) | SMALLINT NOT NULL |
Step
Prompt Table: SAL_STEP_TBL |