PTSESSIONIDPTADSNAMEPTADSCONTENTIDCOMPARETYPEPTADSMSGSEVERITYA=
E=Error
M=Informational
W=Warning
Default Value: 0
Prompt Table: PSPROJECTDEFN
PSADSVALINSTST(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSESSIONID |
Character(36) | VARCHAR2(36) NOT NULL | Compare Session Id |
| 2 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 3 | PTADSCONTENTID |
Number(6,0) | INTEGER NOT NULL | ADS Content Identifier |
| 4 | COMPARETYPE |
Number(5,0) | INTEGER NOT NULL | Compare Type |
| 5 | PTADSMSGSEVERITY |
Character(1) | VARCHAR2(1) NOT NULL |
Message Severity
A= E=Error M=Informational W=Warning |
| 6 | PTADSMESSAGECOUNT | Number(10,0) | DECIMAL(10) NOT NULL |
Messages
Default Value: 0 |
| 7 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Project Name (see PSPROJECTDEFN).
Prompt Table: PSPROJECTDEFN |
| 8 | PTKEYHASH | Character(28) | VARCHAR2(28) NOT NULL |