GPJP_SC_STDRMUN (SQL Table)	Index Back
Monthly Standard Remun Table This table will be used to determine the Monthly Standard Remuneration Amount and Standard Remuneration grade.

GPJP_SC_STDRMUN

(SQL Table)

Monthly Standard Remun Table

This table will be used to determine the Monthly Standard Remuneration Amount and Standard Remuneration grade.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPJP_MTH_RMN_LL Signed Number(20,6) DECIMAL(18,6) NOT NULL Monthly Remuneration Amount Lower Limit.

3 GPJP_MTH_RMN_HL Signed Number(20,6) DECIMAL(18,6) NOT NULL GPJP_MTH_RMN_HL field to hold the maximum amount of a range

4 GPJP_HEL_GRADE Number(3,0) SMALLINT NOT NULL Health Insurance Grade.

5 GPJP_PEN_GRADE Number(3,0) SMALLINT NOT NULL Pension Insurance Grade.

6 GPJP_STD_HELRMN Signed Number(20,6) DECIMAL(18,6) NOT NULL Monthly Standard Health Remuneration.

7 GPJP_STD_PENRMN Signed Number(20,6) DECIMAL(18,6) NOT NULL Monthly Standard Pension Remuneration.

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: JPY
Prompt Table: CURRENCY_CD_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	GPJP_MTH_RMN_LL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Remuneration Amount Lower Limit.
3	GPJP_MTH_RMN_HL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GPJP_MTH_RMN_HL field to hold the maximum amount of a range
4	GPJP_HEL_GRADE	Number(3,0)	SMALLINT NOT NULL	Health Insurance Grade.
5	GPJP_PEN_GRADE	Number(3,0)	SMALLINT NOT NULL	Pension Insurance Grade.
6	GPJP_STD_HELRMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Standard Health Remuneration.
7	GPJP_STD_PENRMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Standard Pension Remuneration.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: JPY Prompt Table: CURRENCY_CD_TBL