PRC_CUSTLVL_VW

(SQL View)
 Index Back

customer level

customer level

SELECT %Substring(A.FIELDVALUE, 1 , 1) , A.XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME = 'CUST_LEVEL' AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND a.eff_status='A'

  • Related Language Record: PRC_CUSTLVL_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level
    N=New
    P=Prospect
    R=Regular
    S=Short-Term
    T=Temporary
    2 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field