| Name | Type MSSql | Type Oracle | Type DB2 | Type Postgresql | Nullable | Description |
|---|---|---|---|---|---|---|
| AJPOP_AH_Idnr | int | NUMBER(38,0) | int | int | false | reference to the archive header (AH) (RunID) |
| AJPOP_AJPP_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | ascending number of the jobplan process (Task Lnr) |
| AJPOP_Location | smallint | NUMBER(38,0) | smallint | smallint | false | 1=Pre, 2=Post |
| AJPOP_AJPOV_Lnr | smallint | NUMBER(38,0) | smallint | smallint | false | ascending number of parameters in a condition/action |
| AJPOP_AJPOV_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Variable name (S=Parameterset) |
| AJPOP_VName | varchar (32) | VARCHAR2 (32 CHAR) | varchar(32) | varchar (32) | false | Variable name of referenced Prompt |
| AJPOP_Value | varchar(max) | CLOB | clob(128 M) INLINE LENGTH 1024 COMPACT | text | true | Variable value |
| AJPOP_AltView | smallint | NUMBER(38,0) | smallint | smallint | true | Flag for alternative view |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_AJPOP | AJPOP_AH_Idnr, AJPOP_AJPP_Lnr, AJPOP_Location, AJPOP_AJPOV_Lnr, AJPOP_AJPOV_VName, AJPOP_VName | true | true | true | false |
| Name | Local References | Foreign References |
|---|---|---|
| FK_AJPOP_AJPOV | AJPOP_AH_Idnr, AJPOP_AJPP_Lnr, AJPOP_Location, AJPOP_AJPOV_Lnr, AJPOP_AJPOV_VName | AJPOV_AH_Idnr, AJPOV_AJPP_Lnr, AJPOV_Location, AJPOV_AJPPO_Lnr, AJPOV_VName |
Return to the Index File