GPJP_MTHRMT_HST

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