BUSINESS_UNITANALYSIS_TYPEPC_DEL_ANTYP_VW(SQL View) |
Index Back |
|---|---|
SQL ViewFROM PS_PROJ_AN_GRP_MAP AGM , PS_SET_CNTRL_REC CNTRL , PS_PC_DEL_ANLGRP DAG |
| SELECT DAG.BUSINESS_UNIT , MAX(AGM.ANALYSIS_TYPE) FROM PS_PROJ_AN_GRP_MAP AGM , PS_SET_CNTRL_REC CNTRL , PS_PC_DEL_ANLGRP DAG WHERE AGM.ANALYSIS_GROUP = DAG.ANALYSIS_GROUP AND CNTRL.RECNAME = 'PROJ_AN_GRP_MAP' AND CNTRL.SETCNTRLVALUE = DAG.BUSINESS_UNIT AND AGM.SETID = CNTRL.SETID GROUP BY DAG.BUSINESS_UNIT, AGM.ANALYSIS_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ANALYSIS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |