UPG_PATHCS80=From Learning Solutions 8.01
HC80=From 8 SP1
HC88=From 8.8X
HC89=From 8.9
XLATLONGNAMEUPG_DATACONV_VW(SQL View) |
Index Back |
|---|---|
Upgrade Data ConversionSearch view for UPG_DATACONV component |
| SELECT DISTINCT A.UPG_PATH ,B.XLATLONGNAME FROM PS_UPG_DATACONV A ,PSXLATITEM B WHERE B.FIELDVALUE=A.UPG_PATH AND B.FIELDNAME='UPG_PATH' AND B.EFF_STATUS='A' AND B.EFFDT=( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME=B.FIELDNAME AND C.FIELDVALUE=B.FIELDVALUE AND C.EFF_STATUS=B.EFF_STATUS) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UPG_PATH |
Character(4) | VARCHAR2(4) NOT NULL |
Definition of supported upgrade paths
CS80=From Learning Solutions 8.01 HC80=From 8 SP1 HC88=From 8.8X HC89=From 8.9 |
| 2 | XLATLONGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |