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
VENDOR_CLASS_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.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'HRMS_CLASS' AND A.FIELDVALUE IN ('P', 'I', 'H') AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | 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 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |