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