PC_MY_PRJ_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 3 | FROM_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | From Clause |
| 4 | MY_PRJ_SETUP | Character(1) | VARCHAR2(1) NOT NULL |
Set Up option for creating My Projects lists.
A=Auto Populate, No Overrides M=Manual Identification by Users O=Auto Populate, Allow Overrides |
| 5 | PROJECT_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Project Security
N=Do not allow project security Y=Allow project security |
| 6 | SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security N=No Security O=User ID Level Security |
| 7 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL | Business Unit Security |
| 8 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |