GM_COMP_APPR_OP

(SQL View)
 Index Back

Component WF Rules


SELECT BUSINESS_UNIT , GM_ELEMENT_VALUE , GM_REQ_APPROVAL , EXCEPTION_OPRID , PROF_ROLE_TYPE , GM_WF_ON_APP , GM_SELF_APP , DESCR FROM PS_GM_CMP_WF_REQ WHERE GM_TRANS_TYPE = 'PG' AND GM_ELEMENTS = 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMPONENT_ID_GR Character(18) VARCHAR2(18) NOT NULL Component ID
3 GM_REQ_APPROVAL Character(1) VARCHAR2(1) NOT NULL Required Approval Process

Y/N Table Edit

4 EXCEPTION_OPRID Character(30) VARCHAR2(30) NOT NULL Exception Oprid. The operator id that all transactions with routing exceptions are routed to.

Prompt Table: GM_EXP_APPROVER

5 PROF_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type

Prompt Table: GM_PROF_ROLE_TY

6 GM_WF_ON_APP Character(1) VARCHAR2(1) NOT NULL Notify When Approved

Y/N Table Edit

Default Value: Y

7 GM_SELF_APP Character(1) VARCHAR2(1) NOT NULL Self Approval

Y/N Table Edit

Default Value: Y

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