PSPRJVALIDERR

index back

ADS Proj Validation Error View

This view joins the PSCOMPOBJKEY and PSCOMPOBJERR tables which capture errors encountered during validation of ADS data carried in ADS projects.
SELECT K.PTSESSIONID , K.PTTYPENAME , K.OBJECTTYPE , K.COMPARETYPE , K.PTKEYHASH , K.PTLOCALHASH , K.PTREMOTEHASH , K.PTRECNAME1 , K.PTRECNAME2 , K.PTRECNAME3 , K.PTRECNAME4 , K.PTRECNAME5 , K.PTRECNAME6 , K.PTRECNAME7 , K.PTRECNAME8 , K.PTRECNAME9 , K.PTRECNAME10 , K.PTTABLENAME1 , K.PTTABLENAME2 , K.PTTABLENAME3 , K.PTTABLENAME4 , K.PTTABLENAME5 , K.PTTABLENAME6 , K.PTTABLENAME7 , K.PTTABLENAME8 , K.PTTABLENAME9 , K.PTTABLENAME10 , K.PTNUMKEYS1 , K.PTNUMKEYS2 , K.PTNUMKEYS3 , K.PTNUMKEYS4 , K.PTNUMKEYS5 , K.PTNUMKEYS6 , K.PTNUMKEYS7 , K.PTNUMKEYS8 , K.PTNUMKEYS9 , K.PTNUMKEYS10 , K.PTKEYCOL1 , K.PTKEYCOL2 , K.PTKEYCOL3 , K.PTKEYCOL4 , K.PTKEYCOL5 , K.PTKEYCOL6 , K.PTKEYCOL7 , K.PTKEYCOL8 , K.PTKEYCOL9 , K.PTKEYCOL10 , K.PTKEYCOL11 , K.PTKEYCOL12 , K.PTKEYCOL13 , K.PTKEYCOL14 , K.PTKEYCOL15 , K.PTKEYCOL16 , K.PTKEYVALUE1 , K.PTKEYVALUE2 , K.PTKEYVALUE3 , K.PTKEYVALUE4 , K.PTKEYVALUE5 , K.PTKEYVALUE6 , K.PTKEYVALUE7 , K.PTKEYVALUE8 , K.PTKEYVALUE9 , K.PTKEYVALUE10 , K.PTKEYVALUE11 , K.PTKEYVALUE12 , K.PTKEYVALUE13 , K.PTKEYVALUE14 , K.PTKEYVALUE15 , K.PTKEYVALUE16 , K.PTKEYTYPE1 , K.PTKEYTYPE2 , K.PTKEYTYPE3 , K.PTKEYTYPE4 , K.PTKEYTYPE5 , K.PTKEYTYPE6 , K.PTKEYTYPE7 , K.PTKEYTYPE8 , K.PTKEYTYPE9 , K.PTKEYTYPE10 , K.PTKEYTYPE11 , K.PTKEYTYPE12 , K.PTKEYTYPE13 , K.PTKEYTYPE14 , K.PTKEYTYPE15 , K.PTKEYTYPE16 , E.PTADSVALIDTYPE , E.PTPARAMETERVAL1 , E.PTPARAMETERVAL2 , E.PTPARAMETERVAL3 , E.PTPARAMETERVAL4 , E.PTPARAMETERVAL5 , E.PTPARAMETERVAL6 , E.PTPARAMETERVAL7 , E.PTPARAMETERVAL8 , E.PTPARAMETERVAL9 , E.PTREMOTEVALTYPE , E.MESSAGE_SET_NBR , E.MESSAGE_NBR , E.MESSAGE_TEXT_254 , E.MESSAGE_TEXT_LONG , E.MSG_SEVERITY FROM %Table(PSCOMPOBJKEY) K , %Table(PSCOMPOBJERR) E WHERE K.PTSESSIONOBJ_GUID = E.PTSESSIONOBJ_GUID

PeopleSoft Field NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PTTYPENAMECharacter(30)VARCHAR2(30) NOT NULL
OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
COMPARETYPENumber(5,0)INTEGER NOT NULLCompare Type
PTKEYHASHCharacter(28)VARCHAR2(28) NOT NULL
PTLOCALHASHCharacter(28)VARCHAR2(28) NOT NULL
PTREMOTEHASHCharacter(28)VARCHAR2(28) NOT NULL
PTRECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1
PTRECNAME2Character(15)VARCHAR2(15) NOT NULL
PTRECNAME3Character(15)VARCHAR2(15) NOT NULL
PTRECNAME4Character(15)VARCHAR2(15) NOT NULL
PTRECNAME5Character(15)VARCHAR2(15) NOT NULL
PTRECNAME6Character(15)VARCHAR2(15) NOT NULL
PTRECNAME7Character(15)VARCHAR2(15) NOT NULL
PTRECNAME8Character(15)VARCHAR2(15) NOT NULL
PTRECNAME9Character(15)VARCHAR2(15) NOT NULL
PTRECNAME10Character(15)VARCHAR2(15) NOT NULL
PTTABLENAME1Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME2Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME3Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME4Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME5Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME6Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME7Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME8Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME9Character(18)VARCHAR2(18) NOT NULL
PTTABLENAME10Character(18)VARCHAR2(18) NOT NULL
PTNUMKEYS1Number(3,0)SMALLINT NOT NULL
PTNUMKEYS2Number(3,0)SMALLINT NOT NULL
PTNUMKEYS3Number(3,0)SMALLINT NOT NULL
PTNUMKEYS4Number(3,0)SMALLINT NOT NULL
PTNUMKEYS5Number(3,0)SMALLINT NOT NULL
PTNUMKEYS6Number(3,0)SMALLINT NOT NULL
PTNUMKEYS7Number(3,0)SMALLINT NOT NULL
PTNUMKEYS8Number(3,0)SMALLINT NOT NULL
PTNUMKEYS9Number(3,0)SMALLINT NOT NULL
PTNUMKEYS10Number(3,0)SMALLINT NOT NULL
PTKEYCOL1Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL2Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL3Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL4Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL5Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL6Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL7Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL8Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL9Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL10Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL11Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL12Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL13Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL14Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL15Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL16Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE1Character(150)VARCHAR2(150) NOT NULLObject Value 1
PTKEYVALUE2Character(150)VARCHAR2(150) NOT NULLObject Value 2
PTKEYVALUE3Character(150)VARCHAR2(150) NOT NULLObject Value 3
PTKEYVALUE4Character(150)VARCHAR2(150) NOT NULLObject Value 4
PTKEYVALUE5Character(150)VARCHAR2(150) NOT NULLObject Value 5
PTKEYVALUE6Character(150)VARCHAR2(150) NOT NULLObject Value 6
PTKEYVALUE7Character(150)VARCHAR2(150) NOT NULLObject Value 7
PTKEYVALUE8Character(150)VARCHAR2(150) NOT NULLObject Value 8
PTKEYVALUE9Character(150)VARCHAR2(150) NOT NULLObject Value 9
PTKEYVALUE10Character(150)VARCHAR2(150) NOT NULLObject Value 10
PTKEYVALUE11Character(150)VARCHAR2(150) NOT NULLObject Value 11
PTKEYVALUE12Character(150)VARCHAR2(150) NOT NULLObject Value 12
PTKEYVALUE13Character(150)VARCHAR2(150) NOT NULLObject Value 13
PTKEYVALUE14Character(150)VARCHAR2(150) NOT NULLObject Value 14
PTKEYVALUE15Character(150)VARCHAR2(150) NOT NULLObejct Value 15
PTKEYVALUE16Character(150)VARCHAR2(150) NOT NULLObject Value 16
PTKEYTYPE1Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE2Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE3Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE4Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE5Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE6Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE7Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE8Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE9Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE10Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE11Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE12Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE13Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE14Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE15Character(4)VARCHAR2(4) NOT NULL
PTKEYTYPE16Character(4)VARCHAR2(4) NOT NULL
PTADSVALIDTYPECharacter(1)VARCHAR2(1) NOT NULLValidation 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
PTPARAMETERVAL1Character(150)VARCHAR2(150) NOT NULLParameter Value 1
PTPARAMETERVAL2Character(150)VARCHAR2(150) NOT NULLParameter Value 2
PTPARAMETERVAL3Character(150)VARCHAR2(150) NOT NULLParameter Value 3
PTPARAMETERVAL4Character(150)VARCHAR2(150) NOT NULLParameter Value 4
PTPARAMETERVAL5Character(150)VARCHAR2(150) NOT NULLParameter Value 5
PTPARAMETERVAL6Character(150)VARCHAR2(150) NOT NULLParameter Value 6
PTPARAMETERVAL7Character(150)VARCHAR2(150) NOT NULLParameter Value 7
PTPARAMETERVAL8Character(150)VARCHAR2(150) NOT NULLParameter Value 8
PTPARAMETERVAL9Character(150)VARCHAR2(150) NOT NULLParameter Value 9
PTREMOTEVALTYPENumber(3,0)SMALLINT NOT NULLTarget Value
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
MESSAGE_TEXT_254Character(254)VARCHAR2(254) NOT NULLMessage Text
MESSAGE_TEXT_LONGLong CharacterCLOBMessage Text This field refers to the Text for a particular Message Number in the Message Catalog.
MSG_SEVERITYCharacter(1)VARCHAR2(1) NOT NULLMessage Severity
C=Cancel
E=Error
M=Message
W=Warning
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19