PSADSCMPINSTST(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 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Project Name (see PSPROJECTDEFN).
Prompt Table: PSPROJECTDEFN |
| 5 | PTKEYHASH | Character(28) | VARCHAR2(28) NOT NULL | |
| 6 | PTADSSOURCESTATUS | Number(1,0) | SMALLINT NOT NULL |
Source Status
A=Added C=Changed D=Deleted S=Unchanged U=Unknown Default Value: 0 |
| 7 | PTADSPROPSTATUS | Number(1,0) | SMALLINT NOT NULL |
Proposed Status
A=Added C=Changed D=Deleted S=Unchanged U=Unknown Default Value: 0 |
| 8 | PTSRCCUSTOMIZEFLG | Number(2,0) | SMALLINT NOT NULL |
Custom Status - Source
E=Equal to database G=Greater than database L=Less than database U=Unknown Default Value: 0 |
| 9 | PTTGTCUSTOMIZEFLG | Number(2,0) | SMALLINT NOT NULL |
Custom Status - Target
E=Equal to database G=Greater than database L=Less than database U=Unknown Default Value: 0 |