RE: [sqr-users] Fwd: Encrypting Credit Cards in Contributor Relations

["Barnes, Tracy" <TBarnes@CIBER.com>]

In PeopleCode, there is the Hash function that does a bit of encryption.

The Hash function is what PS uses for storing Passwords in the PSOPRDEFN
table.

In PeopleCode there is also an Encrypt function.

I would take a look at those.

Tracy E. Barnes
Ciber Enterprise Solutions
Principal Consultant
Cell: (317) 374-7356

 -----Original Message-----
From:   Christine Sessler [mailto:cms41@cornell.edu]
Sent:   Friday, May 16, 2003 8:18 AM
To:     sqr-users@sqrug.org
Subject:        [sqr-users] Fwd: Encrypting Credit Cards in Contributor 
Relations

All -

I'm forwarding this along for a colleague.

We have a need to encrypt credit card information and store it in
PeopleSoft.  We're exploring what would be the best approach.  The data
is
an incoming dataset from the bank.

Anyone have any experience encrypting data and storing it in PeopleSoft?

SQR?  App Engine firing PeopleCode?  Other methods?

Thanks!
Chris



>Is there an encryption procedure that can be called via a supplied
>sqc that emulates the peoplecode function 'encrypt'.   I am looking
>to load membership data into CR via a feed from a local bank.   The
>bank would be transmitting Credit Cards numbers and I would like to
>encrypt them prior to loading them into the PS_AV_EP_MBR_DTL record
>so that we can use CyberSource to validate the cards.

************************************************************
Christine Sessler
Cornell University
CIT/Business Information Systems
120 Maple Avenue
Ithaca, NY  14850

607.255.8149  - Office
607.255.6982  - Fax
cms41@cornell.edu
************************************************************
"Life shrinks or expands in proportion to one's courage." - Anais Nin
"If a dog jumps in your lap, it is because he is fond of you;
but if a cat does the same thing, it is because your lap is warmer." -
Alfred North Whitehead
"The only normal people are the ones you don't know very well." - Joe
Ancis



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users