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