IDO_ORGPLAN_JPN (SQL Table)	Index Back
Organization Plan This record tracks data related to the Organization Plan of the Ido feature.

IDO_ORGPLAN_JPN

(SQL Table)

Organization Plan

This record tracks data related to the Organization Plan of the Ido feature.

Related Language Record: IDO_OP_JPN_LNG

# 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.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 ORG_DATE_JPN Date(10) DATE NOT NULL The date when the Org Plan becomes effective.

5 HC_TYPE_JPN Character(1) VARCHAR2(1) NOT NULL Tracks the method that headcount is grouped below department.
G=Sal Admin Plan/Grade
J=Job code
S=Supervisor Level
Default Value: S

#	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.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	ORG_DATE_JPN	Date(10)	DATE NOT NULL	The date when the Org Plan becomes effective.
5	HC_TYPE_JPN	Character(1)	VARCHAR2(1) NOT NULL	Tracks the method that headcount is grouped below department. G=Sal Admin Plan/Grade J=Job code S=Supervisor Level Default Value: S