Currency data is stored in Pega as Decimals, to two places after the decimal. Currency isn't a actually a basic Pega property type - it's all Decimal in the backend. Default in Oracle is Decimal(18,9).
Phone is also not a basic Pega type - it's Text in the backend. Default text column for Pega in Oracle is varchar2(32).
Booleans are stored in the database as varchar2(5) - I believe because some database types used to not have Boolean columns.
I hope this helps.
Posted: 6 years ago
Posted: 16 Jun 2016 5:20 EDT
Teruyuki Shimizu (shimt)
Senior System Architect