RA_OFRCTX_LVW(SQL View) |
Index Back |
|---|---|
Context related language viewContext Definition - related language view |
| SELECT A.EOCF_CONTEXT_ID , A.LANGUAGE_CD ,A.EOCF_CTX_NAME ,A.DESCR50 FROM PS_EOCF_CTX_LANG A , PS_EOCF_CONTEXT B , PS_RA_CONTEXT C WHERE A.EOCF_CONTEXT_ID = B.EOCF_CONTEXT_ID AND B.EOCF_CONTEXT_ID=C.EOCF_CONTEXT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | the ID value for a configured context | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 3 | EOCF_CTX_NAME | Character(50) | VARCHAR2(50) NOT NULL | context name |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |