SETIDTREE_NAMESOURCE_SETDefault Value: 1
Y/N Table Edit
Default Value: N
Default Value: N
POS_SOURCE_SET(SQL Table) |
Index Back |
|---|---|
Position Source SetA group of position sources that will be used on the CPW. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 5 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL |
a checkbox that identifies the default position source set.
Y/N Table Edit Default Value: N |
| 6 | POS_DEAL_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL |
A checkbox that determines if the current source set is to be used for deal condtions or selection criteria.
Default Value: N |
| 7 | POS_IMPCT_ORIG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the calculated monetary value for a specific position tree node; the result |