UD PeopleSoft Financial System - Data Dictionary
Last updated for this Record on 6/7/2003.

UOD_ROW_SEC_HDR

Contains row level security controls. For each user, there is at least one entry here that specifies a certain degree of access. That access can be applied to one or more Purposes (Chartfield1) by appearing in the child Record (UOD_ROW_SEC_LN) in conjunction with those Purposes.
Further details are in this record's child: UOD_ROW_SEC_LN.

SETID SetID Example: UOD01
KEY Type: character Format: uppercase Length: 5 Decimals: 0
The only valid value at UD at this time is "UOD01".
.
ALL_VALUES_FLAG All Values Example:
Type: character Format: uppercase Length: 1 Decimals: 0
Security rows, if used this emplid can see all of the Purposes of UD.
.
APPROVAL_OPRID Approval User Id Example:
Type: character Format: uppercase Length: 30 Decimals: 0
Operator ID of the employee who can approve journal entries and purchasing and A/P transactions for individual Purposed.
.
APPROVER_TYPE Type of Approver Example:
Type: character Format: uppercase Length: 1 Decimals: 0
Represents whether the approver is a super-approver or a regular approver.
.
OPRID User ID Example:
Type: character Format: lowercase Length: 30 Decimals: 0
The logon id for an employee. Used in this table to control what Purposes the employee can view.
.
OPRID2 User ID Example:
Type: character Format: lowercase Length: 30 Decimals: 0
The logon id for an employee. Used in this table to control what Purposes the employee can view.
.
SSN Social Security # Example:
Type: character Format: SSN Length: 9 Decimals: 0
Social security number.
.