ORG_PLAN_JPNPrompt Table: IDO_ORGPLAN_JPN
BUSINESS_UNITPrompt Table: BUSUNIT_HR_VW
DEPTIDPrompt Table: DEPT_TBL
SEQUENCE_JPNPrompt Table: SUPVSR_LVL_TBL
Prompt Table: JOBCODE_TBL
Prompt Table: SAL_PLAN_TBL
Prompt Table: SAL_GRADE_TBL
IDO_HC_DEPT_JPN(SQL Table) |
Index Back |
|---|---|
Headcount Goals by DepartmentThis record tracks the headcount goals by department, and subdivided by either Supervisor Level, Jobcode, or SalAdmin Plan/Grade. Headcount Type tracked on IDO_ORGPLAN_JPN determines which of the 3 subdivisions is used. |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUSUNIT_HR_VW |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 4 | SEQUENCE_JPN |
Number(4,0) | SMALLINT NOT NULL | Sequence |
| 5 | SUPV_LVL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Supervisor Level ID for use in capability grade system
Prompt Table: SUPVSR_LVL_TBL |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |
| 7 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table: SAL_PLAN_TBL |
| 8 | GRADE | Character(3) | VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table: SAL_GRADE_TBL |
| 9 | HEADCOUNT_JPN | Number(6,0) | INTEGER NOT NULL | Tracks the number of employees assigned to each group. |