KSEC_RULES (SQL Table)	Index Back
Security Rules Page Security Rules definition page

KSEC_RULES

(SQL Table)

Security Rules Page

Security Rules definition page

Related Language Record: KSEC_RULES_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 KSEC_ATTRIB Character(3) VARCHAR2(3) NOT NULL Security Rule Attribute
A=Allow
D=Disallow
S=Super User
Default Value: A

3 KSEC_REGBIND Character(3) VARCHAR2(3) NOT NULL Regular/Dynamic Rule
DYN=Dynamic
REG=Regular
Default Value: REG

4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

5 KSEC_ALL_BU Character(1) VARCHAR2(1) NOT NULL Apply Rule to Business Units
N=Specify Business Unit
Y=All Valid Business Units
Default Value: Y

6 KSEC_ALL_PRODUCTS Character(1) VARCHAR2(1) NOT NULL Budget Date Override Modules
A=All Modules
S=Specify Modules
Default Value: A

7 KSEC_ALL_SOURCE Character(1) VARCHAR2(1) NOT NULL Budget Override Source Trans
A=All Source Transactions
S=Specify Source Transactions
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KSEC_RULE	Character(10)	VARCHAR2(10) NOT NULL	Security Rule
2	KSEC_ATTRIB	Character(3)	VARCHAR2(3) NOT NULL	Security Rule Attribute A=Allow D=Disallow S=Super User Default Value: A
3	KSEC_REGBIND	Character(3)	VARCHAR2(3) NOT NULL	Regular/Dynamic Rule DYN=Dynamic REG=Regular Default Value: REG
4	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
5	KSEC_ALL_BU	Character(1)	VARCHAR2(1) NOT NULL	Apply Rule to Business Units N=Specify Business Unit Y=All Valid Business Units Default Value: Y
6	KSEC_ALL_PRODUCTS	Character(1)	VARCHAR2(1) NOT NULL	Budget Date Override Modules A=All Modules S=Specify Modules Default Value: A
7	KSEC_ALL_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Budget Override Source Trans A=All Source Transactions S=Specify Source Transactions Default Value: A