PSPRJVALERR_DVW |
index back |
|---|
| SELECT PTSESSIONID , PTTYPENAME , '' , CASE WHEN PTNUMKEYS10 > 0 THEN PTRECNAME10 WHEN PTNUMKEYS9 > 0 THEN PTRECNAME9 WHEN PTNUMKEYS8 > 0 THEN PTRECNAME8 WHEN PTNUMKEYS7 > 0 THEN PTRECNAME7 WHEN PTNUMKEYS6 > 0 THEN PTRECNAME6 WHEN PTNUMKEYS5 > 0 THEN PTRECNAME5 WHEN PTNUMKEYS4 > 0 THEN PTRECNAME4 WHEN PTNUMKEYS3 > 0 THEN PTRECNAME3 WHEN PTNUMKEYS2 > 0 THEN PTRECNAME2 ELSE PTRECNAME1 END , PTADSVALIDTYPE , MSG_SEVERITY , MSG_SEVERITY , COMPARETYPE , MESSAGE_TEXT_LONG , MESSAGE_TEXT_254 , PTRECNAME1 , PTRECNAME2 , PTRECNAME3 , PTRECNAME4 , PTRECNAME5 , PTRECNAME6 , PTRECNAME7 , PTRECNAME8 , PTRECNAME9 , PTRECNAME10 , PTNUMKEYS1 , PTNUMKEYS2 , PTNUMKEYS3 , PTNUMKEYS4 , PTNUMKEYS5 , PTNUMKEYS6 , PTNUMKEYS7 , PTNUMKEYS8 , PTNUMKEYS9 , PTNUMKEYS10 , PTKEYCOL1 , PTKEYCOL2 , PTKEYCOL3 , PTKEYCOL4 , PTKEYCOL5 , PTKEYCOL6 , PTKEYCOL7 , PTKEYCOL8 , PTKEYCOL9 , PTKEYCOL10 , PTKEYCOL11 , PTKEYCOL12 , PTKEYCOL13 , PTKEYCOL14 , PTKEYCOL15 , PTKEYCOL16 , PTKEYVALUE1 , PTKEYVALUE2 , PTKEYVALUE3 , PTKEYVALUE4 , PTKEYVALUE5 , PTKEYVALUE6 , PTKEYVALUE7 , PTKEYVALUE8 , PTKEYVALUE9 , PTKEYVALUE10 , PTKEYVALUE11 , PTKEYVALUE12 , PTKEYVALUE13 , PTKEYVALUE14 , PTKEYVALUE15 , PTKEYVALUE16 FROM PSPRJVALIDERR |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTSESSIONID | Character(36) | VARCHAR2(36) NOT NULL | Compare Session Id |
| PTTYPENAME | Character(30) | VARCHAR2(30) NOT NULL | |
| DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| PTADSVALIDTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Validation Type
B=Integrity Check C=Post Copy Validation D=Dynamic Prompt Validation I=Reference Integrity Validation M=Informational Message N=No Validation O=One Zero Validation Edit P=Pre Copy Compare Validation R=Required Field Validation S=Static Prompt Validation T=Date Range Edit U=Pre Update Validation V=View Table Prompt X=Translate Value Edit Y=Yes No Edit Z=Custom Validation |
| MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel E=Error M=Message W=Warning |
| PTADSMSGSEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
A= E=Error M=Informational W=Warning |
| COMPARETYPE | Number(5,0) | INTEGER NOT NULL | Compare Type |
| MESSAGE_TEXT_LONG | Long Character | CLOB | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| MESSAGE_TEXT_254 | Character(254) | VARCHAR2(254) NOT NULL | Message Text |
| PTRECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
| PTRECNAME2 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME3 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME4 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME5 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME6 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME7 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME8 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME9 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTRECNAME10 | Character(15) | VARCHAR2(15) NOT NULL | |
| PTNUMKEYS1 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS2 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS3 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS4 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS5 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS6 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS7 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS8 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS9 | Number(3,0) | SMALLINT NOT NULL | |
| PTNUMKEYS10 | Number(3,0) | SMALLINT NOT NULL | |
| PTKEYCOL1 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL2 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL3 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL4 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL5 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL6 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL7 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL8 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL9 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL10 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL11 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL12 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL13 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL14 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL15 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYCOL16 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE1 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 1 |
| PTKEYVALUE2 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 2 |
| PTKEYVALUE3 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 3 |
| PTKEYVALUE4 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 4 |
| PTKEYVALUE5 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 5 |
| PTKEYVALUE6 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 6 |
| PTKEYVALUE7 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 7 |
| PTKEYVALUE8 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 8 |
| PTKEYVALUE9 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 9 |
| PTKEYVALUE10 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 10 |
| PTKEYVALUE11 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 11 |
| PTKEYVALUE12 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 12 |
| PTKEYVALUE13 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 13 |
| PTKEYVALUE14 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 14 |
| PTKEYVALUE15 | Character(150) | VARCHAR2(150) NOT NULL | Obejct Value 15 |
| PTKEYVALUE16 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 16 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |