PTIAADSCUST_VW

(SQL View)
 Index Back

SELECT B.PTIACUSTNAME ,A.PTIASPADSNAME , A.RECNAME , A.PTIASPKEYHASH , A.PTKEYVALUE1 , A.PTKEYVALUE2 , A.PTKEYVALUE3 , A.PTKEYVALUE4 , A.PTKEYVALUE5 , A.PTKEYVALUE6 , A.PTKEYVALUE7 , A.PTKEYVALUE8 ,A.ptiacustomization , A.ptiacust3waymerge ,A.ptiacustobjinrepo FROM PS_PTIAADSCUSTREPO A left outer join PS_PTIAADSREFREPO B on A.PTIASPADSNAME = B.PTIASPADSNAME AND A.RECNAME = B.RECNAME AND A.PTIASPKEYHASH = B.PTIASPKEYHASH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIACUSTNAME Character(30) VARCHAR2(30) NOT NULL Customization Name
2 PTIASPADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 PTIASPKEYHASH Character(36) VARCHAR2(36) NOT NULL Hash of the key column values
5 PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1
6 PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2
7 PTKEYVALUE3 Character(150) VARCHAR2(150) NOT NULL Object Value 3
8 PTKEYVALUE4 Character(150) VARCHAR2(150) NOT NULL Object Value 4
9 PTKEYVALUE5 Character(150) VARCHAR2(150) NOT NULL Object Value 5
10 PTKEYVALUE6 Character(150) VARCHAR2(150) NOT NULL Object Value 6
11 PTKEYVALUE7 Character(150) VARCHAR2(150) NOT NULL Object Value 7
12 PTKEYVALUE8 Character(150) VARCHAR2(150) NOT NULL Object Value 8
13 PTIACUSTOMIZATION Character(4) VARCHAR2(4) NOT NULL Customization
N== PPLSOFT
U=Unknown
Y=<> PPLSOFT

Y/N Table Edit

14 PTIACUST3WAYMERGE Character(4) VARCHAR2(4) NOT NULL 3 Way Merge Enabled

Y/N Table Edit

15 PTIACUSTOBJINREPO Character(4) VARCHAR2(4) NOT NULL Object in Repository

Y/N Table Edit