RUN_TREEMOVER

Return to Index

Table: PS_RUN_TREEMOVER

Tree Definition

PeopleSoft Field NameDescription
OPRIDA user's ID
RUN_CNTL_IDRun Control ID
TREEMOVER_RUN_MODETreeMover Run Mode
E=Export
I=Import
FILENAMEFile Name
NODE_COUNTTree Definition Node Count

Default: 1

REPLACE_TREE_FLAGReplace Tree if Exists

Y/N Table Edit

Default: Y

SETCNTRL_INDTree Structure User Key Field Type Indicator
B=Business Unit
N=None
S=SetId Indirection
U=User Defined
TREE_KEY_VALUETree Key Value

Prompt Table: %EDITTABLE2

SETIDSetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUETree Definition User Key Value
TREE_NAMETree Name

Prompt Table: TM_TREE_NAME_VW

TREE_EFFDTEffective date of the Tree

Prompt Table: TM_TREE_EFDT_VW

TREE_STRCT_IDTree Structure Name

Prompt Table: PSTREESTRCT

DESCRDescription
ALL_VALUESTree Level All Values flag
N=No
Y=Yes

Y/N Table Edit

USE_LEVELSTree Definition Level Use Type
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced (default)
DUPLICATE_LEAFTree Definition allow duplicate leaf flag

Y/N Table Edit

TREE_CATEGORYCategory name for the Tree

Default: DEFAULT

TREE_ACC_METHODTree 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 (default)

Y/N Table Edit

TREE_ACC_SELECTORTree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors
D=Dynamic Selectors
S=Static Selector (default)

Y/N Table Edit

TREE_ACC_SEL_OPTTree Defintion Tree Access Selector Option for nVision
B=Range of Values (BETWEEN)
R=Range of Values (>=...<=) (default)
S=Single Values

Y/N Table Edit

TREE_DEFN_FLAGTree Definition Flag

Y/N Table Edit

Default: Y

TREE_LEVEL_FLAGTree Level Flag

Y/N Table Edit

Default: Y

TREE_NODE_FLAGTree Node Flagg

Y/N Table Edit

Default: Y

TREE_STRCT_FLAGTree Structure Flag

Y/N Table Edit

TREE_USRLEVEL_FLAGTree User Level Flag

Y/N Table Edit

TREE_USRNODE_FLAGTree User Node Flag

Y/N Table Edit

TREE_DEFN_FILE_FLGLoad Tree Defn from File

Y/N Table Edit

Default: Y

TREE_SAVE_METHODTree Save Method
D=Save as Draft
S=Save (default)

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010