SETIDSCH_INBOUND_BUDA=Active
I=Inactive
PC_MSP2_BUD_VW(SQL View) |
Index Back |
|---|---|
View of PS_INSTALLATION_PCPS_INSTALLATION_PC |
| SELECT VW.SETID , VW.ANALYSIS_TYPE , VW.EFF_STATUS FROM %Table(PROJ_AN_GRP_VW) VW WHERE VW.EFF_STATUS = 'A' AND VW.EFFDT <= %CurrentDateIn AND VW.ANALYSIS_GROUP = ( SELECT PC_SCH_ANGRP_BUD FROM PS_INSTALLATION_PC) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SCH_INBOUND_BUD |
Character(5) | VARCHAR2(5) NOT NULL | Budget Analysis Type |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |