USERIDPTRC_FOLDER_TYPEI=My Reports
M=My Favorites
P=My Process Requests
PTRC_FOLDER_IDA=Active
I=Inactive
Y/N Table Edit
PTRCFOLDERUSR(SQL Table) |
Index Back |
|---|---|
User's folder listReporting Console |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | PTRC_FOLDER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Report Console - Folder Types
I=My Reports M=My Favorites P=My Process Requests |
| 3 | PTRC_FOLDER_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Folder's Unique identifier |
| 4 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Y/N Table Edit |
| 5 | PT_DISPLAY_ORDER | Number(2,0) | SMALLINT NOT NULL | Folder Sort/Display Order |