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. |