PTADSNAMEPTADSNAME_TOPTADSCRITDSFMORTOF=From Data Set
T=To Data Set
RECNAMEFIELDNAMEPTADSCRITFLDNMPSPTADSCRIPMPVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 2 | PTADSNAME_TO |
Character(30) | VARCHAR2(30) NOT NULL | Referenced data set type name |
| 3 | PTADSCRITDSFMORTO |
Character(1) | VARCHAR2(1) NOT NULL |
From Or To
F=From Data Set T=To Data Set |
| 4 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | PTADSCRITFLDNM |
Character(50) | VARCHAR2(50) NOT NULL | Record Field Name |