PSSHADOWDATA(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PSSDWSEQUENCE | 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 |