PSCERTEXTFILE

index back

PSCERTEXTFILE

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

  • Related language record: PSCERTXTFL_LG
  • PeopleSoft Field Name Field Type Column Type Description
    DIGITAL_ID Character(30) VARCHAR2(30) NOT NULL DIGITAL_ID
    SIGNER_ID Character(50) VARCHAR2(50) NOT NULL SIGNER_ID

    Prompt Table: %EDITTABLE

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

    Default: A

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

    Default: O

    ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    KEYSTORE_PSWD Character(254) VARCHAR2(254) NOT NULL KEYSTORE_PSWD
    FROMDATE Date(10) DATE NOT NULL From Date
    EXPIRATION_DATE Date(10) DATE NOT NULL Expiration Date
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    CERTCOMMONNAME Character(254) VARCHAR2(254) NOT NULL X.500 Common Name
    CERTORGUNIT Character(254) VARCHAR2(254) NOT NULL X.500 Organizational Unit
    CERTORG Character(254) VARCHAR2(254) NOT NULL X.500 Organization
    CERTLOCALITY Character(254) VARCHAR2(254) NOT NULL X.500 Locality
    CERTSTATE Character(254) VARCHAR2(254) NOT NULL X.500 State or Province
    COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
    CERTEMAILADDR Character(254) VARCHAR2(254) NOT NULL X.500 email address
    CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
    CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    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.
    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.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19