CC_CRYPT_AET

(SQL Table)
Index Back

State Rec for CC Encryption

State Record for Employee Credit Card Encryption Program

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Credit Card Vendor
4 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
5 CC_NUMBER Character(44) VARCHAR2(44) NOT NULL Credit Card Number. Can be Encrypted or Decrypted
6 CC_INIT_VECTOR Character(128) VARCHAR2(128) NOT NULL Initialization Vector for Credit Card Encryption
7 HSC_ENCPRFL_ID Character(30) VARCHAR2(30) NOT NULL Encryption Profile ID
8 HSC_DECPRFL_ID Character(30) VARCHAR2(30) NOT NULL Decryption Profile ID
9 HCSC_STATUS Character(1) VARCHAR2(1) NOT NULL Field to capture the processed status of staging data. N = Not processed P = Processed
10 CC_CRYPT_ACTION Character(1) VARCHAR2(1) NOT NULL Encryption Action for Employee Credit Cards
D=Decrypt
E=Encrypt
11 CC_CRYPT_ENABLED Character(1) VARCHAR2(1) NOT NULL Credit Card Encryption Seup - Encryption Enabled Yes/No Field
N=No
Y=Yes
12 CC_IV_EXISTS Character(1) VARCHAR2(1) NOT NULL Flag to check if the Initialization Vector Parameter exists in the Encryption or Decryption Profile for Credit Cards

Y/N Table Edit