PSPTADSCRIPMPVW(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 | Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Referenced data set type name | |
3 | Character(1) | VARCHAR2(1) NOT NULL |
From Or To
F=From Data Set T=To Data Set |
|
4 | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). | |
5 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
6 | Character(50) | VARCHAR2(50) NOT NULL | Record Field Name |