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.
|
| |
|
| .