GPJP_MTHRMN_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_RUN
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
5	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
6	GPJP_OBJECT_DATE	Date(10)	DATE NOT NULL	Object Date.
7	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
8	GPJP_HLTH_CARD_NUM	Number(8,0)	INTEGER NOT NULL	Health Insurance Card Number.
9	GPJP_PENS_CODE	Number(8,0)	INTEGER NOT NULL	Pension Insurance Code.
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	GPJP_SUBJECT_IND	Character(2)	VARCHAR2(2) NOT NULL	Subject. 10=Occasional Revision 11=Rev. after Mat./Preg. Leave 11=Revision after Maternity Leave 20=Occasional Revision Candidate 30=Regular Decision 40=Not Applicable
13	GPJP_ORC_IND_N	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N.
14	GPJP_ORC_IND_N1	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-1.
15	GPJP_ORC_IND_N2	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-2.
16	GPJP_BASE_DAYS_N2	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment in N-2.
17	GPJP_MTH_CASH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-2.
18	GPJP_MTH_MAT_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration In N-2.
19	GPJP_SUM_MTH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-2.
20	GPJP_BASE_DAYS_N1	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment In N-1.
21	GPJP_MTH_CASH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-1.
22	GPJP_MTH_MAT_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration in N-1.
23	GPJP_SUM_MTH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-1.
24	GPJP_BASE_DAYS_N	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment In N.
25	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
26	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
27	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
28	GPJP_TOT_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Amount Of Monthly Remuneration.
29	GPJP_AVG_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Average Amount of Monthly Remuneration.
30	GPJP_ADJ_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Average Monthly Remuneration.
31	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
32	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
33	GPJP_REV_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Revised Monthly Standard Health Remuneration.
34	GPJP_REV_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Revised Monthly Standard Pension Remuneration.
35	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
36	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
37	GPJP_CHANGED_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
38	GPJP_RETRO_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
39	GPJP_REMARK1	Character(50)	VARCHAR2(50) NOT NULL	Remarks
40	GPJP_REMARK2	Character(50)	VARCHAR2(50) NOT NULL	Remark 2.
41	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: JPY Prompt Table: CURRENCY_CD_TBL
42	LAST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Last Action C=System D=Hire Process J=Job Data O=Online User S=Supplier Deduction File W=Employee Self Service User
43	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update
44	GPJP_NEGATIVE_FLG	Number(1,0)	SMALLINT NOT NULL	Negative Flag
45	GPJP_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Part-Time L=Part-time < 3/4 N=N/A Y=Part-time Default Value: N