PTUPG_PATH7084=PeopleTools 7.0x to 8.4x
7584=PeopleTools 7.5x to 8.4x
8184=PeopleTools 8.1x to 8.4x
8484=PeopleTools 8.4x to 8.4x
XLATLONGNAMEPTUPGCONVERT_VW(SQL View) |
Index Back |
|---|---|
Upgrade Data ConversionSearch view for PTUPGCONVERT component |
| SELECT DISTINCT A.PTUPG_PATH ,B.XLATLONGNAME FROM PS_PTUPGCONVERT A ,PSXLATITEM B WHERE B.FIELDVALUE=A.PTUPG_PATH AND B.FIELDNAME='PTUPG_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 | PTUPG_PATH |
Character(4) | VARCHAR2(4) NOT NULL |
Definition of supported upgrade paths
7084=PeopleTools 7.0x to 8.4x 7584=PeopleTools 7.5x to 8.4x 8184=PeopleTools 8.1x to 8.4x 8484=PeopleTools 8.4x to 8.4x |
| 2 | XLATLONGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |