| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
PROCESS_STEP |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Step
|
| 3 |
VERSION_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Version Number
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: ALLOC_STEP_TBL.EFFDT
|
| 5 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFLD_LBL_P_VW
|
| 6 |
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
|
| 7 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
%EDITTABLE3
|
| 8 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table:
%EDITTABLE2
|
| 9 |
TREE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Type
D=Detail
Y=Dynamic
Default Value: D
|
| 10 |
SETCNTRLVALUE_TREE |
Character(20) |
VARCHAR2(20) NOT NULL |
Used in allocation panels
Prompt Table:
BUS_UNIT_TBL_FS
|
| 11 |
INCLUDE_EXCLUDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Inclusion/Exclusion
0=Include Specified Values
1=Exclude Specified Values
Default Value: 0
|
| 12 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
Default Value: 0
|