GP_INSTALLATION

(SQL Table)
Index Back

GP Installation

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