PSSHADOWDATA(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL |
SEQUENCE
Default Value: 0 |
|
| 2 | PSSDWEXPORTED | Character(1) | VARCHAR2(1) NOT NULL | HASBEENEXPORTED |
| 3 | PSSDWDATETIME | DateTime(26) | TIMESTAMP | DATETIME |
| 4 | PSSDWCOMPUTERNAME | Character(100) | VARCHAR2(100) NOT NULL | COMPUTERNAME |
| 5 | PSSDWCHECKINID | Character(100) | VARCHAR2(100) NOT NULL | CHECKINID |
| 6 | PSSDWPROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | PROJECTNAME |
| 7 | PSSDWMGR | Character(6) | VARCHAR2(6) NOT NULL | MGR |
| 8 | PSSDWOPERATION | Character(6) | VARCHAR2(6) NOT NULL | OPERATION |
| 9 | PSSDWOBJECTID1 | Long Character(550) | VARCHAR2(550) | OBJECTID1 |
| 10 | PSSDWOBJECTID2 | Long Character(550) | VARCHAR2(550) | OBJECTID2 |
| 11 | PSSDWPATH1 | Long Character(260) | VARCHAR2(260) | PATH1 |
| 12 | PSSDWPATH2 | Long Character(260) | VARCHAR2(260) | PATH2 |