GPJP_SC_RPT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
5	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
6	GPJP_START_DATE	Date(10)	DATE	Appraisal Prd Start Date (14-1)
7	GPJP_END_DATE	Date(10)	DATE	Appraisal Prd End Date (14-2)
8	GPJP_GEP_START_DT	Date(10)	DATE	Appraisal Prd Start Date (14-1)
9	GPJP_GEP_END_DT	Date(10)	DATE	Appraisal Prd Start Date (14-1)
10	GPJP_SAN_START_DT	Date(10)	DATE	Appraisal Prd Start Date (14-1)
11	GPJP_SAN_END_DT	Date(10)	DATE	Appraisal Prd Start Date (14-1)
12	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
13	GPJP_PAYEE_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payee ID Type 1=Health Insurance Card Number 2=Pension Insurance Code
14	GPJP_SC_ESTAB_REF1	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number.
15	GPJP_SC_ESTAB_REF2	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number 2.
16	GPJP_SC_ESTAB2	Character(5)	VARCHAR2(5) NOT NULL	Establishment Number
17	GPJP_PENS_FUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Employee's Pension Fund
18	GPJP_GVT_MANAGED	Character(1)	VARCHAR2(1) NOT NULL	Government Managed
19	GPJP_SC_OCC_RPT	Character(1)	VARCHAR2(1) NOT NULL	Monthly Remun Report (Revised)
20	GPJP_SC_REG_RPT	Character(1)	VARCHAR2(1) NOT NULL	Monthly Remun Report (Regular)
21	GPJP_SC_ENR_RPT	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Report
22	GPJP_SC_TER_RPT	Character(1)	VARCHAR2(1) NOT NULL	Termination Report
23	GPJP_PI_ADR_RPT	Character(1)	VARCHAR2(1) NOT NULL	PI Address Change Report
24	GPJP_MEDIA	Character(1)	VARCHAR2(1) NOT NULL	Media E=Electronic Application F=Floppy Disk M=MO Disk
25	GPJP_CREATE_DT	Date(10)	DATE	File Creation Date
26	SEQ_NUM8	Number(8,0)	INTEGER NOT NULL	Sequence Number
27	ERROR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Error Type ERR=Stop NON=None WAR=Warning
28	GPJP_FD_SEQ	Number(3,0)	SMALLINT NOT NULL	FD Sequential Number
29	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
30	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle
31	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
32	GPJP_SEQ_NUM1	Number(8,0)	INTEGER NOT NULL	Sequence Number 1
33	GPJP_SEQ_NUM2	Number(8,0)	INTEGER NOT NULL	Sequence Number 2
34	GPJP_SEQ_NUM3	Number(8,0)	INTEGER NOT NULL	Sequence Number 3
35	GPJP_SEQ_NUM4	Number(8,0)	INTEGER NOT NULL	Sequence Number 4
36	GPJP_SEQ_NUM5	Number(8,0)	INTEGER NOT NULL	Sequence Number 5
37	GPJP_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Character Filed Length of 1
38	STRING_TEXT	Character(100)	VARCHAR2(100) NOT NULL	String Text
39	GPJP_RD_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Used to select the Monthly Remuneration Result data to be printed on Monthly Standard Remuneration Calculation Report (Regular) 0=Include future Occ candidates 7=Exclude future Occ candidates 8=Modori Regular Decision In Aug 9=Modori Regular Decision In Sep
40	WHERE_VALUE	Character(50)	VARCHAR2(50) NOT NULL	Value for rule selection criteria.
41	WHERE_VALUE1	Character(30)	VARCHAR2(30) NOT NULL	Value for rule selection criteria.
42	WHERE_VALUE2	Character(50)	VARCHAR2(50) NOT NULL	Field used as bind variable in AE process to dynamically build SQL statements using symbolic parameters %()
43	GPJP_PREFECTURE_CD	Character(2)	VARCHAR2(2) NOT NULL	Prefecture Code