RB_WL_TR_SYS_ND

(SQL Table)
Index Back

Worklist Tree Node Record

This table is used as the primary node record for the system folder tree.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FOLDER_TYPE Character(1) VARCHAR2(1) NOT NULL This field designates whether a CRM worklist folder is defined by the system or is user defined.
1=System
2=Personal
2 FOLDER_CD Character(30) VARCHAR2(30) NOT NULL This field is used by the CRM Worklist to store either the type of System folder, unique folder ID, or group worklist name.
3 FOLDER_LABEL Character(30) VARCHAR2(30) NOT NULL This field is used to store the name of a folder that is created to categorize CRM worklist notifications.
4 LEAF_FLAG Character(1) VARCHAR2(1) NOT NULL Leaf Flag
5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 RANGE_FROM Character(30) VARCHAR2(30) NOT NULL Lower boundary for detail value that contains a range of values
8 RANGE_TO Character(30) VARCHAR2(30) NOT NULL Upper boundary for detail value that contains a range of values
9 DYNAMIC_FLAG Character(1) VARCHAR2(1) NOT NULL Dynamic Flag
10 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
11 DISPLAY_OPTION Character(1) VARCHAR2(1) NOT NULL UAD Display Options
I=Image
T=Text
12 STYLECLASSNAME Character(30) VARCHAR2(30) NOT NULL Style Class Name
13 PARENT_FLAG Character(1) VARCHAR2(1) NOT NULL Parent Flag
14 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
15 LEVEL_OFFSET Number(3,0) SMALLINT NOT NULL Level Offset
16 DESCR_IMAGE Character(30) VARCHAR2(30) NOT NULL Description Image Name
17 EXPANDED_FLAG Character(1) VARCHAR2(1) NOT NULL Expanded Flag
18 DISPLAYED_FLAG Character(1) VARCHAR2(1) NOT NULL Displayed Flag
19 DESCR_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
20 DESCR_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
21 IMAGE_WIDTH Number(2,0) SMALLINT NOT NULL Image Width
22 IMAGE_HEIGHT Number(2,0) SMALLINT NOT NULL Image Height
23 COLLAPSED_IMAGE Character(30) VARCHAR2(30) NOT NULL Collapsed Image Name
24 COLLAPSED_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
25 COLLAPSED_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
26 EXPANDED_IMAGE Character(30) VARCHAR2(30) NOT NULL Expanded Image Name
27 EXPANDED_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
28 EXPANDED_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
29 END_NODE_IMAGE Character(30) VARCHAR2(30) NOT NULL End Node Image Name
30 END_NODE_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
31 END_NODE_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
32 LEAF_IMAGE Character(30) VARCHAR2(30) NOT NULL Name of image that is used for leaf , i.e. detail values in tree
33 LEAF_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
34 LEAF_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
35 HTMLAREA Long Character CLOB HTML Area
36 SORT_ORDER_NUM Number(3,0) SMALLINT NOT NULL Field to capture the sort order number.
37 HIDDEN_FLAG Character(1) VARCHAR2(1) NOT NULL Hidden Flag field