USERIDPTRC_FOLDER_TYPEI=My Reports
M=My Favorites
P=My Process Requests
PTRC_FOLDER_IDA=Active
I=Inactive
Y/N Table Edit
PTRCFOLDERUSR |
index back |
|---|---|
User's folder list |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| PTRC_FOLDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Report Console - Folder Types
I=My Reports M=My Favorites P=My Process Requests |
| PTRC_FOLDER_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Folder's Unique identifier |
| ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Y/N Table Edit |
| PT_DISPLAY_ORDER | Number(2,0) | SMALLINT NOT NULL | Folder Sort/Display Order |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |