EOCF_DTYPEXT_SY(SQL Table) |
Index Back |
|---|---|
DL Datatypes vs Extraction parDL this table list the Term datatypes and its valid combination of implementation datatypes followed by data extraction parameters. This is a CLF provided system table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOCF_TERM_DATATYPE |
Character(4) | VARCHAR2(4) NOT NULL |
data library term return data type, possible values are scalar,composite
DATE=Date DTTM=Datetime NUM=Number OTHR=Other REC=Record RSET=Rowset STR=String TIME=Time |
| 2 | EOCF_NUM_OF_VALUES |
Character(1) | VARCHAR2(1) NOT NULL |
Data Library - This field would identify whether a term would return a list of values or single value.
1=One 2=Many |
| 3 | EOCF_IMPL_DATATYPE |
Character(4) | VARCHAR2(4) NOT NULL |
data library IMPl return data type, possible values are scalar,composite
A2AN=Array2 of Any ADAT=Date Array ADTT=Datetime Array ANUM=Number Array ARAN=Array of Any ASTR=String Array ATIM=Time Array DATE=Date DTTM=Datetime NUM=Number OTHR=Other REC=Record RSET=Rowset STR=String TIME=Time |
| 4 | EOCF_EXTRACT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Data Extraction Parms Type
01=None 02=Record.Field 03=Field 04=Position 05=Record |
| 5 | EOCF_IS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Is this Implementation (resolution method) parameter required?
Y/N Table Edit Default Value: Y |