PSCOMPOBJERR

(SQL Table)
Index Back

ADS Validation Session Error

This 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