UD PeopleSoft Financial System -
Data Dictionary
Last updated for this Record on 6/7/2003.
UOD_ROW_SEC_LN
Contains the attachment between a user's degree of row level security access (from the parent
UOD_ROW_SEC_HDR) and one or more Purposes to which that security applies.
This record is a child of UOD_ROW_SEC_HDR.
|
| SETID
| SetID
| Example: UOD01
|
| KEY
| Type: character
| Format: uppercase
| Length: 5
| Decimals: 0
|
| | The only valid value at UD at this time is "UOD01".
|
| |
|
| .
|
| 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.
|
| |
|
| .
|
| CHARTFIELD1
| Purpose
| Example: ENGL110000
|
|
| Type: character
| Format: uppercase
| Length: 10
| Decimals: 0
|
| | Purpose chartfield. Replaces legacy 11 digit account code.
|
| |
Lookup values and translations in
CHARTFIELD1_TBL
|
| .
|
| 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.
|
| |
|
| .