EBICS_IDB=Bank
C=Client
A=Authentication Key
D=Encryption Key
E=Encryption Key
S=Signature Key
X=Authentication Key
A=Active
I=Inactive
USER_CERT_VW(SQL View) |
Index Back |
|---|
| SELECT V.EBICS_ID , V.EBICS_CERT_TYPE , V.EFFDT , V.EBICS_ALIAS , V.EFF_STATUS , V.CERTVALIDFROM , V.CERTVALIDTO , V.CERTLINK1 FROM PS_EBICS_CERT_LIST V WHERE ebics_cert_type = 'C' AND EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_EBICS_CERT_LIST C WHERE C.EBICS_ID = V.EBICS_ID AND C.EBICS_CERT_TYPE = V.EBICS_CERT_TYPE AND C.EBICS_ALIAS = V.EBICS_ALIAS AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EBICS_ID |
Character(20) | VARCHAR2(20) NOT NULL | EBICS ID |
| 2 | EBICS_CERT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Type
B=Bank C=Client |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EBICS_ALIAS | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Alias
A=Authentication Key D=Encryption Key E=Encryption Key S=Signature Key X=Authentication Key |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | CERTVALIDFROM | DateTime(26) | TIMESTAMP | Valid from |
| 7 | CERTVALIDTO | DateTime(26) | TIMESTAMP | Valid to |
| 8 | CERTLINK1 | Character(1) | VARCHAR2(1) NOT NULL | Internal Link |