GLC8572_DYN_VW(SQL View) |
Index Back |
|---|---|
GLC8572 Dynamic Rule SecurityGLC8572 Dynamic Rule Security View |
| SELECT A8.KSEC_OPR_DYN , A8.KSEC_RULE , B8.KSEC_ATTRIB , B8.KSEC_ALL_BU , ' ' , E8.CHARTFIELD , E8.KSEC_RULE_PARAM , E8.KSEC_START , D8.KSEC_EVENT , 'D' FROM PS_KSEC_DYN_RULES A8 , PS_KSEC_RULES B8 , PS_KSEC_RULES_ENTR E8 , PS_KSEC_RULES_EVEN D8 WHERE A8.KSEC_RULE =B8.KSEC_RULE AND E8.KSEC_RULE =D8.KSEC_RULE AND B8.KSEC_RULE =E8.KSEC_RULE AND B8.KSEC_ALL_BU ='Y' |
| # | 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 | KSEC_RULE | Character(10) | VARCHAR2(10) NOT NULL | Security Rule |
| 3 | KSEC_ATTRIB | Character(3) | VARCHAR2(3) NOT NULL |
Security Rule Attribute
A=Allow D=Disallow S=Super User |
| 4 | KSEC_ALL_BU | Character(1) | VARCHAR2(1) NOT NULL |
Apply Rule to Business Units
N=Specify Business Unit Y=All Valid Business Units |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 7 | KSEC_RULE_PARAM | Character(3) | VARCHAR2(3) NOT NULL |
Security Parameters
BIN=Bind EXP=Explicit RAN=Range TRE=Tree Node WLD=Wild Card |
| 8 | 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 |
| 9 | KSEC_EVENT | Character(8) | VARCHAR2(8) NOT NULL | Security Event |
| 10 | ID | Character(1) | VARCHAR2(1) NOT NULL | Text Field |