CAP_TOTALS_VW(SQL View) |
Index Back |
|---|---|
Totals by CAP Num & Asset Stat |
| Select a.Business_Unit, a.CAP_Num, a.CAP_Sequence, d.Descr, a.Cost_Estimated, a.Cost_Limit, a.CAP_Status, b.Asset_ID, c.Asset_Status, b.Cost, c.currency_cd From ps_CAP_Det a, ps_Cost b, ps_Asset c, ps_CAP d, PS_BUS_UNIT_TBL_AM e, ps_Installation_AM f Where a.Business_Unit = b.Business_Unit and b.Business_Unit = c.Business_Unit and a.CAP_Num = c.CAP_Num and a.CAP_Sequence = c.CAP_Sequence and b.Asset_ID = c.Asset_ID and d.Business_Unit = a.Business_Unit and d.CAP_Num = a.CAP_Num and b.Book = e.CAP_Book and e.Business_Unit = c.Business_Unit and b.trans_dt <= %CURRENTDATEin and b.trans_type <> f.type_retire |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | CAP_NUM |
Character(15) | VARCHAR2(15) NOT NULL | Capital Acquisition Plan # |
| 3 | CAP_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | CAP Sequence |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | COST_ESTIMATED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Estimated Cost |
| 6 | COST_LIMIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cost Limit |
| 7 | CAP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Appropriation Status
1=Approval 1 2=Approval 2 3=Approval 3 C=Closed E=Entered H=On Hold O=Open |
| 8 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 9 | ASSET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service) B=Budgeted C=Commitment D=Disposed I=In Service M=Suspended R=Requisitioned T=Transferred W=Work In Progress |
| 10 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |