About This Guide > sodv_hist
  
sodv_hist
Segregation Of Duties Violation Log
 
 
Field Name
Label
Col-Label
Format
Dec
 
oid_sodv_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
sodv__qadc01
 
 
x(24)
 
 
sodv__qadc02
 
 
x(24)
 
 
sodv_category1
SOD Category Code
Category
x(8)
 
 
sodv_category2
SOD Category Code
Category
x(8)
 
 
sodv_date
Created Date
Created
99/99/99
 
 
sodv_fix_date
Fixed Date
 
99/99/99
 
 
sodv_fix_time
Fixed Time
Time
>>>>9
 
 
sodv_fix_userid
Fixed By
 
x(8)
 
 
sodv_group
Role Name
 
x(20)
 
 
sodv_group1
Role Name
 
x(20)
 
 
sodv_group1_conflict
Role 1 Conflict
Role 1
yes/no
 
 
sodv_group2
Role Name
 
x(20)
 
 
sodv_group2_conflict
Role 2 Conflict
Role 2
yes/no
 
 
sodv_mod_date
Modified Date
Mod Date
99/99/99
 
 
sodv_mod_userid
User ID
 
x(8)
 
 
sodv_pe_code
SOD Policy Exception Code
 
x(35)
 
 
sodv_rule_type
SOD Rule Type
Type
x(2)
 
 
sodv_time
Time
 
>>,>>>,>>9
 
 
sodv_user
User ID
 
x(8)
 
 
sodv_user1
User Field Character 1
 
x(24)
 
 
sodv_user2
User Field Character 2
 
x(24)
 
 
sodv_userid
User ID
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_sodv_hist
yes
oid_sodv_hist
yes
no
sodv_vio_id
yes
sodv_rule_type
yes
no
 
 
 
sodv_user
yes
no
 
 
 
sodv_group
yes
no
 
 
 
sodv_category1
yes
no
 
 
 
sodv_category2
yes
no
 
 
 
sodv_group1
yes
no
 
 
 
sodv_group2
yes
no
 
 
 
sodv_userid
yes
no
 
 
 
sodv_date
yes
no
 
 
 
sodv_time
yes
no
 
 
 
sodv_fix_userid
yes
no
 
 
 
sodv_fix_date
yes
no
 
 
 
sodv_fix_time
yes
no