GPJP_WA_PIN_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
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
14	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
15	SUPV_LVL_ID	Character(8)	VARCHAR2(8) NOT NULL	Supervisor Level ID for use in capability grade system
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
18	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
19	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
20	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
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
22	GPJP_LA_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Labour Insurance Establishment.
23	GPJP_SC_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Social Insurance Establishment.
24	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
25	GPJP_ELIG_VOL_ER	Character(1)	VARCHAR2(1) NOT NULL	Eligibility For Voluntary Enrollment.
26	GPJP_BASE_DAYS_N	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment In N.
27	GPJP_BASE_DAYS_N1	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment In N-1.
28	GPJP_BASE_DAYS_N2	Number(3,0)	SMALLINT NOT NULL	Base Days for Payment in N-2.
29	GPJP_ORC_IND_N	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N.
30	GPJP_ORC_IND_N1	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-1.
31	GPJP_ORC_IND_N2	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-2.
32	GPJP_RUN_TYPE_FLAG	Character(3)	VARCHAR2(3) NOT NULL	Run Type
33	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
34	GPJP_SUM_MTH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-1.
35	GPJP_SUM_MTH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-2.
36	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
37	GPJP_MTH_CASH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-1.
38	GPJP_MTH_CASH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-2.
39	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
40	GPJP_MTH_MAT_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration in N-1.
41	GPJP_MTH_MAT_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration In N-2.
42	GPJP_TOT_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Amount Of Monthly Remuneration.
43	GPJP_AVG_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Average Amount of Monthly Remuneration.
44	GPJP_ADJ_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Average Monthly Remuneration.
45	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
46	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
47	GPJP_REV_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Revised Monthly Standard Health Remuneration.
48	GPJP_REV_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Revised Monthly Standard Pension Remuneration.
49	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
50	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
51	GPJP_CHANGED_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
52	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
53	GPJP_WC_INS_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Worker's Compensation Insurance Type. 10=Full Time Insured Worker 20=Insured Officer 30=Temporary Insured Worker 40=Exclusion
54	GPJP_EI_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Employment Insurance Type. 10=Insured 20=Insured Officer 30=Exclusion
55	GPJP_ELDERLY_IND	Character(1)	VARCHAR2(1) NOT NULL	Elderly Insured.
56	GPJP_WORKER_IND	Character(1)	VARCHAR2(1) NOT NULL	Short Time Worker.
57	GPJP_EI_NUM	Character(13)	VARCHAR2(13) NOT NULL	Employment Insurance Insured ID Number.
58	GPJP_TOT_SAL_ERN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Amount Salary Earnings.
59	GPJP_TOT_BNS_ERN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Amount of Bonus Earnings.
60	GPJP_BASE_PAY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base Pay.
61	MUNICIPAL_CD_JPN	Character(6)	VARCHAR2(6) NOT NULL	Japanese Municipal Code
62	TAX_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	One-Time Tax Amount
63	GPJP_SC_EMPL_RCD_C	Signed Number(4,0)	DECIMAL(3) NOT NULL	Social Insurance Current Employee Record.
64	GPJP_NEGATIVE_FLG	Number(1,0)	SMALLINT NOT NULL	Negative Flag
65	GPJP_SC_EMPL_REC_N	Number(3,0)	SMALLINT NOT NULL	Employee Record Number