EOCF_CTX_STORE1(SQL Table) | 
Index Back | 
|---|---|
Context Persistence Elements | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | Persisted Context ID | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Active Analytics Framework sequence number for context variables | |
| 3 | Number(6,0) | INTEGER NOT NULL | 
sequence number for line item rows
 Default Value: 1  | 
|
| 4 | EOCF_DATA_KEYNAME | Character(18) | VARCHAR2(18) NOT NULL | Key Name | 
| 5 | EOCF_DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Context Persistence Data Type
 1=String 2=Number 3=Decimal Number 4=Datetime 5=Date 6=Time 7=Object  | 
| 6 | EOCF_DATA_STRING | Long Character | CLOB | Constant String | 
| 7 | EOCF_DATA_NUMBER | Number(31,0) | DECIMAL(31) NOT NULL | Constant Number | 
| 8 | EOCF_DATA_DECIMAL | Signed Number(26,6) | DECIMAL(24,6) NOT NULL | Constant Decimal | 
| 9 | EOCF_DATA_DATETIME | DateTime(26) | TIMESTAMP | Constant Datetime | 
| 10 | EOCF_DATA_DATE | Date(10) | DATE | Constant Date | 
| 11 | EOCF_DATA_TIME | Time(15) | TIMESTAMP | Constant Time | 
| 12 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime | 
| 13 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID | 
| 14 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. | 
| 15 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |