PSCERTEXTFILE

(SQL Table)
 Index Back

PSCERTEXTFILE

This table is used to store the external file through file attachment.

  • Related Language Record: PSCERTXTFL_LG

  • Audit Record: PSAUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DIGITAL_ID Character(30) VARCHAR2(30) NOT NULL DIGITAL_ID
    2 SIGNER_ID Character(50) VARCHAR2(50) NOT NULL SIGNER_ID

    Prompt Table: %EDITTABLE

    3 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active
    A=Active
    I=Inactive

    Default Value: A

    4 SIGNER_TYPE Character(1) VARCHAR2(1) NOT NULL Signer Type
    E=Employee ID
    O=Operator ID

    Default Value: O

    5 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    6 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    7 KEYSTORE_PSWD Character(254) VARCHAR2(254) NOT NULL KEYSTORE_PSWD
    8 FROMDATE Date(10) DATE NOT NULL From Date
    9 EXPIRATION_DATE Date(10) DATE NOT NULL Expiration Date
    10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    11 CERTCOMMONNAME Character(254) VARCHAR2(254) NOT NULL X.500 Common Name
    12 CERTORGUNIT Character(254) VARCHAR2(254) NOT NULL X.500 Organizational Unit
    13 CERTORG Character(254) VARCHAR2(254) NOT NULL X.500 Organization
    14 CERTLOCALITY Character(254) VARCHAR2(254) NOT NULL X.500 Locality
    15 CERTSTATE Character(254) VARCHAR2(254) NOT NULL X.500 State or Province
    16 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
    17 CERTEMAILADDR Character(254) VARCHAR2(254) NOT NULL X.500 email address
    18 CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    19 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    21 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.