GPJP_SC_REG_RPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number
4	GPJP_SC_ESTAB_REF1	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number.
5	GPJP_SC_ESTAB_REF2	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number 2.
6	GPJP_HLTH_CARD_NUM	Number(8,0)	INTEGER NOT NULL	Health Insurance Card Number.
7	GPJP_HLTH_CARD_NM	Character(6)	VARCHAR2(6) NOT NULL	Health Insurance Card Number.
8	BIRTHDATE	Date(10)	DATE	Date of Birth
9	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
10	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
11	GPJP_WORK2	Character(30)	VARCHAR2(30) NOT NULL	This field is used in file layouts to store constant values.
12	GPJP_ORC_IND_N1	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-1.
13	GPJP_ORC_IND_N	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N.
14	GPJP_CHRDT_M1	Character(1)	VARCHAR2(1) NOT NULL	Month
15	GPJP_OBJECT_DATE	Date(10)	DATE	Object Date.
16	GPJP_CHRDT_YY1	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
17	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
18	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
19	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
20	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
21	GPJP_CHAR_AMT1	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
22	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
23	GPJP_CHAR_AMT2	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
24	DATE1	Date(10)	DATE	Date 1
25	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
26	GPJP_CHRDT_YY2	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
27	GPJP_CHRDT_MM1	Character(2)	VARCHAR2(2) NOT NULL	Month
28	GPJP_CHRDT_DD1	Character(2)	VARCHAR2(2) NOT NULL	Date
29	GPJP_CHRDT_DD2	Character(2)	VARCHAR2(2) NOT NULL	Date
30	GPJP_CHRDT_DD3	Character(2)	VARCHAR2(2) NOT NULL	Date
31	GPJP_MTH_CASH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-2.
32	GPJP_MTH_CASH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-1.
33	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
34	GPJP_MTH_MAT_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration In N-2.
35	GPJP_SUM_MTH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-2.
36	GPJP_SUM_MTH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-1.
37	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
38	GPJP_AVG_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Average Amount of Monthly Remuneration.
39	GPJP_ADJ_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Average Monthly Remuneration.
40	GPJP_CHAR_AMT3	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
41	GPJP_PERS_NBR1	Character(13)	VARCHAR2(13) NOT NULL	This field stores the My Number of each employee and dependent.
42	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
43	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
44	GPJP_AGE70_OLDER	Character(1)	VARCHAR2(1) NOT NULL	Age of 70 or older employee
45	GPJP_70YR_MONTH	Character(4)	VARCHAR2(4) NOT NULL	Target months for 70 years-old
46	GPJP_MULT_LOC_WRKR	Character(1)	VARCHAR2(1) NOT NULL	Multiple Location worker
47	GPJP_GEPPEN_PLN	Character(1)	VARCHAR2(1) NOT NULL	Geppen planned for ee
48	GPJP_NOT_FULL_PAID	Character(1)	VARCHAR2(1) NOT NULL	Sal not fully paid
49	GPJP_ABSENCE	Character(1)	VARCHAR2(1) NOT NULL	Field to identify whether ee in absence
50	GPJP_SHORTM_WRK	Character(1)	VARCHAR2(1) NOT NULL	Part-Time
51	GPJP_PART_TIME_WRK	Character(1)	VARCHAR2(1) NOT NULL	Part-Time
52	GPJP_SANTEI_MANUAL	Character(1)	VARCHAR2(1) NOT NULL	Part-Time
53	GPJP_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Part-Time L=Part-time < 3/4 N=N/A Y=Part-time
54	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
55	GPJP_CHAR_AMT4	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
56	GPJP_NEGATIVE_FLG	Number(1,0)	SMALLINT NOT NULL	Negative Flag
57	GPJP_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Character Filed Length of 1
58	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
59	GPJP_CHAR_AMT5	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
60	GPJP_CHRDT_YY3	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
61	GPJP_CHANGED_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
62	GPJP_RETRO_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
63	GPJP_RETRO_MTH_CHR	Character(2)	VARCHAR2(2) NOT NULL	Month Of Change In Salary.
64	GPJP_CHRDT_MM2	Character(2)	VARCHAR2(2) NOT NULL	Month
65	GPJP_REMARK1	Character(50)	VARCHAR2(50) NOT NULL	Remarks
66	GPJP_REMARK2	Character(50)	VARCHAR2(50) NOT NULL	Remark 2.
67	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment
68	GPJP_MTH_MAT_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration in N-1.
69	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
70	GPJP_NOTIFY_OLD_EE	Character(1)	VARCHAR2(1) NOT NULL	Only Notification of 70 or older employee
71	GPJP_PREFECTURE_CD	Character(2)	VARCHAR2(2) NOT NULL	Prefecture Code
72	GPJP_SUM_MTH_TOT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Total of Monthly Remuneration In N.