GPDE_SI_OTYP_VW

(SQL View)
Index Back

Organisation Type

Organisation Type of SI Provider

SELECT %Substring(X.FIELDVALUE ,1,2) , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'GPDE_SI_ORG_TYPE'

  • Related Language Record: GPDE_SI_OTY_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_SI_ORG_TYPE Character(2) VARCHAR2(2) NOT NULL Organisation Type
    01=SI Insurance Provider
    02=Receiver Institute
    03=Forwarding Institute
    04=Pension Fund Provider
    05=Pension Fund Receiver
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description