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
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).
PTADSNAME_TO Character(30) VARCHAR2(30) NOT NULL Referenced data set type name
PTADSCRITDSFMORTO Character(1) VARCHAR2(1) NOT NULL From Or To
F=From Data Set
T=To Data Set
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
PTADSCRITFLDNM Character(50) VARCHAR2(50) NOT NULL Record Field Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19