AE_KSEC_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 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
4 KSEC_RULE_NO Number(3,0) SMALLINT NOT NULL Combination Set
5 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
6 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
7 KSEC_RULE Character(10) VARCHAR2(10) NOT NULL Security Rule
8 KSEC_OPR_DYN Character(30) VARCHAR2(30) NOT NULL Dynamic Rule Group
9 KSEC_DYN_RECNAME Character(20) VARCHAR2(20) NOT NULL Dynamic Rule Record
10 KSEC_ATTRIB Character(3) VARCHAR2(3) NOT NULL Security Rule Attribute
A=Allow
D=Disallow
S=Super User
11 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
12 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
14 KSEC_REGBIND Character(3) VARCHAR2(3) NOT NULL Regular/Dynamic Rule
DYN=Dynamic
REG=Regular