AMTER_JPN_TMP (SQL Table)	Index Back
Temp table for HR_CMP051 This is a temp table for Japan's 'Salary Increase process by Amount'.

AMTER_JPN_TMP

(SQL Table)

Temp table for HR_CMP051

This is a temp table for Japan's 'Salary Increase process by Amount'.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

5 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence

6 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

7 JOB_EFFDT Date(10) DATE Job Effective Date

8 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence

9 NAME Character(50) VARCHAR2(50) NOT NULL Name

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

12 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	COMP_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Compensation Eff Sequence
6	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code
7	JOB_EFFDT	Date(10)	DATE	Job Effective Date
8	JOB_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Job Effective Sequence
9	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
12	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.