GM_CMP_EVL_COND

(SQL View)
 Index Back

WF Conditions


SELECT A.BUSINESS_UNIT , A.GM_TRANS_TYPE , A.GM_ELEMENTS , A.GM_ELEMENT_VALUE , A.GM_CONDITION_ID , A.PNLGRPNAME , A.CURRENCY_CD , A.CUR_RT_TYPE , A.AMT_RECNAME , A.AMT_FLDNAME , A.FIELDNAME_CUR , A.CRTA_OPERATOR_NUM , A.AMOUNT_1 , A.AMOUNT_2 , B.GM_LEVEL_ID , B.GM_CURR_SCROLL , B.GM_PARENT_RECNAME , B.GM_GP_RECNAME FROM PS_GM_CMP_WF_COND A , PS_GM_WF_COMPONENT B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND B.RECNAME = A.AMT_RECNAME

# 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_CA.BUSINESS_UNIT

Prompt Table: SP_BU_CA_NONVW

2 GM_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL Transaction Type
PB=Protocol Batch Notification
PG=Proposal Component Approval
PM=Milestone Notfication
PN=Protocol Notification
PP=Proposal Notification
PT=Protocol Approval
3 GM_ELEMENTS Character(1) VARCHAR2(1) NOT NULL Element
A=Protocol Approval
B=Protocol Batch Notification
C=Proposal Components
M=Award Milestone
N=Protocol Notification
S=Proposal Status
4 GM_ELEMENT_VALUE Character(18) VARCHAR2(18) NOT NULL GM_ELEMENT_VALUE
5 GM_CONDITION_ID Character(4) VARCHAR2(4) NOT NULL Condition ID
6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: GM_WF_COMP_LIST

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

8 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: CUR_RT_TYPE_TBL

9 AMT_RECNAME Character(15) VARCHAR2(15) NOT NULL Amount Record

Prompt Table: GM_WF_COMPONENT

10 AMT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Amount Field Name

Prompt Table: GM_AMT_FIELDS

11 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

Prompt Table: GM_CURR_FIELDS

12 CRTA_OPERATOR_NUM Character(2) VARCHAR2(2) NOT NULL Criteria Operator
<=Less Than
>=Greater Than
B=Between(Inclusive)
13 AMOUNT_1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
14 AMOUNT_2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Work Field
15 GM_LEVEL_ID Character(1) VARCHAR2(1) NOT NULL Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3
16 GM_CURR_SCROLL Character(15) VARCHAR2(15) NOT NULL 3 Level Scroll Name
17 GM_PARENT_RECNAME Character(15) VARCHAR2(15) NOT NULL 2 Level Scroll Name
18 GM_GP_RECNAME Character(15) VARCHAR2(15) NOT NULL 1 Level Scroll Name