GPCN_BDGT_ITEMPrompt Table: GPCN_BDGT_ITEM
GPCN_BDGT_PRDPrompt Table: GPCN_BDGT_PRD
D=Distributed
P=Planned
Default Value: P
GPCN_DIST_T_VW(SQL View) |
Index Back |
|---|---|
tree view for alerttree temple view for alert |
| SELECT a.gpcn_bdgt_item ,a.gpcn_bdgt_prd ,a.setid ,a.tree_name , a.tree_effdt AS tree_effdt , b.descr , a.gpcn_bdgt_stats FROM ps_gpcn_bdgt_distr a , PS_GPCN_TREE_VW b WHERE a.setid= b.setid AND a.tree_name= b.tree_name AND a.tree_effdt= b.effdt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCN_BDGT_ITEM |
Character(10) | VARCHAR2(10) NOT NULL |
Budget Item
Prompt Table: GPCN_BDGT_ITEM |
| 2 | GPCN_BDGT_PRD |
Character(10) | VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table: GPCN_BDGT_PRD |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 5 | TREE_EFFDT | Date(10) | DATE NOT NULL | Effective date of the Tree |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GPCN_BDGT_STATS | Character(1) | VARCHAR2(1) NOT NULL |
Budget status
D=Distributed P=Planned Default Value: P |