SIMER_JPN_TMP (SQL Table)	Index Back
Temp table for HR_CMP052 This is a temp table for Japan's 'Create Salary Increase Simulation Table'.

SIMER_JPN_TMP

(SQL Table)

Temp table for HR_CMP052

This is a temp table for Japan's 'Create Salary Increase Simulation Table'.

# 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 SAL_INC_ID Character(12) VARCHAR2(12) NOT NULL Salary Increase ID

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

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

13 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

14 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

15 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

16 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	SAL_INC_ID	Character(12)	VARCHAR2(12) NOT NULL	Salary Increase ID
11	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	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
14	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model
15	REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	Review Rating
16	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.