RUN_CNTL_IDPRCSINSTANCEEOCF_CACHED_OBJ_ID00=Configured Term
01=Context Definition
02=Implementation Definition
03=Resolution Type Definition
04=Subject Area
05=Subject Hierarchy
06=Term Definition
Y/N Table Edit
Default Value: N
EOCF_CLR_RESULT(SQL Table) |
Index Back |
|---|---|
fix timestamptime that cached items were fixed |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | EOCF_CACHED_OBJ_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Cached Object Id |
| 4 | EOCF_CACHE_OBJ_TYP | Character(2) | VARCHAR2(2) NOT NULL |
Cached Object Type
00=Configured Term 01=Context Definition 02=Implementation Definition 03=Resolution Type Definition 04=Subject Area 05=Subject Hierarchy 06=Term Definition |
| 5 | EOCF_TIMESTAMP | DateTime(26) | TIMESTAMP | timestamp |
| 6 | EOCF_CLR_IS_FIXED | Character(1) | VARCHAR2(1) NOT NULL |
has this cache element been fixed?
Y/N Table Edit Default Value: N |
| 7 | EOCF_CLR_FIXDTM | DateTime(26) | TIMESTAMP | fix timestamp |
| 8 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
| 9 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 10 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 11 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |