KSEC_FLAT_RULVW (SQL View)	Index Back
Commit Control Security Rules Commit Control Security Rule/Attribute view

KSEC_FLAT_RULVW

(SQL View)

Commit Control Security Rules

Commit Control Security Rule/Attribute view

SELECT A.OPRID , A.BUSINESS_UNIT , A.KSEC_RULE , A.KSEC_RULE_NO , A.SETID , A.CHARTFIELD , B.KSEC_ATTRIB , A.KSEC_RULE_PARAM , A.KSEC_START , A.KSEC_END ,A.INTER_CF_TRAN , A.TREE_NAME , A.TREE_NODE , D.KSEC_EVENT , A.KK_SOURCE_TRAN FROM PS_KSEC_FLAT_RULES A , PS_KSEC_FLAT B , PS_KSEC_RULES_EVEN D WHERE A.OPRID=B.OPRID AND A.KSEC_RULE=B.KSEC_RULE AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.KSEC_RULE=D.KSEC_RULE

# 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

3 KSEC_RULE Character(10) VARCHAR2(10) NOT NULL Security Rule

4 KSEC_RULE_NO Number(3,0) SMALLINT NOT NULL Combination Set

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

6 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

7 KSEC_ATTRIB Character(3) VARCHAR2(3) NOT NULL Security Rule Attribute
A=Allow
D=Disallow
S=Super User

8 KSEC_RULE_PARAM Character(3) VARCHAR2(3) NOT NULL Security Parameters
BIN=Bind
EXP=Explicit
RAN=Range
TRE=Tree Node
WLD=Wild Card

9 KSEC_START Character(15) VARCHAR2(15) NOT NULL Chartfield Security Module This field will contain the actual Chartfield value for the rule. Whether it is the 'Start' of a range, the explicit value or the tree node value

10 KSEC_END Character(15) VARCHAR2(15) NOT NULL Chartfield Security Module This field will contain the actual Chartfield value for the rule. Whether it is the 'Start' of a range, the explicit value or the tree node value

11 INTER_CF_TRAN Character(1) VARCHAR2(1) NOT NULL Inter chartfield transfer for KK Security
N=Donot Allow
Y=Allow Inter CF transfer

12 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

13 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

14 KSEC_EVENT Character(8) VARCHAR2(8) NOT NULL Security Event

15 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type

#	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
3	KSEC_RULE	Character(10)	VARCHAR2(10) NOT NULL	Security Rule
4	KSEC_RULE_NO	Number(3,0)	SMALLINT NOT NULL	Combination Set
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
7	KSEC_ATTRIB	Character(3)	VARCHAR2(3) NOT NULL	Security Rule Attribute A=Allow D=Disallow S=Super User
8	KSEC_RULE_PARAM	Character(3)	VARCHAR2(3) NOT NULL	Security Parameters BIN=Bind EXP=Explicit RAN=Range TRE=Tree Node WLD=Wild Card
9	KSEC_START	Character(15)	VARCHAR2(15) NOT NULL	Chartfield Security Module This field will contain the actual Chartfield value for the rule. Whether it is the 'Start' of a range, the explicit value or the tree node value
10	KSEC_END	Character(15)	VARCHAR2(15) NOT NULL	Chartfield Security Module This field will contain the actual Chartfield value for the rule. Whether it is the 'Start' of a range, the explicit value or the tree node value
11	INTER_CF_TRAN	Character(1)	VARCHAR2(1) NOT NULL	Inter chartfield transfer for KK Security N=Donot Allow Y=Allow Inter CF transfer
12	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
13	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
14	KSEC_EVENT	Character(8)	VARCHAR2(8) NOT NULL	Security Event
15	KK_SOURCE_TRAN	Character(10)	VARCHAR2(10) NOT NULL	Source Transaction Type