RUN_TREE_UTILS

Return to Index

Table: PS_RUN_TREE_UTILS

Run Control for Tree Audits & Maintenance Programs

PeopleSoft Field NameDescription
OPRIDA user's ID
RUN_CNTL_IDRun Control ID
ALL_TREES_FLAGAll Trees

Y/N Table Edit

Default: N

SETIDSetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUETree Definition User Key Value

Prompt Table: %EDITTABLE2

TREE_NAMETree Name

Prompt Table: TM_TREE_NAME_VW

TREE_EFFDTEffective date of the Tree

Default: %DATE

Prompt Table: TM_TREE_EFDT_VW

TREE_UTILITY_TYPETree Utility
00=Tree Audits (default)
01=Correct Parent Node Numbers
02=Reset Tree Node Gaps
03=Correct Level Numbers
04=Delete Orphan Tree Objects
05=Remove Tree Branches
06=Update Tree Table Statistics
07=Remove Tree Reservations
REPORT_ONLY_FLAGReport Only

Y/N Table Edit

Default: N

ALLOW_SKIP_LEVELSAllow Skip Levels

Y/N Table Edit

Default: N

NODE_AUDIT_FLAGNode Audits

Y/N Table Edit

Default: N

LEAF_AUDIT_FLAGDetail Value Audits

Y/N Table Edit

Default: N

TREE_AUDIT_SCOPEAudit Scope
M=Multiple Trees
S=Single Tree (default)
AUDIT_ASOFDATEAs of Date Operator
A=All Trees
C=As of Current Date
E=Effective Date of Tree (default)
S=As of Specific Date
ASOFDATEAs of Date

Default: %date

Author: PeopleTools

Return to Index

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