GPCN_BDGT_ITEMPrompt Table: GPCN_BDGT_ITEM
GPCN_BDGT_PRDPrompt Table: GPCN_BDGT_PRD
D=Distributed
P=Planned
Default Value: P
GPCN_DIT_PRD_VW(SQL View) |
Index Back |
|---|---|
prd view for alertprd temple view for alert |
| SELECT a.gpcn_bdgt_item , a.gpcn_bdgt_prd , b.descr , a.gpcn_bdgt_stats FROM ps_gpcn_bdgt_distr a ,PS_GPCN_BDGT_PRD b WHERE a.gpcn_bdgt_prd=b.gpcn_bdgt_prd |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | GPCN_BDGT_STATS | Character(1) | VARCHAR2(1) NOT NULL |
Budget status
D=Distributed P=Planned Default Value: P |