KK_NOTIFY_SRCH (SQL View)	Index Back
Srch VW 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 sorts out the specifics as to which exact budgets the user will be notified for.)

KK_NOTIFY_SRCH

(SQL View)

Srch VW 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 sorts out the specifics as to which exact budgets the user will be notified for.)

SELECT DISTINCT C.OPRID ,A.BUSINESS_UNIT ,B.LEDGER_GROUP ,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 WHERE D.KSEC_EVENT = 'NOTIFY' AND B.LEDGER_GROUP = A.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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW

3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
Prompt Table: SP_BULGRP_NONVW

4 CONTROL_BUDGET Character(30) VARCHAR2(30) NOT NULL Budget Type
Prompt Table: SP_NTSRCH_NONVW

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW
3	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_BULGRP_NONVW
4	CONTROL_BUDGET	Character(30)	VARCHAR2(30) NOT NULL	Budget Type Prompt Table: SP_NTSRCH_NONVW