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 NameField TypeColumn TypeDescription
PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).
PTADSNAME_TOCharacter(30)VARCHAR2(30) NOT NULLReferenced data set type name
PTADSCRITDSFMORTOCharacter(1)VARCHAR2(1) NOT NULLFrom Or To
F=From Data Set
T=To Data Set
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
PTADSCRITFLDNMCharacter(50)VARCHAR2(50) NOT NULLRecord Field Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19