PROBINSTDOMAIN_IDPSOPTSTATUS(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | DOMAIN_ID |
Character(234) | VARCHAR2(234) NOT NULL | Domain ID |
| 3 | TUXSVCID | Number(3,0) | SMALLINT NOT NULL | This represents the tuxedo service ID used in Optimization framework. |
| 4 | OPTENGID | Number(3,0) | SMALLINT NOT NULL | This represents the tuxedo service ID used in Optimization framework. |
| 5 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 6 | RETRY_LOAD | Character(1) | VARCHAR2(1) NOT NULL | Retry Load after trans failure |
| 7 | RETRY_STATE | Number(1,0) | SMALLINT NOT NULL | RETRY_STATE |