SALER_JPN_TMP (SQL Table)	Index Back
Temp table for HR_CMP053 This is a temp table for Japan's 'Salary Increase process by Simulation'.

SALER_JPN_TMP

(SQL Table)

Temp table for HR_CMP053

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

# 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 NAME Character(50) VARCHAR2(50) NOT NULL Name

8 SAL_INC_ID Character(12) VARCHAR2(12) NOT NULL Salary Increase ID

9 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

10 CALC_NUM Number(3,0) SMALLINT NOT NULL Calculation Number
Prompt Table: SAL_SIM_JPN_VW2

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

12 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

13 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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	SAL_INC_ID	Character(12)	VARCHAR2(12) NOT NULL	Salary Increase ID
9	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
10	CALC_NUM	Number(3,0)	SMALLINT NOT NULL	Calculation Number Prompt Table: SAL_SIM_JPN_VW2
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	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
13	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.