GP_RGST_EXT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_GRP_SRCH
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
4	COUNTRY2	Character(3)	VARCHAR2(3) NOT NULL	Country
5	DATE_FROM	Date(10)	DATE	Date From
6	DATE_TO	Date(10)	DATE	Previous Period Date To
7	GB_EFFDT	Date(10)	DATE	Group As Of Date
8	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
9	GB_REFINE_DATE	Date(10)	DATE	Refinement Date
10	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
11	GP_GENRPT_BLD_GRP	Character(1)	VARCHAR2(1) NOT NULL	Indicates if the group build must be rebuilt or not
12	GP_RGST_POPUL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field controls the method of selecting the employee population for the Payroll Results Register report. 10=All Payees 20=HR Group Build 30=GP Group List 40=Payees
13	GP_RGST_PRD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This field identifies the type of period that will be utilized on the run control. 10=Period Begin Date Range 20=Period End Date Range 30=Payment Date Range 40=Year and Quarter
14	GP_RGST_QTR	Character(2)	VARCHAR2(2) NOT NULL	This field defines the quarter parameter for the Results Register. 01=1st Quarter 02=2nd Quarter 03=3rd Quarter 04=4th Quarter
15	GP_RGST_RUN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The Field is used to define how the Payroll Results Regsiter will be run. 10=Calendar Group 20=Period
16	GP_RGST_YEAR	Number(4,0)	SMALLINT NOT NULL	This field defines the year parameter for the Results Register.
17	GP_RPT_ID	Character(18)	VARCHAR2(18) NOT NULL	Extraction Process Name
18	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List ID
19	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
20	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID