GPJP_SC_OCC_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_OBJECT_DATE	Date(10)	DATE	Object Date.
12	GPJP_WORK2	Character(30)	VARCHAR2(30) NOT NULL	This field is used in file layouts to store constant values.
13	GPJP_CHRDT_YY1	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
14	GPJP_CHRDT_MM1	Character(2)	VARCHAR2(2) NOT NULL	Month
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
18	GPJP_PREFECTURE_CD	Character(2)	VARCHAR2(2) NOT NULL	Prefecture Code
19	GPJP_HLTHINS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Insurance Card Attached
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_MM2	Character(2)	VARCHAR2(2) NOT NULL	Month
28	GPJP_CHRDT_MM3	Character(2)	VARCHAR2(2) NOT NULL	Month
29	GPJP_CHRDT_MM4	Character(2)	VARCHAR2(2) NOT NULL	Month
30	GPJP_CHRDT_MM5	Character(2)	VARCHAR2(2) NOT NULL	Month
31	GPJP_CHRDT_DD1	Character(2)	VARCHAR2(2) NOT NULL	Date
32	GPJP_CHRDT_DD2	Character(2)	VARCHAR2(2) NOT NULL	Date
33	GPJP_CHRDT_DD3	Character(2)	VARCHAR2(2) NOT NULL	Date
34	GPJP_MTH_CASH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-2.
35	GPJP_MTH_CASH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Cash Remuneration in N-1.
36	GPJP_MTH_CASH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Cash Monthly Remun
37	GPJP_MTH_MAT_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration In N-2.
38	GPJP_MTH_MAT_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Monthly Material Remuneration in N-1.
39	GPJP_MTH_MAT_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Non-Cash Mthly Remun
40	GPJP_SUM_MTH_RMN2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-2.
41	GPJP_SUM_MTH_RMN1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N-1.
42	GPJP_SUM_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Of Monthly Remuneration In N.
43	GPJP_SUM_MTH_TOT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Sum Total of Monthly Remuneration In N.
44	GPJP_PERS_NBR1	Character(13)	VARCHAR2(13) NOT NULL	This field stores the My Number of each employee and dependent.
45	GPJP_PEN_NO1	Character(4)	VARCHAR2(4) NOT NULL	Base Pension Department Sign
46	GPJP_PEN_NO2	Character(6)	VARCHAR2(6) NOT NULL	Base Pension Sequential Number
47	GPJP_MULT_LOC_WRKR	Character(1)	VARCHAR2(1) NOT NULL	Multiple Location worker
48	GPJP_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Part-Time L=Part-time < 3/4 N=N/A Y=Part-time
49	GPJP_AGE70_OLDER	Character(1)	VARCHAR2(1) NOT NULL	Age of 70 or older employee
50	GPJP_NOTIFY_OLD_EE	Character(1)	VARCHAR2(1) NOT NULL	Only Notification of 70 or older employee
51	GPJP_AVG_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Average Amount of Monthly Remuneration.
52	GPJP_ADJ_MTH_RMN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Adjusted Average Monthly Remuneration.
53	GPJP_CHAR_AMT3	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
54	CALC_DELTA_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Delta
55	GPJP_RETRO_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
56	GPJP_RETRO_MTH_CHR	Character(2)	VARCHAR2(2) NOT NULL	Month Of Change In Salary.
57	GPJP_CHAR_AMT4	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
58	GPJP_NEGATIVE_FLG	Number(1,0)	SMALLINT NOT NULL	Negative Flag
59	GPJP_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Character Filed Length of 1
60	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
61	GPJP_CHAR_AMT5	Character(12)	VARCHAR2(12) NOT NULL	Character Amount
62	GPJP_CHRDT_YY3	Character(2)	VARCHAR2(2) NOT NULL	Year in Era
63	GPJP_CHANGED_MTH	Number(2,0)	SMALLINT NOT NULL	Month Of Change In Salary.
64	GPJP_CHRDT_MM6	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_GEPDESCR	Character(75)	VARCHAR2(75) NOT NULL	Comment