EOCF_TRM_SUB_VW(SQL View) |
Index Back |
|---|---|
Term search viewCLAF Data Library term search view |
| SELECT B.EOCF_SUBJECT_ID , A.EOCF_LIB_TERM_ID , A.EOCF_LIB_TERM_NAME , A.EOCF_TERM_TYPE , A.EOCF_TERM_LABEL , A.EOCF_TERM_DATATYPE , A.EOCF_NUM_OF_VALUES , A.EOCF_DATA_SOURCE , A.EOCF_TERM_STATUS ,A.EOCF_IS_CFG_FLAG , B.EOCF_ORDERNUM , A.EOCF_IS_SCALAR FROM PS_EOCF_TERM_DEFN A , PS_EOCF_TERMSUB_VW B WHERE A.EOCF_TERM_STATUS = 'A' AND A.EOCF_LIB_TERM_ID = B.EOCF_LIB_TERM_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOCF_SUBJECT_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Library Subject Id |
| 2 | EOCF_ELEMENT_ID |
Number(31,0) | DECIMAL(31) NOT NULL | a library element that can be evaluated. NOTE: this primary key value is actually a foreign key to the library element portion of a term. Terms are sub-types of elements. |
| 3 | EOCF_LIB_TERM_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of the Term in the library |
| 4 | EOCF_TERM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
data library term type, possible values are constant,variable
CON=Constant VAR=Variable |
| 5 | EOCF_TERM_LABEL | Character(254) | VARCHAR2(254) NOT NULL | Term Label (display) field used in Term Definition |
| 6 | 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 Default Value: STR |
| 7 | 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 Default Value: 1 |
| 8 | EOCF_DATA_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
which product line the source comes from
CRM=Customer Relationship Mgmt EPM=Enterprise Performance Mgmt FSM=Financial Services Mgmt HCM=Human Capital Mgmg SCM=Supply Chain Mgmt |
| 9 | EOCF_TERM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
data library term status, possible values are Active, Inactive, Under Construction
A=Active I=Inactive U=In Design Default Value: U |
| 10 | EOCF_IS_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Do Actions of this Action Type need to be configured
Y/N Table Edit Default Value: N |
| 11 | EOCF_ORDERNUM | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
| 12 | EOCF_IS_SCALAR | Character(1) | VARCHAR2(1) NOT NULL | does this term resolve to a scalar value |