EOCF_OPERSET_IDA=Active
I=Inactive
Default Value: A
0=PeopleSoft
1=PeopleSoft / Customer Modified
2=Customer
Default Value: 2
EOCF_OPER_SET(SQL Table) |
Index Back |
|---|---|
Operator Set definitionDefine Operator Set |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_OPERSET_ID |
Number(31,0) | DECIMAL(31) NOT NULL | operator specifier |
| 2 | EOCF_OPRSET_NAME | Character(50) | VARCHAR2(50) NOT NULL | the name of the operator |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 4 | DESCRLONG | Long Character | CLOB | Long Description |
| 5 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
| 6 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 7 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 8 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 9 | 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 |
| 10 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |