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