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.