PeopleSoft Enterprise Human Capital Management & Campus Solutions: Row Level Security in 8.9 Page 3
SJT_PERSON_USF: Security Join Table for USF Employees.......40
HRS_SJT_JO: Security Join Table for Recruiting Solutions Job
Openings..................................................................................................41
Core View Structure and View Text.........................................................41
Persons.....................................................................................................43
Enabling Different fields for the Search and List Box .....................47
Product specific views ................................................................................48
Custom Views..............................................................................................51
Refreshing the Operator Security Join Table..........................................51
Refreshing the Transaction Security Join Tables....................................52
Nightly Updates for the Transaction Security Join Tables....................55
Real-Time updates of the Transaction Security Join Tables.................56
SCRTY_SETTYP_VW .........................................................................56
SCRTY_DERIVED...............................................................................57
Process......................................................................................................57
Creating New Security Types.........................................................................60
Security for People without Jobs...................................................................71
Special Job Security Versions (aka Access by Association).......................73
Include Home/Host Access (aka International Security). ....................74
One Home – One Host.........................................................................75
Include Additional Assignment Security..................................................82
JOB Data .................................................................................................84
Include Japan Assignment Security ..........................................................86
Example of Security Access..................................................................87
Implementation Process .................................................................................91
Steps..............................................................................................................91
What Security Types to enable..................................................................91
What to consider .........................................................................................91
Enabling Multiple Types in a Set ..............................................................92
Security in Production.....................................................................................92
User Maintenance........................................................................................92
Permission List Maintenance.....................................................................92
Role Maintenance........................................................................................93
Department Tree Maintenance .................................................................93
Security Type Maintenance........................................................................93
Future dated entries in the Transactional Tables....................................94
Changes to the Transactional Tables via Batch......................................94
Upgrade Process ..............................................................................................94
Customers Using the Delivered Dept Security Tree..............................94
Customers Using the Delivered Dept Security Tree with Global or
Japan Additional Assignments Versions..................................................95
Customers Who Have Customizations to use the Business Unit,
Location, Regulatory Region, Company, or Salary Grade Fields instead
of DEPTID..................................................................................................95
Customers Who Have Customizations to use the DEPTID but not via
the Tree.........................................................................................................96
