HRMS_CLASSC=Credit Card Supplier
D=General Deduction
G=Garnishment Payee
H=National Health Service Prov.
I=Industrial Ins. Board Provider
M=Imp Partner Provider
N=Not Applicable
P=General Provider
T=Tax Collector
LANGUAGE_CDVNDR_CLS_LNG_VW(SQL View) |
Index Back |
|---|---|
Vendor Class View.Vendor Class View - returns the translate table description for the HRMS_CLASS field, for values 'P', 'I', and 'H'. |
| SELECT %Substring(A.FIELDVALUE, 1, 1) , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'HRMS_CLASS' AND A.FIELDVALUE IN ('P', 'I', 'H') AND %EffdtCheck(PSXLATITEMLANG, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRMS_CLASS |
Character(1) | VARCHAR2(1) NOT NULL |
HRMS Class
C=Credit Card Supplier D=General Deduction G=Garnishment Payee H=National Health Service Prov. I=Industrial Ins. Board Provider M=Imp Partner Provider N=Not Applicable P=General Provider T=Tax Collector |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |