RUN_TREEMOVER

index back

Tree Definition


PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
TREEMOVER_RUN_MODE Character(1) VARCHAR2(1) NOT NULL TreeMover Run Mode
E=Export
I=Import
FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
NODE_COUNT Number(10,0) DECIMAL(10) NOT NULL Tree Definition Node Count

Default: 1

REPLACE_TREE_FLAG Character(1) VARCHAR2(1) NOT NULL Replace Tree if Exists

Y/N Table Edit

Default: Y

SETCNTRL_IND Character(1) VARCHAR2(1) NOT NULL Tree Structure User Key Field Type Indicator
B=Business Unit
N=None
S=SetId Indirection
U=User Defined
TREE_KEY_VALUE Character(20) VARCHAR2(20) NOT NULL Tree Key Value

Prompt Table: %EDITTABLE2

SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: TM_TREE_NAME_VW

TREE_EFFDT Date(10) DATE Effective date of the Tree

Prompt Table: TM_TREE_EFDT_VW

TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

Prompt Table: PSTREESTRCT

DESCR Character(30) VARCHAR2(30) NOT NULL Description
ALL_VALUES Character(1) VARCHAR2(1) NOT NULL Tree Level All Values flag

Y/N Table Edit

USE_LEVELS Character(1) VARCHAR2(1) NOT NULL Tree Definition Level Use Type
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced

Default: S

DUPLICATE_LEAF Character(1) VARCHAR2(1) NOT NULL Tree Definition allow duplicate leaf flag

Y/N Table Edit

TREE_CATEGORY Character(18) VARCHAR2(18) NOT NULL Category name for the Tree

Default: DEFAULT

TREE_ACC_METHOD Character(1) VARCHAR2(1) NOT NULL Tree Access Method for nVision: S=Sub-select, J=Join to Selector, L=Use Literal Values (Suppress Joins)
D=Use Application Defaults
J=Join to Tree Selector
L=Use Literal Values
S=Sub-SELECT Tree Selector

Y/N Table Edit

Default: S

TREE_ACC_SELECTOR Character(1) VARCHAR2(1) NOT NULL Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
D=Dynamic Selectors
S=Static Selector

Y/N Table Edit

Default: S

TREE_ACC_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Tree Defintion Tree Access Selector Option for nVision
B=Range of Values (BETWEEN)
R=Range of Values (>=...<=)
S=Single Values

Y/N Table Edit

Default: R

TREE_DEFN_FLAG Character(1) VARCHAR2(1) NOT NULL Tree Definition Flag

Y/N Table Edit

Default: Y

TREE_LEVEL_FLAG Character(1) VARCHAR2(1) NOT NULL Tree Level Flag

Y/N Table Edit

Default: Y

TREE_NODE_FLAG Character(1) VARCHAR2(1) NOT NULL Tree Node Flagg

Y/N Table Edit

Default: Y

TREE_STRCT_FLAG Character(1) VARCHAR2(1) NOT NULL Tree Structure Flag

Y/N Table Edit

TREE_USRLEVEL_FLAG Character(1) VARCHAR2(1) NOT NULL Tree User Level Flag

Y/N Table Edit

TREE_USRNODE_FLAG Character(1) VARCHAR2(1) NOT NULL Tree User Node Flag

Y/N Table Edit

TREE_DEFN_FILE_FLG Character(1) VARCHAR2(1) NOT NULL Load Tree Defn from File

Y/N Table Edit

Default: Y

TREE_SAVE_METHOD Character(1) VARCHAR2(1) NOT NULL Tree Save Method
D=Save as Draft
S=Save

Default: S

ENCODING Character(4) VARCHAR2(4) NOT NULL Encoding character set
ANSI=ANSI
UTF8=UTF-8

Default: UTF8

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19