| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: SEL_CRITR_TBL.BUSINESS_UNIT
Prompt Table:
SEL_CRITR_TBL
|
| 2 |
CRITERIA |
Character(12) |
VARCHAR2(12) NOT NULL |
Criteria for Selector
Default Value: SEL_CRITR_TBL.CRITERIA
Prompt Table:
SEL_CRITR_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: SEL_CRITR_TBL.EFFDT
|
| 4 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 6 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 9 |
HOW_FIELD_SPECIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
How Specified
1=All Detail Values
2=Selected Detail Values
3=Detail - Selected Parents
4=Selected Tree Nodes
5=Children at a Level
6=All Nodes at Selected Levels
7=Selected Summary ChrtFld Nodes
9=Value Mask
A=Account Type
R=Range of Values
Default Value: 2
|
| 10 |
SF_SEL_OPERATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Selector Operator
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
BLK=Is Blank
BTW=Between A and B
NBL=Is Not Blank
|
| 11 |
TREE_NAME_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
TableSet
Prompt Table:
SP_SETID_NONVW
|
| 12 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREE_NAME_SF_VW
|
| 13 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table:
TREE_LEVEL_VW
|
| 14 |
TREE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Type
D=Detail
Y=Dynamic Tree
Default Value: D
|