GP_INSTALLATION

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CKPT_INTERVAL	Number(4,0)	SMALLINT NOT NULL	Checkpoint Interval
2	PROGRESS_INTERVAL	Number(4,0)	SMALLINT NOT NULL	Progress Interval
3	UNIQUE_XREF	Number(6,0)	INTEGER NOT NULL	Unique Cross Reference
4	ABS_HIST_MONTHS	Number(3,0)	SMALLINT NOT NULL	To allow user to define the number of months of absence daily history they want to load into memory during the GP COBOL process. Once loaded into memory, this absence daily history is then available to duration elements and to the absence daily take process. Default Value: 24
5	LAST_TXN_NUM	Number(6,0)	INTEGER NOT NULL	Last Transaction Number keeps track of the last transaction number used by the absence forecasting process.
6	CANCEL_INTERVAL	Number(6,0)	INTEGER NOT NULL	Checkpoint Interval - Cancel Default Value: 2000
7	IDNT_INTERVAL	Number(6,0)	INTEGER NOT NULL	Parameter to configure size of Unit of Work b/w commits in the Identify process Default Value: 2000
8	TL_INTERVAL	Number(6,0)	INTEGER NOT NULL	Parameter to configure size of Unit of Work b/w commits in the T&L feed process
9	PI_BUNDLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Configuration parameters to indicate whether PI should be bundled on output or on input. The outcome of the final process would be the same, but the details of the individual row of PI is lost. Initially used for the absence process to control whether PI is summed into a single row of generated PI on output. Y/N Table Edit Default Value: N
10	BNK_FILE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Auto generated number when Bank File is loaded
11	SCRIPT_LOCATION	Character(100)	VARCHAR2(100) NOT NULL	Script Location
12	UPG_W_ERR_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to continue upgrade processing with errors. Y/N Table Edit Default Value: N
13	UPG_W_WARN_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to continue upgrade processing with warnings. Y/N Table Edit Default Value: N
14	PRINT_ERR_WARN_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to print Compare Report section for errors and warnings. Y/N Table Edit Default Value: Y
15	PRINT_MOD_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to print the Compare Report section for Modified elements. Y/N Table Edit Default Value: Y
16	PRINT_NEW_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to print the Compare Report section for New elements. Y/N Table Edit Default Value: N
17	PRINT_DEL_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to print the Compare Report section for Deleted elements. Y/N Table Edit Default Value: N
18	PRINT_UNCHG_IND	Character(1)	VARCHAR2(1) NOT NULL	Decide whether to print the Compare Report section for Unchanged elements. Y/N Table Edit Default Value: N
19	PMT_MSG_ID_LAST	Number(13,0)	DECIMAL(13) NOT NULL	Last Payment Message ID used in SEPA Process
20	DB_IDENTIFIER	Character(2)	VARCHAR2(2) NOT NULL	Two character DB identifier for the SEPa Process Default Value: 00
21	GP_PMT_COUNT	Number(5,0)	INTEGER NOT NULL	Number of rows sent to FG per chunk during SEPA Default Value: 3000
22	PIN_NUM_LAST	Number(8,0)	INTEGER NOT NULL	Last Used Element Number
23	DAYS_BEFORE	Number(3,0)	SMALLINT NOT NULL	This field is used to indicate how many days before the current date to show the history date range. Default Value: 90
24	DAYS_AFTER	Number(3,0)	SMALLINT NOT NULL	This field is used to indicate how many days after the current date to show the end of the history date range. Default Value: 90
25	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN_VW
26	HGA_HIDE_FCST	Character(1)	VARCHAR2(1) NOT NULL	Hide the Forecasrt button N=No Y=Yes Default Value: N
27	HGA_HIDE_SAVE_BTN	Character(1)	VARCHAR2(1) NOT NULL	Hide the Save For Later button N=No Y=Yes Default Value: N
28	PG_DAYS_BEFORE	Number(3,0)	SMALLINT NOT NULL	Days Before Current Date Default Value: 90
29	PG_DAYS_AFTER	Number(3,0)	SMALLINT NOT NULL	Days After Default Value: 90
30	PG_ACCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Access Type for AM Pivot Grid Managers 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID Default Value: 2
31	KEYWORD_SRCH_LIMIT	Number(3,0)	SMALLINT NOT NULL	Global Payroll Keyword Search limit in days for Positive Input Search Feature. Default Value: 30
32	GP_ENABLE_PI_SRCH	Character(1)	VARCHAR2(1) NOT NULL	Global Payroll Positive Input Search Enable/Disable field N=Off Y=On Default Value: N
33	GP_PG_ENABLE_ANA	Character(1)	VARCHAR2(1) NOT NULL	GP_PG_ENABLE_ANA Y/N Table Edit Default Value: N
34	GP_PA_PIVOT_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	This field is for enabling pivot grid for payroll analytics N=No Y=Yes Y/N Table Edit Default Value: N
35	GP_WC_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Enable the workarea feature N=No Y=Yes Y/N Table Edit Default Value: N
36	GP_CBL_FTRC_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	This field controls whether you can see the cobol trace options in global payroll run control page. Y/N Table Edit Default Value: N
37	GP_PROC_MON_IND	Character(1)	VARCHAR2(1) NOT NULL	Processing Monitor Indicator for Payroll Processing Default Value: N
38	GP_PYRL_SCH_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	Enable Payroll Scheduling N=No Y=Yes Default Value: N
39	GP_KIB_GBL_TIME	Character(1)	VARCHAR2(1) NOT NULL	Date option for Insights global time filter used in GP installation. B=Period Begin Date E=Period End Date P=Payment Date Default Value: B
40	GP_AUTO_ELK_INDEX	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether or not Search indexing should be triggered automatically after payroll calculation is run. Y/N Table Edit Default Value: N
41	GP_CBL_ETRC_ENABLE	Character(1)	VARCHAR2(1) NOT NULL	This field controls to enable advanced trace options in global payroll run control page. Y/N Table Edit Default Value: N