SETIDPrompt Table: SP_SETID_NONVW
0=Distribution
1=Production
CP_TREE_VW(SQL View) |
Index Back |
|---|---|
CP Rule Tree ViewView of CP_TREE_HDR, CP_TREE_DETL |
| SELECT TH.SETID , TH.CP_AREA , TH.CP_TREE , TH.CP_TREE_DESCR , TD.CP_NODE , TD.CP_TREE_SEQ , TD.RULE_NUMBER FROM PS_CP_TREE_HDR TH , PS_CP_TREE_DETL TD WHERE TH.SETID = TD.SETID AND TH.CP_AREA = TD.CP_AREA AND TH.CP_TREE = TD.CP_TREE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CP_AREA | Character(1) | VARCHAR2(1) NOT NULL |
Functional Area Field
0=Distribution 1=Production |
| 3 | CP_TREE | Character(18) | VARCHAR2(18) NOT NULL | Model Field |
| 4 | CP_TREE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Model Description Field |
| 5 | CP_NODE | Number(5,0) | INTEGER NOT NULL | Node Number Field |
| 6 | CP_TREE_SEQ | Number(5,0) | INTEGER NOT NULL | Model Sequence Field |
| 7 | RULE_NUMBER | Character(10) | VARCHAR2(10) NOT NULL | Rule |