SETIDTREE_NAMESOURCE_SETPOS_SOURCE_IDPrompt Table: POS_SOURCE_TBL
TREE_NODEDefault Value: POS_HDR_TBL.TREE_NODE
Y/N Table Edit
Default Value: N
POS_WHER_SRC_VW(SQL View) |
Index Back |
|---|---|
Position Where Header |
| SELECT SETID , TREE_NAME , SOURCE_SET , POS_SOURCE_ID , TREE_NODE , USE_SOURCE , WEIGHTING FROM PS_POS_WHERE_HDR WHERE USE_SOURCE='Y' |
| # | 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 | POS_SOURCE_ID |
Character(18) | VARCHAR2(18) NOT NULL |
"A unique key identifier that represents a position source dataset
Prompt Table: POS_SOURCE_TBL |
| 5 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL |
Node name
Default Value: POS_HDR_TBL.TREE_NODE |
| 6 | USE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to associate a predefined position source with a selected position tree node (cash worksh
Y/N Table Edit Default Value: N |
| 7 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |