GLC8572_OPR_VW(SQL View) |
Index Back |
|---|---|
GLC8572 Operator Security ViewGLC8572 Operator Security View |
| SELECT A1.OPRID , A1.KSEC_RULE , B1.KSEC_ATTRIB , B1.KSEC_ALL_BU , C1.BUSINESS_UNIT , E1.CHARTFIELD , E1.KSEC_RULE_PARAM , E1.KSEC_START , D1.KSEC_EVENT , 'O' FROM PS_KSEC_OPR_RULES A1 , PS_KSEC_RULES B1 , PS_KSEC_RULES_BU C1 , PS_KSEC_RULES_ENTR E1 , PS_KSEC_RULES_EVEN D1 WHERE A1.KSEC_RULE =B1.KSEC_RULE AND B1.KSEC_RULE =C1.KSEC_RULE AND B1.KSEC_RULE =D1.KSEC_RULE AND E1.KSEC_RULE =A1.KSEC_RULE AND B1.KSEC_ALL_BU ='N' |
| # | 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 |