EP_APPR_WC_VW(SQL View) |
Index Back |
|---|---|
Sub Step ViewThis view is for Work Center Sub Steps |
| SELECT EP_APPRAISAL_ID , EMPLID , EMPL_RCD , LANG_CD FROM PS_EP_WC_DUMMY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EP_APPRAISAL_ID |
Number(8,0) | INTEGER NOT NULL | Document ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |