EMPLIDEMPL_RCDLANGUAGE_CDWPLACE_LOC_BRA1=Employer Establishment
2=Service Taker Establishment
3=Third Party Establishment
WPLACE_CODE_BRAWK_PL_LA_BRA_VW(SQL View) |
Index Back |
|---|---|
Workplace BRA Prompt View.Workplace Language table |
| SELECT EMPLID , EMPL_RCD , LANGUAGE_CD , WPLACE_LOC_BRA , WPLACE_CODE_BRA , DESCR100 FROM PS_JOB J1 , PS_WPL_TBL_BRA_LNG W WHERE J1.EFFDT = ( SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J1.EMPLID AND J2.EMPL_RCD = J1.EMPL_RCD) AND W.COMPANY = J1.COMPANY AND W.EFFDT = ( SELECT MAX(EFFDT) FROM PS_WPLACE_TBL_BRA W1 WHERE W.COMPANY = W1.COMPANY AND W.WPLACE_LOC_BRA = W1.WPLACE_LOC_BRA AND W.WPLACE_CODE_BRA = W1.WPLACE_CODE_BRA) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | WPLACE_LOC_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Worplace location.
1=Employer Establishment 2=Service Taker Establishment 3=Third Party Establishment |
| 5 | WPLACE_CODE_BRA |
Character(10) | VARCHAR2(10) NOT NULL | Workplace code. |
| 6 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |