EOCF_RES_METHD(SQL Table) |
Index Back |
---|---|
Register Resolution Methoddata library - definition of Resolution Method. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_RES_MTHD_ID | Number(31,0) | DECIMAL(31) NOT NULL | data library - resolution method id |
2 | EOCF_RESMTHD_NAME | Character(30) | VARCHAR2(30) NOT NULL | the name of the resolution method in the library |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRLONG | Long Character | CLOB | Long Description |
5 | EOCF_APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
data library - aplication class id
Prompt Table: EOCF_APPCLAS_VW |
6 | EOCF_APPCLASS_PATH | Character(167) | VARCHAR2(167) NOT NULL |
Application Class Full Path
Prompt Table: EOCF_APPPATH_VW |
7 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
8 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
9 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
10 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
11 | 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 |
12 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |