PROBINSTDOMAIN_IDPSOPTSTATUS |
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 Name | Field Type | Column Type | Description |
|---|---|---|---|
| PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| DOMAIN_ID |
Character(234) | VARCHAR2(234) NOT NULL | Domain ID |
| TUXSVCID | Number(3,0) | SMALLINT NOT NULL | This represents the tuxedo service ID used in Optimization framework. |
| OPTENGID | Number(3,0) | SMALLINT NOT NULL | This represents the tuxedo service ID used in Optimization framework. |
| URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| RETRY_LOAD | Character(1) | VARCHAR2(1) NOT NULL | Retry Load after trans failure |
| RETRY_STATE | Number(1,0) | SMALLINT NOT NULL | RETRY_STATE |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |