GP_INSTALLATION(SQL Table) |
Index Back |
---|---|
GP InstallationGP 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 |