EOCF_CONTEXT(SQL Table) |
Index Back |
|---|---|
context definitioncontext definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context | |
| 2 | EOCF_CTX_NAME | Character(50) | VARCHAR2(50) NOT NULL | context name |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | EOCF_CTX_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Context Type
GNRC=Generic ONLN=Online Component Default Value: ONLN |
| 5 | EOCF_GEN_CTX_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Corresponding Generic Context
Prompt Table: EOCF_GEN_CTX_VW |
| 6 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Component Name (see PSBCDEFN).
Prompt Table: EOCF_CI_SRCH_VW |
| 7 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 8 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
| 9 | EOCF_IS_PRIMARY | Character(1) | VARCHAR2(1) NOT NULL |
is this definition primary
Y/N Table Edit Default Value: N |
| 10 | EOCF_OPERSET_ID | Number(31,0) | DECIMAL(31) NOT NULL |
operator specifier
Prompt Table: EOCF_OPRSET_PVW |
| 11 | EOCF_IS_NAMED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | does this object have a user-defined name |
| 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. |
| 16 | EOCF_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer Default Value: 2 |
| 17 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |
| 18 | DESCRLONG | Long Character | CLOB | Long Description |