WM_ORG_OPTIONS

(SQL Table)
Index Back

Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 WM_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Type
A=Asset Components
T=Work Order Tasks
W=Work Orders
3 WM_ORG_ORIENT Character(1) VARCHAR2(1) NOT NULL Orientation
H=Horizontal
V=Vertical

Default Value: H

4 WM_ORG_NAVIGATION Character(1) VARCHAR2(1) NOT NULL Navigation
N=Navigator
S=Scroll Bars

Default Value: N

5 WM_ORG_LEVELS Number(4,0) SMALLINT NOT NULL Hierarchy chart display levels

Default Value: 2

6 WM_ORG_COSTS Character(1) VARCHAR2(1) NOT NULL Costs
A=Actual
E=Estimated
S=Scheduled

Default Value: A