TR_TRFTYPE_LNG(SQL View) |
Index Back |
---|---|
Transfer type Translate ViewView over the translate table to get Transfer type |
SELECT %Substring(A.FIELDVALUE, 1, 1) , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG C WHERE A.FIELDNAME = 'TRANSFER_TYPE' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) AND A.FIELDNAME = C.FIELDNAME AND A.EFFDT = C.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TRANSFER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer 01=External Transfer |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |