RIT_SPEC_TEMP(SQL Table) |
Index Back |
|---|---|
Tree Node |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREECTL_NAME | Character(15) | VARCHAR2(15) NOT NULL | Tree Name |
| 2 | TREE_NODE4 | Character(4) | VARCHAR2(4) NOT NULL | Tree Node Name (ID) |
| 3 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 5 | NODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Tree node description. |
| 6 | DISPLAY_OPTION1 | Character(1) | VARCHAR2(1) NOT NULL |
Display Option
B=Both D=Description N=Name Default Value: D |
| 7 | PARENT_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table: RIT_TREECTL_NDE |
| 8 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
Default Value: 1 |
| 9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 10 | TREE_TAG | Character(3) | VARCHAR2(3) NOT NULL |
Tree Tag
L_L=Leaf Under Leaf L_N=Leaf Under Node N_L=Node Under Leaf N_N=Node Under Node N_R=Node Under Root R=Root |
| 11 | CHILD_NODE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Folder
LEA=Leaf NOD=Folder Default Value: NOD |
| 12 | CHILD_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL |
Child Node Number
Default Value: 999 |
| 13 | VIEWNAME | Character(30) | VARCHAR2(30) NOT NULL | View Name |
| 14 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Node User Key Field Name |
| 15 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 16 | ID_NAME | Character(20) | VARCHAR2(20) NOT NULL | ID Fld in View |
| 17 | ID_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
ID Type
CHA=Character NUM=Number Default Value: CHA |
| 18 | ID_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ID Value |
| 19 | NODE_DESCR_FLD | Character(20) | VARCHAR2(20) NOT NULL | Description Field |
| 20 | NODE_DESCR_FLD2 | Character(20) | VARCHAR2(20) NOT NULL | Second Field |
| 21 | NODE_DESCR_FLD3 | Character(20) | VARCHAR2(20) NOT NULL | Third Field |
| 22 | NODE_DESCR_FLD4 | Character(20) | VARCHAR2(20) NOT NULL | Fourth Field |
| 23 | WHERE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Where Type
D=Default Where Clause E=Exception Where Clause Default Value: D |
| 24 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table: RBT_MENU_VW |
| 25 | BARNAME | Character(30) | VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
RB_BARNAME_VW
|
| 26 | ITEMNAME | Character(30) | VARCHAR2(30) NOT NULL |
Item Name
Prompt Table:
RB_ITEMNAME_VW
|
| 27 | PAGENAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name
Prompt Table:
RBT_PAGENAME_VW
|
| 28 | SRCH_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Search Record |
| 29 | TRANSFER_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Transfer Mode
A=Add C=Correction E=Data Entry L=Update/Display All U=Update/Display Default Value: U |
| 30 | MAX_ROWS_SCROLL | Number(5,0) | INTEGER NOT NULL |
Max Number of Rows in Scrolls
Default Value: 0 |
| 31 | VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Show Sub Page
Y/N Table Edit Default Value: Y |
| 32 | ORDER_BY_COLS | Character(50) | VARCHAR2(50) NOT NULL | Order by |
| 33 | TREECTL_NODE | Character(30) | VARCHAR2(30) NOT NULL | Node name |
| 34 | HIDE_HEADER | Character(1) | VARCHAR2(1) NOT NULL |
Hide the Lead/Opportunity Header fields.
Y/N Table Edit Default Value: N |
| 35 | CONSUMER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
To indicate whether a person has a consumer role.
Y/N Table Edit Default Value: N |
| 36 | SUBINT_OBJ_TYPE | Character(4) | VARCHAR2(4) NOT NULL | sub-interaction object type |
| 37 | EXPANDED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Expanded Flag
Y/N Table Edit Default Value: Y |
| 38 | RIT_TREE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Tree Action Type
N=None (Link Inactive) P=Fire PeopleCode(See Document) T=Transfer (Transfer to Page) Default Value: N |