SCC_DISCREPDSRC

(SQL Table)
 Index Back

Discrepancy Data Source

Data source for discrepancy comparison and resolution

  • Related Language Record: SCC_DISCREPDSLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_DATA_SOURCE Character(30) VARCHAR2(30) NOT NULL Data Source
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 SCC_CONNECTSTRING Character(254) VARCHAR2(254) NOT NULL Connect string
    4 SCC_CONNECTUSERID Character(64) VARCHAR2(64) NOT NULL Connect User
    5 SCC_CRYPT_VAULT_ID Character(36) VARCHAR2(36) NOT NULL Encrypted Value Vault Foreign Key. Store this foreign key in lieu of an encrypted value. Retrieve the actual encrypted value from the encryption vault using this key. This is a UUID.
    6 SCC_PLATFORM_TYPE Character(3) VARCHAR2(3) NOT NULL Platform type This should somewhat correlate with translate values for DB_PLATFORM, but only for those platforms that we are supporting for this product line.
    DB2=Db2/MVS
    DBX=Db2/Unix
    MSS=MS Sql Server
    ORA=Oracle