SP_ORIGIN_CLSVW

(SQL View)
 Index Back

Origins View Class security


select distinct B.BUSINESS_UNIT, A.ORIGIN_ID, B.OPRCLASS, A.EFFDT, A.EFF_STATUS, A.DESCR from PS_ORIGIN_TBL A, PS_SEC_ORIGIN_CLS B, PS_SET_CNTRL_REC C where B.ORIGIN_ID = A.ORIGIN_ID and B.ACCESS_CD = 'Y' and C.SETID = A.SETID and C.SETCNTRLVALUE = B.BUSINESS_UNIT and C.RECNAME = 'ORIGIN_TBL'

  • Related Language Record: SPORIGINCLSVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Origin ID

    Prompt Table: ORIGIN_TBL

    3 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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