EOCF_CTX_STORE1(SQL Table) |
Index Back |
---|---|
Context Persistence Elements |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_CTXPERSIST_ID | Number(31,0) | DECIMAL(31) NOT NULL | Persisted Context ID |
2 | EOCF_CONTEXT_VAR | Number(3,0) | SMALLINT NOT NULL | Active Analytics Framework sequence number for context variables |
3 | EOCF_SEQNUM_6 | 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. |