AGGR_AREA_VW(SQL View) |
Index Back |
|---|---|
Fiscal Aggregate Area VwFiscal Aggregate Area Vw |
| SELECT A.SETID , B.AGGREGATE_AREA , A.AID_YEAR , C.DESCR , C.FA_SOURCE , A.CURRENCY_CD , SUM( A.MAX_OFR_BUDGT) , SUM( A.OFR_GROSS) , SUM( A.OFR_REDUCTN) , SUM( A.OFR_NET) , SUM( A.OFR_AVAILABLE) , SUM(A.OFFERED_NET_COUNT) , SUM( A.MAX_ACC_BUDGT) , SUM( A.ACC_GROSS) , SUM( A.ACC_REDUCTN) , SUM( A.ACC_NET) , SUM( A.ACC_AVAILABLE) , SUM(A.ACCEPTED_NET_COUNT) , SUM( A.DECLINED_AMTS) ,SUM( A.DECLINED_COUNT) , SUM( A.CANCELLED_AMTS) , SUM(A.CANCELLED_COUNT) , SUM( A.MAX_ATH_BUDGT) , SUM( A.NET_ATH_AMT) , SUM( A.MAX_DSB_BUDGT) , SUM( A.NET_DSB_PAID) , SUM( A.POTENTIAL_DSB) FROM PS_ITEM_TYPE_FISCL A , PS_ITEM_TYPE_FA B , PS_AGGR_LIMIT_TBL C WHERE A.SETID = B.SETID AND A.ITEM_TYPE = B.ITEM_TYPE AND A.AID_YEAR = B.AID_YEAR AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_ITEM_TYPE_FA D WHERE D.SETID = B.SETID AND D.ITEM_TYPE = B.ITEM_TYPE AND D.AID_YEAR = B.AID_YEAR AND D.EFFDT <= %CurrentDateIn) AND B.AGGREGATE_AREA = C.AGGREGATE_AREA AND B.AID_YEAR = C.AID_YEAR AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_AGGR_LIMIT_TBL C1 WHERE C1.AGGREGATE_AREA = C.AGGREGATE_AREA AND C1.AID_YEAR = C.AID_YEAR AND C1.EFFDT <= %CurrentDateIn) GROUP BY A.SETID, B.AGGREGATE_AREA, A.AID_YEAR, C.DESCR, C.FA_SOURCE, A.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | AGGREGATE_AREA |
Character(10) | VARCHAR2(10) NOT NULL |
Aggregate Area
Prompt Table: AGGR_LIMIT_VW |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: FED_AID_YR_TBL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | FA_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source
F=Federal G=Government I=Institutional O=Other P=Private S=State |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 7 | AGGR_MAX_OFR_BUD | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budgeted |
| 8 | AGGR_OFR_GROSS | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Gross |
| 9 | AGGR_OFR_REDUCTN | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Reductions |
| 10 | AGGR_OFR_NET | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Net |
| 11 | AGGR_OFR_AVAILABLE | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Available |
| 12 | OFFERED_NET_COUNT | Number(7,0) | INTEGER NOT NULL | Count |
| 13 | AGGR_MAX_ACC_BUDGT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budgeted |
| 14 | AGGR_ACC_GROSS | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Gross |
| 15 | AGGR_ACC_REDUCTN | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Reductions |
| 16 | AGGR_ACC_NET | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Net |
| 17 | AGGR_ACC_AVAILABLE | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Available |
| 18 | ACCEPTED_NET_COUNT | Number(7,0) | INTEGER NOT NULL | Count |
| 19 | AGGR_DECLINED_AMTS | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Amount |
| 20 | DECLINED_COUNT | Number(7,0) | INTEGER NOT NULL | Count |
| 21 | AGGR_CANCELLED_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Amount |
| 22 | CANCELLED_COUNT | Number(7,0) | INTEGER NOT NULL | Count |
| 23 | AGGR_MAX_ATH_BUDGT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budgeted |
| 24 | AGGR_NET_ATH_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Net |
| 25 | AGGR_MAX_DSB_BUDGT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Budgeted |
| 26 | AGGR_NET_DSB_PAID | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Paid |
| 27 | AGGR_POTENTIAL_DSB | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Potential Payments |