IN_TM_OPR_SEC

(SQL Table)
 Index Back

Template Permissions

  • Parent record: IN_TM_OPR_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IN_TM_CODE Character(15) VARCHAR2(15) NOT NULL Template Code
    2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN

    4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: IN_TM_ROLEDF_VW

    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BUIN_NONVW

    7 IN_TM_MAINTAIN_FLG Character(1) VARCHAR2(1) NOT NULL Maintain Flag

    Y/N Table Edit