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 |