PSOPTSTATUS

index back

SELECT PROBINST , %TrimSubstr(MACHINENAME , 1 , 30) %Concat ':' %Concat %TrimSubstr(%NumtoChar(PORT_NUM), 1, 5) %Concat '@' %Concat DOMAIN , PTATTUXSRVID ,PTATTUXSRVID , '//' %Concat %TrimSubstr(MACHINENAME , 1 , 30) %Concat ':' %Concat %NumToChar(PORT_NUM) , 'N' , 0 FROM PSANALYTICREG WHERE PROBINST <> ' '

PeopleSoft Field NameField TypeColumn TypeDescription
PROBINSTCharacter(20)VARCHAR2(20) NOT NULLOptimization Problem Instance
DOMAIN_IDCharacter(234)VARCHAR2(234) NOT NULLDomain ID
TUXSVCIDNumber(3,0)SMALLINT NOT NULLThis represents the tuxedo service ID used in Optimization framework.
OPTENGIDNumber(3,0)SMALLINT NOT NULLThis represents the tuxedo service ID used in Optimization framework.
URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
RETRY_LOADCharacter(1)VARCHAR2(1) NOT NULLRetry Load after trans failure
RETRY_STATENumber(1,0)SMALLINT NOT NULLRETRY_STATE
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19