PSCERTEXTFILE

index back

PSCERTEXTFILE

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

  • Related language record: PSCERTXTFL_LG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    DIGITAL_IDCharacter(30)VARCHAR2(30) NOT NULLDIGITAL_ID
    SIGNER_IDCharacter(50)VARCHAR2(50) NOT NULLSIGNER_ID

    Prompt Table: %EDITTABLE

    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive
    A=Active
    I=Inactive

    Default: A

    SIGNER_TYPECharacter(1)VARCHAR2(1) NOT NULLSigner Type
    E=Employee ID
    O=Operator ID

    Default: O

    ATTACHSYSFILENAMECharacter(128)VARCHAR2(128) NOT NULLUnique Sys Filename
    ATTACHUSERFILECharacter(64)VARCHAR2(64) NOT NULLAttached File
    KEYSTORE_PSWDCharacter(254)VARCHAR2(254) NOT NULLKEYSTORE_PSWD
    FROMDATEDate(10)DATE NOT NULLFrom Date
    EXPIRATION_DATEDate(10)DATE NOT NULLExpiration Date
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    CERTCOMMONNAMECharacter(254)VARCHAR2(254) NOT NULLX.500 Common Name
    CERTORGUNITCharacter(254)VARCHAR2(254) NOT NULLX.500 Organizational Unit
    CERTORGCharacter(254)VARCHAR2(254) NOT NULLX.500 Organization
    CERTLOCALITYCharacter(254)VARCHAR2(254) NOT NULLX.500 Locality
    CERTSTATECharacter(254)VARCHAR2(254) NOT NULLX.500 State or Province
    COUNTRY_2CHARCharacter(2)VARCHAR2(2) NOT NULL2-Char Country Code
    CERTEMAILADDRCharacter(254)VARCHAR2(254) NOT NULLX.500 email address
    CREATEOPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID
    CREATEDTTMDateTime(26)TIMESTAMPDateTime of Query Creation
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19