GPGB_PSLIP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPGB_PSLIP_ID	Character(6)	VARCHAR2(6) NOT NULL	Payslip ID Prompt Table: GPGB_PSLIP_HDR
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
7	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
8	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
9	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	Empl ID To
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
12	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
13	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
14	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
15	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
16	GPGB_PIN_NUM_YTD	Number(8,0)	INTEGER NOT NULL	Pin Number Year to Date
17	GPGB_RSLT_VAL_YTD	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Result Year To Date
18	GPGB_PSLIP_DETAIL	Number(8,0)	INTEGER NOT NULL	Payslip detail Pin
19	GPGB_PSLIP_D_TXT	Character(25)	VARCHAR2(25) NOT NULL	Payslip Detail Text
20	GPGB_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Adjustment
21	GPGB_ADJ_VAL_YTD	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Adjustment YTD
22	GPGB_PIN_NUM_CUR	Number(8,0)	INTEGER NOT NULL	Pin Number Current Value
23	GPGB_RSLT_VAL_CUR	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Result Current
24	GPGB_PSLIP_BSORT	Character(8)	VARCHAR2(8) NOT NULL	Bank Sort Code
25	GPGB_PSLIP_BACC	Character(35)	VARCHAR2(35) NOT NULL	Payslip Bank Account
26	GPGB_PSLIP_UK2_DIS	Character(1)	VARCHAR2(1) NOT NULL	Display User Key2 Y/N Table Edit Default Value: N
27	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
28	GPGB_COUNTER	Number(3,0)	SMALLINT NOT NULL	Counter
29	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
30	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
31	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
32	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
33	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4