EOCF_PHRASE_DFN(SQL Table) |
Index Back |
---|---|
phrase definitionphrase definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_PHRASE_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
2 | EOCF_PHRASE_NAME | Character(80) | VARCHAR2(80) NOT NULL | the user identifier for a phrase |
3 | EOCF_PHRASE_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 |
4 | EOCF_CODE_PTR | Number(31,0) | DECIMAL(31) NOT NULL | unique id value pointing to compiled form of expression code |
5 | EOCF_IS_NAMED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
6 | 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 |
7 | EOCF_DYNLINK_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
does this object have a user-defined name
Y/N Table Edit Default Value: N |
8 | EOCF_CODE_NAME | Character(18) | VARCHAR2(18) NOT NULL | code name for terms and phrases |
9 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
10 | EOCF_TEXT | Long Character | CLOB | User-friendly Text |
11 | EOCF_REF_PHRASE_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
12 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
13 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
14 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
15 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |