RUN_TREE_UTILS

index back

Run Control : Tree Utilities

Run Control for Tree Audits & Maintenance Programs

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
ALL_TREES_FLAGCharacter(1)VARCHAR2(1) NOT NULLAll Trees

Y/N Table Edit

Default: N

SETIDCharacter(5)VARCHAR2(5) NOT NULLSetID

Prompt Table: SETID_NOMETA_VW

SETCNTRLVALUECharacter(20)VARCHAR2(20) NOT NULLTree Definition User Key Value

Prompt Table: %EDITTABLE2

TREE_NAMECharacter(18)VARCHAR2(18) NOT NULLTree Name

Prompt Table: TM_TREE_NAME_VW

TREE_EFFDTDate(10)DATEEffective date of the Tree

Default: %DATE

Prompt Table: TM_TREE_EFDT_VW

TREE_UTILITY_TYPECharacter(2)VARCHAR2(2) NOT NULLTree Utility
00=Tree Audits
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

Default: 00

REPORT_ONLY_FLAGCharacter(1)VARCHAR2(1) NOT NULLReport Only

Y/N Table Edit

Default: N

ALLOW_SKIP_LEVELSCharacter(1)VARCHAR2(1) NOT NULLAllow Skip Levels

Y/N Table Edit

Default: N

NODE_AUDIT_FLAGCharacter(1)VARCHAR2(1) NOT NULLNode Audits

Y/N Table Edit

Default: N

LEAF_AUDIT_FLAGCharacter(1)VARCHAR2(1) NOT NULLDetail Value Audits

Y/N Table Edit

Default: N

TREE_AUDIT_SCOPECharacter(1)VARCHAR2(1) NOT NULLAudit Scope
M=Multiple Trees
S=Single Tree

Default: S

AUDIT_ASOFDATECharacter(1)VARCHAR2(1) NOT NULLAs of Date Operator
A=All Trees
C=As of Current Date
E=Effective Date of Tree
S=As of Specific Date

Default: E

ASOFDATEDate(10)DATEAs of Date

Default: %date

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