OPRIDUPD_SEQ_NUMBUSINESS_UNITPROJECT_IDFIELDNAMEF=Failed
S=Success
A=Activity User Fields
D=End Date
E=Project Template Status
L=Project Location
M=Project Manager
S=Status
T=Project Team
U=Project User Fields
Y=Type
PC_UPD_PRJ_LOG(SQL Table) |
Index Back |
|---|---|
Selected Projects for Update |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | UPD_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Update Sequence Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL | Team sequence number |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | UPDATE_REASON | Character(254) | VARCHAR2(254) NOT NULL | Update Description |
| 9 | UPD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Update Status
F=Failed S=Success |
| 10 | UPDATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Update Type
A=Activity User Fields D=End Date E=Project Template Status L=Project Location M=Project Manager S=Status T=Project Team U=Project User Fields Y=Type |
| 11 | OLDVALUE | Character(65) | VARCHAR2(65) NOT NULL | Old Value |
| 12 | NEWVALUE | Character(65) | VARCHAR2(65) NOT NULL | New Value |
| 13 | DESCRLONG | Long Character | CLOB | Long Description |
| 14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 15 | DTTM_PROCESSED | DateTime(26) | TIMESTAMP | Datetime processed |