GP_PA_SRCH_DEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPG_PGRIDTITLE	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Title
2	PTPG_PGRIDNAME	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Name (see PSPGCORE).
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	OPER_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Operation Fieldname
6	GP_PA_NUM_FLD	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	used in payroll analytics
7	GP_PA_DATE_FLD	Date(10)	DATE	used in payroll analytics
8	GP_PA_SIGN_FLD	Signed Number(25,3)	DECIMAL(23,3) NOT NULL	Used in payroll analytics
9	GP_PA_CHAR_FLD	Character(30)	VARCHAR2(30) NOT NULL	used in payroll analytics Prompt Table: %EDITTABLE
10	GP_PA_USER_FLD	Character(35)	VARCHAR2(35) NOT NULL	Used in payroll analytics
11	GP_CHAR_FLD1	Character(50)	VARCHAR2(50) NOT NULL	used in payroll analytics
12	GP_PA_DATA_TYP	Character(20)	VARCHAR2(20) NOT NULL	used in payroll analytics
13	GP_PA_ALL_OPER	Character(2)	VARCHAR2(2) NOT NULL	used in payroll analytics CN=contains EQ== GE=>= GT=> LE=<= LK=begins with LT=<
14	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
15	GP_PA_XLAT_FLD	Character(1)	VARCHAR2(1) NOT NULL	Used in payroll analytics N=No Y=Yes
16	GP_PA_OPER_VAL	Character(6)	VARCHAR2(6) NOT NULL	Used in payroll analytics
17	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
18	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
19	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
20	GP_EXIST_CURR_CAL	Character(1)	VARCHAR2(1) NOT NULL	exists only in current calendar N=No Y=Yes
21	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %EDITTABLE