UD PeopleSoft Financial System -
Data DictionaryLast 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.