IDO_UNIT_JPN_VW (SQL View)	Index Back
Ido Unit View This view is used to build the level 1 scroll area on the page IDO_TAMATSUKI_JPN.

IDO_UNIT_JPN_VW

(SQL View)

Ido Unit View

This view is used to build the level 1 scroll area on the page IDO_TAMATSUKI_JPN.

SELECT DISTINCT A.ORG_PLAN_JPN , A.UNIT_JPN FROM PS_IDO_TAMATSU_JPN A

# 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 UNIT_JPN Number(4,0) SMALLINT NOT NULL A group of employees that belong to a tamatsuki chain.
Default Value: 1

#	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	UNIT_JPN	Number(4,0)	SMALLINT NOT NULL	A group of employees that belong to a tamatsuki chain. Default Value: 1