IDO_TAMATSU_JPN

#	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	UNIT_JPN	Number(4,0)	SMALLINT NOT NULL	A group of employees that belong to a tamatsuki chain. Default Value: 1
3	SORT_JPN	Number(4,0)	SMALLINT NOT NULL	Tracks the sort order of a tamatsuki chain. Default Value: 1
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: ACTIVE_WRKR_VW
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr Prompt Table: EE_RCD_JPN_VW
6	EMPLID_JPN	Character(11)	VARCHAR2(11) NOT NULL	Used when a second EMPLID is needed on a record/page.
7	EMPL_RCD_JPN	Signed Number(4,0)	DECIMAL(3) NOT NULL	Tracks the empl_rcd of an additional appointment. This is used in records that also lists the main appointment empl_rcd.
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUSUNIT_HR_VW
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
10	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system Prompt Table: SUPVSR_LVL_TBL
11	IDO_ACTION_JPN	Character(2)	VARCHAR2(2) NOT NULL	Tracks the Action being applied to a Tamatsuki Post. 10=Open Post 20=Assigned 30=Closed Post 40=Create Additional Appointment Default Value: 10
12	START_DATE_JPN	Date(10)	DATE	Tracks the beginning date of an additional appointment assignment.
13	EXP_END_DATE_JPN	Date(10)	DATE	Tracks the date in the future when the additional appointment assignment is expected to be completed.
14	END_DATE_JPN	Date(10)	DATE	The actual date that an additional appointment assignment was completed.
15	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
16	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: LOCATION_TBL