PSCOMPOBJERR(SQL Table) |
Index Back |
---|---|
ADS Validation Session ErrorThis record captures validation errors encountered during a compare/copy session of ADS data carried in ADS projects for the corresponding content key values captured in record PSCOMPOBJKEY. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTSESSIONOBJ_GUID | Character(36) | VARCHAR2(36) NOT NULL | Session Object Unique ID |
2 | 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 |
3 | PTPARAMETERVAL1 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 1 |
4 | PTPARAMETERVAL2 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 2 |
5 | PTPARAMETERVAL3 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 3 |
6 | PTPARAMETERVAL4 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 4 |
7 | PTPARAMETERVAL5 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 5 |
8 | PTPARAMETERVAL6 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 6 |
9 | PTPARAMETERVAL7 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 7 |
10 | PTPARAMETERVAL8 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 8 |
11 | PTPARAMETERVAL9 | Character(150) | VARCHAR2(150) NOT NULL | Parameter Value 9 |
12 | PTREMOTEVALTYPE | Number(3,0) | SMALLINT NOT NULL | Target Value |
13 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
14 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
15 | MESSAGE_TEXT_254 | Character(254) | VARCHAR2(254) NOT NULL | Message Text |
16 | MESSAGE_TEXT_LONG | Long Character | CLOB | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
17 | MSG_SEVERITY | Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
C=Cancel E=Error M=Message W=Warning |