SP_BUPCIT_OPRVW

(SQL View)
 Index Back

Integration Template Operator

Operator security view of PC_INT_TMPL_GL.

SELECT B.OPRID , A.SETID , A.INTEGRATION_TMPL , A.BUSINESS_UNIT_GL , A.DESCR , A.PRIMARY_GL_BU , A.CURRENCY_CD , A.PERCENTAGE_SHARE , A.DESCRLONG FROM PS_PC_INT_TMPL_GL A , PS_SEC_BU_OPR B WHERE A.BUSINESS_UNIT_GL = B.BUSINESS_UNIT

  • Related Language Record: SP_BUPCIT_NONLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    3 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL

    4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PRIMARY_GL_BU Character(1) VARCHAR2(1) NOT NULL Primary GL Business Unit

    Y/N Table Edit

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

    Default Value: INSTALLATION_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    8 PERCENTAGE_SHARE Number(6,2) DECIMAL(5,2) NOT NULL Percentage of the deal that is pledged to the collateral.

    Default Value: 100

    9 DESCRLONG Long Character CLOB Long Description