IN_TM_OPR_INQVW

(SQL View)
 Index Back

Template Permission Inquiry Vw


SELECT HDR.IN_TM_CODE , HDR.TEMPLATE_ID , HDR.DESCR , HDR.ACTIVE_FLAG , SEC.SETID , SEC.BUSINESS_UNIT , SEC.ROLENAME , SEC.OPRID , SEC.IN_TM_MAINTAIN_FLG FROM PS_IN_TM_OPR_HDR HDR , PS_IN_TM_OPR_SEC SEC WHERE HDR.IN_TM_CODE = SEC.IN_TM_CODE AND HDR.TEMPLATE_ID = SEC.TEMPLATE_ID

  • Related Language Record: IN_TM_OPR_INQLV

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    7 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    9 IN_TM_MAINTAIN_FLG Character(1) VARCHAR2(1) NOT NULL Maintain Flag

    Y/N Table Edit