SP_NTSRCH_CLSVW

(SQL View)
Index Back

PROMT for Self Service Budg

If the Inquiry Security Event is inactive the user can select any Budget Type attached to their Default business Unit. If the Inquire Event is active, the selection is based upon whether the user is a super user or if they have 'Allow' status for the Inquire event in any rule that contains 'Ledger Group'. ('Disallow' does not pre-empt the 'Allow' since different rules may have allow and disallow for the same ledger group with varying additional chartfields. The Check Security function in rowinit code will sort out the specifics as to which exact budgets the user will see, so the search view doesn't have to.) --CLASS VIEW (BASED ON PERMISSION LIST)

SELECT DISTINCT L.OPRCLASS ,C.OPRID ,A.BUSINESS_UNIT ,B.DESCR FROM PS_BU_LED_GRP_TBL A ,PS_KK_BUDGET_TYPE B ,PS_OPR_DEF_TBL_FS C ,PS_KSEC_EVENTS D ,PS_SET_CNTRL_REC E , PS_SEC_LEDGER_CLS L WHERE D.KSEC_EVENT = 'NOTIFY' AND B.LEDGER_GROUP = A.LEDGER_GROUP AND B.LEDGER_GROUP = L.LEDGER_GROUP AND B.SETID1= E.SETID AND E.SETCNTRLVALUE = A.BUSINESS_UNIT AND E.RECNAME ='KK_BD_TYPE_VW' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_KK_BUDGET_TYPE B1 WHERE B1.LEDGER_GROUP = B.LEDGER_GROUP AND B1.SETID1 = B.SETID1 AND B1.EFFDT <= %CurrentDateIn) AND (D.ACTIVE_STATUS = 'I' OR EXISTS ( SELECT 'X' FROM PS_KSEC_SUPER_USER K1 WHERE K1.OPRID = C.OPRID AND K1.KSEC_EVENT = D.KSEC_EVENT) OR EXISTS ( SELECT 'X' FROM PS_KSEC_FLAT_RULES K2 , PS_KSEC_FLAT K3 , PS_KSEC_RULES_EVEN K4 WHERE K2.CHARTFIELD = 'LEDGER_GROUP' AND K3.KSEC_ATTRIB = 'A' AND K2.OPRID=K3.OPRID AND K2.BUSINESS_UNIT=K3.BUSINESS_UNIT AND K2.KSEC_RULE=K3.KSEC_RULE AND K2.KSEC_RULE=K4.KSEC_RULE AND K2.OPRID = C.OPRID AND K2.KSEC_START = B.LEDGER_GROUP AND K2.BUSINESS_UNIT = A.BUSINESS_UNIT AND K4.KSEC_EVENT = D.KSEC_EVENT))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

4 CONTROL_BUDGET Character(30) VARCHAR2(30) NOT NULL Budget Type