GM_CMP_EVL_DTL

(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.GM_CONTROL_ID , A.PNLGRPNAME , A.RECNAME , A.FIELDNAME , A.CRTA_OPERATOR , A.CRTA_OPERATOR_NUM , A.CRTA_VAL1 , A.CRTA_VAL2 , B.GM_LEVEL_ID , B.GM_CURR_SCROLL , B.GM_PARENT_RECNAME , B.GM_GP_RECNAME FROM PS_GM_CMP_WF_DTL A , PS_GM_WF_COMPONENT B WHERE A.PNLGRPNAME = B.PNLGRPNAME AND B.RECNAME = A.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 GM_CONTROL_ID Number(3,0) SMALLINT NOT NULL Control ID
7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GM_WF_COMPONENT

9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSRECFIELDALL

10 CRTA_OPERATOR Character(3) VARCHAR2(3) NOT NULL Criteria Operator
<=Less Than
<>=Not Equal To
==Equals
>=Greater Than
B=Between
NN=Is Not Blank
NU=Is Blank
11 CRTA_OPERATOR_NUM Character(2) VARCHAR2(2) NOT NULL Criteria Operator
<=Less Than
>=Greater Than
B=Between(Inclusive)
12 CRTA_VAL1 Character(100) VARCHAR2(100) NOT NULL Criteria Value 1
13 CRTA_VAL2 Character(100) VARCHAR2(100) NOT NULL Criteria Value 2
14 GM_LEVEL_ID Character(1) VARCHAR2(1) NOT NULL Level
0=Level 0
1=Level 1
2=Level 2
3=Level 3
15 GM_CURR_SCROLL Character(15) VARCHAR2(15) NOT NULL 3 Level Scroll Name
16 GM_PARENT_RECNAME Character(15) VARCHAR2(15) NOT NULL 2 Level Scroll Name
17 GM_GP_RECNAME Character(15) VARCHAR2(15) NOT NULL 1 Level Scroll Name