PTIACUSTADSO_VW

(SQL View)
 Index Back

SELECT PTIASPADSNAME , RECNAME , PTIASPKEYHASH , PTKEYVALUE1 , PTKEYVALUE2 , PTKEYVALUE3 , PTKEYVALUE4 , PTKEYVALUE5 , PTKEYVALUE6 , PTKEYVALUE7 , PTKEYVALUE8 , PTIACUSTOMIZATION , PTIACUST3WAYMERGE , PTIACUSTOBJINREPO FROM PS_PTIAADSCUSTREPO

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit