RUN_TREEMOVER

index back

Tree Definition


PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
TREEMOVER_RUN_MODECharacter(1)VARCHAR2(1) NOT NULLTreeMover Run Mode
E=Export
I=Import
FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
NODE_COUNTNumber(10,0)DECIMAL(10) NOT NULLTree Definition Node Count

Default: 1

REPLACE_TREE_FLAGCharacter(1)VARCHAR2(1) NOT NULLReplace Tree if Exists

Y/N Table Edit

Default: Y

SETCNTRL_INDCharacter(1)VARCHAR2(1) NOT NULLTree Structure User Key Field Type Indicator
B=Business Unit
N=None
S=SetId Indirection
U=User Defined
TREE_KEY_VALUECharacter(20)VARCHAR2(20) NOT NULLTree Key Value

Prompt Table: %EDITTABLE2

SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value
TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name

Prompt Table: TM_TREE_NAME_VW

TREE_EFFDTDate(10)DATEEffective date of the Tree

Prompt Table: TM_TREE_EFDT_VW

TREE_STRCT_IDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Name (see PSTREESTRCT).

Prompt Table: PSTREESTRCT

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ALL_VALUESCharacter(1)VARCHAR2(1) NOT NULLTree Level All Values flag

Y/N Table Edit

USE_LEVELSCharacter(1)VARCHAR2(1) NOT NULLTree Definition Level Use Type
L=Loosely Enforced
N=Level Not Used
S=Strictly Enforced

Default: S

DUPLICATE_LEAFCharacter(1)VARCHAR2(1) NOT NULLTree Definition allow duplicate leaf flag

Y/N Table Edit

TREE_CATEGORYCharacter(18)VARCHAR2(18) NOT NULLCategory name for the Tree

Default: DEFAULT

TREE_ACC_METHODCharacter(1)VARCHAR2(1) NOT NULLTree 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_SELECTORCharacter(1)VARCHAR2(1) NOT NULLTree 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_OPTCharacter(1)VARCHAR2(1) NOT NULLTree 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_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree Definition Flag

Y/N Table Edit

Default: Y

TREE_LEVEL_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree Level Flag

Y/N Table Edit

Default: Y

TREE_NODE_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree Node Flagg

Y/N Table Edit

Default: Y

TREE_STRCT_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree Structure Flag

Y/N Table Edit

TREE_USRLEVEL_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree User Level Flag

Y/N Table Edit

TREE_USRNODE_FLAGCharacter(1)VARCHAR2(1) NOT NULLTree User Node Flag

Y/N Table Edit

TREE_DEFN_FILE_FLGCharacter(1)VARCHAR2(1) NOT NULLLoad Tree Defn from File

Y/N Table Edit

Default: Y

TREE_SAVE_METHODCharacter(1)VARCHAR2(1) NOT NULLTree Save Method
D=Save as Draft
S=Save

Default: S

ENCODINGCharacter(4)VARCHAR2(4) NOT NULLEncoding character set
ANSI=ANSI
UTF8=UTF-8

Default: UTF8

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