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	BIRTHDATE	Date(10)	DATE	Date of Birth
8	GPJP_CHRDT_ERA1	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
9	GPJP_CHRDT_YYMMDD1	Character(6)	VARCHAR2(6) NOT NULL	Character Date as YYMMDD
10	GPJP_ORC_IND_N1	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N-1.
11	GPJP_ORC_IND_N	Number(1,0)	SMALLINT NOT NULL	Occ Revision Candidate in N.
12	GPJP_CHRDT_M1	Character(1)	VARCHAR2(1) NOT NULL	Month
13	GPJP_OBJECT_DATE	Date(10)	DATE	Object Date.
14	GPJP_CHRDT_YY1	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
15	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
16	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
17	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
18	GPJP_CUR_HEL_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Health Insurance Remuneration.
19	GPJP_CHAR_AMT1	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
20	GPJP_CUR_PEN_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Current Monthly Standard Pension Remuneration.
21	GPJP_CHAR_AMT2	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
22	DATE1	Date(10)	DATE	Date 1
23	GPJP_CHRDT_ERA2	Character(1)	VARCHAR2(1) NOT NULL	Imperial Era
24	GPJP_CHRDT_YY2	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
25	GPJP_CHRDT_MM1	Character(2)	VARCHAR2(2) NOT NULL	Month
26	GPJP_CHRDT_DD1	Character(2)	VARCHAR2(2) NOT NULL	Date
27	GPJP_CHRDT_DD2	Character(2)	VARCHAR2(2) NOT NULL	Date
28	GPJP_CHRDT_DD3	Character(2)	VARCHAR2(2) NOT NULL	Date
29	GPJP_MTH_CASH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-2.
30	GPJP_MTH_CASH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-1.
31	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
32	GPJP_MTH_MAT_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration In N-2.
33	GPJP_SUM_MTH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-2.
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_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
36	GPJP_AVG_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Average Amount of Monthly Remuneration.
37	GPJP_ADJ_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Average Monthly Remuneration.
38	GPJP_CHAR_AMT3	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
39	GPJP_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Part-Time
40	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
41	GPJP_CHAR_AMT4	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
42	GPJP_NEGATIVE_FLG	Number(1,0)	SMALLINT NOT NULL	Negative Flag
43	GPJP_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Character Filed Length of 1
44	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
45	GPJP_CHAR_AMT5	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
46	GPJP_CHRDT_YY3	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
47	GPJP_CHANGED_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
48	GPJP_CHRDT_MM2	Character(2)	VARCHAR2(2) NOT NULL	Month
49	GPJP_REMARK1	Character(50)	VARCHAR2(50) NOT NULL	Remarks
50	GPJP_REMARK2	Character(50)	VARCHAR2(50) NOT NULL	Remark 2.
51	GPJP_DESCR75	Character(75)	VARCHAR2(75) NOT NULL	Comment
52	GPJP_MTH_MAT_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration in N-1.
53	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun