| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPayment Cards |
1 | CCSEC_ENC | Encrypted Payment Card Data | 5 | CRYPTIC_HASH | Hash Value of Payment Card Number | nvarchar | 40 | 0 | | |
2 | CCSEC_ENCV | Encrypted Payment Card Data | 5 | CRYPTIC_HASH | Hash Value of Payment Card Number | nvarchar | 40 | 0 | | |
3 | CCSEC_LOG | Logging of Access to Payment Card Numbers | 9 | CRYPTIC_HASH | Hash Value of Payment Card Number | nvarchar | 40 | 0 | | |
4 | PCA_SECURITY | Card Master: Encryption | 6 | CRYPTIC_HASH | Hash Value of an Encrypted Payment Card Number | nvarchar | 32 | 0 | | |
5 | PCA_SECURITY_RAW | Card Master: Encryption | 6 | CRYPTIC_HASH | Hash Value of an Encrypted Payment Card Number | nvarchar | 32 | 0 | | |
TOPService Station Retailing |
6 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 27 | CRYPTIC_HASH | Hash Value of a Payment Card Number | nvarchar | 40 | 0 | | |
7 | OIRE_RECON_DET | Detailed reconciliation data | 18 | CRYPTIC_HASH | Hash Value of a Payment Card Number | nvarchar | 40 | 0 | | |