GPJP_SC_LD_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	COUNTER	Number(10,0)	DECIMAL(10) NOT NULL	Counter
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	PYMT_DT	Date(10)	DATE	Payment Date
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	GPJP_HLTH_CARD_NUM	Number(8,0)	INTEGER NOT NULL	Health Insurance Card Number.
11	GPJP_PAYEE_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payee ID Type 1=Health Insurance Card Number 2=Pension Insurance Code
12	RUN_FINALIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalized Run
13	GPJP_FORCE_RD	Character(1)	VARCHAR2(1) NOT NULL	Force regular Decision
14	GPJP_PAY_LAST_P	Date(10)	DATE	Last Date of Previous Month
15	GPJP_PAY_LAST_2P	Date(10)	DATE	Last date of 2 previous months before the Payment date
16	GPJP_PAY_LAST_3P	Date(10)	DATE	Last date of the month that is 3 months before the Payment month
17	GPJP_PAY_LAST_C	Date(10)	DATE	Last date of the current month
18	GPJP_SC_REM_P_PIN	Character(15)	VARCHAR2(15) NOT NULL	Previous Month Monthly Remuneration Element Name
19	GPJP_SC_REM_2P_PIN	Character(15)	VARCHAR2(15) NOT NULL	Element Name of corresponding Monthly Remuneration for the month that is 2 month before the Payment Month