EOCF_SUBJECT(SQL Table) | 
Index Back | 
|---|---|
subject definitionsubject area definition | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | Library Subject Id | |
| 2 | EOCF_SUBJECT_NAME | Character(30) | VARCHAR2(30) NOT NULL | the name of the subject under which things are filed in the library | 
| 3 | EOCF_IS_VIRTUAL | Character(1) | VARCHAR2(1) NOT NULL | 
Is Virtual ?
 Y/N Table Edit Default Value: N  | 
| 4 | EOCF_APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | 
data library - aplication class id
 Prompt Table: EOCF_APPCLAS_VW  | 
| 5 | EOCF_APPCLASS_PATH | Character(167) | VARCHAR2(167) NOT NULL | 
Application Class Full Path
 Prompt Table: EOCF_APPPATH_VW  | 
| 6 | DESCRLONG | Long Character | CLOB | Long Description | 
| 7 | 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  | 
| 8 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |