AA_COST_RT_JPN (SQL Table)	Index Back
Cost Rate Japan Table This table tracks the cost rates for Additional Appointments.

AA_COST_RT_JPN

(SQL Table)

Cost Rate Japan Table

This table tracks the cost rates for Additional Appointments.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 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.
Default Value: AA_COST_RT_JPN.EMPL_RCD
Prompt Table: AA_PROMPT_VW

5 COST_RATE_JPN Signed Number(7,2) DECIMAL(5,2) NOT NULL Tracks the percentage of the total compensation that is dervied from this job. All cost rates added together should equal 100%.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	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. Default Value: AA_COST_RT_JPN.EMPL_RCD Prompt Table: AA_PROMPT_VW
5	COST_RATE_JPN	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Tracks the percentage of the total compensation that is dervied from this job. All cost rates added together should equal 100%.