GPJP_MTH_COL_HIR01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
LANGUAGE_CDGPJP_MTH_LNG_VW(SQL View) |
Index Back |
|---|---|
Related Language ViewRelated Language view for Previous Employment Last Month. |
| SELECT %Substring(A.FIELDVALUE,1,2) ,A.LANGUAGE_CD ,A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GPJP_MTH_COL_HIR' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG WHERE FIELDNAME = A.FIELDNAME AND FIELDVALUE = A.FIELDVALUE) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPJP_MTH_COL_HIR |
Character(2) | VARCHAR2(2) NOT NULL |
Previous Employment Last Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |