PC_TIP_AN_SRCHW

(SQL View)
 Index Back

Search 'IN' criteria xlats

View used to display Analysis Types

SELECT A.SETID , A.ANALYSIS_GROUP , A.ANALYSIS_TYPE , ' ' , B.DESCR FROM PS_PROJ_AN_GRP_MAP A , PS_PROJ_ANTYPE_TBL B WHERE A.SETID = B.SETID AND A.ANALYSIS_TYPE = B.ANALYSIS_TYPE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_PROJ_ANTYPE_TBL WHERE SETID = B.SETID AND ANALYSIS_TYPE = B.ANALYSIS_TYPE) AND ANALYSIS_GROUP = 'ALL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SETID_TBL

2 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group

Default Value: ALL

Prompt Table: SP_AN_GRP_NONVW

3 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
4 LINE_SELECT_CB Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description