PSPTADSCRIPMPVW |
index back |
---|
SELECT t.PTADSNAME , ' ' ,'F' PTADSCRITDSFMORTO , t.recname , w.fieldname , 'F.' %Concat %TrimSubstr(t.recname, 1, 100) %Concat '.' %Concat %TrimSubstr(w.fieldname, 1, 100) PTADSCRITFLDNM FROM %Table(PSADSDEFNITEM) t , %Table(psrecfielddb) w WHERE t.recname=w.recname UNION ALL SELECT ' ' , t.PTADSNAME , 'T' PTADSCRITDSFMORTO , t.recname , w.fieldname , 'T.' %Concat %TrimSubstr(t.recname, 1, 100) %Concat '.' %Concat %TrimSubstr(w.fieldname, 1, 100) PTADSCRITFLDNM FROM %Table(PSADSDEFNITEM) t , %Table(psrecfielddb) w WHERE t.recname=w.recname |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
![]() |
Character(30) | VARCHAR2(30) NOT NULL | Referenced data set type name |
![]() |
Character(1) | VARCHAR2(1) NOT NULL |
From Or To
F=From Data Set T=To Data Set |
![]() |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
![]() |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
![]() |
Character(50) | VARCHAR2(50) NOT NULL | Record Field Name |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |