INSTALL_RTBL(SQL Table) |
Index Back |
---|---|
RTBL Installation Options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RTBL_COMBO_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
0=Enabled in RTBL 1=Disabled in RTBL 2=Optional in RTBL Default Value: 2 |
2 | RTBL | Character(1) | VARCHAR2(1) NOT NULL |
RTBL Installed
Y/N Table Edit Default Value: N |
3 | DEPLOY_ID_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Last Scenario Deploy Request |
4 | TREE_RUNCNTL_SEQ | Number(7,0) | INTEGER NOT NULL | Last Tree Run Sequence |
5 | RTBL_TREE_FILEPATH | Character(50) | VARCHAR2(50) NOT NULL | Tree data moves between the base and RTBL environments using the TREEMOVER export/import processes. This file path is used to write the tree export data to a specified file path accessible by both environments so that the tree import can pick it up. |
6 | RTBL_RUNID_SEQ | Number(20,0) | DECIMAL(20) NOT NULL | Last RTBL Run Sequence |
7 | CF_REQ_ID_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Last ChartField Deploy Request |
8 | GTT_INSTANCE | Number(4,0) | SMALLINT NOT NULL |
GTT Instance Count
Default Value: 9 |
9 | MAX_SCE_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Max Scenario ID
Default Value: 2000 |
10 | RTBL_WARN_LVL | Character(1) | VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
0=Suppress all Warnings 1=Display as Warnings 2=Display as Errors Default Value: 1 |
11 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
12 | RTBL_ALOW_PURGE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Batch Data Purge
Default Value: N |
13 | THRESHOLD_PCT | Number(3,0) | SMALLINT NOT NULL |
Confidence %
Default Value: 80 |